Is it also V9.7 on the systems that connect to dev and test
V9.7 GA'ed 10 years ago and have been out of support for a few
years, so if you end up opening a PMR you would be told to
If you have a Db2 monitor you may try to capture what's
happening on the z side, including any negative SQL codes from
authorization issues, stored procedures not running, etc.
You can also enable ODBC trace on the client side.
I ran an SQL trace with IBM Omegamon Db2 while accessing Db2
I notice a number of packages being accessed:
In addition, a number of procedures are being called:
There are several other SQL% procedures in the SYSIBM. schema.
You might want to check if they are all running and that all
associated DSNA% packages are valid and operative.
In Reply to william giannelli:
it seems the application is using a v9.7 ODBC driver. Could this
be the issue?
77 Fourth Avenue • Waltham, MA • 02451 •
E: [login to unmask email] • W:
2019 IBM Champion.
Views are personal.