The pdlogucat command displays information about an unload log file.

You use the pdlogucat command to check the contents of a created unload log file.

HiRDB administrator

(a) -k {std|csv}

Specifies the output format for the information.

std

Output the information in the format of fixed fields with headers.

csv

Output the information in CSV format.

(a) unload-log-file-name ~<path name>

Specifies the absolute path name of the unload log file.

If you are specifying an unload log file created in a HiRDB file system area, the maximum path name length is 167 characters.

1. You can execute the pdlogucat command whether or not HiRDB is active.
2. Execute the pdlogucat command at the server machine where the host containing the unload log file is located.

1. Do not execute the pdlogucat command for an unload log file that is being created by the pdlogunld command or by the automatic log unloading facility. If the pdlogucat command is executed under such circumstances, invalid information may be displayed.
2. For the pdlogucat command, return code 0 indicates normal termination, and return code 8 indicates abnormal termination.

(a) When -k std is specified (output information is fixed-length)

 
Hostname: aa....aa(bbccdd)
File_type  Format_ver  System_id  Unit_id  Serv_name  Run_id    User_run_id  Server_name
Group     Svs_start_time       Gen_num   Unload_time          First_block_num  Buff_leng
Status
eee        fffff       gggg       hhhh     ii....ii   jjjjjjjj  kkkkkkkk     ll....ll
mm....mm  nnnn/oo/pp qq:rr:ss  tt....tt  uuuu/vv/ww xx:yy:zz  AA....AA         BB....BB
CC....CC
 

Note

One line of header text, delimited by a carriage return, is followed by a similarly delimited line of file information.

If there is no information for an item, * is displayed.

If the version of the specified unload log file is earlier than 07-02, an asterisk (*) is displayed for server run ID and file group name.

aa....aa

Host name (up to 32 characters)

bbccdd

Time the pdlogucat command was executed (hour minute second)

eee

File type

sys: System log file

fffff

Internal information used by the system

gggg

HiRDB identifier

hhhh

Unit identifier

ii....ii

Internal information used by the system

jjjjjjjj

System log run ID (hexadecimal)

kkkkkkkk

Server run ID (hexadecimal)

ll....ll

Server name (up to 8 characters)

mm....mm

File group name (up to 8 characters)

nnnn/oo/pp qq:rr:ss

Current system log file allocation time (year/month/date hour:minute:second)

tt....tt

Generation number (up to 8 hexadecimal characters)

uuuu/vv/ww xx:yy:zz

Unload log file creation start time (year/month/date hour:minute:second)

AA....AA

Start log block number (up to 8 hexadecimal characters)

BB....BB

Internal information used by the system

CC....CC

System log unload completion status

completed: Unload log file that has been created correctly

failed: Unload log file whose creation was cancelled

(b) When -k csv is specified (output information is variable-length)

 
aaa,bbbbb,cccc,dddd,ee....ee,ffffffff,gggggggg,hh....hh,ii....ii,jjjjjjjj,kk....kk,
llllllll,mm....mm,nnnnnn,o
 

Note

The null element is displayed for an item for which there is no information. For example, if the system log run ID (ffffffff) is not available, the display is as follows aaa,bbbbb,cccc,dddd,ee....ee,,gggggggg,...

If the specified unload log file is for a version earlier than 07-02, the null element is displayed for the server run ID and for the file group name.

For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.

aaa

File type

sys: System log file

bbbbb

Internal information used by the system

cccc

HiRDB identifier

dddd

Unit identifier

ee....ee

Internal information used by the system

ffffffff

System log run ID (hexadecimal)

gggggggg

Server run ID (hexadecimal)

hh....hh

Server name (up to 8 characters)

ii....ii

File group name (up to 8 characters)

jjjjjjjj

Current system log file allocation time (Julian seconds, in hexadecimal)

kk....kk

Generation number (up to 8 hexadecimal characters)

llllllll

Unload log file creation start time (Julian seconds, in hexadecimal)

mm....mm

Start log block number (up to 8 hexadecimal characters)

nnnnnn

Internal information used by the system

o

System log unload completion status:

0: Unload log file that has been created correctly

1: Unload log file whose creation was cancelled