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
- 4375 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 |
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
how can u understand the end of the table ?
What's The Error Code For Unique Index Voilation?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
Explain in brief how does db2 determine what lock-size to use?
What is the physical storage length of the data types date, time, and timestamp?
Explain how can you do the explain of a dynamic sql statement?
Where could you look if you had a question about whether a column has been defined as an index?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is an instance in db2?
What is an instance database?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
COBOL 
