Requirements for replicating SQL stored procedure operations - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2023
First publish date
1999
ft:lastEdition
2024-05-07
ft:lastPublication
2024-05-07T13:36:02.962500

The following configuration requirements and restrictions must be met:

  • Apply any IBM PTFs (or their supersedes) associated with IBM i releases as they pertain to your environment. Log in to Support and refer the Technical Documents page for a list of required and recommended IBM PTFs.

  • To correctly replicate a create operation, name mapping cannot be used for either the library or program name.

  • GRANT and REVOKE only affect the associated program object. MIMIX replicates these operations correctly.

  • The COMMENT statement cannot be replicated.

  • An appropriately configured data group object entry must identify the object to which the stored procedure is associated.

Stored procedures or other system table concepts that have non-deterministic ties to a library-based object cannot be replicated.