SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 51267: Running z/OS V2R1 while accessing DB2 might result in errors

DetailsAboutRate It
An error might occur when you use SAS® 9.3 (any release) or SAS® 9.4 TS1M0 in a z/OS operating environment to access DB2. Information written to the SAS log might look like this:
NOTE: Statements not processed because of errors noted above.
The actual error is not displayed.

If you are running interactive SAS, you might instead receive a pop-up reporting that an out-of-memory error occurred.

This issue occurs when the release of z/OS is V2R1 and the following are true:

  • The tool IGVDGNPP (formerly known as PRIMEPSA) is active.
  • Your SAS code requires SAS to issue a query to DB2 to either retrieve a list of DB2 tables that exist in the library or to retrieve the names and data types of the columns in a DB2 table. Here are some examples of statements that might cause this issue to occur when referencing a DB2 table:
    • Most of the base procedures including CONTENTS, PRINT, FREQ, and so on
    • A SET, MERGE, MODIFY statement
    • Use of dictionary tables

To work around this issue, disable IGVDGNPP (PRIMEPSA).



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.