Alternative solutions - 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
2025-11-18
ft:lastPublication
2025-11-18T09:56:35.178000
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

If you cannot use the SETIDCOLA command because of its known limitations, you have these options.

Manually reset the identity column starting point: Following a switch to the backup system, you can manually reset the restart value for tables with identity columns. The SQL statement ALTER TABLEnameALTER COLUMN can be used for this purpose.

Convert to SQL sequence objects: To overcome the limitations of identity column switching and to avoid the need to use the SETIDCOLA command, SQL sequence objects can be used instead of identity columns. Sequence objects are implemented using a data area which can be replicated by MIMIX. The data area for the sequence object must be configured for replication through the user journal (cooperatively processed).