z/OS DB2 SQLERRMC=SQLTABLES fix
If when you connect to your DB2 database can see this error:
DB2 SQL Error: SQLCODE=-443, SQLSTATE=38112, SQLERRMC=SQLTABLES;SQLTABLES;-805
Probably you have an error on the stored procedures. You can rebuild all procedures and databases running the DSNTIJSG DB2 installation JOB.
This JOB is located in this dataset:
Or if not exist you can try:
DSNXXX -> XXX is the DB2 version installed, for example.
DB2 9.1 -> DSN910 DB2 8.1 -> DSN810
If when you submit the job, it exits with this error: VENDOR.PROCLIB you can simply remove this entry from the DSNXXX JCLLIB ORDER and resubmit.
Now should work like a charm. :-)