PI54994: EXTENDING DB2 REPORTING CAPABILITIES TO ARCHIVE ALSO OPERATIONS ENDED IN C OR E BELONGING TO NOT COMPLETED OCCURRENCES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 Reporting featured needs to be enhanced. It currently allows
  to archive operations ended in C,E belonging to completed occurr
  ences  or occurrences in error that contains recovered by cond
  operations. The enhancement required now is to have the option o
  f archiving those kind of operations also when they belong to no
  n completed occurrences (e.g. started).
  .
  KEYWORDS FOR SEARCHABILITY:
  SPE SPE9302 9302 930 SPE2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL IWS for z/OS 9.3.0 USERs who             *
  *                 run the DB2 reporting feature                *
  *                 in their environments.                       *
  *                                                              *
  *                 FUNCTION=REPDB2                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: There is the need of extending          *
  *                      the range of candidate operations       *
  *                      for archiving, to include also          *
  *                      the ones that get completed,            *
  *                      successfully or not, and                *
  *                      still belong to the current plan.       *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  There is the need of extending the range of the candidate
  operations for archiving, to include also the ones that
  get completed, successfully or not, and still belong
  to the current plan.
  

Problem conclusion

Temporary fix

Comments

• This ehnancement has been implemented by means of the
  new DBOPT parameter EXTENDEDARC.
  
                           - - -
   THE FOLLOWING TWS FOR ZOS PUBLICATION(S) WILL BE UPDATED:
                           - - -
  +------------------------------------------------------------+
  |                                                            |
  |TITLE:  IWS for z/OS Customization and Tuning               |
  |                                                            |
  |Add the following keyword in the DBOPT section of           |
  |the manual.                                                 |
  |                                                            |
  |EXTENDEDARC(YES,NO) DEFAULT: NO                             |
  |Specifies the type of occurrences that are saved by the     |
  |archiving process.                                          |
  |                                                            |
  |If you specify YES, the archiving process stores the        |
  |occurrences belonging to the old current plans              |
  |and the completed operations, either successful or in error,|
  |that still belong to the current plan.                      |
  |For example, the completed operations related to started    |
  |occurrences are processed to be saved in the DB2 tables.    |
  |                                                            |
  |If you specify NO, the archiving routines save only the     |
  |operations belonging to the occurrences that are no         |
  |longer in the current plan. All the other entries are       |
  |ignored.                                                    |
  |                                                            |
  |Note: When the archiving routines process a job, they do    |
  |not process it again at the next archiving run.             |
  |This means that if you set EXTENDEDARC(NO), the occurrences |
  |that were not stored during the current run will not be     |
  |stored during the next run, even if you change the setting  |
  |to EXTENDEARC(YES).                                         |
  +------------------------------------------------------------+
  

APAR Information

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

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

  UI36331 UI36332 UI36333

Modules/Macros

•    EQQDBCTX EQQDCRES EQQDPLOP EQQDPNWT EQQDPOOP
  EQQDPXRE EQQEMCCS EQQEMR03 EQQMC3CH EQQZRCHV EQQZSPRM
  

Fix information

• Fixed component name

  TIV WRKLD SCHD

• Fixed component ID

  5697WSZ01

Applicable component levels

• R930 PSY UI36331

     UP16/03/23 P F603

• R932 PSY UI36332

     UP16/03/23 P F603

• R933 PSY UI36333

     UP16/03/23 P F603

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.