RETAIN STATSTIME TIMESTAMP GOING FROM SOURCE TO TARGET

book

Article ID: 49643

calendar_today

Updated On:

Products

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

Issue/Introduction

Question: 

Is there any way to retain the STATSTIME timestamp from the source rather than having it be set to the current date/time on the target when copying stats from source to target? The purpose being to know how old the stats really are.

Answer: 

The STATSTIME displays the TIMESTAMP(date and time) column when RUNSTATS was last executed on any one partition. PSM does not have the ability to retain the STATSTIME timestamp from the source when you migrate stats from source to target.

Environment

Release:
Component: PPADB2