RETAIN STATSTIME TIMESTAMP GOING FROM SOURCE TO TARGET

book

Article ID: 49643

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector 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