Reading SMF Data
Can you use CA Insight for DB2 to read SMF data?
Yes it can read SMF data direct.
You can either create your own reports or use some of the supplied CA reports depending on what you
are looking to report on.
CA SYSVIEW® Performance Management Option for DB2 Batch reporting guide for details of
reports we supply.
Remember though that SYSVIEW for DB2 does not write to SMF so you would have
to start your own traces directed to SMF.
To capture and store specific information on SQL errors like your -805
then a product like CA Detector is probably more useful and you wouldn't
need traces for DB2 Statements.