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
2024
First publish date
1999
Last edition
2024-08-27
Last publish date
2024-08-27T12:04:03.662993

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.