IBM Support

II09269: DB2 OEM PRODUCTS, PROBLEM, FIX (CONT. OF II07352 ) BUGS IN IRLM AND DB2 (CONT. IN II10649 )

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as canceled.

Error description

  • (II09269 last updated 12/19/97 plb)
    Lists DB2 IRLM OEM products, problem, fix (Cont. II07352)
    Search arguments: 5740XYR00 r230 r310 r410 SASS/C PRECOMPILER
                      569516401 r101
    ================================================================
    2/05/96 JK
    DB2 UNAVAIL RESOURCE TYPE 802 RC=00E30083
    DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED B
             00000802, AND RESOURCE NAME BINDLOCK
    DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE
    DSNT415I SQLERRP    = DSNXEAAL SQL PROCEDURE DETECTING ERROR
    VALID = 'N' in sysibm.sysplan and/or sysibm.syspackage
    causing autobind on 1st execution.
    Log Analyzer found that  BMC Load Utility ("Load Plus") was
    invalidating the plans on every load...
    ================================================================
    An abend0c4 or abend0c1 can occur when csect dsnpams2 +6b0
    branches to AMS. Register 9 contains the address of dsnpams2 +0,
    register 14 contains the location of dsnpams2 +6b2 and register
    15 contains the 31 bit address of csect FASTVSAM. The psw shows
    24 bit addressing mode. A fix is available from FASTVSAM. THE
    fix number is EWV0647.
    ================================================================
    DUMP00 TITLE= ABEND04E RC00C90105 U=DEFLID  ,COMP=XYR00.310.DMC
                 -DSNIISRT,M=DSNTFRCV,LOC=DSNIDM  .DSNISMRS :0CA4
    VRACE0CA4   ERQUAL0CA4
    DB2 is trying to obtain a Space Map page in the wrong Partition.
    This problem occurs running BMC REORG PLUS for DB2 (Index)
    beginning with Rel. 3.3.00 and fixed in V4.1 (1995).
    BMC REORG PLUS tracking number: 232802
    ================================================================
    ABEND0F8 RC10 or RC14 in STERLING NETMASTER
    Lmod CNNNETV, module NM000S35 V320 +X'47C' did SVC in FRR mode.
    STERLING is preparing a FIX.
    ----5/23/96---------------------------------------------------
    DB2 R410 experiencing shortage of CSA when using BMC products
    Load Plus, Reorg Plus and Recovery Plus. Use procedure listed
    in II05506 to determine if there was an unconditional request
    for SP241 below the line. Refer to BMC ticket numbers 285822
    and 289633 for more details. BMC fix was issued 5/13/96 on
    latest release of the above products for use with DB2 V4.1.
    08/21/96 Update (storage growth in sp241-7) for DB2 v4:
       Further analysis for another one of these problems shows
    many x'4000' byte blocks obtained for locks via DSNSFBK
    for CT's showing eye catchers of BMCARU (Reorg Plus) and
    BMCAMU (Load Plus). Excessive 4k blocks obtained in sp241-7
    storage.
    ---6/4/96-----------------------------------------------------
    DB2 R410 or R310 can get abend0c7 or abend0c4 with unknown
    module from:  SPUFI, any command such as DISPLAY or running job
    DSNTEP2 when using Omegamon monitor and MVS/ESA 5.2.2. Need to
    have Omegamon at fix level QD2D076.
    --------------------------------------------------------------
    06/12/96 - CICSMON with DB2 r310
    --------------------------------------------------------------
    Landmark's CICSMON product has been reported to create a
    CSA shortage which can prevent DB2 from terminating. The
    CICSMON maintenance was in a May '96 CUM tape. No fix or
    problem number info is available at this time.
    --------------------------------------------------------------
    06/20/96 - BMC LoadPlus or backlevel BMC product with DB2 v4
    --------------------------------------------------------------
    Two problems worth noting:
    1) DB2 short (or abbreviated) EB. The EB's length may be x'98'
    bytes...somewhat shorter than x'100' bytes for v4.
    Dump Title: DSN ,ABND=04E-00E50006,U=CA03    ,C=XYR00.410.SMC
                 -DSNSGPOL,M=DSNSVPL ,LOC=DSNSLD1 .DSNSVPL +184A
    This failure has been reported with DB2 v4 users running
    backlevel products which are not compatible with v4. BMC's
    Activity Monitor is one of them. Also RC00E50006.
    2) BMC's LoadPlus CSA/SMP concern
       (Contact BMC for fixes  285822 and 289633)
        289633 is for the BMC Data Packer product
        292851 is resolved by 295474 for the Recover Utility
    Also see II06548.
    =========================================================
    SQLCODE -530 received from inserts into child table even
    though parent record exists after conversion to type 2
    indexes on DB2 V4.1.  Conversion to type 2 indexes were
    performed using BMC Recover Plus.
    .
    BMC problem number is PP292851.
    .
    Additional sympton:  SQLCODE530
    =========================================================
    7/30/96 Various storage usage problems in the DB2 DBM1 asid
    ADMF AGENT LOCAL POOL BMCUTIL IADM BMCAMU x'A000' blocks.
       Unexpected growth in sp229 and/or ABEND878 rc10, ABEND106
    fetch errors loading IDCAMS csects  or ABEND04E rc00E20003
    caused by oem utilities not freeing all storage obtained in K7
    sp229.  Fix tracking numbers provided by a customer for several
    BMC utilities are:
    289622 for Reorg   Plus +  r210 r211
    285822 for Load    Plus +  r140
    289625 for Check   Plus +  r220 r221
    289872 for Recover PLUS +  r421
    ================================================================
    08/20/96 - Abend0C4 on the sort phase of a RECOVER INDEX
    running DB2 R410, with MVS/ESA/52x (with OW14045) and DFSMS130.
    Problem was fixed by a Syncsort PTF EW4874-0.
    ===============================================================
    rc00C90206 DSNKNEXT vrace5006 erqual5006 after PLATINUM
    utility.  Problem can occur when an INDEX dataset size exceeds
    2 GIG where some program storage is used by two different OEM
    task.  The results can be unpredictable and has been assigned
    oem problem PFL22003.  A ZAP is available from the vendor.
    ===============================================================
    11/07/96
    BMC Software is alerting RECOVER PLUS for DB2, V2.2.00 customers
    to a problem that occurs when recovering DB2 V4 Type 2 indexes.
    If index is large enough that it requires more than 2 index lvls
    DB2 errors may occur after recovery ends with CC=0. Specifically
    abend S04E with reason code 00C200AF may occur for applications
    trying to update the index.  BMC fix number is P277139.
    ================================================================
    11/01/96
    Various abends (abend0c4 abend0c1) following a PC call.
    PLATINUM DETECTOR changes PC address to point to their
    routine.  An error occurs and the DETECTOR module is
    FREEMAINed, but the PC address is not changed back to the
    DB2 address.  Fix is ZAP PXM40003 for PAR 291841
    ================================================================
    PLATINUM XMANAGER error, intermittant, various abends like
    s0C1 s0C4 s0C6 s0E0 in Allied, Utility and SPAS asids
    following PC calls.  Timing window for DB2 shutdown and the
    Platinum Xmanager address space.  Platinum csect in ECSA gone.
    DB2 termination module DSNAPRHX is usually the error victim.
    Tapes P512AA / P512AB (err is simular to PXM40003 concern).
    Fix = PAR 306286
    -----------------------------------------------
    Update 2/13/97 - PLB
    -----------------------------------------------
    PLATINUM - XMANAGER/DETECTOR
    Abend0c4's (abend0c4-4, abend0c4-10, abend0c4-11) can occur in
    DB2 csect DSNAPRHX when using SPAs (stored procedures) if this
    product is installed. Here's an example of a dump title:
     Z1U1,ABND=0C4-00000004,U=RQCZ1B8 ,C=XYR00.410.SSSC-DSNAPRHX,
     M=DSNAPRHX,LOC=DSN3EPX .DSNAPRHX+0798
    The Platinum problem record is par#309513 and is fixed on the
    P512AD maintenance tape.  (s0C4 pic04 pic10 pic11)
    ================================================================
    11/27/96 KK
    Precompiler in DB2 V4.1 running on SASS/C compiler needs to
    specify TRIGRAPH as option to have SASS/C compiler recognize
    the TRIGRAPH representation of square brackets, ie. ??( or
    ??). It is not needed to do so for IBM C compilers.
    ===============================================================
    12/27/96     LSK
    Abend0C1 and DB2 terminates with RC00D94001 DSNV086e message.
    Dump shows BALR from DSNTLRST + x'224' to lowcore and CT + ac
    is suppose to be RLPL but it has been overlaid. Reg15 loaded
    00000000 ( zeroes ) and reg1 also bad. IRLM MCB header
    has also been overlaid with an eye catcher of SM1 .This occurs
    starting IRLM  from the DB2 Master ASID. DB2mstr (AUTO START)
    BMC fix number is P270153 + zap P285210.
    ================================================================
    1/17/96 RL
    msgiec909i rc212 rc1 abenda00 abend0c1
    The message and abends are received when running BMC load
    utilities against db2 objects. The following zaps are
    available.
    
    - 295964: A00 or other abends in UTILINIT PHASE running DB2 V4.1
              in REORG PLUS, LOADPLUS and UNLOAD PLUS
    - 297889: REORG PLUS may fail w/system A00
    - 299524: 0C4 in AMUUMAIN+1984 running DB2 V4.1 while LOADPLUS
              is checking for DB2 subsystems for group attach
    - 299529: OC4 in ARUUMAIN+1984 etc. same as 299524
    - 302190: Reorg Plus does not process all rows
    ---------------------------------------------------
    PLB - 2/11/97 - OVERLAY, SHB free chain ptr for DB2
    This problem has surfaced three times. An SHB free
    chain ptr is corrupted and/or overlayed. In each of
    the three cases, the first two bytes of the address
    has been corrupted with x'003C', x'0074', and x'0068'.
    The cust reports that TMON/MVS fix TD00886 may have
    fixed this problem on one of his symptoms. I will
    update this once verified.
    UPDATE: 02/28/97 PLB
    For the overlay noted above, the TD00734 fix for Landmark's
    TMON for MVS may have introduced the problem.  Fix TD00886 is
    needed to fix it.
    UPDATE: 04/22/97 PLB
    Additional symptoms may include abend0c4-10 DSNSCON2 +AF4 (v4),
    rc00e2000e and others.
    ================================================================
    -Increased SP229 Key7 usage in the DBM1 address space with
     DpropR Apply active.
    DB2 4.1 - DBM1 SP229 KEY7 STORAGE GROWTH.  When running a
    heavy dynamic SQL job under DB2 4.1, it is possible to
    experience hugh increases in subpool 229 key 7 storage
    consumption. Performance problems may also be seen.  This APAR
    is for genlevel 9606 and below.
       ---------------------------
       CA fix is : USERMOD T7M8420
    ********* added 2/24/97 Ed Rigsby  ****************
    ====================================================
    Running a program with stored procedure receiving
    sqlcode084 due to the MDI odbc driver 2.2.1.00 (latest version)
    not supporting this stored procedure call function.
    The early version of IBM ODBC driver also has this lack of
    function problem. But the current version of IBM ODBC is
    working fine w/STORED PROCEDURE function.
    Customer checked with MDI Support that this will be a design
    request for the future release consideration.
    ********* added 2/28/97 Kai-Li Kow ****************
    ---------------- 03/10/97 ------------------------------
    Various hangs and abends at or immediately after DB2 Startup.
    Errors are related to a CA security product CA/90 EMF.  Some
    noted errors are  ABEND0C4, ABEND0C6, ABEND04E rc00E30089
    THe Computer Associates ENF function will try to issue DB2
    start message:  CAS9800I ENF - DB2 INITIALIZATION in PROGRESS
    This msgCAS9800I may or may NOT be issued at startup, but,
    if the CA/ENF product is installed, and the message does fail
    to be presented, this is a good indication of fault.  The CA
    function appears to key off the DSNR002I RESTART COMPLETE msg.
    Fix is T7M8432 for CAS230D.......JBW.......
    UPDATE: 4/29/97 - PLB
    It has been reported that CA/ENF has an initialization or
    setup parameter 'DB2REL' which if used can prevent DB2
    startup.(ENF = Computer Associates Event Notification Facility)
    Additional info provided by another customer (11/25/97 SC):
    CASR230D - ABEND0C3 in CASR230D when running with more than 1
    DB2 subsystem.  Product: CAIENF/DB2-MVS Occurs at genlevel 9611.
    CA-ACF2 DB OPTION-MVS release 1.0 and 1.1
    CA-ACF2-MVS release 6.0 6.1 and 6.2
    CA-CA90S SERVICES MVS release 1.0
    CA-TOP SECRET DB OPTION-MVS release 1.0 and 1.1
    CA-TOP SECRET-MVS release 4.4 and 5.0
    Fix apar LO13092
    ================================================================
    Problem: ABEND04E RC00C50103 from SPUFI and RC00F30018 from CAF.
    Solution: Problem caused by OEM product Control-O.
    To avoid the rc00c50103 abend, define the entries in the
     IEFSSNxx member as follows:
       JES2,,PRIMARY
       CONT                /* control-O */
       DSN,DSN3INI,'DSN3EP,-'
    Control-O must be defined above DB2.
    
    (** Note: this CONTROL-O product is NOT from Boole & Babbage **)
    
    ================== Added by L.Lee 3/14/97 ==================
    --03-17-97 RJL--------------------------------------------------
      CSA overlay with eye catcher of ENF51C in overlaid data.
      ACF/DB2 ENF component. Fixes are GO95769 and GO91220.
    ----------------------------------------------------------------
    4/2/97 SC
    Various getmain failures or increase in sp229 storage use in the
    dsndbm1 asid.  Symptoms ABEND878 and/or ABEND04E RC00E20003
    occurred after running oem (BMC) utilities with DB2 R410.  The
    customer applied BMC fix P285822 to correct the problem.
    ----------------------------------------------------------------
    +++added by Kai-Li Kow 4/11/97+++
    OEM PEOPLE SOFT package via BARR Device to communicate to
    DB2/MVS causing the error on db2/mvs w/DSNL032I for DRDA
    exception condition from requester, RC00d35d11, ifcid=191
    when variable length data is larger. Smaller record of data
    has no problem.
    .
    After examining the IFCID191 trace and vtam buffer trace and
    ddcs trace, development concluded that this problem is not in
    DB2, but introduced by the OEM Channel Device, BARR.
    BARR fix for this problem is 32643.
    PMR# for this prob is 22879,033.
    ----------------------------------------
    4/25/97 MHM
    SYNCSORT R3.5C did not recognize FILSZ greater than 9
    characters.  Received messages:
       WER268A  SORT STATEMENT    : SYNTAX ERROR
       WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000
    SYNCSORT FIX: zap EW4512-1.
    -----------------------------------------------------
    5-12-97 RJL
    msgdsnw124i dsnwvfrr trace terminated RC=040F8000
    TITLE=SMF ABEND, ERRMOD=IEFU84,   RECVMOD=IEEMV830
    An abend0f8 rc10 occurs on an svc 78 issued from cas9u83
    Contact Computer Associates for a fix.
    The ptf's have been reported as T5ZS292, T5ZS294 & T5ZS301.
    -----------------------------------------------------
    5-19-97 MHM
    abend04e rc=00c9021c ( rc00c9021c ) fixed by applying
    FIX P302893 from BMC for REORG PLUS.
    -----------------------------------------------------
    7/17/97 LL
    DB2 V4 dynamic SQL users hang in dynamic bind running
    with OEM Circle product HOURGLASS 2000.  The OEM product
    has its own LOADLIB which is concatenated ahead of the
    DB2 LOADLIB.  Problem was resolved after the OEM LOADLIB
    was was changed to a PDS from a PDSE.
    -------------------------------------------------------------
    07/29/97 - PLB
    Problem described by DB2 apar PQ03857. RC00F30801 received
    with BMCXLC latch held. BMC's XBM (Extended Buffer Mgr)
    component overlays a DB2 FRE (functional recovery element)
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • closed for DB2INFO retention
    

APAR Information

  • APAR number

    II09269

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    CLOSED CAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1996-02-08

  • Closed date

    1996-10-03

  • Last modified date

    1998-09-09

  • 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



Document information

More support for: z/OS family

Software version: 001

Operating system(s): MVS

Reference #: II09269

Modified date: 09 September 1998