Transfer Log List Display utility
Externally outputs the Transfer Log to the standard output.
The Transfer Log is stored at a regular interval according to the System Environment Settings, but this utility allows you to manually store the Log.
Usage
utlhubloglist [-csv | -list] [-sortend] [-notitle] [-fromdate d1] [-todate d2] [-count]
Explanation of parameters
- [-csv | -list]
-
Specification of output format (Optional)
Specifies the output format.
- -csv:
-
Detailed display with a CSV format
- -list:
-
Simplified display with a fixed-length format
If omitted, -csv is assumed.
- [-sortend]
-
Sort by Transfer End Date/Time (Optional)
Specify this parameter if you want to sort the Transfer Log records by the Transfer End Date/Time.
If omitted, the records are sorted based on the Transfer Start Date/Time.
- [-notitle]
-
Omission of the header line (Optional)
If you specify "-notitle", the list is displayed without the header line.
If you do not specify "-notitle", a field name is displayed as the header. For details about field names, see Displayed fields.
- [-fromdate d1] [-todate d2]
-
Range of date and time to be output (Optional)
Specify the date and time of the Transfer Log 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.
If both -fromdate and -todate are omitted, log records for the entire range of dates are targeted for output.
= 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
NoteThe Transfer End Date/Time is targeted for output.
-
- [-count]
-
Output the number of records (Optional)
If specified, outputs only the number of logs that matches the conditions is displayed.
NoteIf -count is specified, even when the data that matches the conditions does not exist, the processing ends with outputting 0 as the number of records and outputting status code 0.
Status code
- 0:
-
The information was output successfully.
- 10:
-
The specified options are incorrect.
- 12:
-
Failed to allocate memory.
- 13:
-
A system error occurred.
- 101 or above:
-
An SQL error occurred.
If -count is specified, even when the data that matches the conditions does not exist, the processing ends with outputting 0 as the number of records and outputting status code 0.
Notes on using the utilities
For details about the operation environment for using the utilities, see Notes on execution of utilities (commands).
Output example
The following shows an output example for each specified value of the parameter.
"FileID","Business Group","Transfer Source","Transfer Destination","Transfer Sta tus"," Accumulation Status"," Type"," Start Date"," Start Time"," End Date","End Time","Progress","Finished (Byte)","Scheduled (Byte)","Record Count","Latest Id entifier","Starting Identifier","JobFlowID","Send File Name","Transfer Type","En cryption Used","Transfer ID","Compression Preference","Code Converted By" "FileID01(FileID01 Alias)","group01","host01:service01(Alias 01)","host02:servic e02(Alias 02)","-","Accumulation Complete","Rely","2009/03/17","14:38:32","2009/ 03/17","14:38:33","100%","602","602","1","A01DEFGHIJKLMNOPQRSTUVWXYZ78901234","A 02DEFGHIJKLMNOPQRSTUVWXYZ78901234","JF0000000001","sendfile","BINARY","AES","B12 0F1DA757382A16A543279343248D781000200000000000000000000000000","None","-" "FileID02(FileID02 Alias)","group02","host11:service11(Alias 11)","host12:servic e12(Alias 12)"," Transfer Error (0650,7061)"," Accumulation Error (7012)","Relay ","2009/03/17","14:38:32","2009/03/17","14:38:33","0%","0","602","0","A11DEFGHIJ KLMNOPQRSTUVWXYZ78901234","A12DEFGHIJKLMNOPQRSTUVWXYZ78901234","","send.txt""TEX T","AES","6D1104DE9F99883DE3118CD62665DD81000100000000000000000000000000","None" ,"Sending Side"
Figure 3.17 Display example of Transfer Log List (when -csv is specified)
FileID
Business Group Transfer Source
Transfer Destination
Transfer Status Accumulation Status Type Start Date Start Ti End Date
End Time Prog Finished (Byte) Scheduled (Byte) Record Count Latest Identifier
Starting Identifier JobFlowID
FileID01(File01 Alias)
group01 host01:service01(Alias 01)
host02:service02(Alias 02)
- Accumulation Complete Relay 2015/12/08 20:08:182015/12/08
20:08:18 100% 602 602 2 7C72B1D5304D614E
58BC0CB8431B9A6581 7C72B1D5304D614E58BC0CB8431B9A6581 JF0000000001
FileID02(File02 Alias)
group02 host11:service11(Alias 11)
host12:service12(Alias 12)
Transfer Error (0650,7061) Accumulation Error (7012) Relay 2015/12/15 09:05:24 2015/12/15
09:05:25 0% 0 602 0 694B
064FFC6ECA7B2EBC1D81FCA6491281 694B064FFC6ECA7B2EBC1D81FCA6491281
Figure 3.18 Display example of Transfer Log List (when -list is specified)
"Number of Records" "2"
Figure 3.19 Display example of Transfer Log List (when -csv -count is specified)
COUNT 2
Figure 3.20 Display example of Transfer Log List (when -list -count is specified)
Displayed fields
The following table lists and describes the fields shown in the output example.
|
Field name |
Description |
Display size |
|||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FileID(*1) |
File ID |
308 bytes |
|||||||||||||||||||||
|
Business Group |
Name of the Business Group |
32 bytes |
|||||||||||||||||||||
|
Transfer Source(*1) |
Host name and service name of the Transfer Source |
427 bytes |
|||||||||||||||||||||
|
Transfer Destination(*1) |
Host name and service name of the Transfer Destination |
427 bytes |
|||||||||||||||||||||
|
Transfer Status(*1) |
Status when the data is transferred |
19 bytes |
|||||||||||||||||||||
|
Accumulation Status(*1) |
Status when the data is accumulated |
24 bytes |
|||||||||||||||||||||
|
Type |
Transfer Type
|
7 bytes |
|||||||||||||||||||||
|
Start Date |
The year, month, and date on which the processing was started. Displayed with yyyy/mm/dd format (the leading digits of the month and date are filled with 0). |
10 bytes |
|||||||||||||||||||||
|
Start Time |
The time (hour, minute, and second) on which the processing was started. Displayed with hh:mm:ss format (the leading digits of each value are filled with 0, ignoring milliseconds). |
8 bytes |
|||||||||||||||||||||
|
End Date |
The year, month, and date on which the processing was completed. Displayed with yyyy/mm/dd format (the leading digits of the month and date are filled with 0). |
10 bytes |
|||||||||||||||||||||
|
End Time |
The time (hour, minute, and second) on which the processing was completed. Displayed with hh:mm:ss format (the leading digits of each value are filled with 0, ignoring milliseconds). |
8 bytes |
|||||||||||||||||||||
|
Progress(*2) |
Progress of the processing |
4 bytes |
|||||||||||||||||||||
|
Finished (Byte)(*2) |
The number of bytes when the processing is completed. |
20 bytes |
|||||||||||||||||||||
|
Scheduled (Byte)(*2) |
The number of scheduled bytes when the processing is completed. |
20 bytes |
|||||||||||||||||||||
|
Record Count(*2) |
Record Count |
20 bytes |
|||||||||||||||||||||
|
Latest Identifier |
Latest Identifier |
34 bytes |
|||||||||||||||||||||
|
Starting Identifier |
Starting Identifier |
34 bytes |
|||||||||||||||||||||
|
JobFlowID |
Job Flow ID |
16 bytes |
|||||||||||||||||||||
|
Send File Name(*3)(*4) |
File name of the Send file |
256 bytes |
|||||||||||||||||||||
|
Transfer Type(*3)(*5) |
Transfer data format of the transferred files
|
12 bytes |
|||||||||||||||||||||
|
Encryption Used (*3) |
Encryption type used to encrypt the transfer files
|
8 bytes |
|||||||||||||||||||||
|
Transfer ID (*3) |
Unique identifier issued for each file transfer |
64 bytes |
|||||||||||||||||||||
|
Compression Preference (*3) |
Compression preference for the Send file 'None', 'Horizontal', 'Vertical', 'DEFLATE', or 'Zstandard' |
11 bytes |
|||||||||||||||||||||
|
Code Converted By (*3) |
Code conversion side of the transfer file
|
13 bytes |
|
*1 |
: |
According to Kanji Code Type (KnjCode) in the System Environment Settings, the string is converted to EUC, SJIS, or UTF-8. |
|
*2 |
: |
The values are output in a right-justified and left-zero-filled format. |
|
*3 |
: |
Only output when -csv is specified. |
|
*4 |
: |
If the Send File Name has been dynamically specified at the time of Send File, this will be the specified file name. If the Send File Name was not dynamically specified, this will be the file name specified in the Send Management Information. |
|
*5 |
: |
For a direct transfer, if the sending side client is mainframe, you cannot acquire the transfer type. |
|
*6 |
: |
This is displayed only when differentiation is impossible. |
|
*7 |
: |
This is displayed when you view the conversion history from less than HULFT-HUB Server Ver.3.9. |
Table 3.19 Displayed fields when -csv -count is specified
|
Field name |
Description |
|---|---|
|
Number of Records |
The number of the accumulated data that matches the conditions |
Table 3.20 Displayed fields when -list -count is specified
|
Header name |
Field name |
Description |
|---|---|---|
|
Number of Records |
Number of Records |
The number of the accumulated data that matches the conditions |