What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?
Answer Posted / 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 View All Answers
Is the primary key a clustered index?
How do I add a column in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What do you mean by storage group (stogroup)?
What is a Foreign Key?
What is reorg?
What is a trigger in the db2 database?
What is image copy in db2?
How to take backup of table in db2?
What is db2 purescale?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are concurrency issues?
What is multi row fetch in db2?
Why do we need reorg in db2?
How can you count the number of rows from a table tab?