What is the STOSPACE Utility used for ?
The STOSPACE Utility updates the DB2 catalog with the DASD utilization of the table space and index space data sets. Read more »
‘Database Interview Questions’ - KyaPoocha.com
What DB2 Catalog column tell you when an index needs table reorganized ?
The FAROFFPOS column of the SYSIBM.SYSINDEXPART table. Read more »
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run ?
The DBA can see this in the PERCDROP column of the SYSIBM.SYSTABLEPART catalog table. Read more »
Why use RUNSTAT Utility ?
Because the DB2 Optimizer need accurate data in order to formulate the most efficient access path given the state of the environment and because the information... Read more »
What does the RUNSTATS Utility do?
The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in the DB2 Catalog. Read more »
What can the Locate option of the Repair Utility accomplish
The Locate option of the Repair Utility can delete a row from a table space, repair broken table space pages, and replace data as specific locations in a table space... Read more »
What can the SET option of the Repair Utility accomplish ?
The set option of the Repair utility can reset a copy pending, check pending, and recover pending flags. Read more »
What does the REORG Utility do ?
The REORG Utility will sort the index space and table space to conform with the primary index or clustering index specified in the DDL. It will also reclaim the... Read more »
What is the purpose of the QUIESE Utility ?
The QUIESE Utility prevents the start of any new table space activity while it gives active threads a chance to finish their tasks. Once all thread are inactive,... Read more »
Why might full image copies be faster to implement than an incremental image copy ?
Because an incremental image copy has to search for changed data and cannot make use of sequential pre fetch. Conversely, a full image copy has no checking to do... Read more »
What does the CHECK Utility do ?
The CHECK Utility checks the referential integrity of table relations and checks the integrity of the indexes by matching index column values to table column... Read more »
What is the purpose of the DSNC transaction ?
The DSNC transaction is used for controlling the CICS Call Attach Facility(CAF) and for Displaying CAF statistics. Read more »
What is a thread ?
A thread is the connection between DB2 and some other subsystem, such as CICS or IMS/DC. Read more »
What is a root page ?
The opposite of a leaf page; it is the highest level index page. An index can contain only the one root page; all other index pages are associated to the root. Read more »
What is a precompiler ?
It is a DB2 facility for static SQL statements - it replaces these statements with calls to the DB2 language interface module. Read more »