pctfree in syscat.indexes and syscat.tables

MarkhamDBA · #1 (**permalink**) 09-30-09, 15:27

manual says pctfree = 10 by default when creating tables and indexes.

what does pctfree=-1 in syscat.tables/indexes mean? does it mean pctfree=10? it does not say anywhere that -1 means default = 10.
then why doesn't it say 10 instead?

thank you

db2girl · #2 (**permalink**) 09-30-09, 16:06

-1 mean default. I think default is 0% for tables and 10% for indexes.

MarkhamDBA · #3 (**permalink**) 10-01-09, 09:33

Quote:

Originally Posted by db2girl

-1 mean default. I think default is 0% for tables and 10% for indexes.

you are right, Bella

Internet Services

Web Development

Digital Marketing

Consumer Tech