What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?
Answer / guest
The question should be how much space can be reclaimed from
dropped tables, that would be PERCDROP from
SYSIBM.SYSTABLEPART
Is This Answer Correct ? | 0 Yes | 0 No |
When is the authorization check on DB2 objects done - at BIND time or run time?
What is buffer pool and list some of them?
What is a DB2 plan?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
When do you use the IMAGECOPY?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is a db2 table?
What do you do to keep the cursor from closing after a commit?
What are the 2 sqlcodes that are returned?
what is Static and dynamic linking
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th