Listing records from the operation log (for Command Execution Log)

The Command Execution Log can be displayed in a list.

= Remarks =

The log records of the Command Execution Log that are backed up by automatic or manual switching can become the target of this command as well.

(1) Command Execution Log List Display command

Program interface

CALL library name/UTLOPLLIST PARM(['LIB=library name'] 'CL'
   ['OUTFILE=filename'] ['H=hostname'] ['USR=userid|ADMUSR=userid']
   ['OP=operation'] ['PRCID=processingid']
   ['FROM=DATE1' ['FTIME=TIME1']] ['TO=DATE2' ['TTIME=TIME2']]
   ['G'] ['OUTPUT=filename'] ['EXIT' CL variable name])

Explanation of parameters

LIB=Library name

Library name in which HULFT is installed ("HULFT" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

CL

Specification of Command Execution Log (Mandatory)

OUTFILE=filename

Output file name (Optional)

Specify this parameter in the format of Library name/File name(Member name).

When the log is output to a file, all the fields in the Command Execution Log are output.

When omitted, some main fields are written to standard output.

= Remarks =

  • For the file format of the Command Execution Log, refer to the appendix in Administration Manual.

  • For the fields written to standard output when the output file name is defaulted, refer to Table 5.6 Fields of the Command Execution Log.

H=hostname

Target Starting Host Name to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 68 bytes or less.

When omitted, all the host names become the targets of this command.

USR=userid

The User ID (OS) on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter within 105 bytes.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the "ADMUSR=" at the same time.

= Remarks =

The user ID of OS is subject to the convention of the OS on the starting host. For details, refer to the explanation of the Operation Log in Administration Manual.

ADMUSR=userid

The User ID of the Management Console Security on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 32 bytes or less.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the "USR=" at the same time.

= Remarks =

For details on the User ID of the Management Console Security of each host type, refer to the explanation of the Operation Log in Administration Manual.

OP=operation

Name of the target request, command, or command execution key to be displayed in the list (Optional)

When omitted, all requests, commands, and command execution keys become targeted by this command.

= Remarks =

For details on request, command, or command execution key names you can specify, refer to the explanation about the operation log in Administration Manual.

PRCID=processingid

Target Latest Identifier to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 34 bytes.

When omitted, all the Latest Identifiers become the targets of this command.

= Remarks =

For details on the Identifier, refer to the explanation of the Operation Log in Administration Manual.

FROM=DATE1 [FTIME=TIME1] TO=DATE2 [TTIME=TIME2]

Target Start date (Time) and end date (Time) to be displayed in a list (Optional)

When the "FTIME=" is specified, the "FROM=" is mandatory. When the "TTIME=" is specified, the "TO=" is mandatory.

When the "FROM=" is omitted, HULFT displays the log records from the beginning till the date that you specified in the "TO=".

When the "TO=" is omitted, HULFT displays the log records from the date that you specified in the "FROM=" till the latest log record.

When both are omitted, log records of all dates become target of this command. You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings, and the DATE1 must be earlier than or equal to the DATE2. The log record of the date you specified is included in the target records to be deleted.

= Remarks =

The target of these parameters are the Execution Date and the Execution Time.

G

Control of error messages that the Command Execution Log List Display command outputs (Optional)

When omitted, HULFT displays error messages.

OUTPUT=filename

Destination of the error messages that the Command Execution Log List Display command outputs (Optional)

Specify this parameter in the format of Library name/File name(Member name).

When omitted, error messages are not output.

The number of log records that a log file can retain is unlimited.

EXIT CL variable name

Specifies to receive the error code output by the Command Execution Log List Display command and specifies the CL variable name to set the error code value (Optional)

The CL variable name must be immediately after the EXIT tag.

HULFT sets an error code to the CL variable only if the command ends unsuccessfully.

When omitted, an error code is not set.

Command interface

UTLOPLLIST OPLFILE() PRCID() HOSTNAME() FROMDATE() FROMTIME() TODATE()
 TOTIME() USERID() USR() ADMUSR() CMDNAME() LFILE() LMBR()
 LIBRARY( ) MSG( ) FILE( ) MBR( )

Explanation of parameters

OPLFILE

Specification of Command Execution Log (Mandatory)

PRCID

Target Latest Identifier to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 34 bytes.

When omitted, all the Latest Identifiers become the targets of this command.

= Remarks =

For details on the Identifier, refer to the explanation of the Operation Log in Administration Manual.

HOSTNAME

Target Starting Host Name to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 68 bytes or less.

When omitted, all the host names become the targets of this command.

FROMDATE

Target start date to be displayed in a list (Optional)

Specify this parameter in numbers of 8 bytes in length.

When omitted, all the dates through the specified date for the TODATE become the targets of this command.

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings. Specify a date in the range from FROMDATE to TODATE. The log record of the date you specified is included in the target records to be output in a list.

What is searched is Execution Date.

FROMTIME

Target start time to be displayed in a list (Optional)

Specify this parameter in numbers shorter than 6 bytes in length. You can specify this parameter only when the FROMDATE is specified.

When omitted, all the times through the specified time for the TOTIME become the targets of this command.

The time is output in the form of hhmmss. Specify a time in the range from FROMTIME to TOTIME. The specified time is covered by the target range of output as well.

What is searched is Execution Time.

TODATE

Target end time to be displayed in a list (Optional)

Specify this parameter in numbers of 8 bytes in length.

When omitted, all the dates on and after the specified date for the FROMDATE become the targets of this command.

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings. Specify a date in the range of FROMDATE through TODATE. The log record of the date you specified is included in the target records to be output in a list.

What is searched is Execution Date.

TOTIME

Target end time to be displayed in a list (Optional)

Specify this parameter in numbers shorter than 6 bytes in length. You can specify this parameter only when the TODATE is specified.

When omitted, all the times after the specified time for the FROMTIME become the targets of this command.

The time is output in the form of hhmmss. Specify a time in the range of FROMTIME through TOTIME. The specified time is covered by the target range of output as well.

What is searched is Execution Time.

USERID

The User ID on the starting host which is the target to be displayed in a list (Optional)

*USR :

User ID (OS)

*ADMUSR :

User ID of the Management Console Security

When omitted, all the User ID become the targets of this command.

= Remarks =

For the details on the User ID on each host type, refer to the explanation on the Operation Log in Administration Manual.

USR

The User ID (OS) on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter within 105 bytes.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the ADMUSR at the same time.

= Remarks =

The user ID of OS is subject to the convention of the OS on the starting host. For details, refer to the explanation of the Operation Log in Administration Manual.

ADMUSR

The User ID of the Management Console Security on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 32 bytes or less.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the USR at the same time.

= Remarks =

For details on the User ID of the Management Console Security of each host type, refer to the explanation of the Operation Log in Administration Manual.

CMDNAME

Command name or request name to be displayed in a list (Optional)

When omitted, all the command names or request names become the targets of this command.

LFILE

Library name and file name of the output file (Optional)

Specify this parameter in the format of Library name/File name. Specify these names as an alphanumeric character string of 10 bytes or less starting with an alphabet, respectively.

When the log is output to a file, all the fields in the Command Execution Log are output.

When omitted, some main fields are written to standard output.

= Remarks =

  • For the file format of the Command Execution Log, refer to the appendix in Administration Manual.

  • For the fields written to standard output when the output file name is defaulted, refer to Table 5.6 Fields of the Command Execution Log.

LMBR

Member name of the output file ("*FILE" by default)

LIBRARY

Library name in which HULFT is installed ("HULFT" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

MSG

Control of error messages ("*YES" by default)

*NO :

Suppress error messages.

*YES :

Show error messages.

FILE

Name of the library and the file to which error messages are output (Optional)

Specify this parameter in the format of Library name/File name.

Specify these names as an alphanumeric character string of 10 bytes or less starting with an alphabet, respectively.

When omitted, error messages are not output. The number of log records that a log file can retain is unlimited.

MBR

Member name of the file to which error messages are output ("*FILE" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

Table 5.6 Fields of the Command Execution Log

Field Name

Description

Size

DATE

Execution Time and Execution Date
(in the form of YYYY/MM/DD HH:MM:SS.mmm) (*1)

23 bytes

PROC-ID

Latest Identifier

34 bytes

OS-USERID

User ID (OS)

32 bytes

ADM-USERID

User ID (Management Console)

32 bytes

HOSTNAME

Starting Host Name

68 bytes

OPERATION

Command Execution Key

36 bytes

OPERATION-DETAIL

Command Parameter

40 bytes

*1

:

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings.
= Remarks =

  • The item that doesn't come up to the display size is indicated in left justification.

  • When the size of a filed to be displayed is larger than that of the display size, the part that exceeded the display size is cut off.

(2) Output example

Standard output

2017/12/29 18:36:18.503 420972D411140625000E471A000000F421
USR01
AS400
MANAGEMENT_INFORMATION_REGISTRATION  'LIB=HULOLIB' 'I=RCV' 'ID=FILE00018NAGOY
 
2017/12/29 18:36:24.749 420972D41145FDF4000E471A000000F821
USR01
AS400
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY
 
2017/12/29 18:37:36.570 420972D413848F5C000E471A0000010621
USR01
AS400
MANAGEMENT_INFORMATION_REGISTRATION  'LIB=HULOLIB' 'I=SND' 'ID=FILE00018NAGOY
 
2017/12/29 19:08:56.434 420972D44E4376C9000E471A0000011921
USR01
AS400
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY
 
2017/12/29 19:08:56.434 420972D44E4376C9000E471A0000011921
USR01
AS400
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY
 
2017/12/29 19:13:58.802 420972D457B66A7F000E471A0000012221
USR01
AS400
HULFT_MANAGEMENT_SCREEN_FINISH
 
2017/12/29 19:14:09.562 420972D4580C7EFA000E471A0000012E21
USR01
AS400
HULFT_MANAGEMENT_SCREEN_START        'LIB=HULOLIB'
 
2017/12/29 19:14:12.271 420972D458222B02000E471A0000013221
USR01
AS400
HULFT_MANAGEMENT_SCREEN_FINISH
 

File output

"2017/12/29","18:36:18.503","2017/12/29","18:36:18.503","USR01","","AS400","420972D411140625000E471A000000F421","420972D411140625000E471A000000F421","AS400","","MANAGEMENT_INFORMATION_REGISTRATION","HULFT_MANAGEMENT_SCREEN","'LIB=HULOLIB' 'I=RCV' 'ID=FILE00018NAGOYA8TO8TOKYO'"
"2017/12/29","18:36:24.749","2017/12/29","18:36:24.749","USR01","","AS400","420972D41145FDF4000E471A000000F821","420972D41145FDF4000E471A000000F821","AS400","","SEND_FILE","HULFT_MANAGEMENT_SCREEN","'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKYO'"
"2017/12/29","18:37:36.570","2017/12/29","18:37:36.570","USR01","","AS400","420972D413848F5C000E471A0000010621","420972D413848F5C000E471A0000010621","AS400","","MANAGEMENT_INFORMATION_REGISTRATION","HULFT_MANAGEMENT_SCREEN","'LIB=HULOLIB' 'I=SND' 'ID=FILE00018NAGOYA8TO8TOKYO'"   
"2017/12/29","19:08:56.434","2017/12/29","19:08:56.433","USR01","","AS400","420972D44E4376C9000E471A0000011921","420972D44E4376C9000E471A0000011921","AS400","","SEND_FILE","HULFT_MANAGEMENT_SCREEN","'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKYO'"
"2017/12/29","19:13:58.802","2017/12/29","19:13:58.802","USR01","","AS400","420972D457B66A7F000E471A0000012221","420972D457B66A7F000E471A0000012221","AS400","","HULFT_MANAGEMENT_SCREEN_FINISH","HULFT_MANAGEMENT_SCREEN",""
"2017/12/29","19:14:09.562","2017/12/29","19:14:09.562","USR01","","AS400","420972D4580C7EFA000E471A0000012E21","420972D4580C7EFA000E471A0000012E21","AS400","","HULFT_MANAGEMENT_SCREEN_START","HULFT_MANAGEMENT_SCREEN","'LIB=HULOLIB'"
"2017/12/29","19:14:12.271","2017/12/29","19:14:12.271","USR01","","AS400","420972D458222B02000E471A0000013221","420972D458222B02000E471A0000013221","AS400","","HULFT_MANAGEMENT_SCREEN_FINISH","HULFT_MANAGEMENT_SCREEN",""

= Remarks =

The date format varies depending on a value of the Date Format (DATEFMT) that is specified in the System Environment Settings. For details, refer to Administration Manual.

(3) Notes

  • If you specify the FROMDATE, HULFT searches the Command Execution Log from the top, then detects the first log record that matches the value of the FROMDATE, and displays the log record together with all the records that follow after.

  • If you specify TODATE, HULFT searches the Command Execution Log from the top or from the time or date that is specified for the FROMDATE, and displays the log records up to the first one that exceeds the value that is specified for the TODATE.

    Figure 5.2 Display Range of Operation Log