Database operating system
The dbos.log file records information about the SQL plans submitted to the database server and also the restarting of the dbos process.
Log files
- /nz/kit/log/dbos/dbos.log
- Current log
- /nz/kit/log/dbos/dbos.YYYY-MM-DD.log
- Archived log
Sample messages
2012-12-12 18:12:03.258402 EST Info: NZ-00022: --- program 'dbos' (25991) starting
on host 'nzhost' ... ---
2012-12-12 18:12:03.321092 EST Info: cacheDir=/nz/data.1.0/cache cacheImg=/nz/data
.1.0/cache/cache_img.txt m_size=52190 m_numDirs=307 m_ROWSIZE=170 m_planHistFiles=
2000
2012-12-12 18:17:38.713027 EST Info: plan queued: planid 1 tx 0x189402 cli 1 uid 1
001 sid 16056 pid [29672] (run 0/1)
2012-12-12 18:17:38.713306 EST Info: plan prep : planid 1 tx 0x189402 cli 1 uid 1
001 sid 16056 pid [29672] (run 0/1)
- Plan ID
- The plan number queued or started. This number relates to the corresponding execution plan in the /nz/data/plans directory. The system increments it for each new portion of SQL processed and resets it to 1 when you restart the system.
- Q ID
- The queue to which this plan was assigned.
- Tx ID
- The unique transaction identifier.
- cli
- The ID of the client process.
- UID
- The unique ID of the dbos client. Every time a client connects it receives a unique number.
- SID
- The ID related to the ID returned from the nzsession.
- PID
- The process ID of the calling process running on the Performance Server host.