Setting up RTC with DB2 on Z/OS causes an error

Spencer Murata (2.3k●11●59●71) | asked Apr 08 '13, 3:10 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

When installing RTC with DB2 I get the following error:

The log from the BLZCREDB job cotains:

... 190 more

Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][

3.63.131] Invalid parameter: Unknown column name TABLE_SCHEM.

ERRORCODE=-4460, SQLSTATE=null

at com.ibm.db2.jcc.am.fd.a(fd.java:663)

at com.ibm.db2.jcc.am.fd.a(fd.java:60)

at com.ibm.db2.jcc.am.fd.a(fd.java:103)

at com.ibm.db2.jcc.am.gb.a(gb.java:2095)

at com.ibm.db2.jcc.am.vn.a(vn.java:1855)

at com.ibm.db2.jcc.am.vn.getString(vn.java:1698)

com.ibm.team.repository.service.db.provider.AbstractDbProvider.getSche

mas(AbstractDbProvider.java:770)

com.ibm.team.repository.service.db.provider.AbstractDbProvider.doesTa

bleExist(AbstractDbProvider.java:373)

What causes this error? How can I install?

One answer

permanent link

Spencer Murata (2.3k●11●59●71) | answered Apr 08 '13, 3:11 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

Try the following to workaround the problem:

1) Ensure that the DSNZPARM DESCSTAT is set to YES.

2) Refresh the WLM application environment:

V WLM,APPLENV=<wlmenv>,REFRESH

3) Re-run the DSNTIJMS install job

~Spencer