How to change the date on Sysview for Db2 reports from MM/DD/YY format

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

How to modify the Sysview for Db2 for z/OS (IDB2) date format on generated reports from MM/DD/YY format.

Resolution

If submitting the IDB2 report from a BATCH job, 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 submitting the IDB2 report as an online IQL, 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.