Quenstion PCTFREE while creating tablespace



IBM's flagship relational database management system

Quenstion PCTFREE while creating tablespace

Postby fornanthakumar » Thu Jan 24, 2013 9:54 am

Hi,

Good Day.

Could you anyone assist me on the below question ?

While creating TABLESPACE we are using PCTFREE where howmuch percentage should leave in a page which helps for future insertions.

Incase if i mention PCTFREE 100 then what wil happen ? Please advise.
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Quenstion PCTFREE while creating tablespace

Postby enrico-sorichetti » Thu Jan 24, 2013 1:53 pm

While creating TABLESPACE we are using PCTFREE where howmuch percentage should leave in a page which helps for future insertions.


only the people who designed the application can tell ...
they know the insertion pattern and rate values
WE DO NOT
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post