Previous Topic: Test Encyclopedia FunctionsNext Topic: Package Bind


RUNSTATS, Rebind CA Gen Packages, and Image Copy

Before rebinding the packages, follow these steps to update DB2 statistics to optimize encyclopedia access:

  1. Run CEJOB06 or CAJOB06 again to update the DB2 statistics for the Host Encyclopedia tables and indexes.

    Uploading the models to the Host Encyclopedia and exporting to the public interface, populates many CA Gen tables. For DB2 optimization, a RUNSTATS of the CA Gen data tables, followed by a BIND of all CA Gen packages, speeds subsequent access to the encyclopedia.

  2. Run CEJOB07A to execute a DB2 BIND of the CA Gen packages taking advantage of the new RUNSTATS statistics.
  3. Run CEUCOPY to execute the DB2 COPY utility to create an image-copy of all CA Gen tablespaces.