
B-4 20751-12 Rev.5
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide
loggertype
You can set the following case-insensitive log format types:
loggertype=text (Default)
loggertype=html
logdirpath
You can set the directory path for the log files, as in the following:
logdirpath=<path on the local file system>
The default values for logdirpath are as follows:
Windows: C:\
UNIX/Linux: /tmp/
Connection String Examples
Separate connection string components with a semicolon, as in the following examples:
jdbc:netezza://<host>/<database>;user=<username>;password=<password>;
loglevel=<log level>;logdirpath=<log directory>
UNIX logdirpath:
jdbc:netezza://tom/will;user=admin;password=password;loglevel=2;
logdirpath=/jdbc_log_file
Windows logdirpath:
jdbc:netezza://tom/will;user=admin;password=password;loglevel=2;
logdirpath=C:\
OLE DB Debug Logging
OLE DB debug logging is set up via the connection URL with the following components:
Provider — Enter NZOLEDB
User ID — Enter your user ID
Password — Enter your password
Data Source — Enter the Netezza appliance hostname
Initial Catalog — Enter the database name
Port — Enter the port number (default is 5480)
Logging Level — Enter 1 to enable logging or 0 for no logging
Log Path — Enter the path for the log file (for example, c:\logs)
Separate components with a semicolon, as in the following example:
Provider=NZOLEDB;User ID=<UserID>;Password=<Password>;Data
Source=<npshostname>;Initial Catalog=<database name>;Port=5480;Logging
Level=1;Log Path=c:\logs
Comentários a estes Manuais