Error logs

You can view the error logs to identify errors that occur during any database operations, and view information about the success or failure of these operations. By default the log files are created under tmp in the root directory.

While writing data to the Netezza Performance Server by using the nzload method, log files such as nzlog and nzbad files are created in the /tmp directory on the client computer. The nzlog file is upended for every nzload command that loads the same table into the same database.

The nzbad files contains the records that caused the errors. The system overwrites this file each time you invoke the nzload command for the same table and database name. The following names are used for the log files:

  • /tmp/database name.table name.nzlog
  • /tmp/database name.table name.nzbad

While writing data to the Netezza Performance Server by using the External Table method, the log files are created in the /tmp directory in the Netezza Performance Server. The following names are used for the log files:

  • /tmp/external table name.log
  • /tmp/external table name.bad