What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?
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 do I delete a table in db2?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How can you compare table column after update and before update?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is usage pointer in cobol?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
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.
What is db2 catalog database?
What is the maximum number of columns in a db2 table?
What is a page?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?