Usage Note 10509: ERROR: CLI error trying to establish a connection when attempting to use
multiple DB2 connections in SAS 9
The following error message may be issued when using DB2 version 8 and
SAS 9.0 (and SAS 9.1) with multiple connections to DB2.
ERROR: CLI error trying to establish connection: [IBM][CLI Driver]
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005
This problem occurs on Unix and PC systems using DB2 version 8.1.0.8
with SAS 9.0.
The following steps demonstrate how to replicate this problem:
1. Create an autoexec.sas containing the following LIBNAME statement:
libname db_core db2 userdb2usr password=db2usr1 database=db2db
schema=db2schema;
2. Invoke SAS 4 (sometimes 5) times using the same autoexec.
To resolve this problem, apply DB2 V8 FixPack2:
ftp://ftp.software.ibm.com/ps/products/db2/fixes/english-us/db2sunv8/fixpak/FP2_U486567/
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | 64-bit Enabled Solaris | 9 TS M0 | |
| Solaris | 9 TS M0 | |
| Microsoft Windows XP Professional | 9 TS M0 | |
| 64-bit Enabled AIX | 9 TS M0 | |
| 64-bit Enabled HP-UX | 9 TS M0 | |
| HP-UX | 9 TS M0 | |
| AIX | 9 TS M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2003-09-04 16:28:46 |
| Date Created: | 2003-07-28 14:02:14 |
