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:
DSNXXX.NEW.SDSNSAMP(DSNTIJSG)

Or if not exist you can try:
DSNXXX.SDSNSAMP(DSNTIJSG)

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. :-)