Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › DELETE: Deleting DB2 Records › Syntax › Parameters

Parameters

The DELETE subcommand takes the following parameters:

*

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

recid

Names the record ID of the DB2 record you want to delete. 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 one‑ to four‑character subsystem ID of the DB2 record that you want to delete. 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 SYSID itself and not as a mask.

If you specify SYSID, you cannot specify MSYSID.

MSYSID(sysidmask)

Specifies a mask to delete DB2 records for more than one subsystem. This mask must contain at least one asterisk or a trailing dash. Use extreme care when you delete multiple DB2 records with this parameter.

If you specify MSYSID, you cannot specify SYSID.