ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
DB2 tools R20 New table PTI.PREFCHKPT definition
Article ID: 200229
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.
Feedback
Yes
No
Powered by
