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.

Table 1. SCQMSAMP library members for the offloading to Analytics Accelerator
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:
  • Removes all WITH DEFAULT clauses
  • Converts SQL statement text tables CQM_SUMM_TEXT, CQM_EXCP_TEXT, and CQM_SQLCODE_TEXT tables to the EBCDIC encoding
  • Changes the SQLTEXT column to VARCHAR(32000)
  • Changes the ROW_ID column to SMALLINT
  • Changes the buffer pool for the CQMMT1, CQMET1, and CQMST1 table spaces to BP32K
  • For accelerator-only tables, removes all CREATE TABLESPACE statements and add the IN ACCELERATOR clause to all tables
The EBCDIC code page does not support all characters available in the Unicode code page. The conversion of the Unicode SQL Statement text collected from Db2 to EBCDIC might result in data loss. Dynamic SQL texts that are more than 32K are truncated if you load using Analytics Accelerator.
CQMIDAAL Loads data from the Db2 Query Monitor 3.3.0 Performance History Database to the Db2 Query Monitor 3.3.0 accelerator shadow tables.
Important: When migrating from 3.2.0 accelerator shadow tables to 3.3.0 accelerator shadow tables, run CQMMIDAA before you run CQMIDAAL.
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.
  • If the target tables are accelerator-only tables, submit only the first step.
  • If the target tables are accelerator shadow tables, submit the entire job. In this case, new accelerator shadow tables are loaded in ONLY mode (only accelerator tables are populated, Db2 tables remain empty).
  • This job does not drop old tables. If you want to drop old tables and they are Db2 / accelerator-shadow tables, then use CQMIDAD1. If the tables are accelerator-only tables, use CQMIDAD2.
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.
CQMMIDAA Migrates data from Db2 Query Monitor V3.2 accelerator-only tables to Db2 Query Monitor V3.3 accelerator-only tables. When you run CQMMIDAA and then CQMIDAAL, migrates data from Db2 Query Monitor V3.2 accelerator shadow tables to Db2 Query Monitor V3.3 accelerator shadow tables.
Important: Before submitting CQMMIDAA, make sure that the V3.3 offload Db2 tables are empty.