News
Abstract
CHECK_SYSROUTINE procedure added to SYSTOOLS
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > CHECK_SYSROUTINE procedure added to SYSTOOLS
Many customers have a High Availability configuration where a backup machine needs to exactly match the production environment.
Db2 for i catalog tables are not replicated objects, so entries about Db2 external stored procedures and user-defined functions can cause the catalog tables to be out of sync.
Keeping SQL and external procedure and function database catalog entries in sync across machines is a complex task. Db2 for i is providing a catalog assessment utility that compares a target system's SYSROUTINE catalog with the version on the local system.
See IBM Documentation for details: CHECK_SYSROUTINE procedure
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11168804