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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels