Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › CHANGE: Modifying DB2 Records › Syntax › Parameters

Parameters

The CHANGE subcommand takes the following parameters:

*

Specifies the record ID of the last DB2 record processed since establishing the CONTROL(DB2) setting.

recid

Names the record ID of the DB2 record you want to change. You cannot mask this field. For SAFELIST records, the recid must be in the form: SAFELIST.qualifier. The qualifier makes the record key unique since there can be multiple SAFELIST records for one DB2 subsystem.

SYSID(sysid)

Names the specific one‑ to four‑character subsystem ID of the DB2 record that you want to change. Any value that you specify with the SYSID parameter can contain asterisks or a trailing dash, however, CA ACF2 Option for DB2 treats these characters as part of the subsystem ID itself and not as a mask.

If you do not specify this value, CA ACF2 Option for DB2 changes the record with the SYSID value set by the SET subcommand, if specified. If not specified by the SET subcommand, CA ACF2 Option for DB2 displays the message INVALID REQUEST ‑ UNDEFINED SYSID.

If you specify SYSID, you cannot specify MSYSID.

MSYSID(sysidmask)

Specifies a mask to change DB2 records for more than one subsystem. This mask must contain at least one asterisk or a trailing dash.

If you specify MSYSID, you cannot specify SYSID.

ADD

For DB2 EXITS records only, ADD adds the specified fields and values to the existing fields and values in the specified DB2 record. If a field already exists, the specified value replaces the existing value. ADD is the default.

For DB2 OPTS records, ADD is invalid because CA ACF2 Option for DB2 creates default field values that values cannot be added to. Use the REP parameter instead.

REP

Replaces a corresponding field in the specified DB2 record. If a specified field does not currently exist, it is added to the existing fields.

DEL

For DB2 EXITS records only, DEL deletes the specified DB2 record.

For DB2 OPTS records, DEL is invalid because CA ACF2 Option for DB2 creates default field values that cannot be deleted.

field1,field2,...,fieldn

Specifies the fields and any values to change as indicated by the ADD, REP, or DEL parameter.