Db2 Data Gate stored procedures

The Db2 Data Gate stored procedures provide the functionality for all interaction with Db2 for z/OS®. Stored procedures are executed when you run Db2 Data Gate functions from the Cloud Pak for Data user interface. However, you can also run the stored procedures standalone from z/OS or embed them in custom applications.

Uses

The Db2 Data Gate stored procedures provide functions for the following tasks:

  • Testing the connection between Db2 for z/OS and a Db2 Data Gate instance
  • Starting or stopping query acceleration for a a Db2 Data Gate instance
  • Adding or removing tables from a Db2 Data Gate instance
  • Enabling or disabling tables for query acceleration
  • Loading tables
  • Enabling or disabling tables for synchronization
  • Archiving or restoring Db2 for z/OS tables or partitions
  • Obtaining information about queries
  • Collecting table statistics

Shared set of stored procedures

Db2 Data Gate and IBM® Db2 Analytics Accelerator for z/OS basically use the same stored procedures.

For a complete description of the stored procedures, see Stored procedures in the IBM Db2 Analytics Accelerator for z/OS documentation.

Mind that the following stored procedures are currently not used by Db2 Data Gate, and that running these in a Db2 Data Gate context is therefore discouraged:

  • SYSPROC.ACCEL_REMOVE_CREDENTIALS
  • SYSPROC.ACCEL_UPDATE_SOFTWARE2