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 |
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What are the abend codes occour in ur latest PROJECT in DB2
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is a clustering index ?
what are stage one indexable predicates?
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 iseries database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to retrieve rows from a db2 table in embedded sql?
What is buffer pool and list some of them?
What are the two types of logging in the db2 database? Explain them.
When is the access path determined for dynamic SQL?