Skip to Content

Migrate Access Path Statistics process

Migrating access path statistics is a three-step operation.

  1. Extract the statistics from the source Db2 subsystem. This process creates a script containing the access path statistics to update on the target Db2 catalog.
  2. Apply rules for translating the object names according to the target Db2 subsystem.
  3. Input this script file a Db2 Update step, run against the target subsystem (SSID).

Related topic

Migrating access path statistics

(BMC.DB2.SPE2310) 
The user administering the Extract or the Update jobs must have the appropriate authority to access the Db2 catalog. You can also use the migrate stats user ID with the authorities determined by your shop.

Because of the method used to extract the statistics, BMC AMI SQL Explorer for Db2 does not validate that the objects exist in the target environment. If the objects do not exist, the Update job receives the following message: The following row not found for update.

Warning

Important

Migrate Access Path Statistics cannot process temporary tables, because temporary tables have no column definitions to examine.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI SQL Explorer for Db2 13.1