1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest


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

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

What is isolation level?

4 Answers  

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

What is REORG? When is it used?

4 Answers  




What are foreign keys?

1 Answers  

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

How to restart a DB2 program?

0 Answers   Cognizant,

What is cursor with hold option in db2?

0 Answers  

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

What are the levels of isolation available with DB2V4

2 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories