Problem Note 56387: Attempting to use the bulk-load utility to load data into a DB2 table might result in an error
 |  |  |  |  |
You might receive errors if you specify BULKLOAD=YES in the LIBNAME statement or as a data set option when trying to load data into a DB2 table. The errors vary by the release of SAS that is running.
With SAS® 9.3 TS1M2
DSNU032E I/O ERROR ON WORKFILE ,DB210WLM,DB210WLM,8528,D,SYSREC ,READ ,NO ERROR STATUS,00000DA8000001,BSAM DSNU040I 033 11:28:37.45 DSNUGSDA - ERROR ACCESSING DDNAME SYSREC, DECB=X'4100000000800000000441382273F000000442F8' DSNU016I 033 11:28:37.47 DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40071'
With SAS® 9.4 TS1M2
NOTE: Traceback called NOTE: Module Function Offset Line NOTE: -------- -------- ------ ---- NOTE: SASVM VMZABND 0000A8 0 NOTE: SASVM VMZCMBN 000118 0 NOTE: SASVM VMFREE 00038E 0 NOTE: SASDB2BS D2BSCLS 000078 0 NOTE: SASIODB2 @@636394 0001E2 0 db2m_load NOTE: SASIODB2 @@010036 000100 0 db2m_file_close NOTE: SASXDBI DBICLOS 000096 0 NOTE: SASXDBI YOECLOS 000218 0 NOTE: SASYOIO YOCLOSE 0010DE 0 NOTE: SASYH YORCLNP 00051A 0 NOTE: SASYH YHCSTEP 000068 0 NOTE: SASXKERN YAKREXT 00095E 0 NOTE: SASVT VTRDEL 0001BE 0 NOTE: SASHOST HANDLER 0003AA 0 NOTE: SASHOST VHSIGNL 0000FA 0
There is no known workaround other than not using the BULKLOAD=YES option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M2 | 9.4 TS1M3 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/S59.html#56387A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J41.html#56387| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-09-24 12:45:03 |
| Date Created: | 2015-08-10 13:20:23 |