Interested to Buy Any Domain ? << Click Here >> for more details...
What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?
- 1 Answers
- 4372 Views
- I also Faced
- E-Mail Answers
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 |
What are the benefits of using the db2 database?
What is an inner join, and an outer join ?
How to define the a field which accepts value till 99999.99 in db2
What is the difference between static and dynamic SQL?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
The only place of VSAM KSDS in DB2 is?
How do you pull up a query which was previously saved in qmf?
What is JOIN and different types of JOIN.
How do you concatenate the firstname and lastname from emp table to give a complete name?
Which catalog table stores referential constraints?
Give some example of statistics collected during RUNSTATS?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
COBOL 
