This section contains information that is specific to the database type Sybase IQ.

Supported Functions

The Sybase IQ database can be used with:

• Database Table Related Functions (APL)
  

• APL function sqlexec 

• Database Collection/Forwarding Agents

• Event Notifications

• SQL Collection/Forwarding Agents

• SQL Loader Agent

• Task Workflows Agents (SQL)

Preparations

The Sybase JDBC driver that is included in the SDK has to be downloaded to the Platform in order to connect to a Sybase IQ database from Image Modified.

You must proceed as follows:

1. Go to the SAP Software Solutions web page for information about the SDK and included drivers:
   https://www.sap.com/index.html.

2. Place the downloaded jar file in the $MZ_HOME/3pp directory.

3. Restart the Platform and ECs.

Close Pooled Connections

  The   The APL function closePooledConnections enables  enables you to close a pooled connection with the Sybase IQ server. This feature helps you eliminate invalid connections.

int closePooledConnections
     (string dbProfile)

Parameters:

persistent int profileUsageCnt; 
      .... 
      if ( profileUsageCnt > 100 ) { 
         closePooledConnections("sybase_iq.mydb"); 
         profileUsageCnt = 0; 
      }

...

The default maximum number of connections on an Execution Context is five. You can tune this number by setting the Execution Context property sybase.iq.pool.maxlimit in the relevant <pico>.conf file.

$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.sybase.iq.pool.maxlimit 20

...

To specify other timeout values, in milliseconds, set the Execution Context properties in the relevant <pico>.conf file.

$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.sybase.jdbc.socketread.timeout 600000 
$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.sybase.jdbc.socketconnect.timeout 20000