...
- Disable all workflow groups, either from the Execution Manager in Desktop, or by using the
mzsh wfdisable
command. Let all batch workflows finish execution.
Note title Note! Batch workflows containing Inter Workflow agents that do not have the Deactivate on Idle check box selected will have to be shutdown manually.
Use the command
mzsh topo
get to list the instances of the the servicestorage-dispatcher
jdbc parameters.Code Block language text theme Eclipse $ mzsh topo get -s --format data-only topo://services:standard/container:<mz.container>/pico:platform/obj:storage-dispatcherconfig.properties.mz.jdbc
Info title Example - List of sevice instancesjdbc parameters Code Block { "storage-dispatcher1" : { "config" : { "password" : "DR_DEFAULT_KEY-48851644227183C2041D838568E117EC", "type" : "oracle", "url" : "jdbc:oracle:thin:@myhost:1521:orcl" "user" : "mzadmin" }, "start-after" : [], "template" : "1/standard/oracle" } }language text theme Eclipse Use the
mzsh topo
set
command to update the passwords in the STRpassword for mzadmin:Code Block language text theme Eclipse $ mzsh topo set topo://services:standard/container:<mz.container>/pico:platform/val:storage-dispatcher.<service instance>.\ configconfig.properties.mz.jdbc.password `mzsh encryptpassword <password>`<new password>`
Info title Example - Updating the mzadmin password(s) Code Block language text theme Eclipse $ mzsh topo set topo://services:standardcontainer:platform1/pico:platform/val:storage-dispatcher.storage-dispatcher1.\ configconfig.properties.mz.jdbc.password `mzsh encryptpassword mypassword`
- Shut down the platform using the
mzsh shutdown
command. - Update the Oracle, PostgreSQL or SAP HANA passwords to correspond to the ones you set in the STR.
- Startup the Platform.
- Enable all workflow groups and start all workflows again.