Data Gate stored procedures

The Data Gate stored procedures provide the functionality for all interaction with Db2 for z/OS. Stored procedures are executed when you run 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 Data Gate stored procedures provide functions for the following tasks:

  • Testing the connection between Db2 for z/OS and a Data Gate instance
  • Starting or stopping query acceleration for a a Data Gate instance
  • Adding or removing tables from a 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

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 Data Gate, and that running these in a Data Gate context is therefore discouraged:

  • SYSPROC.ACCEL_REMOVE_CREDENTIALS
  • SYSPROC.ACCEL_UPDATE_SOFTWARE2