{"type":"doc","content":[{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"This feature is not currently available. See the known issue ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://infozone.atlassian.net/wiki/spaces/MD91/pages/23278867/Known+Issues#Unable-to-change-platform-database-after-installation"}}]}]},{"type":"paragraph"},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"details","parameters":{"macroParams":{"hidden":{"value":"true"}},"macroMetadata":{"macroId":{"value":"21dee662738d4b7b1e07d74281cb6bbc"},"schemaVersion":{"value":"1"},"title":"Page Properties"}},"localId":"6730e84d-d678-4e9d-95dd-5a032935dc89"},"content":[{"type":"paragraph","content":[{"text":"This section describes how to change the Platform database. The new database can be of the type Oracle, PostgreSQL or SAP HANA.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Note!","type":"text"}]},{"type":"paragraph","content":[{"text":"Changing the database will cause the stored data to be lost.","type":"text"}]},{"type":"paragraph","content":[{"text":"This includes:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System log messages","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Duplicate Batch processing data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Archiving data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error Correction System data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User Access data (deprecated and configurable with Platform property)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System Statistics","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Alarm data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Group Server data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"License data","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Workflow transactions and workflow states","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Migration of the data listed above is possible, however the method for this is outside the scope of this document.","type":"text"}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"text":"Follow these steps to change the Platform database type to an Oracle, PostgreSQL or SAP HANA database.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a properties file for the new database. This file contains the database related properties that are available when you install MediationZone.","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ mzsh mzadmin/ db-scripts create-properties \\\n--properties-file ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update the properties that are applicable for the new database type. For further information about the properties in this file, see ","type":"text"},{"text":"Properties for Oracle","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD93&title=Properties%20for%20Oracle%20%28to%20be%20removed%29&linkCreation=true&fromPageId=205657718"}}]},{"text":", ","type":"text"},{"text":"Properties for PostgreSQL (to be removed)","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD93&title=Properties%20for%20PostgreSQL%20%28to%20be%20removed%29&linkCreation=true&fromPageId=205657718"}}]},{"text":" or ","type":"text"},{"text":"Properties for SAP HANA","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD93&title=Properties%20for%20SAP%20HANA%20%28to%20be%20removed%29&linkCreation=true&fromPageId=205657718"}}]},{"text":" in the ","type":"text"},{"text":"Installa","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD93/pages/204996705"}}]},{"text":" (to be removed)","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/pages/createpage.action?spaceKey=MD93&title=Properties%20for%20SAP%20HANA%20%28to%20be%20removed%29&linkCreation=true&fromPageId=205657718"}}]},{"text":" ","type":"text"},{"text":"ion Instructions","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD93/pages/204996705"}}]},{"text":". ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Extract the database scripts that are required to create the new database.","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ mzsh mzadmin/ db-scripts extract --output-directory \\\n--properties-file ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When the database and MediationZone are not installed on the same machine (the database may be installed on any machine within the network), you need to transfer the database definition files.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create the new database.","type":"text"}]},{"type":"paragraph","content":[{"text":"For an Oracle database, follow the steps in ","type":"text"},{"text":"Oracle Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD93/pages/205029608"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"For a PostgreSQL database , follow the steps in ","type":"text"},{"text":"PostgreSQL Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD93/pages/204669918"}}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"For a SAP HANA database, follow the steps in ","type":"text"},{"text":"SAP HANA Database Creation","type":"text","marks":[{"type":"link","attrs":{"href":"https://infozone.atlassian.net/wiki/spaces/MD93/pages/205029638"}}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable all workflow groups from the Execution Manager in Desktop, or by entering an mzsh command, for example:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh mzadmin/ wfgroupdisable \\*","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Note!

If you use the wfgroupdisable command, make sure that you enable all system tasks again when you are done.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Note!","type":"text"}]},{"type":"paragraph","content":[{"text":"If you use the ","type":"text"},{"text":"wfgroupdisable ","type":"text","marks":[{"type":"code"}]},{"text":"command, make sure that you enable all system tasks again when you are done.","type":"text"}]}]}],"version":1},"reason":"A note macro in a list item can't be created or edited in the new editor."}}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Stop all batch workflows and let them finish execution.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Shut down all connected Desktops.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you want to see which Desktops that are connected, you can use the following command:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh mzadmin/ pico -view","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set up the connection to the new database.","type":"text"}]},{"type":"paragraph","content":[{"text":"For Oracle:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ cd ./scripts/system-configure\n$ ./oracle.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"For PostgreSQL:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ cd ./scripts/system-configure\n$ ./postgresql.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"For SAP HANA:","type":"text"}]},{"type":"codeBlock","content":[{"text":"$ cd ./scripts/system-configure\n$ ./saphana.sh","type":"text"}]},{"type":"paragraph","content":[{"text":"When the saphana.sh script is launched without any parameters, it will return a list of expected parameters, an example command output is the following: ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]}]},{"type":"paragraph","content":[{"text":"The user needs to specify the mandatory parameters such as the SQL port where the tenant database is listening. The","type":"text"},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"field indicates the tenant name, while the ","type":"text"},{"text":"","type":"text","marks":[{"type":"em"}]},{"text":" is the name of the directory where the ngbc.jar file is stored. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the platform. ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh restart platform","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Start all ECs that were previously shut down.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"plaintext"},"content":[{"text":"$ mzsh startup ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable the workflow groups.","type":"text"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"scroll-pagebreak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2de953e2-389b-4d61-8fc3-d0111518066a"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://scroll-exporter-extensions.us.exporter.k15t.app/static/assets/images/macro-icons/scroll-pagebreak.svg"}}],"title":"Scroll Pagebreak"}},"localId":"61c8e86f-7041-46e0-af5e-c3ee9ea2dbba"}}]},{"type":"paragraph"}],"version":1}

Changing Platform Database