Defining DB2 Records › SYSID Use in CA ACF2 Option for DB2 › Selecting the SYSID

Selecting the SYSID

You can select the SYSID of the DB2 record or CA ACF2 Option for DB2 rule that you want to process in two ways:

• For each ACF command session. You can use the SYSID or MSYSID parameter of the ACF SET subcommand to select the DB2 records or CA ACF2 Option for DB2 rules that are processed during that session. (See the next section for information about the SET subcommand.) For example, you can set the SYSID to DB2A for the entire ACF command session. In this session, CA ACF2 Option for DB2 processes only the subset of CA ACF2 Option for DB2 rules with the type code ($TYPE) of TBL and the $SYSID of DB2A (unless you specify a different SYSID with later subcommands). The SET subcommand to establish the SYSID is:

  SET DB2(TBL) SYSID(DB2A)
  

  You can specify

  SET SYSID(DB2B)
  

  to change the SYSID for a session.

  You can also use MSYSID to process multiple DB2 records or CA ACF2 Option for DB2 rules at a time. For example, you can specify the value of MSYSID to match all SYSIDs that begin with certain characters. This example selects all of the CA ACF2 Option for DB2 table rules with $SYSID control statements that begin with PR:

  SET DB2(TBL) MSYSID(PR‑)
  

  All later subcommands affect only the CA ACF2 Option for DB2 table rules with $SYSID control statements that begin with PR.

• For each ACF subcommand. You can also specify the SYSID or MSYSID parameter with any of the ACF subcommands (DECOMP, LIST, INSERT, CHANGE, or DELETE). These parameters override the SYSID you specified on the SET subcommand for the execution of that subcommand only. For example, suppose you set the SYSID on the SET subcommand to ed DB2A. Then, you want to delete a CA ACF2 Option for DB2 table rule with the SYSID of DB2B, as follows:

  DELETE EMPLOYEE.PICNIC SYSID(DB2B)
  

  The rule covering the EMPLOYEE.PICNIC table on the DB2B subsystem is deleted. If a rule exists covering the EMPLOYEE.PICNIC table on the DB2A subsystem, it is not deleted.