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.
--------------------------------------------------------- |
The following example shows the report information returned when specifying detail=no or omitting the detail parameter.
|
|