The following error message may be issued when attempting to connect to DB2 using SAS/ACCESS® Interface to DB2.

ERROR: Error allocating CLI environment.

This error indicates that the DB2 environment set-up is not set up correctly when using SAS/ACCESS Interface to DB2.

1. The System Requirements *MUST* be met to ensure the proper software products are installed and used. Specifically, the 64-bit DB2 Client Libraries.
2. The Configuration Guide instructions must be followed and the appropriate environment variables must be set and set correctly.

      LD_LIBRARY_PATH, LIBPATH, SHLIB_PATH must be set to point to 
      the 64-bit DB2 Client Libraries.  A common error is that this
      environment variable is pointing to 32-bit libraries and should NOT be.  It should be pointing to 64-bit libraries.
   

3. With a 64-bit DB2 installation, the server must be configured as a 64-bit instance as well, in order to use SAS/ACCESS Interface to DB2 with SAS 9.

The only way we know 100% that SAS/ACCESS Interface to DB2 will work on 64-bit machines is to have a 64-bit instance/client. There may be other configurations that might work but they have not been tested.

The following cat and ls commands can assist in determining whether a DB2 instance is a 32-bit or a 64-bit instance.

   unix_prompt> cat $INSTHOME/sqllib/ctrl/.instuse
   unix_prompt> ls $INSTHOME/sqllib/cfg/*.lvl

   root@f03l01
   (/)# cat /home/inst04/sqllib/ctrl/.instuse
   BitWidth=32
   INSTVER=81
   DB2DIR=/usr/opt/db2_08_01
   InstanceType=4

   root@f03l01
   (/)# ls /home/inst04/sqllib/cfg/*.lvl
   /home/inst04/sqllib/cfg/db2admcl.lvl
   /home/inst04/sqllib/cfg/db2rtcl.lvl

BitWidth=32 indicates that you are accessing a 32-bit instance. To update an instance to a 64-bit instance, you can issue the following DB2 command. This *MUST* be done by your site's DBA and more details or explanations on this must be addressed with your DB2 DBA. These are DB2 commands and must be addressed with DB2.

   db2iupdt -w 64 instance_name

Your DBA should be familiar with this. SAS 9.x requires a 64-bit client component. Apparently, the DB2 default installation (even on the 64-bit platforms) is a 32bit instance. However, it needs to be a 64-bit instance with a 64-bit Client using SAS 9.

The instance_name would just be another user on the machine that will "own" the 64-bit instance. All they really need is a 64-bit client that points to their 32 bit instance.

Operating System and Release Information