Select Statistics Command

Issue the select statistics command to examine records in the Connect:Direct® statistics database. The type of information in the output from this command includes such data as copy status and execution events. The search criteria provide flexibility in selecting information you want to retrieve. Additional parameters determine the form in which the information is presented.

When using the select statistics command, specify your selection criteria carefully to avoid displaying excessive volumes of records. If you do not provide selection criteria, all records for the day are retrieved.

Format

The format for the select statistics command follows.

Command Parameters
select statistics /* Selection Criteria */
[ccode=(operator, code)]
[dfile=destination filename | (list)]
[pname=Process name | generic | (list)]
[pnumber=Process number | (list)]
[reccat=caev | capr | (caev,capr)]
[recids=record id | (list)]
[snode=snode name | generic | (list)]
[sfile=source filename | (list)]
[startt=([date | day][, hh:mm:ss[am|pm]])]
[stopt=([date | day][, hh:mm:ss[am|pm]])]
[submitter=(node name, userid) | generic | (list)]
Note: To use a wildcard within the submitter parameter, you must have administrator access.
/* Display option */
[detail=yes | no]

Parameters

Provide one or more of the following parameters to determine what statistics are returned:

Parameter Description
ccode=(operator, code)

Select statistics records based on the completion code operator and return code values associated with step termination. The condition code operator default is eq. You must specify the return code.

Following are the valid completion code operators:

eq | = | == Equal (This is the default.)

ge | >= | => Greater than or equal

gt | > Greater than

le | <= | =< Less than or equal

lt | < Less than

ne | != Not equal

Following are the valid completion codes:

0—Successful execution of the Process.

4—A warning level error was encountered. The statement probably completed normally but you should verify the execution results.

8—An error occurred during Process execution.

16—A Severe error occurred during Process execution.

dfile=destination filename | (list)

Enables you to search all copy termination records (CAPR category, CTRC record ID) to find those with a destination file name matching the filename or list of filenames specified.

This parameter is not supported by Connect:Direct for UNIX.

pname=Process name | generic | (list) Selects Process statistics by Process name, a generic name, or a list of names. The name can be 1 to 8 alphanumeric characters long.
pnumber=Process number | (list) Selects statistics by Process number or a list of Process numbers. The Process number is assigned when the Process is submitted.
reccat=caev | capr | (caev , capr)

Selects statistics based on whether the record category is related to events or to a Process.

The default for this keyword depends on the other search criteria specified. If you specify Process characteristics, such as Process name, Process number, or Submitter, the default is capr. If you perform a general search using startt or stopt, the default is caev and capr.

caev—Specifies that the retrieved statistics file records should include those related to Connect:Direct events, such as a Connect:Direct shutdown.

capr—Specifies that the retrieved statistics file records should include those related to one or more Connect:Direct Processes.

recids=record id | (list)

Specifies selection by record ID or a list of record IDs. This parameter identifies particular types of statistics records, such as a copy termination records or initialization event records. Following is a list of the record IDs:

AUPR—Authorization file processing

CHGP—Change Process command issued

COAC—Communication activated

CMLT—CMGR listen thread terminated

CRHT—Connect:Direct copyright

CSTP—Child Process stopped

CTRC—Copy control record written

CTRM—Child Process terminated

CUKN—Child process unknown status

CXIT—Child process exited

DELP—Delete Process command issued

FLSP—Flush Process command issued

FMRV—Formatted Header (FMH) received

FMSD—Formatted Header (FMH) sent

 

GPRC—Get Process issued

IFED—If statement ended

IPPR—Initialization parameter processing

LIOK—Listen okay

LSST—The record ID of a step on the local node

NAUH—Node Authorization check issued

NMOP—Network map file opened

NMPR—The network map is updated through Sterling Connect:Direct Browser User Interface, IBM Control Center, or KQV Interface.

NUIC—Connect:Direct initialization complete

NUIS—Connect:Direct start initialization

NUT1—Connect:Direct phase one termination complete status

NUT1—Connect:Direct phase two termination complete status

NUTC—Connect:Direct termination complete

NUTR—Connect:Direct termination requested

PERR—Process error was detected

PFLS—Process was flushed

PMED—Process Manager ended

recids=record id | (list)

(continued)

PMIP—Process Manager Initprocs thread initialized

PMMX—Process Manager Max Age thread initialized

PMRC—Process Manager release cell thread initialized

PMST—Process Manager started

PPER—Pipe error

PRED—Process ended

PRIN—Process interrupted

PSAV—Process was saved

PSED—Process step was detected

PSTR—Process has started

 

QCEX—A Process moved from another queue to the EXEC queue

QCHO—A Process moved from another queue to the HOLD queue

QCWA—A Process moved from another queue to the WAIT queue

QCTI—A Process moved from another queue to the TIMER queue

QCHO—A Process moved from another queue to the HOLD queue

RJED—Run Job command completed

