Utility Services

These procedures provide interfaces to monitor and work with SQL in jobs on the current system or to compare constraint and routine information across systems.

CANCEL_SQL procedure
The CANCEL_SQL procedure requests cancellation of an SQL statement for the specified job.
CHECK_SYSCST procedure
The CHECK_SYSCST procedure compares entries in the QSYS2.SYSCONSTRAINTS table between two systems.
CHECK_SYSROUTINE procedure
The CHECK_SYSROUTINE procedure compares entries in the QSYS2.SYSROUTINES table between two systems.
DUMP_SQL_CURSORS procedure
The DUMP_SQL_CURSORS procedure lists the open cursors for a job.
FIND_AND_CANCEL_QSQSRVR_SQL procedure
The FIND_AND_CANCEL_QSQSRVR_SQL procedure finds a set of jobs with SQL activity and safely cancels them.
FIND_QSQSRVR_JOBS procedure
The FIND_QSQSRVR_JOBS procedure returns information about a QSQSRVR job.
GENERATE_SQL procedure
The GENERATE_SQL procedure generates the SQL data definition language statements required to recreate a database object. The results are returned in the specified database source file member or as a result set.
GENERATE_SQL_OBJECTS procedure
RESTART_IDENTITY procedure
The RESTART_IDENTITY procedure examines the source-table and determines the identity column and its next value. The next value and column name are used to configure the target-table to use the same next value.

Parent topic: DB2 for i Services