on 06-30-2009 3:39 PM
We have the following connection defined in DBCO:
AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;
When we check this connection via ADBC_TEST_CONNECTION we get the error:
B Connect to <con_name> as <user_name> with AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;
C Secondary DB connect, user <user_name>
C Environment: AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;
C *** ERROR => CPDA0FF occured. Refer to job log.
[dbsldb4dbi.c 474]
C *** ERROR => === Secondary DB connect FAILED! ===
[dbsldb4.cpp 15683]
C *** ERROR => === Connection settings ===
[dbsldb4.cpp 17806]
C *** ERROR => connected = FALSE
[dbsldb4.cpp 17807]
...
C *** ERROR => ===========================
[dbsldb4.cpp 17849]
B ***LOG BYI=> connect failed for connection DEPLIS [dbds#1 @ 1052] [dbds 1052 ]
B ***LOG BZY=> unexpected return code 8192 calling DBACDS [dbacds#2 @ 1471] [dbacds 1471 ]
In SM21 - system log - we have 2 entries:
Connect to the databzse with ID <con_name> failed
Unexpeted return value 8192 when calling up DBACD
Any idea on how we can solve this?
Hello together,
I know it's a pretty old discussion but we're facing a similar issue right now with a newly created dialog instance - CI connection is fine, dialog instance is throwing the exact same error as mentioned above.
How did you solve the problem?
Thanks & regards
Marie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Marie,
it's been a while since I've configured once this szenario on our server:
there are some sapnotes:
http://service.sap.com/sap/support/notes/523381
and
http://service.sap.com/sap/support/notes/146624
is your dialog-instance on IBM-i ?
HTH
Christoph
Hi Christoph,
thanks for the quick reaction.
The SAP system is running on AIX 6.1 with DB2 LUW 10.5 FP4.
Thank you for mentioning note 146624 - I've checked the xdnxdaapi* and dbdb4slib* libraries in all possible exe directories of the DI - they exist in the same version as on the CI.
The only difference I see now, is that the CI has the full DB2 software package installed where the DI only had the CLI driver. We've already installed the DB2 Runtime Client for LUW in Version 10.5.4 on the DI server, hoping it might help - still getting the same error.
I couldn't find any documenation or note on how to setup such a connection in a multi-instance environment...
I asked our customer to check the target database - I'm afraid there might be some restrictions like max. connections or the like that keep disturbing the connection.
I just answered to this old discussion, because I hoped someone would remember how the problem had been solved back then...
I'll let you know as soon as I've got any news.
Thanks & regards
Marie
Hi Marie,
you should be aware of, that this threat was for DB4 and not DB2 ...
Therefore, the XDN stuff and the dbdb4slib information is wrong for you ...
You should try to ask your question in the DB6 area (DB2 LUW for windows & linux & AIX).
Regards,
Volker Gueldenpfennig, consolut international ag
Hi,
our szenario:
we read some data from the source system (non-SAP) into our SAP-BW on IBM-i:
target-system: SAP-BW on IBM-i and IBM DB2-for-i (DB2/400)
source-system IBM-i and IBM DB2-for-i (DB2/400) with some legacy-Data (non-SAP)
so we did on the source-system
- restored the kernel-library SAP<SID>IND (copy of the library from the SAP-BW system)
- created a CLP-batchjob SBMJOB CMD(CALL XDNSTART) , that causes a running XDNLISTEN-Job
SBMJOB | CMD(CALL PGM(&KERNELLIB/XDNLISTEN) + | |
PARM('-tf/tmp/XDNTrace')) JOB(XDNLISTEN) + | ||
JOBD(QBATCH) JOBQ(QSYS/QUSRNOMAX) LOG(4 + | ||
*JOBD *SECLVL) ALWMLTTHD(*YES) | ||
Subsystem/Job Benutzer Art CPU % Funktion Status .
QUSRWRK QSYS SBS 0,0 DEQW
XDNLISTEN QSECOFR BCH 0,0 PGM-XDNLISTEN TIMA
i do not know, if on DB6 is a corresponding thing like XDNLISTEN
Christoph
see SAP note 751451: the product version of qxdaedrs.dll should be the same as your AS/400 product version + iSeries Access should be installed on the SAP server (see also: http://www-01.ibm.com/support/docview.wss?uid=nas2137f687b04e98914862570f20041f23b)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.