Customizing the Netezza Environment

In this section:

The Adapter for Netezza provides several parameters for customizing the environment and optimizing performance.

Top of page
x
Specifying a Timeout Limit

How to:

TIMEOUT specifies the number of seconds the adapter will wait for a response after you issue an SQL request to Netezza.

x
Syntax: How to Issue the TIMEOUT Command
ENGINE SQLNEZ SET TIMEOUT {nn|0}

where:

SQLNEZ

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

nn

Is the number of seconds before a time-out occurs. 30 is the default value.

0

Represents an infinite period to wait for a response.
Top of page
x
Cancelling Long Requests

How to:

You can cancel long running requests from the Web Console. Depending on the capabilities of the native JDBC driver, this action will either cancel the request entirely or break out of the fetch cycle.

x
Procedure: How to Cancel Long Requests
  1. From the Web Console menu bar choose Workspace, Configuration/Monitor, Java Services, DEFAULT. Right-click on DEFAULT and select Agents.
  2. In the Java Services Agents pane, highlight a row with the jscomid you wish to kill, right-click on it and select Stop.
Top of page
x
Obtaining the Number of Rows Updated or Deleted

How to:

PASSRECS returns the number of rows affected by a successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.

Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
x
Syntax: How to Obtain the Number of Rows Updated or Deleted
ENGINE SQLNEZ SET PASSRECS {ON|OFF}

where:

SQLNEZ

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

ON

Provides the number of rows affected in the application program SCB count member after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.

OFF

Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.
Top of page
x
Controlling HOLD DBMS Creation

How to:

An extension of the HOLD AS dbms_name FORMAT SQLNEZ syntax enables you to exercise more precise control over the creation of HOLD DBMS tables.
x
Syntax: How to Control DBMS Creation 
HOLD [AS dbms_name] FORMAT SQLNEZ [CONNECTION conn_name]

where:

dbms_name

Is the DBMS table to create. It may be a one, two, or three part name, using the separator appropriate to the DBMS, typically a dot (.).

conn_name

Is the DBMS connection name. When multiple DBMS connections have been configured and are in use, conn_name specifies which connection to use.

Note: If a table exists with the same name and connection, it will be dropped.
Example: Creating a Netezza Table

The following command creates a Netezza table named DBCS_NEZ using connection CON1:

ON TABLE HOLD AS DBCS_NEZ FORMAT SQLNEZ CONNECTION CON1
WebFOCUS