What tables are maintained by implementing the ALOGDEL member of CDBAPARM
search cancel

What tables are maintained by implementing the ALOGDEL member of CDBAPARM

book

Article ID: 25704

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

What tables are processed when one implements the ALOGDEL member of hlq.CDBAPARM to maintain the
Database Management for Db2 for z/OS tools logging tables?

Resolution

The hlq.CDBAPARM ALOGDEL member can be edited to specify the number of days to keep log records.
One then needs to run the JCL from the LOG#ADEL member in hlq.CDBAJCL to delete old log records based on the days specified in ALOGDEL.

The ALOGDEL job purges the following tablespaces and tables:

Tablespace         Table
PTITSLOG           PTLOG_MAIN_#     MAIN logging table
PTITSSEC           PTLOG_SEC_#      RCS logging table
PTRALGT7           PTLOG_RDAMSG_#   Audit messages
PTRALGT7           PTLOG_DASTATS_#  Maintenance statistics
where # is a version number

 

The following are backup tables for restore processing if the above tables need to be restored after the ALOGDEL is complete.

These backup tables are populated during ALOGDEL processing: 
PTITSGBK         PTLOG_BACKUP_0202
PTITSGB2         PTLOG_BACKUP2_0202
Powered by Wolken Software