Listing records from the operation log (for File Access Log)

The File Access Log can be displayed in a list.

= Remarks =

The File Access Logs backed up by automatic or manual switching become the object of this command as well.

(1) File Access Log List Display command

Program interface

CALL Library name/UTLOPLLIST PARM(['LIB=Library name'] 'FL'
    ['OUTFILE=filename'] ['H=hostname'] ['USR=userid|ADMUSR=userid']
    ['OP=operation'] ['FILE=systemfile'] ['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.

FL

Specification of the File Access 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 File Access Log are output.

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

= Remarks =

For the file format of the File Access 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.5 Fields of the file access 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.

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

Target File Access Type to be displayed in a list (Optional)

When omitted, all of the File Access Type become the targets of this command.

= Remarks =

For the details on the operation type you can specify, refer to the explanation of the Operation Log in Administration Manual.

FILE=systemfile

Target System File Type to be displayed in a list (Optional)

When omitted, all of the System File Type become the targets of this command.

= Remarks =

For the details on the System File Type you can specify, refer to the explanation of 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 "FROM=" is omitted, HULFT displays the log records from the beginning untill the date specified as "TO=". The time is output in the format of hhmmss.

When "TO=" is omitted, HULFT displays the log records from the date specified as "FROM=" untill 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 DATE1 must be earlier than or equal to DATE2.

= Remarks =

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

G

Control of error messages that the File Access Log List Display command outputs (Optional)

When omitted, HULFT displays error messages.

OUTPUT=filename

Destination of the error messages that File Access 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 File Access 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() FILEACCESS() SYSTEMFILE() LFILE() LMBR()
   LIBRARY( ) MSG( ) FILE( ) MBR( )

Explanation of parameters

OPLFILE

Specification of the File Access 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 specified date is included in the records output to the 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.

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 from FROMTIME to 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.

FILEACCESS

Target File Access Type to be displayed in a list (Optional)

When omitted, all of the File Access Type become the targets of this command.

= Remarks =

For the details on the operation type you can specify, refer to the explanation of the Operation Log in Administration Manual.

SYSTEMFILE

Target System File Type to be displayed in a list (Optional)

When omitted, all of the System File Type become the targets of this command.

= Remarks =

For the details on the System File Type you can specify, refer to the explanation of the Operation Log in Administration Manual.

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 File Access Log are output.

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

= Remarks =

For the file format of the File Access 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.5 Fields of the file access 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.

(2) Fields in the list

Table 5.5 Fields of the file access log
Field Name	Description	Display 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	File Access Type + single-byte space + System File Type	10bytes + 1 byte + 25 bytes
OPERATION-DETAIL	File Key Information	40 bytes

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.

(3) Output example

Standard output

2017/12/29 18:20:48.553 420972D3EDA8F1AA000E471A0000005921                   
HULFT                                                                        
AS400                                                                        
NEW        HULSNDLOG                 ""FILE00018NAGOYA8TO8TOKYO"",""MAINFRAME
                                                                             
2017/12/29 18:20:52.261 420972D3F422147B000E471A0000009621                   
HULFT                                                                        
AS400                                                                        
UPDATE     HULRHT                    TGRP0001TOKYO                           
                                                                             
2017/12/29 18:24:46.159 420972D3F0829FBE000E471A0000006B21                   
HULFT                                                                        
AS400                                                                        
NEW        HULSNDLOG                 ""FILE00018NAGOYA8TO8TOKYO"",""WINDOWS""
                                                                             
2017/12/29 18:30:11.266 420972D4059A1CAC000E471A000000A421                   
HULFT                                                                        
AS400                                                                        
UPDATE     HULSND                    FILE00018NAGOYA8TO8TOKYO                
                                                                             
2017/12/29 18:30:15.398 420972D405B974BC000E471A000000A621                   
HULFT                                                                        
AS400                                                                        
NEW        HULSNDLOG                 ""FILE00018NAGOYA8TO8TOKYO"",""AS400"","
                                                                             
2017/12/29 18:30:15.400 420972D405B974BC000E471A000000A621                   
HULFT                                                                        
AS400                                                                        
NEW        RESENDREQ                 ""FILE00018NAGOYA8TO8TOKYO"",""AS400"","
                                                                             
2017/12/29 18:31:01.859 420972D4072EDD2F000E471A000000B821                   
HULFT                                                                        
AS400                                                                        
UPDATE     HULSND                    FILE00018NAGOYA8TO8TOKYO                
                                                                             
2017/12/29 18:36:18.505 420972D411140625000E471A000000F421                   
HULFT                                                                        
AS400                                                                        
UPDATE     HULRCV                    FILE00018NAGOYA8TO8TOKYO                
                                                                             
2017/12/29 18:36:24.771 420972D41145FDF4000E471A000000F821                   
HULFT                                                                        
AS400                                                                        
DELETE     RESENDREQ                 ""FILE00018NAGOYA8TO8TOKYO"",""AS400"","

File output

"2017/12/29","18:20:48.553","2017/12/29","18:17:25.118","USR01","","AS400","420972D3EDA8F1AA000E471A0000005921","420972D3EDA8F1AA000E471A0000005921","AS400","","NEW","HULSNDLOG","""FILE00018NAGOYA8TO8TOKYO"",""MAINFRAMEHOSTTOKYO"",""20171229"",""181726"""
"2017/12/29","18:20:52.261","2017/12/29","18:20:52.260","USR01","","AS400","420972D3F422147B000E471A0000009621","420972D3F422147B000E471A0000009621","AS400","","UPDATE","HULRHT","TGRP0001TOKYO"
"2017/12/29","18:24:46.159","2017/12/29","18:18:56.328","USR01","","AS400","420972D3F0829FBE000E471A0000006B21","420972D3F0829FBE000E471A0000006B21","AS400","","NEW","HULSNDLOG","""FILE00018NAGOYA8TO8TOKYO"",""WINDOWS"",""20171229"",""181856"""
"2017/12/29","18:30:11.266","2017/12/29","18:30:11.264","USR01","","AS400","420972D4059A1CAC000E471A000000A421","420972D4059A1CAC000E471A000000A421","AS400","","UPDATE","HULSND","FILE00018NAGOYA8TO8TOKYO"
"2017/12/29","18:30:15.398","2017/12/29","18:30:15.181","USR01","","AS400","420972D405B974BC000E471A000000A621","420972D405B974BC000E471A000000A621","AS400","","NEW","HULSNDLOG","""FILE00018NAGOYA8TO8TOKYO"",""AS400"",""20171229"",""183015"""
"2017/12/29","18:30:15.400","2017/12/29","18:30:15.181","USR01","","AS400","420972D405B974BC000E471A000000A621","420972D405B974BC000E471A000000A621","AS400","","NEW","RESENDREQ","""FILE00018NAGOYA8TO8TOKYO"",""AS400"",""20171229"",""183015"",""HULDLIB/HUL002(SNDDATA)"""
"2017/12/29","18:31:01.859","2017/12/29","18:31:01.858","USR01","","AS400","420972D4072EDD2F000E471A000000B821","420972D4072EDD2F000E471A000000B821","AS400","","UPDATE","HULSND","FILE00018NAGOYA8TO8TOKYO"
"2017/12/29","18:36:18.505","2017/12/29","18:36:18.503","USR01","","AS400","420972D411140625000E471A000000F421","420972D411140625000E471A000000F421","AS400","","UPDATE","HULRCV","FILE00018NAGOYA8TO8TOKYO"
"2017/12/29","18:36:24.771","2017/12/29","18:36:24.749","USR01","","AS400","420972D41145FDF4000E471A000000F821","420972D41145FDF4000E471A000000F821","AS400","","DELETE","RESENDREQ","""FILE00018NAGOYA8TO8TOKYO"",""AS400"",""20171229"",""183015"",""HULDLIB/HUL002(SNDDATA)"""

(4) Notes

If you specify the FROMDATE, HULFT searches the File Access 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 File Access 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.1 Display Range of Operation Log