Registered Client Log List Display utility

Acquires the log records from a specified client and outputs the records in CSV format to the standard output.

Usage

utlhubclientloglist -h hostname[:servicename] [-s | -r] 
  [-fromdate d1] [-todate d2] [-f fileid] [-host hostname] [-notitle]

utlhubclientloglist -h hostname[:servicename] -o 
  [-fromdate d1] [-todate d2] [-service name] [-notitle]

utlhubclientloglist -h hostname[:servicename] -sc 
  [-fromdate d1] [-todate d2] [-id schedule] [-notitle]

utlhubclientloglist -h hostname[:servicename] {-t | -rs} 
  [-fromdate d1] [-notitle]

utlhubclientloglist -h hostname[:servicename] -sd 
  [-fromdate d1] [-notitle]

utlhubclientloglist -h hostname[:servicename] {-js | -jr} 
  [-fromdate d1] [-todate d2] [-f fileid] [-host hostname] [-notitle]

Explanation of parameters

-h hostname[:servicename]

Host name and service name (Mandatory)

Specifies the host name and service name of the client from which you want to acquire the log records.

If you specify a host for which no service name is set, specify only a host name, and do not specify a service name that includes a colon (:).

= Remarks =

If the service name is omitted, it will not be possible to make more than one host with the same host name a target.

[-s | -r | -o | -sc | -t | -rs | -sd | -js | -jr]

Log Type (Optional)

Specify the type of the log records to acquire.

-s:

Send Log

-r:

Receive Log

-o:

Request Acknowledge Log

-sc:

Schedule Log

-t:

Send and Receive Status

-rs:

Resend Queue Status

-sd:

Today's Schedule

-js:

Post-send Job Execution Log

-jr:

Post-receive Job Execution Log

If omitted, -s is assumed to be specified.

Note

