Upgrading Precisely Assure MIMIX™ Software version 10.0.19.00 and older on Skytap VMs

This procedure will upgrade Precisely Assure MIMIX™ Software version 10.0.19.00 or older to the most current version on Skytap VMs. If your Assure MIMIX™ Software version is 10.0.19.00 or older (use the LAKEVIEW/WRKPRD command to see the version information) then use these steps to upgrade.

This upgrade procedure is required only for Skytap Assure MIMIX™ Software version 10.0.19.00 and older. If your Skytap Assure MIMIX™ Software version is 10.0.20.00 or newer, follow the steps in Upgrading Precisely Assure MIMIX™ Software software (from version 10.0.20.00 or higher).

Type ENDMMX *IMMED and press Enter to end all Assure MIMIX™ Software jobs.

This should leave the PORTxxxxx jobs active on each node.
Sign out and sign in using a high-power profile (as described in Prerequisites) to a Skytap Assure MIMIX™ Software-enabled node. If there are more than two nodes in the installation, the node must be a *MGT node.
Type CHGJOB CCSID(37) DECFMT(*BLANK) and press Enter to change the CCSID of the job to 37.
Type CALL QCMD and press Enter.
Press F11 to expand the command input to full screen.
Press F10 to include detailed messages (this is a toggle PF key).
Copy the following command, paste it to the command window, and then press Enter:

/******** ISSUE 'CHGJOB CCSID(37)' BEFORE RUNNING THIS COMMAND ********/ 
RUNSQL COMMIT(*NONE) SQL('BEGIN DECLARE C CLOB(2G) CCSID 1208; DECLARE M 
CHAR(2000);DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN CALL QCMDEXC(     
''QSH CMD(''''rm -rf /qsys.lib/qgpl.lib/cldrqs.dtaara'''')'');SET M=     
REPEAT('' '',135) CONCAT''ERROR MXUPG: SEE SKYTAP MIMIX INSTALLATION GU''
CONCAT ''IDE FOR FURTHER INFO'' CONCAT REPEAT('' '',90) CONCAT ''ERROR'';
SIGNAL SQLSTATE ''MXUPG'' SET MESSAGE_TEXT=M;END;SET C = REPEAT(         
UX''0020'',690000000);CALL QCMDEXC(''CHGJOB CCSID(37)'');CALL QCMDEXC(   
''QSH CMD(''''rm -rf /qsys.lib/qgpl.lib/cldrqs.dtaara'''')'');CALL       
QCMDEXC(''CRTDTAARA QGPL/CLDRQS TYPE(*CHAR) LEN(10) VALUE(UPGRADE)'');   
CALL QCMDEXC(''QSH CMD(''''rm -rf /qsys.lib/qgpl.lib/inscfgmmx.file'''') 
'');CALL QCMDEXC(''CRTSAVF QGPL/INSCFGMMX'');SET C = QSYS2.HTTP_GET(     
''http://gw/skytap?feature=hadr&request=installer&provider=precisely''); 
CALL QSYS2.IFS_WRITE_BINARY(''/qsys.lib/qgpl.lib/inscfgmmx.file'',LINE =>
BASE64_DECODE(TRIM(T UX''000D''FROM TRIM(T UX''000A''FROM C))),FILE_CCSID
=>37,OVERWRITE=>''REPLACE''); SET C = '''';CALL QCMDEXC(''LODRUN *SAVF   
SAVF(QGPL/INSCFGMMX)''); END') DECMPT(*PERIOD)

This command downloads the main installer from the Skytap repository. After a short delay, the INSCFGMMX command displays:

Type the installation library name.
For RMTNODE, enter *ALL to upgrade all configured nodes, or enter *NONE to upgrade only the local node.

Press F1 to see the available help.
                    Install and Configure MIMIX (INSCFGMMX)
Type choices, press Enter.
Installation library . . . . . . > MIMIX         Name
Local node information:
  System def. name for MIMIX . . LPAR1         Name
  Role for replication . . . . . *PRIMARY      *PRIMARY, *BACKUP, *SAME
  Host name or address . . . . . *NODE
  Port number or alias . . . . . 50410
Remote node information:
  System def. name for MIMIX . . *ALL          Name, *ALL, *INSTALLED, *NONE
  Role for replication . . . . . *BACKUP       *PRIMARY, *BACKUP, *SAME
  Host name or address . . . . . *NODE
  Port number or alias . . . . . 50410
  User profile . . . . . . . . . *CURRENT      Character value, *CURRENT
  Password . . . . . . . . . . . ________
Product-level sec. additions:   _
  User profile . . . . . . . .   *NONE         *NONE, Name
  MIMIX PLS level. . . . . . .   _____         *OPR, *DSP, *MGT, *ADM...
  Lic Mgr. PLS level . . . . .   _____         *NONE, *DSP, *OPR, *MGT...
            + for more values _
System to start AUI server . .   *NONE         *NONE, *ALL

F3=Exit  F4=Prompt  F5=Refresh  F12=Cancel  F13=How to use this display