10. MODIFICATION › 10.2 Standard User Exits › 10.2.1 Input Exits

10.2.1 Input Exits

This section provides a description of the input exit that is
shared by DB2 with the other installed CA MICS products.

The exit description includes the name and title, a
description of its purpose, when it is invoked, and whether
it has an interface to CA MICS Accounting and Chargeback. It
also shows which data elements are available, the special
considerations to note, and a sample user exit.


+-------------+
| U S R S E L |  Input Record Selection Exit (USRSEL)
+-------------+

DESCRIPTION:  The _USRSEL exit allows you to reject records
from being processed by the CA MICS Analyzer Option for DB2
during the DB2 input format routine.  It is similarly invoked
in input format routines for other CA MICS products. It can
be defined at the complex level in
sharedprefix.MICS.SOURCE(#BASEXIT) or at the unit level in
prefix.MICS.USER.SOURCE(#BASEXIT).

INVOCATION:  The _USRSEL exit gains control during the input
format routine in the DAY065 step of the DAILY job. It is
invoked for each input record processed from SMF.

ACCOUNTING INTERFACE:  No interface is provided.

USES:  This exit can be used to exclude records from being
processed by the CA MICS Analyzer Option for DB2 during the
daily input step.  To exclude a record, set SKIP_REC to one.
For example, you can code the following to skip records that
contain the SMF system ID "TEST":

   MACRO _USRSEL;
     IF ROUTINE EQ 'DYDB2FMT' THEN DO;
      IF ORGSYSID EQ 'TEST' THEN SKIP_REC=1;
     END;
   %

The CA MICS Analyzer Option for DB2 provides the appropriate
logic to delete the record based on the value of SKIP-REC
after the _USRSEL exit is invoked.

ELEMENTS AVAILABLE:  ORGSYSID - Original System ID

CODING RESTRICTIONS:  Do not refer to any CA MICS-assigned
data elements such as DB2ID and DB2ACTx when setting SKIP_REC
in this exit.  Extra records will be deleted as a result.
For additional coding restrictions, refer to the SMG, Section
4.3.2.1.


+---------------+
| U S R S D B 2 |  Input Record Selection Exit (DB2SEL)
+---------------+

DESCRIPTION:  The USRSDB2 exit allows you to reject records
from being processed by the CA MICS Analyzer Option for DB2
during the DB2 input format routine.  It is ONLY invoked in
CA MICS DB2 format routine.  It can be defined at the complex
level in sharedprefix.MICS.SOURCE(#DB2EXIT) or at the unit
level in prefix.MICS.USER.SOURCE(#DB2EXIT).

INVOCATION:  The USRSDB2 exit gains control during the input
format routine in the DAY065 step of the CA MICS DAILY job
following the decode of the DB2 header information from an
input SMF log record.  Elements available at the point of
this exit are listed below, after the sample exit.  It is
invoked for each DB2 input record processed from SMF.

ACCOUNTING INTERFACE:  No interface is provided.

USES:  This exit can be used to exclude records from being
processed during the daily input step based on distributed
thread type, user ID, plan ID, transaction, and facility ID.
To exclude a record, set SKIP_REC to one.  For example, you
can code the following to skip records that contain the
DB2PLAN, LOOPER:

      IF DB2PLAN EQ 'LOOPER' THEN SKIP_REC=1;

The CA MICS Analyzer Option for DB2 provides the appropriate
logic to delete the record based on the value of SKIP-REC
after the USRSDB2 exit is invoked.

ELEMENTS AVAILABLE:

  ORGSYSID -  Original System ID
  ENDTS    -  SMF Time stamp
  DB2RMID  -  DB2 Resource Manager ID
  DB2IFCID -  Instrumentation Facility ID
  DB2RELN  -  DB2 Release Number
  DB2ACE   -  DB2 Agent Control Element (ACE) ID
  DB2ID    -  DB2 Subsystem ID
  DB2STCK  -  Time Stamp
  DB2LOCN  -  Location ID
  DB2AUTH  -  Primary Authid
  DB2CORR  -  Job name
  DB2CONN  -  DB2 Facility ID (TSO, CICS, IMS)
  DB2PLAN  -  DB2 Plan name
  DB2OPID  -  DB2 OPERATOR ID
  DB2NETID -  NETWORK ID
  DB2LUNAM -  DDF  LU NAME
  DB2UNIQ  -  DDF  INSTANCE NUMBER
  DB2DDFCT -  DDF  COMMIT COUNT
  DB2REQID -  Remote Requesting Location Id
  DB2THDTY -  Distributed Thread Type