Page Comparison

...

1. Create a properties file for the new database. This file contains the database related properties that are available when you install install.

   Code Block
   $ mzsh mzadmin/<password> db-scripts create-properties \ --properties-file <properties file>

   
   

2. Update the properties that are applicable for the new database type. For further information about the properties in this file, see 3.1.3.2 Properties for Oracle, 3.1.3.3 Properties for PostgreSQL or 3.1.3.4 Properties for SAP HANA in the Installation Instructions. 
   
   

3. Extract the database scripts that are required to create the new database.

   Code Block
   $ mzsh mzadmin/<password> db-scripts extract --output-directory <db script directory> \ --properties-file <properties file>

   
   

4. When the database and are and Image Added 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.

   
   

5. Create the new database.

   For an Oracle database, follow the steps in 3.2.3 Oracle Database Creation in the Installation Instructions.

   For an Oracle database in Amazon Web Services, follow the steps in 3.2.4 Oracle Database Creation in Amazon Web Services in the Installation Instructions.

   For a PostgreSQL database , follow the steps in 3.4.3 PostgreSQL Database Creation in the Installation Instructions. 

   For a SAP HANA database, follow the steps in 3.5.3 SAP HANA Database Creation in the Installation Instructions.
   
   

6. Disable all workflow groups from the Execution Manager in Desktop, or by entering an mzsh command, for example:

   Code Block
   language text theme Eclipse
   $ mzsh mzadmin/<password> wfgroupdisable \*

   
   

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

   
   

7. Stop all batch workflows and let them finish execution.
   
   
8. Shut down all connected Desktops.
   
   

9. If you want to see which Desktops that are connected, you can use the following command:

   Code Block
   language text theme Eclipse
   $ mzsh mzadmin/<password> pico -view

   Shut down all EC/ECSAs.

   theme

   Code Block
   language	text
   	Eclipse
   $ mzsh shutdown platform <ec name> <ecsa name>

   
   

10. Set up the connection to the new database.

    For Oracle:

    Code Block
    language text theme Eclipse
    $ cd ./scripts/system-configure $ ./oracle.sh

    For PostgreSQL:

    Code Block
    language text theme Eclipse
    $ cd ./scripts/system-configure $ ./postgresql.sh

    For SAP HANA:

    Code Block
    $ cd ./scripts/system-configure $ ./saphana.sh

    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: 

    <host> <port> <username> <password> <dbname> <SAP HANA JDBC driver dir>

    The user needs to specify the mandatory parameters such as the SQL port where the tenant database is listening. The <dbname> field indicates the tenant name, while the <SAP HANA JDBC driver dir> is the name of the directory where the ngbc.jar file is stored. 
    
    

11. Restart the platform. 

    Code Block
    language text theme Eclipse
    $ mzsh restart platform

    
    

12. Start all EC/ECSAs that were previously shut down.

    Code Block
    language text theme Eclipse
    $ mzsh startup <ec names> <ecsa names>

    
    

13. Enable the workflow groups.