How would one remove old reorg information from the DB2 catalog ?
Run the MODIFY RECOVERY Utility.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Difference between:-DOMAIN CONTROLLER and GLOBAL CATALOG ? 20.08.08
1. Transmission Control Protocol: a standard protocol for transmitting the information. Remote Desktop Protocol: Used for accessing the Desktop Remotely 2...There are at least seven IDCAMS commands; name and explain each of them ? 11.08.08
ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. DEFINE is used for ALTERNATEINDEX,...Where besides the DB2 catalog is database object information stored by DB2 ? 12.04.08
DB2 also stores information about DB2 objects as database descriptors (DBDs) in the DBD Directory table....Which catalog tables contain authorization information ? 10.04.08
The SYSIBM table that contain authorization information are SYSCOLAUTH, SYSDBAUTH, SYSPLANAUTH, SYSTABAUTH and SYSUSERAUTH....What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run ? 09.04.08
The DBA can see this in the PERCDROP column of the SYSIBM.SYSTABLEPART catalog table....What does the REORG Utility do ? 05.04.08
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...What is REORG? When is it used? 18.03.08
REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. I...What is a DB2 catalog ? 12.03.08
The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.)....What information is used as input to the bind process? 07.03.08
The database request module produced during the pre-compile. The SYSIBM.SYSSTMT table of the DB2 catalog....What is system catalog or catalog relation? How is better known as? 08.03.06
A RDBMS maintains a description of all the data that it contains, information about every relation and index that it contains. This information is stored in a c...