Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › INSERT: Creating DB2 Records › Syntax › Examples

Examples

This example shows how to create a new OPTS record for the TEST DB2 subsystem. With this record, CA ACF2 Option for DB2 permits access to any resource but logs it. This example uses the REP parameter to insert new values into a DB2 OPTS record. This example shows how an INSERT subcommand might look when you enter it:

INSERT OPTS SYSID(TEST) BPLMODE(LOG) CONMODE(LOG) DBSMODE(LOG) FNCMODE(LOG) 
PLNMODE(LOG) PRCMODE(LOG) ROLMODE(LOG) SCHMODE(LOG) SEQMODE(LOG) STGMODE(LOG) 
SYSMODE(LOG) TBLMODE(LOG) TSPMODE(LOG) TYPMODE(LOG)

In the next example, the EXITS record of the TEST subsystem is used as a model to create the EXITS record for the PROD subsystem. This subcommand changes the DB2POST exit value to NEWPOST for the PROD subsystem.

I EXITS SYS(PROD) USYS(TEST) DB2POST(NEWPOST) REP

In the next example, a SAFELIST record is inserted for the DB2 PROD subsystem.

insert safelist.pln sys(prod) class(db2plan) service(execute) resource(dsnesprr)