IBM Support

II14195: DB2 OEM PRODUCTS PROBLEM FIX (CONT. OF II14036) R710 R810 R910 (CONT. IN II14490 )

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

  • DB2 OEM PRODUCTS  PROBLEM  FIX  (CONT. OF II13897, II14039)
    ================= GEPutintsev  05/13/09 =====================
    DTS 31057 Informational Fix
    SYMPTOM: Perf - large consumption of CPU time in DB2 or other
    address spaces that have large numbers of datasets allocated
    to them.  DB2 regions often have upwards of 10,000 datasets
    allocated.  CPU is consumed even if ACC/SRS do not have to take
    any action.
    SOLUTION: Add the DDNAME(MAXSCAN(20)) parameter to the DEFPROD
    statement. This will limit ACC/SRS scan of DD statements to the
    first 20 in the SIOT.  DEFPROD DDNAME(MAXSCAN(20))
    NOTE: MAXSCAN feature is only avail w/release 3.1 or higher.
    ==============JKelly 04/02/2009=================================
    xxxx,ABND=0C4-00000011,U=xxxxxx  ,M=(C),C=910.RDS
    -DSNXACAE,M=DSNTFRCV,PSW=070C3001A7E1EAF8,A=009F
    PSW in .00-*CASR230K/11/07 12.58      < CASR230K +11D8 >
    CA ACF2 CAIENF/DB2 fixes are QO96498 and RO06057
    addl symptoms: FREE PACKAGE with SYSADM authority gets DSNT235I
    ==============MTANG 03/18/2009==================================
    Z1Q3,ABND=B78-00004B2C,U=Z1HRSS02,M=(N),C=810.TMGR-DSNTTRUN,
     M=DSNTFRCV,PSW=070C100081564CCC,A=0062
    Caller(R14) points inside ITH$ENTY.  A few pages up it has
    CA product signature RMID(UDTF388).
    CA recommends applying PTF UDTF389 first, they are still working
    on it.
    ============ MTANG 03/16/2009 ================================
    DB2 subsystem abend with 00F30406, no dump was generated and
    there was no logrec entry.
    The xxxxMSTR never completely went away and caused customer to
    ipl this system. Customer is running DB2 z/OS V9 New Function
    mode at pdo level 0848.
    Problem is from BMC MAINVIEW for DB2, the BMC fix is bpd3122.
    
    ========= TBURCH      02/11/2009 ===============================
    Customer reported multiple hangs in Parallel Threads and they
    were unable to -CANCEL the threads.  Some were DDF threads and
    others were local threads.  The issue ended up being CA
    Detector (PTXMAN) causing loops in their code.  For local
    threads, the loops were in TCB mode, and for DDF threads, the
    loops were in SRB mode.  CA has a fix available UDTF379 that
    fixes the issue.
    ========= GEPutintsev 11/11/2008 ===============================
    Customer reported seeing Parallel =10 on their TMON Reporting
    system though customer had disabled Parallelism across the board
    in DB2 via CDSSRDEF =1, COORDNTR & ASSIST =NO, Bufferpools
    VPPSEQT =0. The customer had Peoplesoft Tuxedo Server connect-
    ivity with NPGTHRSH (&SPRMPTH) reset to =10 to enforce Index
    over Tablespace scan and PARAMDEG =2 and RLF (Resource Limit
    Facility) setup to limit RLFFUNC =3 I/O & =4 CPU Parallelism by
    Authid et.al. By resetting DSNTIPN ZPARM ACCUMACC= NO, it helped
    TMON report non Parallel thread use correctly when these People
    Soft related dynamic application transaction jobs were run
    from workstations.
    .
    =========GEPutintsev 09/22/2008 ==========================
    ABEND04E RC00E20003 DSNGEPLC DSNSVBK +0602  When Computer
    Associates Jobnames DBA5452Q & DBA5452S are running.  Dump shows
    DMTR DSNXKCLO +09B0 and thread executing DSNXKACC Func
    (CLOSEALL) called by vendor module PTACAP CA RMID( UGEF315 ).
    .
    CA's handling of the cursors open in DSNXKAL was incorrect and
    has caused a storage accumulation until the closing of the
    cursors. The associated logic will be reviewed to determine
    best way to correct this.  CA Fix  URMF771  opened.
    .
    When running RC/Migrator analysis with Limited Tree processing
    and no ACM, the cursor logic may tie-up large amount of region
    within the DBM1 address space. This storage is freed when the
    cursors are closed; however, depending on the database numerous
    cursors will be open without freeing the storage associated with
    prior open cursors.
    .
    Monitoring SP229 in the DBM1 address space, shows an increase
    usage without freeing storage associated with prior open cursors
    during the processing in modules RMA@OTCP and RMA@PCAP.
    .
    In extreme situations this has caused the DBM1 address space to
    fail with an s04E and RC00E20003. This may also have caused an
    additional s04E with a RC00E20016.
    =========MMT 09/19/2008==================================
    D99T,ABND=073-00000008,U=SYSOPR  ,M=(N),C=810.IPC -D
    SNYASCP,M=DSNYECTE,PSW=040C10008138F5C0,A=007C
    
    LOGREC has IEAVESLK AB/S0073 PRCS/00000008
    LOCKS HELD: CPU
    This is caused by Computer Associate code and the fix is
    CA ptf USAF114                       (ABEND073)
    
    =========MMT 08/27/2008==================================
    subpool 241 key 7 uses a large amount of CSA/ECSA storage.
    The storage is allocated with '26000'x-sized blocks with
    CPOOL CELL POOL ITH$ENTY as the eye-catcher.
    This is from CA(Computer Associates) and fixed by UDTF353
    There is a new fix UDTF386 for this usage. LJY 04/07/2009
    .
    ================G.E. Putintsev======= 4/04/2008
    In our RDS DB2 Dumps  CACHEDYN =No vs Visual Explain PARM
    showing CACHEDYN =Yes, we're seeing  DASIPT ..Entry Point for
    BMC Module DASDB2A0 Mainview Data Collector related to their
    APPTUNE STC's.  Customer must stop DATA Collector, set the
    CACHEDYN =Y and ensure they are at new BMC version (V6.1.00).
    Apptune is a started task, also known as the Collector.
    APPTUNE  STC 20266 15    EXE PMEA PMEA       APPTUNE - BMC
    APPTUNE  STC 20689 15    EXE DIPF DIPF       APPTUNE - BMC
    APPTUNE  STC 21798 15    EXE DIPH DIPH       APPTUNE - BMC
    APPTUNE  STC 22939 15    EXE DIPG DIPG       APPTUNE - BMC
    APPTUNE  STC 23993 15    EXE DIPL DIPL       APPTUNE - BMC
    APPTUNE  STC 27724 15    EXE DIPE DIPE       APPTUNE - BMC
    .
    Customer must disable BMC APPTUNE to allow dynamic statement
    cacheing to resume and relieve usage for spufi.
    .
     R710 R810
    ===========MMT 12/14/2007=======================================
    DBXQ,ABND=0C4-00000010,U=PRGIFH1
    ,C=XYR00.710.ASMC-DSNVDSRB,DISTRBUTED,LOC=DSNSLD1 .DSNSVSTK+0966
    caused by Computer Associates
    fix is to apply CA PTF UDTF279
    CA issue #16574944-1
    
    ============09/18/2007=================================
    DB2T,ABND=0C4-00000010,U=SYSOPR  ,C=XYR00.710.SSSC
    -DSN3EOTS,M=DSN3AAES,LOC=DSN3EPX .DSNAPRHX+0DC2"
    and
    DB2T,ABND=0C6-00000006,U=SYSOPR
    ,C=XYR00.710.SSSC-DSN3EOTS,M=DSN3AAES,LOC=DSN3AMGP.DSN3CT80+0A9A
    Both are caused by CA code error.
    fixed by CA fix UDTF258
    ================ 9/10/07 =======================================
    ABEND04E RC00F30075 DSN3AUSI with OEM (CA) security.
    ABND=04E-00F30075 LOC=DSN3AMGP.DSN3AUSI+142C
    Systrace entries leading to the 00F30075 during signon
    processing are in CA code.
    .
    | .00u"ACF9CXTR -  |
    | 11/08/06 15.06   |
    |   eTrust CA-ACF2 |
    |   REL 9.0        |
    |      COPYRIGHT ( |
    | C) 2005 COMPUTER |
    |  ASSOCIATES INTE |
    | RNATIONAL, INC.  |
    .
    Customer advised that the CA fix is QO90637.
    .
    ================ 7/10/07 =======================================
    ABEND0D6 RC27 in various csects such as DSNXEEZ after Xmanager
    asid (CA Unicenter Detector) fails with ABEND40D while Detector
    collections are active.  Symptoms may include msg PXM0731 to
    indicate a critical memory shortage in the XManager asid.
    .
    The customer provided CA fix info for CA Detector (PDT) 11.5
    Noted fixes are: UDTF232 & UXMF044
    .
    Additional symptoms may include ABEND04E and ABEND0C4 for DDF
    threads. Also see II14333.
    .
    =================07/08/2006===============================
    DUMP TITLE=DBP4,ABND=0D6-0000002E,U=SYSOPR ,M=(?),C=810.IPC -D
    SNYSIRM,M=DSNYECTE,PSW=077C2000940065CA,A=001A
    DSNV086E #DBP4 DB2 ABNORMAL TERMINATION REASON=00E80100
    IEF450I DBP4MSTR IEFPROC EXEC01 - ABEND=S0D6 U0000
    REASON=0000002E
    .
    "COMPON=SSI,COMPID=5752SC1B6,ISSUER=IEFJSARR,MODULE
     =IEFJRASP,ABEND=S0D6,REASON=0000002E,SNAME=DBP4"
    .
    From PMR findings
    . Found that Linkage second table sequence number for PC
    180000 is overlayed. Absolute address 01F01600 contains the
    linkage second table data 3EBE6EC1 8F6FB0A8. The first word
    identifies valid Entry Table address. The second word should
    be the Linkage Second Table sequence  Second Table sequence
    number, but is overlayed.  Searching storage for the source of
    the overlaying data, found
    0F6FA400.:0F6FAFFF. LENGTH(X'0C00')--All bytes contain X'00'
    0F6FB000   47F0F0A8  D4C8C940  D4C9D4C5  E3C6C9E5
    0F6FB010   E3D7C3C6  F44BF640  40404040  0F6FD658
    0F6FB020   00002740  E3C4F4F6  F0F4F840  D4C9D404
    0F6FB030   00200000  F0F861F2  F261F0F3  F0F84BF0
    0F6FB040   F5404040  00000000  00000000  01CB7700
    0F6FB050   80000000  8F6FB0A8  00000000  00000000
                         --------
    .
    | .00yMHI MIMETFIV |
    | TPCF4.6     .?O. |
    | ... TD46048 MIM. |
    | ....08/22/0308.0 |
    | 5   ............ |
    | .....?.y........ |
    .
    0F6FB060.:0F6FB06F. LENGTH(X'10')--All bytes contain X'00'
    0F6FB070   404D835D  40F2F0F0  F340C396  9497A4A3
    0F6FB080   859940C1  A2A29683  8981A385  A240C995
    0F6FB090   A3859995  81A38996  9581936B  40C99583
    .
    |  (c) 2003 Comput |
    | er Associates In |
    | ternational, Inc |
    .
    This is caused by problem with MIM. The problem was resolved
    by applying MIM fix TD46065
    ABEND0D6 RC2E RC002E RC0000002E PC 00180002
    =================05/17/2007=====================================
    An abend0c4 occurred due to a freed storage area in a DB2 allied
    address space. The address was in an area pointed to in a syslog
    message.
    PDT0102 DETECTOR TERM IN PROGRESS FOR DB2=DSN
    PDT0736 DETECTOR DEFERRED CLEANUP INITIATED DB2=DSN ID=xxxxxxxx
    PDT0733 DETECTOR TERM DELETE SUCCESSFUL ID=710 ADDR=0E513000
    PDT0737 DETECTOR DEFERRED CLEANUP ENDED DB2=D2SNID=xxxxxxx
    COUNT=0000
    Detector r11.5 PTF UDTF230 was provided by the vendor and
    corrected the condition.
    =================05/29/2007=====================================
    abend152 rc102 DT$DIIC8 RMID(UDTF194) Version R11.5
    similar to Hiper UDTF219
    =================04/06/2007=====================================
    pmr36355,180,846
    CADB20?? - The resource entity name is too long
    when using auth exit, since The XAPLOBJN( x'40') and the
    XAPLOWNQ( x'44') are blanks (x'40').
    DDF trace showed that 3rd party application, client, sent in
    a request for '  '.'  ' , (blank  package and collid), and we
    returned -805).
    #rd party software was a client is from company Microfocus
    called Mainframe  Express.
    FIX: RPI 1060469 Sev 1 was raised with Microfocus
    =================07/25/2008=====================================
    DDF DSNL033I DSNLILNR V9
    DB2 V9 customer experienced problem with DDF startup:
    DSNL033I DSNLILNR DDF TERMINATION SCHEDULED DUE TO
    DETECTION OF
    ABEND 0C4
    REASON 00000000
    
    Dump title showed:
    ABND=0C4-00000011,U=SYSOPR  ,M=(C),C=910.DCRM-DSNLILNR,
    M=DSNLFRCV,PSW=077C000000AF79E0,A=0295
    
    The PSW pointed to tso/vtam module called IKTOMLU1.
    SYSTRACE shows many PC/PR coming from storage address
    with module eyecatcher of:
     .00ojMZ1USRHK 20
     070330 14.15 .CO
     PYRIGHT (C) 2007
      MAZDA COMPUTER
     CORPORATION. ALL
    
    Abend in IKTOMLU1 is due to invalid TVWATOMW address. The
    address is 31 bit when IKTOMLU1 is running AMODE 24 RMODE24.
    Branch is from OEM Mazda Computer Corporations module
    MZ1USRHK20. OEM vendor provided a fix for the problem.
    Product is Event Action
    Fix provided was Z70502
    **************** 08/21/08 *******************************
    DB2 V9 subsystem abend 00D95001 on startup with
    CA Top Secret enabled.
    The following msgs were issued just prior to DB2 abend:
    CAS9800I - ENF-DB2 Interface Initialization in Progress
    CADB2002 - DB2 subsystem DB2E now protected by CA-TOP SECRET
    
    SVC dump also produced on startup:
    ABND=0C4-00000004,U=SYSOPR,M=DSN9SCN9,PSW=xxxxxx where xxxx
    points into a CA module CASR230Z. Also eyecatcher of
    CAS9EVT may be seen.
    CAS9EVT DISTUIRB
    JDD .....&0GLCA
    ERROREVT ERROR..
    .{.{.{.{{..0{.*C
    ASR230Z 01/29/07
    
    Logrec may also show an entry for
    DSNFWTO and subfunction MGC WTO SERVICE TASK.
    CA has provided a fix for CA Common
    Services in Q094419
    *********** 09/25/2008 ******************
    ABND=04E-00C200F7,U=xxxxxx,M=(N),C=810.BMC
    -DSNB1GET,M=DSNTFRCV,LOC=DSNBBM.DSNB1GET+1446
    
    Abend happened while image copy was running
    against a tablespace and DB2 found the real page
    number was inconsistent after CA fast load was run.
    Vendor product had run against tablespace.
    CA DB2 R11.5 PTF UFLF238 is in error causing this abend.
    CA fixing PTF is UFLF253
    =================02/13/2009=====================================
    For a description of the problem with DB2 R910 ABENDB00 when
    reading Archive Log data set see the following APAR.
    
    APAR= II14470  SER=                            IN INCORROUT
    DB2 PRODUCT PROBLEM FIX FOR R910 WHEN USING THE OEM CA VTAPE
    PRODUCT FOR DB2 ARCHIVE DATA SETS.
    STAT= INTRAN       FESN5NFO000-000  CTID= II0000 ISEV= 4
    SB09/02/16  RC          CL          PD           SEV= 4
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II14195

  • 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

    2006-07-09

  • Closed date

  • Last modified date

    2009-07-07

  • 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":"BU059","label":"IBM Software w\/o TPS"},"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:
07 July 2009