How to change the date on Insight reports from MM/DD/YY format?

Products

• RC Compare for DB2 for z/OS
• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

This describes how to change the date on Insight generated reports from MM/DD/YY format.

Solution:

First, make sure you have PTF UCID187 applied.

Next:

If you are submitting your report from a BATCH job, you will need to change the DATE parm in your IDRWPRMS member of your IDB2.SOURCE library to your desired format (e.g. YY/MM/DD, DD/MM/YY).

If you are submitting your report as an online IQL, you will need to first change the DATE parm in your IDDCPRMS member of your IDB2.SOURCE library to your desired format (e.g. YY/MM/DD, DD/MM/YY). Then you will need to recycle the Data Collector started tasks in order to pick up the ew DATE parm.

Environment

Release:
Component: IDB2