DB2 sets a restrictive or advisory status on an object to control access and help ensure data integrity. The following list outlines the restrictive and nonrestrictive object states that affect utilities and the steps required to correct each status for a particular object. Use the -DISPLAY DATABASE command to display the current status for an object. Following is an example of this command to display those objects that are in a restrictive state: -DISPLAY DATABASE(DBASE1) SPACE(*) RESTRICT Output for objects in a restrictive state is shown next: DSNT360I +DSN8 *********************************** DSNT361I +DSN8 * DISPLAY DATABASE SUMMARY * RESTRICTED DSNT360I +DSN8 *********************************** DSNT362I +DSN8 DATABASE = DBASE1 STATUS = RW DBD LENGTH = 4028 DSNT397I +DSN8 NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE -------- ---- ----- ----------------- -------- -------- -------- ----- TS001 TS RW,RESTP ******* DISPLAY OF DATABASE DBASE1 ENDED ********************** DSN9022I +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION The -DISPLAY DATABASE command can also be used to display objects in an advisory state: -DISPLAY DATABASE(DBASE1) SPACE(*) ADVISORY Output for objects in an advisory state is as follows: DSNT360I +DSN8 *********************************** DSNT361I +DSN8 * DISPLAY DATABASE SUMMARY * ADVISORY DSNT360I +DSN8 *********************************** DSNT362I +DSN8 DATABASE = DBASE1 STATUS = RW DBD LENGTH = 4028 DSNT397I +DSN8 NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE -------- ---- ----- ----------------- -------- -------- -------- ----- TS002 TS RW,ICOPY ******* DISPLAY OF DATABASE DBASE1 ENDED ********************** DSN9022I +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION Some options find objects that are in a particular status. The following output shows objects in LPL status: DSNT360I +DSN8 *********************************** DSNT361I +DSN8 * DISPLAY DATABASE SUMMARY * GLOBAL LPL DSNT360I +DSN8 *********************************** DSNT362I +DSN8 DATABASE = DBASE1 STATUS = RW DBD LENGTH = 4028 DSNT397I +DSN8 NAME TYPE PART STATUS LPL PAGES -------- ---- ----- ----------------- ------------------ TS002 TS RW 000039-00003C ******* DISPLAY OF DATABASE DBASE1 ENDED ********************** DSN9022I +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION Table 7-2 shows all the restrictive and advisory states, the objects affected, and what corrective actions need to be taken.
|