Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change page size of db2

Status
Not open for further replies.
ericwong

ericwong

MIS
Oct 3, 2001
8
0
0
HK
Hi all,

In DB2, the default page size of database is 4KB size. However, I want to change default page size of tablespace to 8KB. How can I do? And, I want to know how to set the
default page size when create a database?

Thanks
Eric Wong
 
Sort by date Sort by votes
AFAIK, you can set a tablespace size only when creating a tablespace. Also I haven't come across any setting to change the default pagesize when creating the tablespace.

Cheers

Sathyaram
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
108
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
82
tekpr00
tekpr00
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
46
Rohit K Gupta
Rohit K Gupta
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
95
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
99
walter.weinmann
walter.weinmann

Part and Inventory Search

Sponsor

Back
Top