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
- 4301 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 |
How will you return the number of records in table?
What is a synonym ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What do you do to keep the cursor from closing after a commit?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What is difference between rollback and commit?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
what is the difference between declaring the cursor in WS section and Procedure division?
what is plan? is plan executable or package?
is it compulsory commitment control in journal?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is the role of the data page in the db2 database?
COBOL 
