.NET debug logging
You set up .NET debug logging by using the connection URL.
Use the following components in the connection URL. Component names and values are not case sensitive.
- Server
- Enter the IBM® Netezza® appliance host name.
- Port
- Enter the port number. The default is 5480.
- Database
- Enter the database name.
- Username
- Enter your user ID.
- Password
- Enter your password.
- Level
- Enter the log level by using a type or number from the following table, for example,
Level=Debug
orLevel=3
.Table 1. Log level values Level Number Result None 0 Do not log. This is the default. Normal 1 Log only the most common issues. Error 2 Log exceptions. Debug 3 Log everything. - logname
- Enter the path for the log file, for example, c:\logs.
- bulkinsert
- To cause data to be loaded into the table by doing an external load query, enter true; otherwise, enter false.
Separate components with a semicolon. A sample connection string follows:
Server=vmnps-dw1.nzlab.ibm.com; Username=admin;Password=password; Database=system;
Port=5480; SECURITYLEVEL=3; level=3; logname=C:\\NZdotNET_logs;
caCertFile=C:\\test\\working\\cacert.pem;