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
book
Article ID: 200229
calendar_today
Updated On:
Products
Database Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteInsight Performance Monitor for DB2 UDB for z/OSDatabase Analyzer for DB2 for z/OSDatabase 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.