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
ft:locale
en-US
Product name
Assure MIMIX
ft:title
Assure MIMIX Administrator Reference
Copyright
2025
First publish date
1999
ft:lastEdition
2026-03-10
ft:lastPublication
2026-03-10T14:48:05.710000
L1_Product_Gateway
Integrate
L2_Product_Segment
IBM Infrastructure
L3_Product_Brand
Precisely Assure
L4_Investment_Segment
IBM i HA
L5_Product_Group
IBM i HA
L6_Product_Name
Assure MIMIX

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.