Articles & Content


A DB2 hitchhikers guide to RMF and SMF. (A11)

Topic: 2011 NA

Subtopic: DB2 for z/OS

DATE: 2011-5-5 (01:30 PM - 02:30 PM)
SPEAKERS: Frank Petersen (Bankdata)

This presentation will go through DB2 with focus on the related or interesting issues in RMF and SMF. There will however also be some general information on how RMF and SMF can be used to help understand general problems in your installation.The presentation is to be considered as a 'brush up', but in many installations DBA'a and z/OS Systems Programmers are so distant from each other that knowledge in this area has been lost or degraded. Even though this is a 'brush up', there will also be advanced stuff. For instance there will be shown ways to extract data from RMF in "almost" real time, which might not be known to everybody. In this way RMF data can easily be included in your performance data warehouse. There will also be a few hints on related issued in Omegamon/DB2.

EXP. LEVEL: Beginner,Intermediate


Give the audience an understanding of how DB2 interacts with and uses SMF and the role of RMF and SMF in the z/OS system.

Make the audience able to use RMF actively to examine and understand problems seen in DB2.

Make a DB2 DBA or Systems Programmer capable of taking discussions with z/OS experts at their site concerning system setup and specific problems.

Make a DB2 DBA or Systems Programmer capable of extracting certain RMF data on the fly to include these data in the installations performance Data Warehouse.

Briefly discuss other tools that might contribute with related information (Omegamon DB2 and SDSF).

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.