Data Gate on Cloud stored procedures

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

Uses

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

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

Shared set of stored procedures

Data Gate on Cloud and IBM Cloud® 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 for z/OS documentation.

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

  • SYSPROC.ACCEL_REMOVE_CREDENTIALS
  • SYSPROC.ACCEL_UPDATE_SOFTWARE2