-sc (Schedule Log) and -sd (Today's Schedule) can be specified when the host type of the client is Windows.

[-fromdate d1] [-todate d2]

Range of date and time to be output (Optional)

Specify the date and time of the records to be output.

d1 and d2 must be 14-byte numeric values (yyyymmddhhmmss), or 8-byte numeric values (yyyymmdd). If the date is specified with 8-byte numeric values, all the log records in the specified date range are targeted for output.

If -todate is omitted, all the log records on or after the date and time specified by -fromdate are targeted for output.

If -fromdate is omitted, all the log records on or before the date and time specified by -todate are targeted for output.

-todate cannot be specified when Log Type is specified as one of -t (Send and Receive Status), -rs (Resend Queue Status), or -sd (Today's Schedule).

= Remarks =

• If you specify -fromdate and -todate at the same time, d1 must be equal to or smaller than d2.

• -fromdate and -todate can have a different date format (14 bytes and 8 bytes).
  Example: -fromdate 20080101 -todate 20080930123000

[-f fileid]

File ID (Optional)

Specify the File ID of the file to be output.

If the targeted client is HULFT8, the ID must be no more than 50 bytes. If the targeted client is HULFT8 or earlier, the ID must be no more than 8 bytes.

If specified, only the log records whose File ID match fileid are targeted. If omitted, all the File IDs are targeted.

This parameter can be specified when the log type is specified as one of -s (Send Log), -r (Receive Log), -js (Post-send Job Execution Log), or -jr (Post-receive Job Execution Log).

[-host hostname]

Name of the remote host (Optional)

Specify the name of the remote host for transfer processing.

If the log type is specified as either -s (Send Log) or -js (Post-send Job Execution Log), only the log records whose receiving side matches hostname are targeted.

If the log type is specified as either -r (Receive Log) or -jr (Post-receive Job Execution Log), only the log records whose sending side matches hostname are targeted.

-host cannot be specified if the log type is none of the above.

[-service name]

Service Name (Optional)

Specify a Request Acknowledge service name to be output.

If specified, only the log records whose service name matches name are targeted. If omitted, all the service names are targeted.

This parameter can be specified when the log type is specified as -o (Request Acknowledge Log).

[-id schedule]

Schedule ID (Optional)

Specify the Schedule ID to be output.

If the targeted client is HULFT8, the ID must be no more than 50 bytes. If the targeted client is HULFT8 or earlier, the ID must be no more than 8 bytes.

If specified, only the log records whose Schedule ID matches schedule are targeted. If omitted, all the Schedule IDs are targeted.

This parameter can be specified when the log type is specified as -sc (Schedule Log).

[-notitle]

Suppression of Title Output (Optional)

If you specify "-notitle", the title line of the CSV header is not output.

If you do not specify "-notitle", a field name is displayed as the header. For details about field names, see Displayed fields.

Status code

0:

The utility was executed successfully.

10:

The specified options are incorrect.

11:

A termination instruction was detected.

12:

Failed to allocate memory.

13:

A system error occurred.

40:

The acquisition was not performed, because the client referred to is outside of control.

41:

The client referred to does not support the length of the specified ID.

60:

An error occurred during the acquisition of the log records.

100:

The relevant Registered Client does not exist.

101 or above:

An SQL error occurred.

Notes on using the utilities

For details about the operation environment for using the utilities, see Notes on execution of utilities (commands).

For this utility, also note the following:

• The Log records are output using the Kanji code specified with Kanji Code Type (KnjCode) in the System Environment Settings.

• Request Acknowledge Log records of a client are added each time the utility is executed.

• If 1000 or more log records are output per second, log records 1 to 999 are output and records 1000 or above are skipped.

• A large number of trace log records are output when Post-send Job Execution Log or Post-receive Job Execution Log is acquired. Specify a date range, File ID, or host name to narrow down the log records.

• When acquiring Post-send Job Execution Log or Post-receive Job Execution Log, according to the number of logs stored in the targeted client, it may take substantial time.

Output example

"File ID","Send Host Name","Receive Host Name","Start Date","Start Time","End Da 
te","End Time","Send File Name","Status Code","Detail Code","Record Count","Data 
Size","Transmission Rate","Connection Type","Volume Serial","UNIT","Interface D 
BID","Compression Ratio","IP Version","Message 0","Message 1","Message 2","Messa 
ge 3","Message 4","Message 5","Mailbox Use","Send Acknowledge Date","Send Acknow 
ledge Time","Latest Identifier","Starting Identifier","Transfer Block Length","T 
ransfer Block Count","Long Message 0","Long Message 1","Encryption Used","Transf 
er ID","Compression Preference","Code Converted By","Comment"
"FILE01","HOST01","HOST02","2015/09/27","20:16:05","2015/09/27","20:16:09","C:\D
Ata\testdata\snd\test2.txt","000000","00000","454","37682","9420","LAN","","",""
,"0","IPv4","","","","","","","No","2015/09/27","20:16:05","8E49C9451CE0BA19E555
C3B14B6D34B861","8E49C9451CE0BA19E555C3B14B6D34B861","32768","1","","","HULFT","
B120F1DA757382A16A543279343248D781000200000000000000000000000000","None","Sendin
g Side","TEST"

"File ID","Send Host Name","Receive Host Name","Start Date","Start Time","End Da 
te","End Time","Receive File Name","Status Code","Detail Code","Record Count","D 
ata Size","Transmission Rate","Connection Type","Volume Serial","UNIT","Interfac 
e DBID","Compression Ratio","IP Version","Message 0","Message 1","Message 2","Me 
ssage 3","Message 4","Message 5","Mailbox Use","Send Acknowledge Date","Send Ack 
nowledge Time","Latest Identifier","Starting Identifier","Transfer Block Length" 
,"Transfer Block Count","Long Message 0","Long Message 1","Encryption Used","Tra 
nsfer ID","Compression Preference","Code Converted By","Comment"
"FILE02","HOST01","HOST02","2013/09/27","20:16:05","2013/09/27","20:16:09","C:\D
Ata\testdata\rcv\moya\rcv02.txt","000000","00000","454","37682","9420","LAN","",
"","","IPv4","","","","","","","No","","","8E49C9451CE0BA19E555C3B14B6D34B861","
8E49C9451CE0BA19E555C3B14B6D34B861","","","","","C4S","6D110461DE9F99883DE3118CD
62665DD81000100000000000000000000000000","None","","TEST"

"Service Name","Host Name","Direction Host Name","Direction Acknowledge Date","D 
irection Acknowledge Time","Status Code","Detail Code","Latest Identifier","Star
ting Identifier" 
"HULADMIN","HOST01","HUBSVR","2015/11/11","17:26:41","000735","00000","00D5F51D5 
9BC9A5726877BD1F006955281","00D5F51D59BC9A5726877BD1F006955281"

"Schedule ID","Host Name","Start Date","Start Time","End Date","End Time","Statu 
s Code","Detail Code","Latest Identifier","Starting Identifier" 
"TEST","HOST01","2015/11/11","22:45:00","2015/11/11","22:45:14","000709","00002" 
,"ACD9C7BDC5E0CE76B61182748D357F6041","ACD9C7BDC5E0CE76B61182748D357F6041"

"Type","File ID","Host Name","Send/Receive Host Name","Direction Date","Directio 
n Time","Status","Connection Type","Size","Total Size","Latest Identifier","Star 
ting Identifier","SEQ No.","File Name","Transfer ID" 
"Send","FILE01","HOST01","HOST02","2015/09/27","20:16:05","Auto Resend Queue","L 
AN","0","37682","8E49C9451CE0BA19E555C3B14B6D34B861","8E49C9451CE0BA19E555C3B14B 
6D34B861","","C:\Data\testdata\snd\Sample.txt","AA5BE71E7E19EE57E822EE567E479FBE
81000100000000000000000000000000"

"File ID","Host Name","Send Host Name","Date","Time","Send File Name","Status Co 
de","Detail Code","Record Count","Total Record Count","Data Size","Total Data Si 
ze","Connection Type","Volume Serial","UNIT","Resend Queue List No.","Message 0" 
,"Message 1","Message 2","Message 3","Message 4","Message 5","Latest Identifier" 
,"Starting Identifier","Long Message 0","Long Message 1" 
"FILE03","HOST01","HOST02","2015/08/27","09:42:10","C:\Data\testdata\snd\test2.t
xt","331701","00003","0","0","0","0","LAN","","","","","","","","","","C12AA2F81
EEF3B279E9031378825C41561","C12AA2F81EEF3B279E9031378825C41561","",""

"Status","Schedule ID","Host Name","Execution Date","Start Time","End Time","Sta 
tus Code","Detail Code" 
"Waiting","TEST","HOST01","2015/11/12","22:45:00","","",""

"File ID","Send Host Name","Receive Host Name","Start Date","Start Time","End Ti 
me","Library Name","Job Name","Message ID","Severity","Status","Latest Identifie 
r","Starting Identifier" 
"FILE01","HOST01","HOST02","2013/09/27","20:16:09","20:16:12","","c:\tools\batfi
le\set_exitcode.bat 0","","","0","8E49C9451CE0BA19E555C3B14B6D34B861","8E49C9451
CE0BA19E555C3B14B6D34B861"

Displayed fields

The following table lists and describes the fields shown in the output example.

Legend:

Y:

Available in all versions

7.0:

Available on a client whose version is Ver.7.0 or above.

(In a client whose version is earlier than Ver.7.0, "" is always output.)

8.0:

Available on a client whose version is Ver.8.0 or above.

(In a client whose version is earlier than Ver.8.0, "" is always output.)

8.1:

Available on a client whose version is Ver.8.1 or above.

(In a client whose version is earlier than Ver.8.1, "" is always output.)

8.4:

Available on a client whose version is Ver.8.4 or above.

(In a client whose version is earlier than Ver.8.4, "" is always output.)

-:

Unavailable for the host type ("" is always output.)