PI35527: ORF: AUTONOMICS SUPPORT PHASE 2

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ORF: Autonomics support phase 2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM IMS Database Solution Pack V2.1 *
  *                 IMS Online Reorganization Facility           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Conditional Reorganization support      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR enables IMS Online Reorganization Facility to use the
  Conditional Reorganization Support Service, which is provided by
  IMS Database Reorganization Expert.
  The following APARs are also needed for the related products:
  - Tools Base V1R4 (FMID HAHN140) PI20517, PI24388
     or
  - Tools Base V1R5 (FMID HAHN150) PI48640, PI50575
  - IMS Database Reorganization Expert V4R1 (FMID H25N410) PI32990
  

Problem conclusion

Temporary fix

Comments

• ========================
  = DOCUMENTATION CHANGE =
  ========================
  The IBM IMS Database Solution Pack for z/OS Version 2 Release 1
  IMS Online Reorganization Facility User's Guide (SC19-4103-00)
  ----------------------------------------------------------------
  > IMS Online Reorganization Facility overview
  >> IMS Online Reorganization Facility features and benefits
  Conditional reorganization
  IMS Online Reorganization Facility supports the Conditional
  Reorganization Support Service (CRSS) of IMS Database
  Reorganization Expert. The CRSS adds the conditional
  reorganization capability to the reorganization jobs of IMS
  Online Reorganization Facility.
  ----------------------------------------------------------------
  > IMS Online Reorganization Facility overview
  >> Overview of the conditional reorganization process
  Runtime Modes for CRSS
  IMS Online Reorganization Facility supports the following three
  runtime modes for use with the CRSS:
    Conditional Reorganization mode
      When you run IMS Online Reorganization Facility in this
      mode, it invokes the CRSS to evaluate the database.
      - When the CRSS determines that the database needs to be
       reorganized, IMS Online Reorganization Facility reorganizes
       the database. When the reorganization process completes,
       the CRSS is called to evaluate the reorganized database and
       to report the processing result and the status of the
       database before and after reorganization.
      - When the CRSS determines that the database does not need
       to be reorganized, it reports the current database status
       and requests IMS Online Reorganization Facility to end the
       job without reorganization.
      Conditional Reorganization mode is useful when you do not
      know the database status and you want to reorganize the
      database only if database reorganization is needed.
    Reorganization Diagnosis mode
      When you run IMS Online Reorganization Facility in this
      mode, IMS Online Reorganization Facility reorganizes the
      database regardless of the database status. The CRSS
      evaluates the database and reports the processing results
      and the status of the database before and after
      reorganization. Although the CRSS is invoked, the database
      is reorganized every time a job is run in this mode.
      Use Reorganization Diagnosis mode when you want to
      reorganize the database and want to compare the database
      status before and after reorganization. You can also obtain
      a list of exceptions that remained after the reorganization.
    Diagnosis-only mode
      When you run IMS Online Reorganization Facility in this
      mode, it invokes the CRSS to evaluate the database and to
      report the database status. The reorganization process of
      IMS Online Reorganization Facility is not invoked in this
      mode.
      Use Diagnosis-only mode to check the database status.
  The CONDREORG keyword of the HRFSYSIN DD statement requests the
  CRSS and controls the runtime modes.
  ----------------------------------------------------------------
  > IMS Online Reorganization Facility overview
  >> IMS Online Reorganization Facility restrictions
  When IMS Online Reorganization Facility is used with the
  Conditional Reorganization Support Service (CRSS), the following
  restrictions apply:
  - Both the IMS Tools Knowledge Base server and the Policy
   Services server must be configured and active.
  - For HALDBs, only a single partition can be processed in a
   single IMS Online Reorganization Facility job.
  - DBD changes are not allowed in Conditional Reorganization mode
   or in Reorganization Diagnosis mode.
  - For a database that uses VSAM data sets, SHAREOPTIONS other
   than (1,3) must be specified for each VSAM data set of the
   database.
  - When DB Sensor collects sensor data from an online database,
   the collected data element values might not reflect the latest
   database condition.
  ----------------------------------------------------------------
  > Using IMS Online Reorganization Facility
  >> DD statements
  BBEJRNL
    This statement defines the data set that contains the journal
    messages that are issued by the CRSS. The journal messages
    show the processing information for the CRSS, and they can be
    used for problem determination.
    The journal messages are printed in the BBEJRNL data set only
    when CR.JOURNAL(Y) is specified.
  Format  RECFM=FA or FBA, LRECL=133
  -------
  BBERPRT
    This statement is effective only when you use the Conditional
    Reorganization Support Service (CRSS). The statement defines
    the data set that contains the Diagnosis report that is
    generated by the CRSS.
    The Diagnosis report is not printed in the BBERPRT data set
    when CR.PRINTRPRT(N) is specified.
  Format  RECFM=FA or FBA, LRECL=81
  -------
  BSNJM01
    This statement is effective only when you use the Conditional
    Reorganization Support Service (CRSS). The statement defines
    the data set that contains the journal messages that are
    issued by Policy Services. The Policy Services journal
    messages show the processing information for the Policy
    Services component, as well as the information about the
    policy that was used. If a warning situation is detected or if
    an error occurs while the Policy Services components are in
    process, one or more warning messages or error messages are
    issued as journal messages. The journal messages are printed
    in the BSNJM01 data set only when CR.JOURNAL(Y) is specified.
  Format  RECFM=FA or FBA, LRECL=133
  ----------------------------------------------------------------
  > Using IMS Online Reorganization Facility
  >> HRFSYSIN DD statement keywords
  CONDREORG keyword
  Use this keyword to specify whether to use the Conditional
  Reorganization Support Service (CRSS) and which runtime mode to
  use.
  This keyword is optional for REORG HRFSYSIN DD statements, but
  is not applicable for UNLOAD HRFSYSIN DD statements.
  Requirement: Policy Services server must be configured and
  active. You can specify one of the following values:
    CONDREORG(Y)
      The job runs in Conditional Reorganization mode.
    CONDREORG(Y,DIAGONLY)
      The job runs in Diagnosis-only mode.
    CONDREORG(Y,REORGDIAG)
      The job runs in Reorganization Diagnosis mode.
    CONDREORG(N)
      The CRSS is not called in the job.
  Usage note: To enable the CRSS, all of the following conditions
  must be met:
  - The load library of IMS Database Reorganization Expert is
   included in the STEPLIB concatenations.
  - The SHKTLOAD library of Tools Base is included in the
   STEPLIB concatenations.
  - The primary database to be reorganized is either a
   full-function database or a single partition of a HALDB
  - The primary database to be reorganized is not an index
   database.
  - The ITKBSERVER keyword is specified in the REORG HRFSYSIN DD
   statement.
  - TAKEOVER(N) keyword is not specified in the REORG HRFSYSIN DD
    statement.
  - DBD change is not requested.
  Format  (N | Y | Y,DIAGONLY | Y,REORGDIAG)
  Default value  N
  -------
  CR.DIAGDATAFROM keyword
  Use this keyword to specify how the Conditional Reorganization
  Support Service (CRSS) retrieves database statistics data that
  is to be used for database diagnosis in the first evaluation
  phase to determine whether reorganization is needed.
  You can specify one of the following values:
    CR.DIAGDATAFROM(DBSENSOR)
      The CRSS requests DB Sensor to collect database statistics
      and uses it for database diagnosis.
    CR.DIAGDATAFROM(REPOSITORY)
      The CRSS retrieves the latest statistics from the Sensor
      Data repository of IMS Tools KB and uses it for database
      diagnosis.
  Format  (DBSENSOR | REPOSITORY)
  Default value  DBSENSOR
  -------
  CR.DIAGDATAFROM keyword
  Use this keyword to specify how the Conditional Reorganization
  Support Service (CRSS) retrieves database statistics data that
  is to be used for database diagnosis in the first evaluation
  phase to determine whether reorganization is needed.
  You can specify one of the following values:
    CR.DIAGDATAFROM(DBSENSOR)
      The CRSS requests DB Sensor to collect database statistics
      and uses it for database diagnosis.
    CR.DIAGDATAFROM(REPOSITORY)
      The CRSS retrieves the latest statistics from the Sensor
      Data repository of IMS Tools KB and uses it for database
      diagnosis.
  Format  (DBSENSOR | REPOSITORY)
  Default value  DBSENSOR
  -------
  CR.JOURNAL keyword
  Use this keyword to print the journal messages in the output
  stream.
  When CR.JOURNAL(Y) is specified, the following journal messages
  are printed:
  - The journal messages that are issued by the CRSS are printed
   in the output stream that is specified by the BBEJRNL DD
   statement.
  - The journal messages that are issued by Policy Services are
   printed in the output stream that is specified by the BSNJM01
   DD statement.
  Note: Even when CR.JOURNAL(N) is specified, if you specify the
  BBEJRNL DD statement, the BSNJM01 DD statement, or both in the
  JCL, the journal messages are printed in the specified DD data
  sets.
  Format  (Y | N)
  Default value  N
  -------
  CR.POLICYBY keyword
  Use this keyword to specify how the CRSS selects the
  reorganization policy for database diagnosis.
  You can specify one of the following values:
    CR.POLICYBY(DBDNAME)
      The reorganization policy is selected based on the DBD name
      of the target database. When you specify this option, the
      reorganization policy that is named SYS.DBDNAME.dbdname in
      the Input repository of IMS Tools KB is used. dbdname is the
      DBD name of the  target database.
    CR.POLICYBY(DBTYPE)
      The reorganization policy is selected based on the type of
      the target database. When you specify this option, the
      reorganization policy that is named SYS.DBDTYPE.dbtype in
      the Input repository of IMS Tools KB is used. dbtype is one
      of HDAM, HIDAM, PHDAM, PHIDAM, HISAM, or SHISAM.
    CR.POLICYBY(NAME)
      The reorganization policy is selected based on the policy
      name that is specified on the CR.POLICYNM keyword. When you
      specify this option, you must also specify the CR.POLICYNM
      keyword.
  Format  (DBDNAME | DBTYPE | NAME)
  Default value  DBTYPE
  -------
  CR.POLICYNM keyword
  Use this keyword to specify the name of the reorganization
  policy for database diagnosis.
  This keyword must be specified together with the
  CR.POLICYBY(NAME) keyword.
  Format  (policyname)
    where policyname is the 1- to 20-alphanumeric name of the
    reorganization policy.
  Default value  None.
  -------
  CR.PRINTRPRT keyword
  Use this keyword to print the Diagnosis report to the output
  stream.
  If you specify CR.PRINTRPRT(Y), the Diagnosis report is printed
  to the output stream. To omit the Diagnosis report, specify
  CR.PRINTRPRT(N).
  Format  (Y | N)
  Default value  Y
  -------
  CR.SENSOR_HOME keyword
  Use this keyword to request DB Sensor to collect additional
  data elements that are related to root segment distribution.
  When CR.SENSOR_HOME(Y) is specified, DB sensor collects the
  following additional data elements:
  - DB_NUM_ROOT_NOHOME
  - DB_PCT_NUM_ROOT_NOHOME
  - DB_AVG_LEN_SYNONYM_CHAIN
  Because DB Sensor calls a randomizer to collect data for these
  elements, the CPU time and the elapsed time increase compared to
  when CR.SENSOR_HOME(N) is specified.
  Restriction: If the key compression option of the Segment
  Edit/Compression exit routine is specified for the root segment,
  these data elements are not collected even when
  CR.SENSOR_HOME(Y) is specified.
  The data elements that are additionally collected when
  CR.SENSOR_HOME(Y) are useful factors for determining the need of
  database reorganization.
  Format  (Y | N)
  Default value  Y
  -------
  CR.STORERPRT keyword
  Use this keyword to store the Diagnosis report in the Output
  repository of IMS Tools KB.
  If you specify CR.STORERPRT(Y), the Diagnosis report is stored
  in the Output repository of IMS Tools KB. If you do not want to
  store the report in the repository, specify CR.STORERPRT(N).
  Format  (Y | N)
  Default value  Y
  -------
  ITKBDATA keyword
  Use this keyword to specify the type of additional data to be
  stored in the IMS Tools KB repository. To specify the ITKBDATA
  keyword, you must also specify the ITKBSERVER keyword.
  UTILHIST is the currently supported value for the ITKBDATA
  keyword. If ITKBDATA(UTILHIST) is specified, the utility history
  data for the reorganization job is stored in the Sensor Data
  repository of IMS Tools KB. The utility history data contains
  the reorganization timestamp, which indicates the time when the
  database or the HALDB partition was reorganized.
  Format  (UTILHIST)
  Default value  None.
  ----------------------------------------------------------------
  > Troubleshooting
  >> Messages and codes
  >>> Messages
  New messages:
  HRF01604I Utility history data for dbdname  partname  stored
  HRF01605W An error occurred in HKTEXST call, FUNC=, RC=, RSN=
  HRF01606W Utility history data process was canceled. REASON: rsn
  HRF01611I Reorganization starts for database dbname
  HRF01612I Reorganization is not needed for database dbname
  HRF01613I One or more exceptions are detected in database dbname
  HRF01614I No exception is detected in database dbname
  HRF01615I Database dbname is reorganized because REORGDIAG is
  specified
  HRF01616W An error occurred in BBECRAPI call, FUNC=, RC=, RSN=
  HRF01617W Conditional Reorg service is deactivated. REASON: rsn
  

APAR Information

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

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

  UI26291

Modules/Macros

• HAHP210J HRFOCRSS HRFODSN0 HRFOLEV0 HRFOREOD
  HRFOREOE HRFOREOF HRFOREO0 HRFOREO8 HRFOREO9 HRFOUOW1 HRFXEXST
  HRFYCCDF HRFYCCRD HRFYCC01 HRFYITKB HRFYMSGL HRFYMSGT HRFYSVLS
  

Fix information

• Fixed component name

  IM DB SOLUTION

• Fixed component ID

  5655S7700

Applicable component levels

• R210 PSY UI26291

     UP15/03/28 P F503

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.