SELECT STATISTICS Command Examples

Edit online

The following command searches for statistics records based on start and stop date and time, and excludes write-to-operator statistics messages.

SEL STAT WHERE ( -
  EXCLUDE=(WTO) - 
  STARTT=(11/24/2003,06:45:00) -
  STOPT=(11/25/2003,8AM) -
       )

The following command searches for statistics records based on start and stop date and time, and excludes write-to-operator and PDS member copy statistics records.

SEL STAT WHERE (-
                EXCLUDE=(WTO,MEMB) -
                STARTT=(11/21/2003,15:25:00) -
                 STOPT=(11/25/2003,15:30:00) -
                 )

The following command searches for statistics records based on Process name, and start and stop date and time. It excludes write-to-operator statistics messages.

SEL STAT WHERE ( -
                 EXCLUDE=(WTO) -
                 PNAME=BILLING  -
                 STARTT=(12/28/2003,06:00)  -
                 STOPT=(12/28/2003,23:00) -
                )

The following command searches for signon records for the user Mary.

SEL STAT WHERE (USER=MARY, TYPE=SI) TABLE

The following command searches are identical and both select only WTO records.

SEL STAT WHERE (TYPE=WO) TABLE
SEL STAT WHERE (EXCLUDE=(NOTWTO)) TABLE

The following command searches for statistics records based on Process start/stop date and time that ran on a IBM® Connect:Direct® Server named SERVER1.

SEL STAT WHERE ( -
                 SERVER=SERVER1 -
                 STARTT=(12/28/2003,06:00) -
                 STOPT=(12/28/2003,23:00) -
                 )

The following command searches for Process submission records for Processes in which the SNODE is any node in Dallas, and prints the output. Assume that the site administrator indicates that the November statistics records are contained in a file pair whose key sequenced data set is named SYS.ARCH.STATS.M9611. For an explanation of statistics file pairs, search on Administering Statistics in the IBM Sterling Connect:Direct for z/OS® Administration Guide.

SEL STAT WHERE ( -
                 TYPE=(PS,SW) -
                 SNODE=DALLAS* -
                 ARCHDSN=SYS.ARCH.STATS.M9611 -
                ) PRINT

The following command searches for signon and signoff records that match today’s date and the User ID SEAN.

SEL STAT WHERE ( -
                 TYPE=(SI,SO) -
                 USER=SEAN  -
                 STARTT=(TODAY) -
                 STOPT=(TODAY,24:00:00) -
                 ) TABLE

The following command searches for the message ID SCMG010I and all message IDs that begin with SCPA.

SEL STAT WHERE ( -
                 MSGID=(SCMG010I, SCPA*) -
                )

The following figure illustrates the commands for archiving statistics for a single day using the Batch Interface. These commands archive the statistics from the previous day into the preallocated data set of the API referenced by the DD DMTMPDSN.

SIGNON      USERID=(USERID,PASSWORD) TMPDD=DMTMPDSN  -
            NETMAP=HLQ.CD.NETMAP
SELECT STAT WHERE (STARTT=(YESTERDAY,00:00:00) -
                   STOPT=(YESTERDAY,24:00:00))  FILE
SIGNOFF