ERROR: The SAS/ACCESS Interface to DB2 cannot be loaded. The SASDBU code appendage could not be load

[kumarsandip975]

We recently upgraded SAS 9.4 M8 to M9, and we are facing issue with DB2 connection from SAS Studio to MF connection. 

103 PROC SQL;
104 CONNECT TO DB2 (schema = "_PDUSER");
ERROR: The SAS/ACCESS Interface to DB2 cannot be loaded. The SASDBU code appendage could not be loaded.
ERROR: A Connection to the DB2 DBMS is not currently supported, or is not installed at your site.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
105 CREATE TABLE extractt
106 AS SELECT * FROM CONNECTION TO DB2 (
107 SELECT name, creator, dbname, tsname
108 FROM sysibm.systables
109 where creator='SYSIBM'
110 )
111 ;
NOTE: Statement not executed due to NOEXEC option.
112 %PUT &SQLXMSG &SQLXRC;
ERROR: A Connection to the DB2 DBMS is not currently supported, or is not installed at your site. -1

[Ksharp]

1) firstly using the following code to check whether you have license to " SAS/ACCESS Interface to DB2" .

proc setinit; run;


2)Re-install your DB2 client software.

[LinusH]

As an addition to @Ksharp tips, also run PROC Product_Status. It will give details on what is actually installed.

[kumarsandip975]

Original site validation data

Current version: 9.04.01M9P060525

Site name: 'xxxx'.

Site number: xxxx.

CPU A: Model name='' model number='' serial=''.

Expiration: xxx2026.

Grace Period: 0 days (ending xx2026).

Warning Period: 15 days (ending xxx2026).

System birthday: xxxxx2026.

Operating System: WX64_SV .

Product expiration dates:

---Base SAS Software 30NOV2026 (CPU A)

---SAS/STAT 30NOV2026 (CPU A)

---SAS/GRAPH 30NOV2026 (CPU A)

---SAS/ETS 30NOV2026 (CPU A)

---SAS/FSP 30NOV2026 (CPU A)

---SAS/AF 30NOV2026 (CPU A)

---SAS/IML 30NOV2026 (CPU A)

---SAS/CONNECT 30NOV2026 (CPU A)

---SAS/EIS 30NOV2026 (CPU A)

---SAS/IntrNet 30OCT2026 (CPU A)

---MDDB Server common products 30NOV2026 (CPU A)

---SAS Integration Technologies 30NOV2026 (CPU A)

---SAS/Secure 168-bit 30NOV2026 (CPU A)

---SAS/Secure Windows 30NOV2026 (CPU A)

---SAS Enterprise Guide 30NOV2026 (CPU A)

---SAS/ACCESS Interface to DB2 30NOV2026 (CPU A)

---SAS/ACCESS Interface to Oracle 30OCT2026 (CPU A)

---SAS/ACCESS Interface to PC Files 30NOV2026 (CPU A)

---SAS/ACCESS Interface to ODBC 30NOV2026 (CPU A)

---SAS/ACCESS Interface to Microsoft SQL Server 30NOV2026 (CPU A)

---SAS/ACCESS Interface to MySQL 30OCT2026 (CPU A)

---SAS/IML Studio 30NOV2026 (CPU A)

---SAS Workspace Server for Local Access 30NOV2026 (CPU A)

---SAS Workspace Server for Enterprise Access 30NOV2026 (CPU A)

---High Performance Suite 30NOV2026 (CPU A)

---SAS Add-in for Microsoft Excel 30NOV2026 (CPU A)

---SAS Add-in for Microsoft Outlook 30NOV2026 (CPU A)

---SAS Add-in for Microsoft PowerPoint 30NOV2026 (CPU A)

---SAS Add-in for Microsoft Word 30NOV2026 (CPU A)

74

75 PROC Product_Status; run;

For Base SAS Software ...

Custom version information: 9.4_M9

Image version information: 9.04.01M9P060425

For SAS/STAT ...

Custom version information: 15.4

For SAS/GRAPH ...

Custom version information: 9.4_M9

For SAS/ETS ...

Custom version information: 15.4

For SAS/FSP ...

Custom version information: 9.4_M9

For SAS/AF ...

Custom version information: 9.4_M9

For SAS/IML ...

Custom version information: 15.4

For SAS/CONNECT ...

Custom version information: 9.4_M9

For SAS/EIS ...

Custom version information: 9.4_M9

For SAS/IntrNet ...

Custom version information: 9.4_M9

For SAS Integration Technologies ...

Custom version information: 9.4_M9

For SAS/Secure 168-bit ...

Custom version information: 9.4_M8

For High Performance Suite ...

Custom version information: 2.2_M10

For SAS/ACCESS Interface to DB2 ...

Custom version information: 9.4_M3

For SAS/ACCESS Interface to Oracle ...

Custom version information: 9.50

For SAS/ACCESS Interface to PC Files ...

Custom version information: 9.4_M9

For SAS/ACCESS Interface to ODBC ...

Custom version information: 9.4_M9

For SAS/ACCESS Interface to MySQL ...

Custom version information: 9.41_M3

NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

76

77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

[Eddie305]

Please verify whether you can login DB2 database by DB2CLI first. This will help to isolate the problem is from SAS side or from DB2 client side.

If you are on AIX or unix, please login to the console by account 'sas' first and then validate the DB2CLI functionality.

Also suggest opening the TS log if it is not DB2 client problem.

[kumarsandip975]

Hey, Is this version issue, seems during M9 upgrade, it did pick the correct version .

For SAS/ACCESS Interface to DB2 ...
Custom version information: 9.4_M3

[Ksharp]

Since you already have "SAS/ACCESS Interface to DB2", I think you should try to reinstall DB2 client software and make a connected string again.

[kumarsandip975]

I was doing mistake, I had forgot to make sandwich (RUBMIT, ENDRSUBMIT), as I am connecting from SAS Studio to MF, now seems okay. Can somebody suggest about warning message.   

NOTE: Remote signon to XXXX complete.

"-------------------------"

"INFO - Successfully connected to : XXXX"

"-------------------------"

77 RSUBMIT;

NOTE: Remote submit to XXXX commencing.

1 PROC SQL;

2 CONNECT TO DB2 (schema = "_PDUSER");

DB2 NOTE: The QUERYNO for the EXPLAIN is 2283370

DB2 WARNING: Some connection options are not valid and will be ignored with explicit pass-thru. Some options currently supported

include SSID, SERVER, DEGREE, and READBUFF. Some options currently ignored include AUTHID and IN.

3 CREATE TABLE extractt

4 AS SELECT * FROM CONNECTION TO DB2 (

5 SELECT name, creator, dbname, tsname

6 FROM sysibm.systables

7 where creator='SYSIBM'

8 )

9 ;

NOTE: Table WORK.EXTRACTT created, with 285 rows and 4 columns.

10 %PUT &SQLXMSG &SQLXRC;

0

11 QUIT;

NOTE: The PROCEDURE SQL used the following resources:

CPU time - 00:00:00.00

Elapsed time - 00:00:00.03

EXCP count - 140

Task memory - 3965K (1651K data, 2314K program)

Total memory - 21006K (6688K data, 14318K program)

Timestamp - 2/28/2026 1:10:34 PM

NOTE: The address space has used a maximum of 1060K below the line and 28652K above the line.

12 RUN;

NOTE: Remote submit to XXXX complete.

[Ksharp]

That does not mean anything. It just told you there are some options the DB2 engine doesn't support.