What is FREEPAGE and PCTFREE in TABLESPACE creation?
Answer / abhishek kale
PCTFREE indicates to DB2 what percentage of each page in
the table space or index to leave free when either loading
or reorganizing the data. DB2 will then use that free space
when inserting new rows and index entries.
FREEPAGE indicates to DB2 how often to leave a full page of
free space when either loading or reorganizing the data.
For example, if you specify FREEPAGE 5, DB2 will allocate a
page of free space after filling five pages with data.
Is This Answer Correct ? | 11 Yes | 3 No |
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain how can you do the explain of a dynamic sql statement?
Mention the downsides of page level lock.
Explain about dbrm.
Explain the EXPLAIN statement?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is netezza database?
Can there be more than one cursor open for any program?
can we view the access paths created by dbrm ? how ? thx
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the difference between Primary key and unique index?
what types of copies can be made with the COPY Utility ?