Solving Problems with 32-Bit SAPDBA Access to 64-Bit Software (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Solving Problems with 32-Bit SAPDBA Access to 64-Bit Software

Use

This section tells you how to solve problems occurring between 32-bit and 64-bit software in an Informix environment. SAPDBA, currently 32-bit software, cannot successfully connect to 64-bit software, such as a 64-bit operating system or database, using shared memory.

Prerequisites

The problem occurs in the following situation:

64-bit operating system
64-bit database
32-bit SAPDBA running on the database server with shared memory connection to the database

The database server issues the following error message:

DBA011E: The program could not establish a connection to the database.

sqlerror -25588

The appl process cannot connect to Dynamic server

<host><dbid>shm.

isam error 4:

Interrupted system call

Procedure

When starting SAPDBA, set the environment variable INFORMIXSERVER from shared memory to TCP/IP. See the example below. For more information about environment variables, see Setting Up SAPDBA Environment Variables.

Example

This example shows how to change the environment variable to TCP/IP if you are using the C shell with UNIX:

setenv INFORMIXSERVER <host><dbid>tcp

Caution

Only set the environment variable to TCP/IP while starting SAPDBA. After you have started SAPDBA, set it back to shared memory.