Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Disable all workflow groups, either from the Execution Manager in Desktop, or by using the mzsh wfdisable command.

  2. Let all batch workflows finish execution.

    Note
    titleNote!

    Batch workflows containing Inter Workflow agents that do not have the Deactivate on Idle check box selected will have to be shutdown manually.


  3. Use the command mzsh topo get to list the jdbc parameters.

    Code Block
    languagetext
    themeEclipse
    $ mzsh topo get -s --format data-only topo://container:<mz.container>/pico:platform/obj:config.properties.mz.jdbc


    Info
    titleExample - List of jdbc parameters


    Code Block
    languagetext
    themeEclipse
    mzsh topo get -s --format data-only topo://container:platform1/pico:platform/obj:config.properties.mz.jdbc
    
    {
      "password": "DR-4-48851644227183C2041D838568E117EC",
      "oracle": {
        "ons": ""
      },
      "type": "oracle",
      "user": "mzadmin",
      "url": "jdbc:oracle:thin:@//<install.ora.host>:1521/MZ"
    }    



  4. Use the mzsh topo set command to update the password for mzadmin in the STR:

    Code Block
    languagetext
    themeEclipse
    $ mzsh topo set topo://container:<mz.container>/pico:platform/val:config.properties.mz.jdbc.password `mzsh encryptpassword <new password>` 


    Info
    titleExample - Updating mzadmin password


    Code Block
    languagetext
    themeEclipse
    $ mzsh topo set topo://container:platform1/pico:platform/val:config.properties.mz.jdbc.password `mzsh encryptpassword mypassword` 



  5. Shut down the platform using the mzsh shutdown command.

  6. Update the Oracle, PostgreSQL or SAP HANA passwords to correspond to your new mzadmin password.

  7. Startup the Platform.

  8. Enable all workflow groups and start all workflows again.