IBM Support

PM77125: ABENDX37 FOR THE ADBIN DDNAME IN EXEC ADBTSIN WHEN RUN PROGRAM ADBTEP2 WITH LARGE TAPE INPUT FILE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool for z/OS fails with abendb37 or similar
    abendx37 symptom when running WSL in batch with large TAPE input
    file. Error messages appear similar to:
    .
    10.15.19 JOB11273 *IEF233A M 69A0,B68040,,QCPDG08M,DEV1STAT
    10.15.35 JOB11273  IEC030I B37-04,IFG0554A,QCPDG08M,DEV1STAT,
      ADBIN,3619,D53619,SYS12317.T101521.RA000.QCPDG08M.R0357171
    .
    RUN  PROGRAM(ADBTEP2) PLAN(ADBTEP2)    LIB('<hlq>.SADBLLIB')
    PARMS('/WORKLIST(DB2BATCH) SSID(ssid) MAXE(-1)  RESTRT(NO)')
    .
     IRX0250E System abend code B37, reason code 00000004.
     IRX0255E Abend in host command EXECIO or address environment
              routine TSO.
     IRX0670E EXECIO error while trying to GET or PUT a record.
     ADBTSIN: Error writing to  ADBIN return code  20
    .
    ** ADBTEP2 Id: 10.1 D2443625.APR.12 10.23.07
    ADB5003E A failure occurred attempting command %ADBTSIN
       FILE(ADBIN)
         COPYDD(SYSIN)TRACE(O)..
     ADB5185E The run is ending due to errors.
     ADBT010W - Rollback performed due to previous error
    .
    Additional search keywords: msgirx0250e msgirx0255e
       msgirx0670e msgadb500e3 msgiec030i rc04 rc20
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who run Work Statement List (WSL) in    *
    *                 batch with a large removable media           *
    *                 ( aka TAPE/CART ) input file.                *
    ****************************************************************
    * PROBLEM DESCRIPTION: The DB2 Administration Tool for         *
    *                      z/OS fails with abendb37 or similar     *
    *                      abendx37 symptom when running WSL       *
    *                      in batch with a large removable         *
    *                      media ( aka TAPE/CART ) input file.     *
    *                      Error messages appear similar to:       *
    *                                                              *
    *                      IEC030I B37-04,                         *
    *                      IFG0554A,QCPDG08M,DEV1STAT,             *
    *                      ADBIN,3619,D53619,SYS12317.T101521.     *
    *                      RA000.QCPDG08M.R0357171                 *
    *                                                              *
    *                      RUN PROGRAM(ADBTEP2)                    *
    *                        PLAN(ADBTEP2)                         *
    *                        LIB('>hlq<.SADBLLIB')                 *
    *                        PARMS('/WORKLIST(DB2BATCH)            *
    *                        SSID(ssid) MAXE(-1) RESTRT(NO)')      *
    *                                                              *
    *                      IRX0250E System abend code B37,         *
    *                                reason code 00000004.         *
    *                      IRX0255E Abend in host command          *
    *                                EXECIO or address             *
    *                                environment routine TSO.      *
    *                      IRX0670E EXECIO error while trying      *
    *                                to GET or PUT a record.       *
    *                      ADBTSIN: Error writing to  ADBIN        *
    *                                return code  20               *
    *                                                              *
    *                      ** ADBTEP2 Id: 10.1 D2443625.APR.12     *
    *                      ADB5003E A failure occurred             *
    *                      attempting command                      *
    *                      %ADBTSIN FILE(ADBIN)                    *
    *                      COPYDD(SYSIN)TRACE(O)                   *
    *                      ADB5185E The run is ending due to       *
    *                      errors.                                 *
    *                      ADBT010W - Rollback performed due       *
    *                      to previous error                       *
    *                                                              *
    *                      Additional search keywords:             *
    *                      msgirx0250e msgirx0255e msgirx0670e     *
    *                      msgadb500e3 msgiec030i rc04 rc20        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The DB2 Administration Tool for z/OS fails with abendb37 or
    similar abendx37 symptom when running WSL in batch with a
    large removable media ( aka TAPE/CART ) input file.  The
    estimation of space for file ADBIN is not correct when SYSIN
    is large and on the TAPE.
    

Problem conclusion

  • Problem has been resolved.  For the large input file, please
    note that users need to enlarge the space of DD SYSPRINT,
    ADBDIAG and ADBRPTSM in the step which invokes ADBTEP2 to
    avoid B37 errors since there is large data output to these
    files.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77125

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-14

  • Closed date

    2013-03-15

  • Last modified date

    2013-04-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK92561 UK92562

Modules/Macros

  •    ADBTSIN
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK92561

       UP13/03/19 P F303

  • RA20 PSY UK92562

       UP13/03/19 P F303

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 April 2013