PI23374: ALLOW ANALYZEPART FUNCTION TO EXECUTE AGAINST AN ONLINE DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Customer does not want to take the database offline to be able
  to run the ANALYZEPART.
  This is an enhancement as a result of RFE ID 32398.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM IMS Database Solution Pack V2.1 *
  *                 IMS HALDB Toolkit                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides a new option of      *
  *                      READINT for the ANALYZEPART function.   *
  *                      This new option allows ANALYZEPART      *
  *                      function to run against an online       *
  *                      database.                               *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  The current ANALYZEPART function unloads a database with read-
  integrity, by using PROCOPT=G DBPCB.
  Therefore, ANALYZEPART function failed with the following
  message whenever it tried to unload against an online database
  with ACCESS=UP.
    DFS047A - UNABLE TO OBTAIN AUTHORIZATION FOR DATA BASE
  
  This APAR provides a new option of READINT for the ANALYZEPART
  function to unload a database without read-integrity, by using
  PROCOPT=GO DBPCB. This new option allows ANALYZEPART function
  to run against an online database with ACCESS=UP.
  
  Note:
   - This option is effect only when HALDB Toolkit dynamically
     detects the existence of IMS High Performance Unload for
     z/OS.
   - ANALYZEPART without read-integrity might get a segment
     that has been updated by another program. This might cause
     a data problem.
  

Problem conclusion

Temporary fix

Comments

• The new option of READINT for ANALYZEPART function has been
  added.
  
  ========================
  = DOCUMENTATION CHANGE =
  ========================
  IBM IMS Database Solution Pack for z/OS Version 2 Release 1
  IMS High Availability Large Database Toolkit for z/OS User's
  Guide (SC19-4102-00)
  ----------------------------------------------------------------
  Chapter 2. Simulating HALDB using ANALYZEPART
   ANALYZEPART command parameters
    Table 3. ANALYZEPART command parameters
  
  | READINT
  
  | Specifies whether ANALYZEPART function reads the database to
  | be simulated with read-integrity, PROCOPT=G.
  | If you want to simulate the effect of the HALDB partition
  | setting for a database that is used by IMS online system with
  | ACCESS=UP, you can specify READINT(N) to read the database
  | without read-integrity, PROCOPT=GO.
  | This option is effect only when HALDB Toolkit dynamically
  | detests the existence of IMS High Performance Unload for
  | z/OS.
  | Specify Y or N. The default is Y.
  |
  |  Note: If the READINT(N), PROCOPT=GO option, is used to read
  |        the database, IMS does not check the ownership of the
  |        segments returned. Therefore, ANALYZEPART without read
  |        integrity might get a segment that has been updated by
  |        another program. This might cause a data problem,
  |        such as IMS user abend, loops and system abends.
  |        For more details refer to IMS manual, Application
  |        programming.
  

APAR Information

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

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

  UI22260

Modules/Macros

• IHCULEV0 IHCUTIC0 IHCWLIU0 IHCWTDBA IHCWTDBB
  IHCWTDBG IHCWTDB0 IHCWTDB1 IHCWTDB2 IHCWTDB3 IHCWTDB4 IHCWTDB7
  IHCWTDB8 IHCWTDRC IHCWTKOV IHCWUNL0 IHCYCCDF
  

Fix information

• Fixed component name

  IM DB SOLUTION

• Fixed component ID

  5655S7700

Applicable component levels

• R210 PSY UI22260

     UP14/10/20 P F410

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.