...

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 Added.

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 EC/ECSAs.

Close Pooled Connections

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

...

...

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

Performance Tuning

The default maximum number of connections on in 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.

...