Previous Topic: ParametersNext Topic: INSERT: Creating DB2 Records

Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › LIST: Displaying DB2 Records › Syntax › Examples

Examples

This subcommand displays the OPTS record that applies to the TEST DB2 subsystem.

LIST OPTS SYSID(TEST)

CA ACF2 Option for DB2 displays the following:

TEST / OPTS LAST CHANGED BY USER01 ON 05/27/03‑09:13
                     ACTIVE BPLMODE(ABORT) CONMODE(ABORT) DBSMODE(ABORT) 
                     FNCMODE(ABORT) GSYSID(TES1) JARMODE(ABORT) PLNMODE(ABORT)
                     PRCMODE(ABORT) ROLMODE(ABORT) SCHMODE(ABORT) SEQMODE(ABORT) 
                     STGMODE(ABORT) SYSMODE(ABORT) TBLMODE(ABORT) TSPMODE(ABORT) 
                     TYPMODE(ABORT)

The next example uses abbreviations to display all the OPTS records that apply to subsystems when their IDs begin with PRD.

L OPTS MSYS(PRD*)

For example, these records are displayed:

PRD1 / OPTS LAST CHANGED BY USER01 ON 05/27/03‑09:09
                     ACTIVE BPLMODE(ABORT) CONMODE(ABORT) DBSMODE(ABORT) 
                     FNCMODE(ABORT) GSYSID(PROD) JARMODE(ABORT) PLNMODE(ABORT) 
                     PRCMODE(ABORT) ROLMODE(ABORT) SCHMODE(ABORT) SEQMODE(ABORT) 
                     STGMODE(ABORT) SYSMODE(ABORT) TBLMODE(ABORT) TSPMODE(ABORT) 
                     TYPMODE(ABORT)

PRD2 / OPTS LAST CHANGED BY USER01 ON 05/27/03‑09:09
                     ACTIVE BPLMODE(ABORT) CONMODE(ABORT) DBSMODE(ABORT) 
                     FNCMODE(ABORT) GSYSID(PROD) JARMODE(ABORT) PLNMODE(ABORT) 
                     PLNMODE(ABORT) PRCMODE(ABORT) ROLMODE(ABORT) SCHMODE(ABORT) 
                     SEQMODE(ABORT) STGMODE(ABORT) SYSMODE(ABORT) TBLMODE(ABORT)
                     TSPMODE(ABORT) TYPMODE(ABORT)
PRD3 / OPTS LAST CHANGED BY USER01 ON 05/27/03‑09:09
                     ACTIVE BPLMODE(ABORT) CONMODE(ABORT) DBSMODE(ABORT) 
                     FNCMODE(ABORT) GSYSID(PROD) JARMODE(ABORT) PLNMODE(ABORT) 
                     PLNMODE(ABORT) PRCMODE(ABORT) ROLMOD(ABORT) SCHMODE(ABORT) 
                     SEQMODE(ABORT) STGMODE(ABORT) SYSMODE(ABORT) TBLMODE(ABORT)
                     TSPMODE(ABORT) TYPMODE(ABORT)

The next example uses abbreviations to display all the SAFELIST records in the infostroage database.

L LIKE(SAFELIST.‑) MSYS(‑)

**** / SAFELIST.PLN LAST CHANGED BY USER01 ON 07/16/02‑14:31
                     CLASS(DB2PLAN) COLUMN() RESOURCE(DSNESPRR) SERVICE(EXECUTE)

**** / SAFELIST.3 LAST CHANGED BY USER01 ON 07/23/02‑11:29
                     CLASS(DB2DBASE) COLUMN() RESOURCE(RESTDB1) SERVICE(DBADM)

**** / SAFELIST.4 LAST CHANGED BY USER01 ON 07/25/02‑13:32
                     CLASS(DB2SYS) COLUMN() RESOURCE(CREATESG) SERVICE()

**** / SAFELIST.5 LAST CHANGED BY USER01 ON 07/25/02‑13:33
                     CLASS(DB2DBASE) COLUMN() RESOURCE(TESTDB1) SERVICE(DBADM)