PH69666: PROBLEMS WHEN REPAIRING THE DATABASE IN DBRF PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DBRF in interactive mode may incorrectly update the database
  when changing the value of Tgt-RBA in Segment Prefix panel.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM IMS Database Repair Facility (DBRF) for  *
  *                 z/OS Version 3 Release 1 (FMID=H22K310)      *
  *                 users who run DBRF in interactive mode.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes DBRF interactive mode   *
  *                      problems that updating the database     *
  *                      may corrupt the database and may fail   *
  *                      to undo.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  This APAR fixes the following five problems when running DBRF
  in interactive mode.
  
  1. When the database is HD DB or DEDB and the database data set
     is VSAM, including OSAM LDS, updating the pointer value
     (Tgt-RBA) in Segment Prefix panel incorrectly updates the
     Tgt-RBA and corrupts the different place. This occurs when
     the Tgt-RBA spans 2 rows in CI data.
  
     Underlined 4 bytes starting from offset '9E' in below CI
     data exemplifies the Tgt-RBA spanning 2 rows.
  
      <CI data>
      Ofst 0                   1
           0.1.2.3. 4.5.6.7. ~ 0.1.2.3. 4.5.6.7. 8.9.A.B. C.D.E.F.
      0080 7B7B7B7B 7B7B7B7B ~ 01000000 11120000 10020000 132E0000
                                                              ----
      00A0 132E0000 11160000 ~ C9F4D9E3 F0F0F0F2 4C4C4C40 D9D6D6E3
           ---- <= Tgt-RBA spanning 2 rows
  
     Also, the above update cannot undo because the database is
     corrupted.
  
  2. When the database is HD DB or DEDB and the database data set
     is OSAM, updating the Tgt-RBA in Segment Prefix panel, where
     the Tgt-RBA spans 2 rows in CI data, fails to create undo
     files when 2 undo files have duplicate timestamp. As a
     result, the update cannot undo.
  
  3. When the database is HD DB, updating the FSE in Free Space
     Element Chain panel incorrectly updates the FSE and corrupts
     the different place. This occurs when the Tgt-RBA spans 2
     rows in CI data.
  
     Also, the DB Update Confirmation panel is shown more times
     than the number of rows being updated. If the DB Update
     Confirmation panel has been processed further, more places
     are corrupted.
  
  4. When the database data set is VSAM, including OSAM LDS, after
     updating database in CI data panel and confirming the update
     in the DB Update Confirmation panel, CI data panel shows only
     the updated row and the offset value always show 0.
  
  5. In the panel showing the dump data, such as CI/Block panel,
     updating multiple rows shows the DB Update Confirmation panel
     for multiple times. The user may confuse because the DB
     Update Confirmation panel does not change.
     The DB Update Confirmation panel has been improved to show
     the number of rows. The user is able to understand that the
     DB update confirmation continues.
  
     Following panel is the improved image. nnnn is the ordinal
     number of current updating row to confirm. mmmm is the
     total number of rows to update.
  
     <DB Update Confirmation panel>
     ************************************************************
     * Warning: You are about to update data (nnnn of mmmm rows).
     *          Enter Y to proceed.
     ************************************************************
  

Problem conclusion

• DBRF has been modified to fix the problems.
  

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:

  UO06664

Modules/Macros

• FABZCONF FABZDATA FABZMAIN FABZPRO2 FABZPROC
  

Fix information

• Fixed component name

  IMS DATABASE RE

• Fixed component ID

  5655E0300

Applicable component levels

• R310 PSY UO06664

     UP26/02/05 I 1000

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.