How to bind a zOS Table
I am trying to AddTables to CLM V4.0.5, the first being JTS, I am getting the Database connection but then a : 2014-01-29 09:54:09,957 CRJAZ1365I The server is attempting to connect to the following database: "//wtsc47.itso.ibm.com:38460/DB1R:user=xxxxxxxx;password=xxxxxxxx;"
2014-01-29 09:54:10,842 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2 for DB2 UDB for z/OS
Db Product Version: DSN11015
Db URL: jdbc:db2://wtsc47.itso.ibm.com:38460/DB1R:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.65.102
2014-01-29 09:54:11,259 ***** Out of Package Error Occurred (2014-01-29 09:54:11.252) *****
Exception stack trace:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB1R.NULLID.SYSLH200.5359534C564C3031;DISTSERV;04, DRIVER=3.65.102
This is a brand new V11 Build. The sys prog thinks it has do with DB2 Connect but I don't believe that. In goggle there is alot of distributed bind commands which should resolve a SQLCODE=-805, SQLSTATE=51002, but this is a zOS and I see no SYSLH200 in any of the build jobs.
2014-01-29 09:54:10,842 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2 for DB2 UDB for z/OS
Db Product Version: DSN11015
Db URL: jdbc:db2://wtsc47.itso.ibm.com:38460/DB1R:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.65.102
2014-01-29 09:54:11,259 ***** Out of Package Error Occurred (2014-01-29 09:54:11.252) *****
Exception stack trace:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB1R.NULLID.SYSLH200.5359534C564C3031;DISTSERV;04, DRIVER=3.65.102
This is a brand new V11 Build. The sys prog thinks it has do with DB2 Connect but I don't believe that. In goggle there is alot of distributed bind commands which should resolve a SQLCODE=-805, SQLSTATE=51002, but this is a zOS and I see no SYSLH200 in any of the build jobs.