Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

What DB2 package names are used by DataDirect products?

« Go Back

Information

 
Article Number000023412
EnvironmentProduct: Connect for ODBC DB2 driver, Connect for JDBC DB2 driver, Connect for ADO.NET DB2 driver
Version: All supported versions
OS: All supported platforms
Database: DB2
Application: All supported applications
Question/Problem Description

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

Example:

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.

Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution

The Package Naming Convention is:

DDpiVRMx


This name is derived as follows:

DD -> Static identifier indicating a DataDirect product

p -> product identifier

  • (A) = ADO .NET
  • (J) = JDBC
  • (O) = ODBC


i -> isolation level used (C,S,R,U,N)

  • (C)ommited Read (ANSI): DB2 CS ==> DRDA ISOLLVL CS
  • (S)erializable (ANSI): DB2 RR ==> DRDA ISOLLVL RR
  • (R)epeatable Read (ANSI): DB2 RS ==> DRDA ISOLLVL ALL
  • (U)ncommited Read (ANSI): DB2 UC ==> DRDA ISOLLVL CHG
  • (N)ot committed: DB2 NC (only applies to DB2 on AS400, iSeries) ==> DRDA ISOLLVL NC


VRM -> VersionReleaseModification e.g 210

This is the package version. This does not correspond to the version of the product using the packages.      


x -> Package suffix ( a letter from A-Z ) that differentiates between the packages:

  • A - Package with cursors closed at commit
  • B - Package with cursors held over commit
  • C - Package used for non-prepared stored procedure execution (not created on AS/400)
  • D-Z - Saved for future use. (Static SQL, system queries, etc…)
Workaround
Notes
Attachment 
Last Modified Date8/17/2018 4:24 PM