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