Problem Note 51267: Running z/OS V2R1 while accessing DB2 might result in errors
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
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2013-10-09 13:48:59 |
Date Created: | 2013-10-07 12:50:29 |