Missing Database Analyzer (PDA) Action Condition Member RAAACTB2 and RAAACTB3 (high-level.SRCLIB) under Release r12 SP0.

Products

• RC Compare for DB2 for z/OS
• 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
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS
• CA Distributed Database Management
• CA Database Analyzer for DB2 for Oracle
• Endevor
• Endevor Natural Integration
• Endevor - ECLIPSE Plugin
• Endevor - Enterprise Workbench
• Database Analyzer (IMS Tools)
• Mainframe Configuration Manager for IMS for z/OS
• IMS TOOLS - MISC
• Compress Data Compression (IMS Tools)
• Database Analyzer for IMS for z/OS
• Database Copier for IMS for z/OS
• Database Organizer for IMS for z/OS
• Mainframe Extended Terminal Manager (IMS Tools)
• High Performance Recovery for IMS for z/OS
• Database Organizer (IMS Tools)
• Mainframe Program Restart Manager for IMS for z/OS
• Secondary Index Builder for IMS for z/OS
• Secondary Index for IMS for z/OS

Issue/Introduction

Description:

Successfully upgraded to new R12 SP0 Version of CA Database Analyzer for DB2 for z/OS and the pre-defined user-supplied conditions Member's RAAACTB2 and RAAACTB3 from the high-level.SRCLIB product library are missing, if not copying over the old Libraries from previous installed version within the Post Install Process.

Solution:

Since Release R12 SP0 the Member's RAAACTB2 and RAAACTB3 are removed from the high-level.SRCLIB, because of the new #INCLUDE statement.

For more Information, please see CA Database Management Solutions r12.0 for DB2 for z/OS, Release Notes, Chapter1 on Page 21: #INCLUDE Custom SQL Enhancement or Check Online using options C;3;5 from the PDA main menu.

A new #INCLUDE statement is now provided with CA Database Analyzer that lets you extend the predicates of existing action conditions and create customized conditions without modifying Assembler source and building the RAAACTB2 or RAAACTB3 load modules. The latter functionality is being depreciated and is replaced by the #INCLUDEs.

The SQL statements (extended predicates and complete user customized conditions) are created in model members in the model libraries.

Note: The customized member can be put into any of the model libraries in your high-level.PARMLIB(DSNAMEx).

Once created, you must specify a #INCLUDE statement in the Condition field on the Extract or Action Conditions panel, followed by the member name in which the custom SQL was created. CA Database Analyzer reads the contents of the model library member used on the #INCLUDE statement during the condition evaluation and appends the user SQL to the end of the existing condition (extending the predicate) or executes the complete custom user SQL statement (customizable SQL condition). In either case, the custom SQL is used in CA Database Analyzer processing to determine whether an object has met the selection criteria. This enhancement makes adding action conditions and Real Time Object Selection (RTOS) criteria more flexible.

Environment

Release:
Component: ENDBAS