Instructions for installing the patch for the OLAP server component
Service level 4.00.012 - US English
April 2001

Summary of problems fixed

The Essbase/400 4.00.012 Server patch includes the following updates:

• Cubes created with the RSM option may now be directed to specific libraries named by the user by configuring the applications and databases in the RSM.CFG file.

Performance improvements for servers running on V4R5.
DBCS fix for restructuring outlines using attribute dimensnions. (F6562)

Downloading the Patch

This patch will fix all problems described in the previous document. The patch must be applied only to the ShowCase STRATEGY 4.0 release. Refer to the instructions below for downloading and applying the patch.

1. Download the patch (ESE012US.EXE - 22.6 MB), saving the file in any convenient directory on your PC.

 
2. In Windows Explorer, double-click ESE012US.EXE. When the dialog box appears, click Extract - you will be prompted to save the file in a new directory. Click Yes. ESE012US.BIN will be saved.

• Verify that the version of ShowCase STRATEGY Essbase/400 installed is 4.0. Type the following to display the ESSSVR version:

<Essbase Installation Library>/DSPESSENV
• To find out if this patch has already been applied to 4.0, check if the ShowCase PTF user space exists.
DSPOBJD <Essbase installation library>/ESE012US *USRSPC If the following message appears, the patch has not been applied. CPF9801 - Object ESE012US in library <Essbase installation library> not found.
• Ensure that you can use FTP between your PC and your AS/400.
• You will be required to sign on to your AS/400 as QSECOFR or with equivalent authority (*ALLOBJ, *IOSYSCFG, *SAVSYS, *JOBCTL, and *SECADM special authorities are needed) to apply the patch.
• The Essbase OLAP server to which this patch will be applied must be shut down before applying the patch. Either use your typical method of shutting down, or use the ShowCase-supplied command, ENDESSSVR.
• After shutting down the OLAP server, signoff your AS/400 session and re-signon.

Note: Before installing the patch, be sure to read and follow the prerequisites listed above.

1. OS/400: Create a save file in QGPL
CRTSAVF QGPL/ESE012US
2. PC: Use FTP to transfer ESE012US.BIN to the AS/400:
C:\>FTP<AS/400 IP Address>
User (system:(none)): <userid>
331 Enter password.

Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\ESE020PS.BIN QGPL/ESE020PS
ftp> quit
C:\>

3. OS/400: Restore the LODRUNS program and command from the save file using the following command. This may replace an existing version of the command and program which is OK.
RSTOBJ OBJ(LODRUNS) SAVLIB(QTEMP) DEV(*SAVF) OBJTYPE(*ALL) SAVF(QGPL/ESE012US) RSTLIB(<Essbase installation library>) ALWOBJDIF(*ALL) MBROPT(*ALL)
4. OS/400: If the restore is correct, the following message will appear:
2 objects restored from QTEMP to <Essbase installation library>. Note: If the RSTOBJ command fails, be sure you successfully created the save file in step 1 and that the FTP in step 2 was also successful.
5. OS/400: Update the command as follows.
CHGCMD CMD(<Essbase installation library>/LODRUNS) PGM(<Essbase installation library>/LODRUNS)
6. OS/400: Apply the patch as follows. When prompted, enter the name of the Essbase installation library.
<Essbase installation library>/LODRUNS SAVF(QGPL/ESE012US)
7. OS/400: A journal will be created during the apply process. The journal contains information about the apply process and the last entry in the journal contains the PTF level. There should not be any journal entries of type ER or CE. The last ID entry will indicate the latest PTF level that was applied. DSPJRN JRN(<Essbase installation library>/SCPTFLOG)
8. The patch process is now complete.