IBM Support

II14620: DB2 OEM PRODUCT PROBLEM INFO (CONT OF II14490) (CONT IN II14701 )

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • INTRAN

Error description

  • ========== Min-Mei Tang 07/14/2013 ================
    DB2 cannot start, keep abending with 00E80084.
    Once customer shut down vendor TMON product, DB2 can come up.
    =========  Tim McAllister  11/13/2012  =====================
     SVM4922S EXTENT WILL EXCEED THE 4GB LIMIT
     IEC070I 034(004)-220
     DSNP011I  @DBGPROD DSNPXTN0 - MEDIA MANAGER SERVICES ERROR
       MMRC=8 DSMRC=00D70014
    .
     BMC APAR BAG4211:
     =============
     StopX37/II was obtaining the current CI count for a VSAM
     dataset from the AMB for determining the available CI count
     before a non-EA (extended addressability) dataset reached
     the 4GB limit.  The CI count in the AMB was no longer valid
     in a DB2 environment and StopX37/II now obtains this value
     from the last EDB entry.
    .
    ======== Georgann Putintsev 11/01/2012 =====================
    This issue occurred with Attunity (using odbc connections to
    get from the remote Attunity services of the MF) to DB2 z/OS.
    If customer gets SQLCODE-805 on DSNAOCLI Reason:03
       BIND PLAN(DSNACLI)                   -
       BIND PACKAGE (DSNAOCLI) MEMBER(DSNCLIMS) -
         ENCODING(EBCDIC) SQLERROR(CONTINUE)       << change
    .
     Followed by IFI306/IEF450I-U0921 on Attunity Job/Task requiring
     complete load library replacements from V5.3.2.39 to V5.3.3.6.
     This code level is good for DB2 V8 or later.
    .
     For any client environments that connect to DB2 V10 -- the
     customer had to add a "tempfeature" to the bind: cdcDB2Version
     with a value 10.
    .
    ======== Min-Mei Tang 06/06/2012 ====================
    After an abend S522 in a batch job, DB2 hangs.
    ABND=522-00000000,C=XYR00.910.UTIL-DSNUT910,M=DSNUGBAC,
    LOC=DSNUT910.DSNUBBID+5696
    DSNR048I messages show backout stalled.
    The dump taken after the hang occurred show that DB2 buffer
    mgr is suspended in DSNB1SSR waiting for I/O after the abort.
    It turns out this is caused by CA. Fix is RO4600
    logrec shows SA$CID(vendor PTXMAN) in the timeframe when
    DB2 buffer mgr write engine started to wait for I/O.
    =========  Georgann Putintsev 5/29/2019 ============
    The loop issue identified by IBM is resolved by PTF BPU4733.
    Seen in Dump as | x4..IODXAOBJ 20110912-09.48 PTF BPU4163  |.
    CPU time can increase and the abend can occur in rare situations
    with object collection active for DB2 10, due to incorrect pro-
    liferation of object entries.  This PTF insures that the object
    entries are generated correctly.
    .
    The proliferation of object entries is the cause of the high CPU
    utilization in module IODXAOBJ.  This proliferation is based on
    the content of a particular field in DB2 storage, which changed
    in DB2 v10.  When it is 0 (usual case), processing is normal.
    When it is non-zero (seen in rare cases), the object
    proliferation and resulting high CPU usage is the result.
    ===============================================================
    ====== 05/08/2012 Michal      ======
    LOOP in DIST caused by BMC:
    04-011C 097A1580  EXT   1005 077C2001 BB6BD20C  00001005
    04-011C 097A1580  SSRB       077C2001 BB6BD20C  00000000
                                                    00000000
    04-011C 097A1580  EXT   1005 077C1001 BB6BD1FE  00001005
    04-011C 097A1580  EXT   1005 077C2001 BB6BD20C  00001005
    04-011C 097A1580  EXT   1005 077C1001 BB6BD206  00001005
    04-011C 097A1580  EXT   1005 077C1001 BB6BD202  00001005
    04-011C 097A1580  EXT   1005 077C2001 BB6BD20C  00001005
    04-011C 097A1580  EXT   1005 077C2001 BB6BD20C  00001005
    04-011C 097A1580  EXT   1005 077C2001 BB6BD20C  00001005
    
    address points to:
    3B6BD0F0 12FF07FE A7F40015 0088E5C1 D3D3C5D5 | ....x4...hVALLEN
    3B6BD100 404040F2 F0F1F1F0 F8F1F060 F1F54BF5 |    20110810-15.5
    3B6BD110 F140D7E3 C6C2D7E4 F4F0F3F9 4040EBEC | 1 PTFBPU4039  ..
    
    IODX8
    
    It is fixed by fixed by PTF BPU4439 and it's prereqs (BMC
    provided PTF)
    
    
    
    
    
    
    
    ====== 04/30/2012 SL Kragness ======
    
    All BMC Apptune users must have BMC-fix-BPU4440 applied to avoid
    CPU spikes when running DB2 10 for z/OS
    
    ==========Min Mei Tang 04/13/2012
    COMPID=SC1CJ,COMPON=CONTENTS SUPERVISOR,ISSUER=CSVFRR,0F4-04
    Dump shows sp6 (subpool6) key8 has many 2000x-byte-sized blocks
    The fix is from vendor SAS, SAPBD54 and SAPBD55.
    
    ====== 03/09/2012 MA Ritosa ======
    Customers using the DB2 external security
    exit may see DSNX210I reached AEXITLIM when
    running BMC Load/Loadplus jobs.
    LOGREC will show several abend 0C4-10 from DSNX@XAC
    and 0C4-11 from RACF IRRRFC27 ICHRAU03.
    
    Dump title for RACF similar to:
    ICHRST00-RACF SVCS,ABEND CODE=0C4-011,SVC=IRRRFC27
    ..... EXIT=ICHRAU03
    
    The DB2 external security exit dump will be
    similar to this:
    COMPON=DB2 ,COMPID=5740DRE00,ISSUER=DSNX@FRR,MODUL
    E=DSNX@XAC,ABEND=S00C4,REASON=00000010,L=xxxxxx
    
    The above dumps will be associated to BMC LOAD
    utility. Dumps indicate the ACEE has been freed
    or deleted during processing.
    BMC has provided PTF BPJ0544
    ============= Swathi Venugopal 03/01/2012=================
    ABEND04E RC00E20017 ,U=CICSPRDJ,M=(N),C=910.SMC
    -DSNSFSTK,M=DSNTFRCV,LOC=DSNSLD1 .DSNSTACK+036E
    While freeing stack segment address of segment to be freed
    contained zeroes
    BMC resolved issue by fix ptf BPU4624 for Apptune
    Keywords : DSNSTACK OFFSET036E 04E 00E20017
    ============= Min-Mei Tang 02/27/2012============
    ABEND04E RC00E20017,M=(N),C=910.SMC
    -DSNSFSTK,M=DSNTFRCV,LOC=DSNSLD1 .DSNSTACK+036E"
    The forward link is wrong(off by 10) in the save area stack
    and there is eye-catcher DIS8 next to the forward link in
    F4SA.
    BMC has provided a fix BAU4598
    =========== PH 23/01/2012 =====================================
    Looping Distributed Stored Procedure
    BMC APPTUNE V6.2 module, BPU4439 Pre Reqs BPU4431 and its
    description is that it resolves a High  CPU issue which IBM
    is most likely referring to. The APAR for BPU4439 is
    BAU4386 - QM1728402: HIGH CPU UTILIZATION FOR DB2 V8 TRIGGER
    PACKAGES
    ============GS 12/03/2011=======================================
    ABEND878-10 in DBM1. High usage of SP230 K7 filled with SMS
    pools and
    messages from DTS Software's SMS Debug Product:
    .
    C9C7C4D4   C3E2C3F2   40D4E2C7   40C3C5D3   | IGDMCSC2 MSG CEL |
    D340D7D6   D6D34040   C9C7C4D4   C3E2D4C7   | L POOL  IGDMCSMG |
    008B0000   0098F018   003F0800   00000000   | .....q0......... |
    9005F. LENGTH(X'30')--All bytes contain X'00'
    00000000   C1C3C3F0   F3F7F5F1   605C40C4   | ....ACC03751-* D |
    D5C4E2F0   C84040E2   C7E3C4C2   F2F9F340   | NDS0H  SGTDB293  |
    40F6F4F9   F9C4F9C5   F24040E2   C5C34040   |  6499D9E2  SEC   |
    4040F5F0   F04040F5   F3F1F1F0   40404040   |   500  53110     |
    4040F000   00000000   00000000   00000000   |   0............. |
    .
    Fix available from DTS vendor to not use the same CPOOL buffer
    as BMC's StopX37 product.
    ==============KF 10/28/2011=====================================
    DSNJ012I DSNJOFF1 ERROR rc00D10264 READING RBA.
    .
    This message was issued because DSNJW407 detected that the RBA
    in CI that it is trying to write is lower than the previous log
    RBA. Discovered that this was zDMF issue and OA37851 will fix.
    Look for the zDMF message starting GZD prefix (like DEN for DB2)
    around the time when the log became bad.
    Please note that although this informational APAR is updated
    to alert the customers, zDMF is IBM product outside of DB2.
    ==============KF 10/07/2011============================
    ABEND0C4 RC00000010 in LOADMOD DSN9SCN9
    .
    PSW was pointing to OIHIP900 for BMC APPTUNE.
    BMC issue 3838029 resolved the issue.
    
    =============KF 09/15/2011======================================
     Hang thread. The customer observed hang thread when they are
     shutting down. The stack trace showed it called CA exit.
     RO31202 was identified as a fix for this condition from CA
    
    ============== Min-Mei Tang 08/12/2011=======================
    Customer reported that their SQLPL native SQL procedure(run as
    a batch job, not running in WLM) appears to be hung. The calling
    chain is DSNXEBR  +25E6 06/03/11UK68467
    DSNXRRTN +1346 06/28/11UK69248
    DSNXESPL +23E 03/04/11UK65480
    Systrace shows looping in vendor code.  Vendor fix is BMC
    Apptune BPU4035.
    ============ Min-Mei Tang 07/12/2011 ==========================
    The following abends occurred every few hours and crashed DB2.
    DB2 ,ABND=0C4 00000038 ,U=nnnnn   ,M=C8 ,C=101.SMC
    -DSNSFBLK,M=DSNTFRCV ,LOC=DSNSLD1 .DSNSFBK +07E8
    DB2 ,ABND=0C4 0000003B,U=rrrrrr  ,M=C8 ,C=101.BMC
    -DSNB1GET,M=DSNTFRCV ,LOC=DSNIDM  . DSNB1SPF +0580
    DB2 ,ABND=04E 00E2000F ,U=xxxxxx  ,M=C8 ,C=101.SCC -DEALLOC
    ,M=DSNTFRCV,LOC=DSNTADL .DSNSVSFB+0858
    Turning off BMC MainView product resolved the problem.
    The BMC fix number is BMC APPTUNE PTF BPU3772
    ============== Min-Mei Tang 07/08/2011 ==================
    DB2 encountered 00E20016 abend due to one huge stack at a size
    of 1G+. The huge stack is from recursive calls from DSNIOPNP,
    DSNIOPPS, DSNB1OPS, DSNB1OPP, DSNIPPHO, DSNIBMCL repeatedly.
    The root cause is from BMC REORG and BMC LOAD changed the
    header page HPGDNUMB to a wrong value.
    This is caused by BMC's fix ptf BPJ0402.
    The fix for this BPJ0402 is BPJ0468.
    A bypass is for customer to run IBM REORG to create correct
    header page.
    ============07/01/2011 Min-Mei Tang===================
    ABND=0C4-00000011,,M=(N),C=910.SSSC-DSNAPRHX,
    M=DSNAPRHX,LOC=DSNWVSR1.DSNWVSR1+0040DSNWVSR1
    The area pointed by EBSKB is clobbered(32 bytes):
    EBSKB=7F553000
    7F553000   67000084   B8D10080   010100D7   80000000
    7F553010   8F8A3000   00000000   00000000   8E5E8803
    7F553020   7F5533D8   00000000   7F5533D8   00000000
    7F553030   7F553000   00000000   00000000   00000278
    The abending job is CA Analyzer, the ACEE length is
    miscalculated. The CA fix is RO32270 and RO32271 for CA R14.5
    CA Quick Copy, CA Rapid Reorg(Online), CA Recovery, CA LOG
    Analyzer are affected.
    ============ 06/07/2011 Min-Mei Tang================
    ABND=04E-00D10266,U=SYSOPR  ,M=C9 ,C=101.RLMC-BFR-WRT
    ,M=DSNJW008,LOC=DSNJL002.DSNJW107+2CDE
    due to vendor BMC overlaid DB2's log buffer, field LRHRUID in
    the second segment is overlaid
    7E50A06B                               00   74006B06
    7E50A070   0000190E   A1BC3407   A1BC3407   5EACC800
                          |||||||||||||||||||
    7E50A080   00072607   5EACC800   00C7DDEC   14AF5C00
    7E50A090   00100007   32290000   00030040   5EACC7F9
    Other symptoms can be:
    ABND=04E-00D10331,U=xxxxxxx ,M=C9 ,C=101.LOCN
    =::10.40.20.22      ,LOC=DSNJL002.DSNJR103+061C"
    ABND=0C4-00000004,U=xxxxxxx ,M=C9 ,C=101.GCPC
    -DSN9CMD ,M=DSN9SCN9,LOC=DSN9PREP.DSN9SCNP+043A"
    ABND=04E-00D10265,U=SYSOPR  ,M=C9 ,C=101.RLMC
    -BFR-WRT ,M=DSNJW008,LOC=DSNJL002.DSNJW107+2CDE"
    The product signature of vendor:
    | .00..PMDX0A1RV1
    | 0R1    20110302
    | 22.31 BMCPMD1
    | ----- -------
    |  (C) COPYRIGHT
    |2000-2011.  BMC
    |SOFTWARE, INC.
    see pmr 40687,370,000 and 11674,122,000, and 40781,370,000
    L2: check LVALBUFF second segment lrhruid
    then search systrace for 7E50A if the segment prefix is 7E50A.
    BMC fix is bpu3793 and also to apply bpu3794 to
    prevent another potential overlay possibility...
    Both fixes are BMC latest release of POOL ADVISOR product
    ========== 04/19/2011 MinMei Tang =======
    ABND=878-00000010,U=SYSOPR
    ,M=(N),C=810.RLMC-DSNJDS04,M=DSN9SCN9, then
    ARCHLOG2 failures
    DSNJ114I  -DB2U ERROR ON ARCHIVE DATA SET, OFFLOAD CONTINUING
    WITH ONLY ONE ARCHIVE DATA SET BEING GENERATED
    The VSMDATA report shows SP50 Key7 took largest amount of
    storage. This is from vendor CA-1 product.
    CA: "20230096 01 - DB2 ARCHIVE LOGS ON VIRT TAPE"; per CA
    RO24270 for 11.5 and RO24271 for rel 12.0 will resolve
    the storage problem.
    ===============SLKragness 03/09/2011============================
    DB2 DDF startup never completes.
    Logrec shows ABEND0C1(s) in IEFW21SD.IEFAB42A leading
    to 04E-ABEND04E-00E50013 for DDF startup.
    The valid return address (31-bit) will be contained in Reg 14
    but will be truncated in the PSW (24-bit).
    Customer has resolved this issue with CA-MainView fix BPG6300.
    Contact Vendor for more details.
    ===============Yi Bu Li 09/27/2011==============================
    ECSA storage usage keep increasing and the customer has to
    re-IPL the lpar to release the ECSA storage.  CA finally owned
    up to being at least partially responsible for the storage
    growth (workload increasing is another cause).
    The CA description is CA Detector for DB2 for z/OS (PDT) may
    cause Extended CSA to grow when certain combinations of Stored
    Procedures and CPU parallelism are encountered.
    SYMPTOMS: Growth of Subpool 241, Key 7, as measured by MVS
    monitors.
    IMPACT: Eventual exhaustion of ECSA may cause an unplanned
    system outage.
    CIRCUMVENTION: Stop the Detector collection to reclaim
    the ECSA storage.
    The PTF is RO32543.
    =============JAK 01/13/2012=====================================
    abend0c4  0C4-3B  DSNXERD+0001 for all SQL calls after fallback
    from V10 (RA10 R910 R810)
    PC number, 001B7901,  has an entry point address pointing in
    code owned by STRSSA (Compuware STROBE SQL Agent)
    with eyecatchers: SSIB STRB
    Vendor recommends bring up Strobe with parm DB2SSAHOOK=NO as
    the "permanent fix".
    =============JAK 01/13/2012=====================================
    abend0c4  CADB2SEC CBAV130  ~RMID(RO25437)~ 20101216 11.44
    CA fixes:  RO24834 , RO31202, and RO33061
    

Local fix

  • N/A
    

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II14620

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    INTRAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-10

  • Closed date

  • Last modified date

    2013-07-14

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 July 2013