How to figure out the actual log bytes for the IDB2 SUBSYSTEM_DETAIL TABLE?
search cancel

How to figure out the actual log bytes for the IDB2 SUBSYSTEM_DETAIL TABLE?

book

Article ID: 269130

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

Issue/Introduction

Using SUBSYSTEM_DETAIL TABLE(request ARCISTD) to try to figure out logbytes.  How to figure out the actual log bytes for the SUBSYSTEM_DETAIL TABLE?

Environment

Release : 20.0

Resolution

The corresponding THD_BYTES_LOGGED column of APPLICATION_DAILY table is not available in SUBSYSTEM_DETAIL table. Instead those corresponding columns are available in SUBSYS_ACCT_BY_CONN_DETAIL and SUBSYS_ACCT_BY_CONN_DAILY archive tables. Check the request ARCISACD for SUBSYS_ACCT_BY_CONN_DETAIL (THD-BYTES-LOGGED) or at the request ARCISACS for SUBSYS_ACCT_BY_CONN_DAILY (SUM(THD-BYTES-LOGGED)) when looking for summary data.