Nonstop Database, HiRDB Version 9 UAP Development Guide
The command trace facility outputs a client's trace information to the command trace file when a command is executed by a UAP (during the execution of the COMMAND EXECUTE SQL statement).
When the command trace file becomes full, the facility overwrites the oldest information.
You can obtain command trace information by specifying appropriate values in PDCLTPATH and PDCMDTRACE in the client environment definitions. For details about each client environment definition, see 6.6 Client environment definitions (setting environment variables).
Two command trace files named pdccmd1.trc and pdccmd2.trc are output to the specified directory.
Command trace information is output when a command is executed by a UAP. The following shows sample command trace information and explains each item:
** COMMAND TRACE (CLT:06-00:Jan 11 2001) HP32 ** [1] USER APPLICATION PROGRAM FILE NAME : TESTAP [2] COMMAND START TIME : 2001/01/11 10:55:27 [3] COMMAND EXECUTE ENVIRONMENT & STATUS : [4] PDASTHOST(dcm3500) PDASTPORT(20266) PDSYSTEMID("HRD1") PDUSER("hirdb") PDASTUSER("hirdb ") PDCMDWAITTIME(0) ENVGROUP("") CLTPID(9155) CLTTID(0) [5] [6] [7] [8] [9] 9155 0 2001/01/11 10:55:27 0 pdhold -r RDDATA01 9155 0 2001/01/11 10:55:27 1 KFPZ02444-E Communication error, func=connect, errno=2
If the command trace file becomes full while writing command trace information, HiRDB continues output using another command trace file. In this case, existing contents of the command trace file are overwritten, beginning with the oldest information. Therefore, you should make a backup copy of a command trace file when the UAP is terminated.
To determine the command trace file that is being used currently, check the most recent update dates/times of the files. The command trace file that was updated most recently is the current file.
For a Windows edition HiRDB client, you use the dir command or the Explorer to check the file update dates/times.
For a UNIX edition HiRDB client, you use the OS's 1s -1 command to check the file update dates/times.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.