DB2 tools R20 New table PTI.PREFCHKPT definition
search cancel

DB2 tools R20 New table PTI.PREFCHKPT definition

book

Article ID: 200229

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS Database Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

 After migration, the new table PTI.PREFCHKPT, and its columns was created with DATA CAPTURE CHANGES. Any particular reason? would that be fine to turn this off?
(ALTER TABLE PTI.PREFCHKPT NONE)

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

PTI.PREFCHKPT is defined with DATA CAPTURE CHANGES to ensure that complete log records are written for all updates. For that reason we recommend that you keep it on.