DB2 as source system to BI

[Former Member]

I try to set up a DB2 (os/390) as source system to BI 7.00. But it fails, in the wp trace I find this information:

B Connect to DB2TEST as ELMARK with SSID=NO153DH3T,PORT=3450,SAPDBHOST=x.x.x.x,SCHEMA=ELMARK

C dbs/db2/use_accounting != 1 -> DB2 accounting is switched off

C dbs/db2/use_drda_lob_handling != 1 -> SAP LOB handling is used

C dbs/db2/opt2_hint = 0 -> implicit 'optimize for 1 rows' is switched on

C dbs/db2/rs_by_hint = 1 -> isolation level RS by hint is switched on

C dbs/db2/chaining = 0 -> CLI CHAIN optimization is switched off

M

M Wed Oct 15 10:02:01 2008

M *** ERROR => DlLoadLib: LoadLibrary(db2cli64.dll) Error 126 [dlnt.c 237]

M Error 126 = "The specified module could not be found."

C Could not load DB2 library db2cli64.dll. No database connection possible.

B ***LOG BYI=> connect failed for connection DB2TEST [dbds#1 @ 1052] [dbds 1052 ]

I can't find any notes matching. Any idea of what fails here?

Regards,

Asbjorn

[Former Member]

Hello

we have the same problem.

the problem is a security-problem that the user SAPServiceSID isn't in the group DB2ADMNS.

After Restart Service and SAP the db2-connect runs fine

regards Siegfried Dörfler / W&W-Informatik