Question & Answer
Question
How can I correct the DB2® High Performance Unload for z/OS® (DB2 HPU) USER 1017 abend?
Cause
The USER 1017 abend is a secondary abend that is explained in the "User abend codes" section of the DB2 HPU user's guide:
A subtask abended, which resulted in a general abend. Examine the error messages that were issued for the original abend (for example, B37 issued by a SORT utility).
Answer
Review messages that were issued before the USER 1017 abend. Consider the following suggestions as possible solutions:
- If USER 1095 abend was issued before the USER 1017 abend, the USER 1095 is likely from DFSORT.
- If you are running SYNCSORT 1.4, and the following SYNCSORT-generated message is issued, the problem was resolved by the SYNCSORT fix for SR #577931, fix EW69290.
WER999A VNSLDU05,STEP010 , - UNSUCCESSFUL SORT 8ED U
Contact SYNCSORT, and request the fix for SR #577931, fix EW69290.
In collaboration with their z/OS-Syncsort support technician, some users have disabled this SVC by passing the ?SVC=0? parameter to Syncsort. Disabling this SVC prevented the Syncsort abend 2285. Then, the users were able to progress with their ORDER BY test cases, although they were not running with the optimal Syncsort performance.
If you are using DFSORT and you are using any software that either reduces or increases file allocations, such as Tivoli Allocation Optimizer, you might see the following messages:
GLO2123I UMILP0S2,DWNBJQ,,T003WK11,SYS11365.T232110.RA000
GLO2128I DATA SET SUCCESSFULLY EXTENDED TO VOLUME TMP044 -AOPT
The USER 1095 abend is issued because the external software was doing ADDVOL processing on DFSORT WORK data sets.
The following text is copied from information APAR II14047, which was created to help explain some of the interactions and considerations when DFSORT is run with DB2.
5. Exclude SORTWK*, STATWK*, DATAWK*, DAnnWK*, STnnWK*
and SWnnWK* datasets from any OEM products that
reduce space allocations.
Exclude the DFSORT work data set names to prevent the USER 1095 abend.
[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 High Performance Unload","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"3.2.0;4.1.0;4.2.0;4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 February 2021
UID
swg21567911