Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

pdlogucat (Display unload log file information)

Function

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.

Executor

HiRDB administrator

Format

 
  pdlogucat [-k {std|csv}] unload-log-file-name
 

Options

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.

Command arguments

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.

Rules

  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.

Notes

  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.

Output format

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, * 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

Note
If there is no information for an item, that item is simply omitted. For example, if the system log run ID (ffffffff) is not available, the display is as follows aaa,bbbbb,cccc,dddd,ee....ee,,gggggggg,...

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