Articles & Content


CA Database Analyzer - you can’t do that, can you ? (B09)

Topic: DB2 for z/OS

Subtopic: 2009

DATE: 2009-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Steen Rasmussen (CA)

The attendee will get an "alternative" view of how CA Database Analyzer can be used (and mis-used) to do almost everything under the sun except coffee and dinner. Often the Database Administrators or Application DBA’s need to generate certain processes for a number of objects based on conditions or simply unconditional, and once you know the small secrets there are an incredible number of tasks which can be done in a fraction of the time it normally would take. A couple of examples could be to send an email when certain RTS values are hit or violated, or generate SQL statements or JCL pieces for objects meeting certain criteria, but all the examples covered are from real life scenarios.

EXP. LEVEL: Beginner,Intermediate


A quick overview of the engine - Extracts and Actions

Exploitation of Conditions - and make your own if needed

Model skeletons - this is where the action really is

Using IF-ELSE logic and Symbolic Variables to brew your own coffee

Real life sophisticated examples how all the pieces tie together to fit your needs and create what you need in seconds compared to hours of manually work

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.