Logging Netezza Performance Server SQL information on the server
About this task
To log information on the server, complete the following steps:
Procedure
- Using any text editor, modify the file /nz/data/postgresql.conf.
- Add or change the following parameter:
debug_print_query = true - Restart Netezza Performance Server after changing /nz/data/postgresql.conf.
Results
The system writes log information to the /nz/kit/log/postgres/pg.<date>.log file.