Versions Compared

Old Version 3

changes.mady.by.user Jenni Wallin

Saved on

compared with

New Version 4

changes.mady.by.user Jenni Wallin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Note
title

Note!

The Sybase IQ database type requires jConnect v16.0 and later. 

Supported Functions

The Sybase IQ database can be used with:

  • Audit Profile

  • Database Collection/Forwarding Agents

  • Event Notifications

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. Follow these steps to set up the Sybase JDBC driver on the Platform:

  1. Set up a persistent file system.

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

  3. Copy the downloaded jar file to the $MZ_HOME/persistent/3pp folder on the plaform-0 pod. 

Info

...

Example - Copy the Sybase JDBC

...

File into the

...

themeEclipse

...

Directory

$ kubectl cp jconn4.jar

...

platform-0:/opt/mz/persistent/3pp

...

-n

...

<namespace>

  1. Restart the platform and EC pods.

Info

...

Example - Restart the

...

Platform and EC

...

themeEclipse

...

Pods

$ kubectl delete pod platform-0

...

-n

...

<namespace>

  1. Restart the Desktop.

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.

Note
title

Note!

This function only closes inactive connections, regardless of how long the connections have been idle.  

Code Block
theme
languagetextEclipse
int closePooledConnections
     (string dbProfile)

Parameters

Returned Value

Description

dbProfile

The name of the database where the table is stored, preceded by the folder name.

title
Info

Example - Using APL function closePooledConnections

Code Block
languagetext
themeEclipse
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 EC.

title
Info

Example - Setting the maximum number of connections for Sybase IQ

Code Block
languagetext
themeEclipse
For Helm deployed ECs, in values.yaml add at:
systemProperties:
  - config.properties.sybase.iq.pool.maxlimit=20

For ECs deployed in Desktop Online, add:
EC Deployment, Execution Context, Configure EC: System Properties: Add -> 
config.properties.sybase.iq.pool.maxlimit=20 

Deploy the EC again either in Desktop Online or with:
$ kubectl delete pod <ec-pod> -n <namespace>

By default there is no timeout value defined for the socket tied to a database connection. This means that a running query could get stuck, in case the database suddenly becomes unreachable. To specify a timeout value, in milliseconds, set the Execution Context property sybase.jdbc.socketread.timeout .

Info
title

Example - Setting the timeout for a socket tied to a Sybase IQ connection

Code Block
languagetext
themeEclipse
For Helm deployed ECs, in values.yaml add at:
systemProperties:
  - config.properties.sybase.jdbc.socketread.timeout=600000 

For ECs deployed in Desktop Online, add in:
EC Deployment, Execution Context, Configure EC: System Properties: Add ->
config.properties.sybase.jdbc.socketread.timeout=600000 

Deploy the EC again either in Desktop Online or with:
$ kubectl delete pod <ec-pod> -n <namespace
title
Note

Note!

When using the timeout property you must ensure that you set a limit that exceeds your longest running query, otherwise you might terminate a connection while it is executing a query.

...