View previous topic :: View next topic |
Author |
Message |
Dragon_Lee Beginner
Joined: 13 Feb 2006 Posts: 31 Topics: 17
|
Posted: Sat Aug 14, 2010 5:02 am Post subject: Error happens when binding DSNTIAUL to DB2 for AIX |
|
|
Hi all,
I got an error when binding the DSNTIAUL to a DB2 server (AIX DB2) in a DRDA system, the DB2 requester is DB2 V8 for z/OS, and DB2 server is AIX DB2 V9.1.
The error message is as below:
DSN
BIND PACKAGE(DB2 Server.Collection Name) MEM(DSNTIAUL)
CURRENTDATA(NO) ACT(REP) ISO(CS) ENCODING(EBCDIC) SQLERROR(CONTINUE)
LIB('DSNDB2.DBRMLIB.DATA') DBPROTOCOL(DRDA)
DSNE932I WARNING, ONLY IBM-SUPPLIED PACKAGE-IDS SHOULD BEGIN
WITH "DSN"
DSNT408I SQLCODE = -30020, ERROR: EXECUTION FAILED DUE TO A
DISTRIBUTION PROTOCOL ERROR THAT CAUSED DEALLOCATION OF THE CONVERSATION: REASON 124C (011D)
DSNT233I -DB2T UNSUCCESSFUL BIND FOR
PACKAGE = DB2 Server.Collection name.DSNTIAUL.()
DSN
Can anyone please advise me what the problem is and how to solve it? Thanks. _________________ Dragon |
|
Back to top |
|
 |
Nic Clouston Advanced
Joined: 01 Feb 2007 Posts: 1075 Topics: 7 Location: At Home
|
Posted: Sat Aug 14, 2010 5:29 am Post subject: |
|
|
Did you look at the DB2 Messages and Codes for the error code? It redirects you to another manual which is not available via the 'Quick Manuals' link above. However, you can then go and search the IBM manuals site for the referred to manual.
The SQL and Reason Code seems to indicate a syntax error on the local system. _________________ Utility and Program control cards are NOT, repeat NOT, JCL. |
|
Back to top |
|
 |
Dragon_Lee Beginner
Joined: 13 Feb 2006 Posts: 31 Topics: 17
|
Posted: Sat Aug 14, 2010 6:32 am Post subject: |
|
|
Hi Nic,
Yep, I referred to the DB2 Messages and Codes (http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.codes/n30020.htm) and it directed me to the reference of 'Distributed Data Management (DDM) Architecture' (http://www.db.opengroup.org/bookstore/catalog/c068.htm), I also looked up this manual for SYNERRCD and SYNTAXRM, and still could not figure out what the problem is and how to fix it.  _________________ Dragon |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
Dragon_Lee Beginner
Joined: 13 Feb 2006 Posts: 31 Topics: 17
|
Posted: Sat Aug 14, 2010 9:45 pm Post subject: |
|
|
THat's it. Thanks Kolusu a lot.  _________________ Dragon |
|
Back to top |
|
 |
|
|