After upgrading DB2, the format of some reports has changed.

Document ID : KB000007216
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After upgrading DB2, the format of some reports in RC/Query has changed. These reports were previously customized saved reports but after the upgrade they are no longer customized. This is affecting online reports as well as Batch Reporting.

Cause:

A customized Saved Report in RC/Query is DB2 version specific. When the reports are saved in table PTI.PTRCQ_SAVED_RPTS, the DB2 version of the subsystem is saved in column VERSION.

For example:

  • a report saved on a DB2 v10 subsystem, will have VERSION = 10R1M0
  • a report saved on a DB2 v11 subsystem, will have VERSION = 11R1M0

Therefore once a subsystem is upgraded then the saved report will no longer be applicable and will no longer be displayed in a customized format.

 

Resolution:

As of release r18 there was an enhancement to the Saved Reports functionality, that could help avoid or resolve these problems after an upgrade to DB2?

The Synchronize Save Report enhancement provides an option to upgrade saved reports from a previous version of DB2.

A user that has saved reports in RC/Query, can enter the REPORTS command on any RC/Query panel. Then on the RC/Q Customized Report Formats panel, the version of each report will be displayed and the synchronize option can be used:

Synchronize Save Report Profile  ===> N  (Y/N)

This will upgrade saved reports created in a lower version to the higher version of DB2.

Please note the warning, if you intend to use 'Synchronize Save Report = Y', do not use line commands on the saved reports. 

Additional Information:

Further details on synchronizing saved reports can be found at Synchronize Save Report