SCQMSAMP members for loading data to Analytics Accelerator
The following SCQMSAMP members are utility jobs or scripts that perform accelerator operations in batch. These members are not created in Tools Customizer.
SCQMSAMP member | Description |
---|---|
CQM@LIDA | The IBM® Db2 Analytics Accelerator for z/OS® offload sample. |
CQMDDL | Creates the Performance History Database objects. |
CQMIADD | A REXX program to define accelerator shadow tables. Before running CQMIADD, you must first have an existing Db2 table. This REXX program is used by the CQMIDAD1, CQMIDAM1, CQMIDAM2, and CQMIDAM3 scripts. |
CQMIDAA |
CQMIDAA is an ISPF edit macro that modifies CQMDDL to
be compatible with Analytics Accelerator. When you
run CQMIDAA without parameters, the resulting DDL creates accelerator shadow tables. When
you run CQMIDAA with parameters, the resulting DDL creates accelerator-only tables. To
define accelerator-only tables, the macro requires the database name and the Analytics Accelerator name. The edit macro modifies the
Performance History Database in the following ways:
|
CQMIDAAL | Loads data from the Db2 Query Monitor Performance History Database to the Db2 Query Monitor accelerator shadow tables. |
CQMIDAD1 | Drops accelerator shadow tables and database. Use this any time you want to drop accelerator objects. |
CQMIDAD2 | Drops accelerator only tables and database. Use this any time you want to drop accelerator-only objects. |
CQMIDAM1 | Moves data from old accelerator schema to new accelerator schema (accelerator shadow or accelerator-only
tables) as long as the number and sequence of columns in old and new are the same. Before running
CQMIDAM1, make sure the new target database (#DBNEW#) and offload tables have been created using
CQMDDL.
|
CQMIDAM2 | Moves offloaded data from Db2 schema to accelerator schema. |
CQMIDAM3 | Migrates offloaded data from accelerator
schema created prior to PH17430 (#DBOLD#) to newly created accelerator schema (#DBNEW#) for support of anomaly
detection and data collection. Note: Db2 Query
Monitor
does not currently support altering the table structure of accelerator tables. CQMIDAM3 must be used to create the new
database with offload tables in the new column format and to migrate your data.
|
CQMIDEL | A REXX program to drop accelerator shadow tables. This REXX program is used by the CQMIDAD1, CQMIDAM1, CQMIDAM2, and CQMIDAM3 scripts. |
CQMIENBL | A REXX program to enable query acceleration for the accelerator shadow table by changing its state. This REXX program is used by the CQMIDAD1, CQMIDAM1, CQMIDAM2, and CQMIDAM3 scripts. |
CQMLDTAS | A REXX program to load data from the source tables in Db2 into the corresponding accelerator shadow tables. |