Problem Note 3050: Problems running DB2 Version 6
Running DB2 Version 6 with SAS/ACCESS to DB2 may result in errors if
the program or SAS (as a result of your program) issues either a
COMMIT WORK or a ROLLBACK. The two most common errors are:
ERROR: Unable to perform a COMMIT WORK sqlcode = -2147334.
or:
ERROR: DB2 execute error DSNT408I SQLCODE = -804, ERROR: AN ERROR
WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE
SQL STATEMENT, REASON 04
The reason code may be different. A Reason 06 has also been seen.
A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#003050
A hot fix is not available for Release 8.0 TSLEVEL M0. However you can
download a fix from the web at the following URL:
ewe3.sas.com/techsup/download/mvs
The fix contains a replacement module for SASIODB2. There is a readme
file that describes the steps you must take.
The files for the fix are as follows:
Version of SAS replacement module readme
----------------- ------------------ ------------------
Release 8.0 TS M0 V6COMMIT_80.EXE V6COMMIT_80.readme
Even after applying the fix you may encounter a IBM problem if you are
running with an access method of RRS. You may receive a -925 if the
first statement you execute upon connecting to DB2 is either a ROLLBACK
or a COMMIT WORK. If you happen to do anything prior to a ROLLBACK or
a COMMIT WORK it should work. The text of the error is:
ERROR: COMMIT NOT VALID IN IMS OR CICS ENVIRONMENT
This problem is corrected in Release 8.2 TSLEVEL 2M0 and beyond.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 8.2 TS2M0 |
*
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 |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2002-04-16 12:25:46 |
| Date Created: | 2000-07-14 14:45:54 |
