Converting the Engine System Database
System Database Backup
It is highly recommended that you back up your system database before the conversion.
Engine Configuration Tool
Step 1
Start the Engine Configuration tool (AxonIvyEngineConfig) of the new Axon.ivy Engine in the browser and switch to the System Database tab.A message will be shown that the current database is outdated:
Step 2
To automatically convert your old system database click the Convert Database button. A dialog appears asking for confirmation:
Confirm the dialog and the system database will be converted automatically. The next attempt to connect to the now converted database will succeed.
Auto Convert Property
Instead of using the Engine Configuration Tool to convert the system database you can also set the autoConvert property to true in the serverconfig.xml in the configuration directory. Then the system database will be converted automatically on the next engine start.
Notes
Stop other connections to the system database!
Depending on the conversion steps and your database system it may be necessary to cut all connections to the system database to avoid problems. If you have problems with the conversion, please disconnect all other database management tools, clients or other tools that has a connection to the system database and try again.
IBM Db2 System i (AS400, iSeries)
Before converting a system database located on a Db2 IBM System i the following command must be execute on a green screen on the system to prevent the conversion to fail with a SQL0952 error:
ADDRPYLE SEQNBR(9999)
MSGID(CPA32B2) RPY(I)
This will add an I (Ignore) auto reply for the message CPA32B2. This is a global setting affecting the whole IBM System i. Therefore, the added auto reply should be removed once the system database is successfully converted using the following command:
RMVRPYLE SEQNBR(9999)