What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?



What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the ..

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

Post New Answer

More DB2 Interview Questions

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  


What is buffer pool and list some of them?

0 Answers  


What is a DB2 plan?

8 Answers  


when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


When do you use the IMAGECOPY?

4 Answers  






How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


What is a db2 table?

0 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  


What are the 2 sqlcodes that are returned?

0 Answers  


what is Static and dynamic linking

1 Answers   Virtusa,


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

5 Answers  


Categories