Starting specified IFCIDS thru Sysview for Db2
search cancel

Starting specified IFCIDS thru Sysview for Db2

book

Article ID: 13827

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Can the following performance traces be started through Sysview Performance Management Option for Db2 for z/OS (IDB2):

IFCID(003,023,024,025,090,091,105,172,196,197,199,203,204,205,206,207,208,209, 210,221,224,235,236,239,250,258,313)

If yes, in which IDB2 parameter should they be specified.

Resolution

HIST-STATS-RECS=(nn,nn,…)  

Specifies a list of IFCID records to write to the statistics history file. IFCIDs 1 and 2 are included even when they are not specified.
You can include any valid IFCID, but the following IFCIDs are recommended and enabled by default: 

1—statistics subtype 0 

2—statistics subtype 1 

106—DSNZPARM data 

172—deadlock details 

196—timeout details 

199—data set I/O statistics 

202—statistics subtype 2 

225—DB2 storage statistics 

230—statistics subtype 3 

254—CF cache structure stats 

313—long running URs at checkpoint 

365—remote location activity 

Default: Enabled in the default SYSPARMS member. If this parameter is not specified, only IFCIDs 1 and 2 are enabled by default.