PH70787: 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:

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

  PH71124 UO07757

Modules/Macros

• HRG#LBID HRG$$CCQ HRG$$DSC HRG4DLL  HRG4MVSF HRG4QGLO HRG4QGST
  HRG4QRSU HRG4QUTH HRG4SAXC HRG4SOCK HRG4SRRC HRG4SRWR HRG4TYPS
  HRG4XMLU HRG4XMLW HRG4XSWR HRG@BAKE HRG@BULD HRG@CGPT HRG@DISC
  HRG@MSGS HRGBABAL HRGBABAQ HRGBABCK HRGBABDT HRGBABIP HRGBABOB
  HRGBABRO HRGBABSC HRGBABSN HRGBABSQ HRGBABSR HRGBABTP HRGBABTS
  HRGBABUR HRGBABVA HRGBABWM HRGBACS4 HRGBADBV HRGBADMA HRGBADT@
  HRGBAICG HRGBALA  HRGBAMRR HRGBAOBM HRGBAOPT HRGBAORD HRGBAPBB
  HRGBAPDM HRGBAROM HRGBARPA HRGBARPD HRGBARPS HRGBASAM HRGBASIM
  HRGBASR  HRGBASYM HRGBATDS HRGBATPM HRGBAVDM HRGBBADM HRGBBBOS
  HRGBBCAI HRGBBCK  HRGBBCSI HRGBBDDM HRGBBDTM HRGBBERS HRGBBGRS
  HRGBBIPS HRGBBISL HRGBBJCL HRGBBLRJ HRGBBOBS HRGBBPCJ HRGBBPCO
  HRGBBPCV HRGBBPI  HRGBBPLM HRGBBPLS HRGBBPQS HRGBBPSL HRGBBRDM
  HRGBBRPA HRGBBRPC HRGBBRSL HRGBBSAS HRGBBSDM HRGBBSLR HRGBBSYM
  HRGBBTPM HRGBBTRM HRGBBTRS HRGBBTSM HRGBBTSS HRGBBTUJ HRGBBUCO
  HRGBBUCR HRGBBUDC HRGBBULD HRGBBUPR HRGBBURD HRGBBURV HRGBBUTH
  HRGBBUTM HRGBBVDS HRGBBVRP HRGBBZPM HRGBCDCS HRGBCDGI HRGBCOAS
  HRGBCOPT HRGBCRC  HRGBCRCL HRGBCUTL HRGBD2LS HRGBDPLS HRGBDRAS
  HRGBDSB  HRGBDSC  HRGBDSES HRGBDSUT HRGBEDT@ HRGBEMDT HRGBERE
  HRGBERRC HRGBEUSJ HRGBEUTL HRGBFOPT HRGBGRCA HRGBGRDG HRGBGRDL
  HRGBGRGR HRGBGRMD HRGBGRML HRGBGRMT HRGBGRPL HRGBGRRI HRGBGRRR
  HRGBGRSF HRGBGUS  HRGBHDT@ HRGBHLEE HRGBIND3 HRGBIPDS HRGBIPRS
  HRGBIRS  HRGBISDO HRGBISSC HRGBJGBC HRGBJGDL HRGBJGID HRGBJGSD
  HRGBJGWD HRGBLAQ  HRGBLDRG HRGBLDSG HRGBLDSQ HRGBLDT@ HRGBLEJ
  HRGBLFS  HRGBLMAN HRGBLUTL HRGBMACT HRGBMAIX HRGBMATB HRGBMATS
  HRGBMAVT HRGBMBMC HRGBMMAN HRGBMSGS HRGBMUM  HRGBMUMD HRGBMUTL
  HRGBMWRT HRGBNDT@ HRGBNOPT HRGBNUTL HRGBOOAS HRGBOOMM HRGBOPAS
  HRGBOPDS HRGBOPLS HRGBORDS HRGBOSR  HRGBOSSF HRGBOSTS HRGBOVAS
  HRGBOVBS HRGBOVCD HRGBOVCM HRGBOVCS HRGBOVSR HRGBPPCS HRGBRMAN
  HRGBRMOS HRGBRODC HRGBROPS HRGBRRCS HRGBRROT HRGBRSH  HRGBRUTL
  HRGBSCB  HRGBSCBS HRGBSCDS HRGBSDT@ HRGBSEBS HRGBSEDS HRGBSERS
  HRGBSGDS HRGBSGRS HRGBSLJ  HRGBSMAN HRGBSPRS HRGBSUTL HRGBSYDS
  HRGBTENV HRGBTPOL HRGBTRAS HRGBTRVS HRGBTSAS HRGBTSJ  HRGBTSJB
  HRGBTTLR HRGBTXUT HRGBUIPS HRGBUOPT HRGBURU  HRGBUSGJ HRGBUSIG
  HRGBUUTL HRGBVAL  HRGBVBDS HRGBVCC  HRGBVCDL HRGBVCV  HRGBVDAL
  HRGBVDBD HRGBVDCE HRGBVDNB HRGBVDSS HRGBVEEO HRGBVGCR HRGBVIC
  

Fix information

• Fixed component name

  DB2 REC EXPRT F

• Fixed component ID

  5698RET00

Applicable component levels

• R110 PSY UO07757

     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.