Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 4
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Jul
17
awarded  Notable Question
Sep
24
awarded  Autobiographer
Jun
9
awarded  Popular Question
Aug
15
comment DB2: Is it good to create the LONG table space to use 32 KB data page
I am a bit hesitating to use inline to store the xml into the base table directly. As it said, it will be benefit to operate on the xml. But not normally it happens on non-xml columns.And the base table is defined on the table space with 4k data page. I could try to inline some small xml column though.
Aug
15
comment DB2: Is it good to create the index table space to use 32 KB data page
We do create table spaces like you did. But as you said you will prefer to use a 4K table space to save disk. How can we find out the total size that has been wasted due to the data page is big like 32k?
Aug
15
awarded  Student
Aug
15
awarded  Supporter
Aug
15
asked DB2: Is it good to create the index table space to use 32 KB data page
Aug
15
asked DB2: Is it good to create the LONG table space to use 32 KB data page