What statistic will tell the DBA how must space can be reclaimed from dropped

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

Question Posted / guest

1 Answers
4434 Views
I also Faced
E-Mail Answers

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

how do we solve soc 7 and soc4 ?

3 Answers Tech Mahindra,

What is a db2 schema?

0 Answers

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers Amdocs, HeadStrong,

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers

What are the three DB2 date and time data types and their associated functions?

1 Answers

What is a cursor?

2 Answers

how to resolve -805 . how to see dbrm and package not found

2 Answers IBM,

what are the bind parameters?

5 Answers IBM,

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers Cap Gemini, Tech Mahindra,

Where do you specify them?