IBM Support

DB2 High Performance Unload for z/OS fails with USER 1017 abend

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 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.

  • 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.

[{"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"}}]

Document Information

Modified date:
11 February 2021

UID

swg21567911