RNCF—Remote Connect:Direct server call failed

RSST—The record ID of a step on the remote node

RTED—Run Task command completed

SBED—Submit complete

SELP—Select Process command issued

SELS—Select Statistics command issued

SEND—Session end issued

SERR—System error

SFSZ—Size of the file submitted

SHUD—Connect:Direct shutdown

 

SIGC—System error

SMED—Session Manager ended

SMST—Session Manager started

SNMP—SNMP

SSTR—Session start issued

STOP—Stop Connect:Direct command issued

SUBP—Submit command issued

TCPI—TCP started

TRAC—Trace command issued

TZDI—Time zone of the local node represented as the difference in seconds between the time at the local node and the Coordinated Universal Time

UNKN—Unknown command issued

USEC—User Security check issued

xxxx—Record types identified by the first four characters of the message ID

snode=snode name | generic | (list) Selects statistics file records by SNODE name, a generic node name, or a list of node names. The SNODE name can be 1 to 16 alphanumeric characters long.
sfile=filename| (list)

Enables you to search all copy termination records (CAPR category, CTRC record ID) to find those with a destination file name matching the file name or list of the file names specified.

This parameter is not supported by Connect:Direct for UNIX.

startt=([date | day] [, time])

Selects statistics starting with records logged since the specified date, day, or time. The date, day, and time are positional parameters. If you do not specify a date or day, type a comma before the time.

date—Specifies the day (dd), month (mm), and year (yy), which you can code as mm/dd/yyyy or mm-dd-yyyy. If you only specify date, the time defaults to 00:00:00. The current date is the default.

day—Specifies the day of the week. Values are today, yesterday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. If you specify a day of the week, Connect:Direct uses the previous matching day.

time—Specifies the time of day coded as hh:mm:ss[am | pm] where hh is hours, mm is minutes, and ss is seconds. You can specify the hour in either 12- or 24-hour format. If you use the 12-hour format, then you must specify am or pm. The default format is the 24-hour format. The default value is 00:00:00, which indicates midnight. If you specify only the day value, the time defaults to 00:00:00.

stopt=([date | day] [, time])

Retrieves statistics including records logged up to and including the specified date, day, or time. The date, day, and time are positional parameters. If you do not specify a date or a day, type a comma before the time.

date—Specifies the day (dd), month (mm), and year (yy), that you can code as mm/dd/yyyy or mm-dd-yyyy. If you only specify date, the time defaults to 00:00:00. The current date is the default.

day—Specifies the day of the week. Values are today, yesterday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. If you specify a day of the week, Connect:Direct uses the previous matching day.

time—Specifies the time of day coded as hh:mm:ss[am | pm] where hh is hours, mm is minutes, and ss is seconds. You can specify the hour in either 12- or 24-hour format. If you use the 12-hour format, then you must specify am or pm. The default is the 24-hour format. The default value is 00:00:00, which indicates midnight. If you specify only the day value, the time defaults to 00:00:00.

submitter=(node name, userid) | generic | (list) Selects statistics by the node name and userid of the Process owner (submitter). You can also specify a generic name and userid or a list of names and userids. The maximum combined length, including the node name and userid, is 66 characters for this parameter.

Display Parameter

Provide this optional parameter if you want to generate a report of the statistics that are generated:

Parameter Description
detail=yes | no

Specifies the type of report generated for the selected Processes. The default is no.

yes—Generates a detailed report.

no—Generates a short report.

Example

The following example shows the report information returned when specifying detail=yes.

==================================================================
              SELECT STATISTICS
==================================================================
PROCESS RECORD   Record Id=>SUBP
Process Name     =>SAMPLE     Stat Log Time     =>09:54:33
Process Number   =>38         Stat Log Time     =>07/30/2003
Submitter Id     =>user1
Snode            =>CSGPUBS
Completion Code  =>0
Message Id       =>
Short Text       =>
---------------------------------------------------------
PROCESS RECORD   Record Id=>SUBp
Process Name     =>SAMPLE     Stat Log Time     =>09:54:33
Process Number   =>39         Stat Log Time     =>07/30/2003
Submitter Id     =>user1
Snode            =>CSGPUBS
Completion Code  =>0
Message Id       =>
Short Text       =>

---------------------------------------------------------

The following example shows the report information returned when specifying detail=no or omitting the detail parameter.

==================================================================
              SELECT STATISTICS
==================================================================
P RECID LOG TIME               PNAME PNUMBER STEPNAME CCOD FDBK MSGID
P RECID LOG TIME               MESSAGE TEXT
-----------------------------------------------------------------
P  SUBP  07/30/2003 09:54:33   SAMPLE  38    0  0
P  SUBP  07/30/2003 09:54:35   SAMPLE  39    0  0
The following command generates statistics output for Process number 7. The output consists of all records for that Process starting with those generated on July 11, 2003.
select statistics pnumber=7 startt=(07/11/2003);