PH71124: INTERNAL FIXES AND IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Miscellaneous changes:
  * SYSOUT API (SSOBRETN = 4, SSS2REAS = 0) which happens in JES3
  environment during the plan generation on a standalone subsystem
  has been
  
     fixed.
  * SQLCODE = -811 on Log Based Recovery of a dropped table with
  multiple indexes has been fixed.
  * Recovery of dropped objects to Current using SLR repository
  data, which led to SQLCODE = 802 warning, has been fixed.
  * Advanced Recover plan has been enabled for tables with COPY
  YES indexes.
  * Support for the CCQ_DB2_FL TCz field has been introduced.
  * The number of required fields in the Discover Customized
  Product Information panel has been reduced to simplify migration
  from Db2 Recovery
  
     Expert v3.2.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: Internal fixes and improvements         *
  ****************************************************************
  Miscellaneous changes:
  - SYSOUT API (SSOBRETN = 4, SSS2REAS = 0) which happens in JES3
  environment during the plan generation on a standalone subsystem
  has been fixed.
  - SQLCODE = -811 on Log Based Recovery of a dropped table with
  multiple indexes has been fixed.
  - Recovery of dropped objects to Current using SLR repository
  data, which led to SQLCODE = 802 warning, has been fixed.
  - Advanced Recover plan has been enabled for tables with
  COPY YES indexes.
  - Support for the CCQ_DB2_FL TCz field has been introduced.
  - The number of required fields in the Discover Customized
  Product Information panel has been reduced to simplify migration
  from Db2 Recovery Expert v3.2.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

  PH70787

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

  UO07758

Modules/Macros

• HRG#QS10 HRG4COMM HRG4GRPF HRG4MSG  HRG4QCLO HRG4QRHC HRG4QRRC
  HRG4SAXB HRG4SCNV HRG4SERV HRG4SGLO HRG4SRRD HRG4TIME HRG@APRN
  HRG@BACK HRG@BAKO HRG@BAKV HRG@CGOT HRG@CGRV HRG@DSCC HRG@MAIN
  HRG@OFLD HRG@ORPT HRG@REST HRGBABCS HRGBABDB HRGBABHE HRGBABOI
  HRGBABOP HRGBABPK HRGBABPL HRGBABRL HRGBABRS HRGBABRT HRGBABSG
  HRGBABTB HRGBABTR HRGBABUT HRGBACSA HRGBADCS HRGBADTM HRGBAIPM
  HRGBAMAN HRGBAODM HRGBAOEN HRGBAPBP HRGBAPPL HRGBARCS HRGBASDM
  HRGBASEI HRGBASRC HRGBATAS HRGBATDM HRGBATRM HRGBATSM HRGBAUTL
  HRGBAVIM HRGBAVOM HRGBBASL HRGBBCFO HRGBBCOS HRGBBCSL HRGBBDES
  HRGBBDFL HRGBBDSL HRGBBDSQ HRGBBDTS HRGBBGLO HRGBBGOC HRGBBGOL
  HRGBBGRJ HRGBBGRP HRGBBIDM HRGBBIEN HRGBBIPM HRGBBJOB HRGBBJRN
  HRGBBKSG HRGBBLIR HRGBBOBM HRGBBOCN HRGBBOCR HRGBBODM HRGBBOPS
  HRGBBOSV HRGBBOXG HRGBBPAC HRGBBPDM HRGBBPLN HRGBBQTA HRGBBQTJ
  HRGBBRA  HRGBBRDS HRGBBRMA HRGBBROM HRGBBROS HRGBBSAM HRGBBSCM
  HRGBBSGD HRGBBSR  HRGBBSRC HRGBBSSL HRGBBSYS HRGBBTDM HRGBBTIR
  HRGBBTPS HRGBBTSJ HRGBBTSL HRGBBUCD HRGBBUCI HRGBBUCL HRGBBUES
  HRGBBUGC HRGBBULA HRGBBUNM HRGBBUPV HRGBBUQU HRGBBURB HRGBBURC
  HRGBBURL HRGBBURP HRGBBUSR HRGBBUSS HRGBBVDM HRGBBVSL HRGBCDT@
  HRGBCICI HRGBCMAN HRGBCRAS HRGBDAMA HRGBDCLP HRGBDDCS HRGBDSF
  HRGBDT@  HRGBDTCS HRGBDTRS HRGBEMAN HRGBEOPT HRGBERES HRGBFDT@
  HRGBFMAN HRGBFRG  HRGBFUTL HRGBGINS HRGBGRAR HRGBGRDD HRGBGRGU
  HRGBGRMR HRGBGRSR HRGBHHC  HRGBHHEC HRGBIDCS HRGBIDT@ HRGBIND1
  HRGBIND4 HRGBINV  HRGBIPR  HRGBIRA  HRGBIRAS HRGBIRES HRGBISCD
  HRGBISMC HRGBISMR HRGBISUG HRGBJGCS HRGBJGDA HRGBJGGN HRGBJGIM
  HRGBJGNT HRGBJGRD HRGBJGSB HRGBJGUF HRGBLOPT HRGBLREG HRGBMAAP
  HRGBMACA HRGBMACL HRGBMDT@ HRGBMIXM HRGBMMIA HRGBMO@  HRGBMOPT
  HRGBMVTM HRGBNDR  HRGBNMAN HRGBOBAS HRGBOODS HRGBOPRS HRGBOROD
  HRGBOSEP HRGBOSLG HRGBOSPQ HRGBOVA  HRGBOVB  HRGBOVSC HRGBOVSD
  HRGBOVSI HRGBOVSJ HRGBOVSO HRGBPCJ  HRGBPDCS HRGBPLDS HRGBPLOS
  HRGBPLRS HRGBPOCS HRGBPRFV HRGBRDCS HRGBRMOQ HRGBRMRS HRGBRORC
  HRGBRSMS HRGBSADS HRGBSARS HRGBSCD  HRGBSCTS HRGBSEB  HRGBSED
  HRGBSGSL HRGBSLBS HRGBSLRJ HRGBSM@  HRGBSOIV HRGBSOPT HRGBSPDS
  HRGBSYRS HRGBTDT@ HRGBTINT HRGBTSDS HRGBUDT@ HRGBUSGB HRGBUTSI
  HRGBVBC  HRGBVCBU HRGBVCCR HRGBVCRP HRGBVCTC HRGBVCTM HRGBVDLG
  HRGBVDLR HRGBVDT@ HRGBVEXN HRGBVI   HRGBVIDS HRGBVIIC HRGBVLIT
  

Fix information

• Fixed component name

  DB2 REC EXPRT F

• Fixed component ID

  5698RET00

Applicable component levels

• R110 PSY UO07758

     UP26/05/09 P F605

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.