Reading SMF data
search cancel

Reading SMF data


Article ID: 15329


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS


Storing SMF Data

One of my applications received an sqlcode -805. I've tried to get more information through option 6 - Thread History, but information from last week is no longer available. 

Is there a way that I can use CA Insight for DB2 to read SMF dataset created during the time of the event? If yes, how? 


z/os DB2


To answer your question re storing History Data. 


Yes you can unload history data into DB2 tables and then run SQL queries 

against these tables. 

To read about the whole process 

See the 

CA SYSVIEW® Performance Management Option for DB2 

System Reference Guide 


Chapter 8: Archiving DB2 Performance Data