The DB packages used by the .Net, ODBC and JDBC all follow a single naming convention. Using the formula below, you can check to see whether the packages exist on the database by looking for the package names in the DB2 system catalog tables.
The default DB2 catalog tables containing package details are:
DB2 for UWL - SYSCAT.PACKAGES
DB2 for z/OS, OS/390 - SYSIBM.SYSPACKAGE
DB2 for iSeries, AS400 - QSYS2.SYSPACKAGE
To check for the existence of the packages used by the ODBC driver when connected to DB2 on Solaris, issue the following SELECT statement:
SELECT "NAME" FROM SYSIBM.SYSPLAN WHERE CREATOR = 'NULLID' AND (NAME = 'DDOU510A' OR NAME = 'DDOU510B' OR NAME = 'DDOC510A' OR NAME = 'DDOC510B' OR NAME = 'DDOR510A' OR NAME = 'DDOR510B' OR NAME = 'DDOS510A' OR NAME = 'DDOS510B' OR NAME = 'DDON510A' OR NAME = 'DDON510B')
Please see the DB2 documentation for the column definitions of the result set that is produced from this query.