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.
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:
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:
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/ACCESS Interface to DB2
8 TS M0
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
A fix for Release 8.1 (TS1M0) for this issue is available at: