IBM
DB2 OLAP Server for AS/400 1.1
Fixpack
12:
OLAP
Server patch - Uppercase English
Downloading the Patch
This patch will fix all problems described in the previous document. Refer
to the instructions below for downloading and applying the patch. These
directions refer to DB2 OLAP Server as "Essbase".
-
Download
the patch (EOD060PS.EXE - 24.1 MB), saving the file in any convenient
directory on your PC.
-
In Windows Explorer, double-click EOD060PS.EXE. When the dialog box appears,
click Extract - you will be prompted to save the file in a new directory.
Click Yes. EOD060PS.BIN will be saved.
Prerequisites for Applying
the Patch
-
Verify that the version of ShowCase STRATEGY Essbase/400 installed
is 3.01. Type the following to display the ESSSVR version:
<Essbase Installation
Library>/DSPESSENV
To find out if this patch has already been applied to 3.0, check if
the ShowCase PTF user space exists.
DSPOBJD <Essbase installation library>/EOD060PS
*USRSPC
If the following message appears, the patch has not been applied.
CPF9801 - Object EOD060PS 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.
-
Ensure no one is currently using the Essbase server. Use ESSCMDAPI
to check which users are still connect, as follows:
-
Login with the LOGINESS command and enter your username and password
-
Type LSTESSUSR to display the list of users
that are still connected to the server. Your username will appear in this
list.
Type the following to log out all users:
RUNNESSCMDC COMMAND('LOGOUTALLUSERS
Y')
NOTE: You will receive a message that you cannot log yourself out
with this command.
-
Logout of the ESSCMDAPI with the LOGOUTESS command.
-
The Essbase 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.
-
Bring down your OLAP server. Either use your typical method of shutting
down, or use the ShowCase-supplied command, ENDAOSSVR.
-
We recommend waiting 15 minutes after shutdown to ensure that all system
resources have been released.
Installing the Patch
Note: Before installing the patch, be sure to read and follow the prerequisites
listed above.
-
OS/400: Create a save file in QGPL:
CRTSAVF QGPL/EOD060PS
-
PC: Use FTP to transfer EOD060PS.BIN to the AS/400. For example:
C:\>FTP<AS/400 IP Address>
User (system:(none)): <userid>
331 Enter password.
Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\EOD060PS.BIN QGPL/EOD060PS
ftp> quit
C:\>
-
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/EOD060PS) RSTLIB(<Essbase installation library>) ALWOBJDIF(*ALL)
MBROPT(*ALL)
-
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.
-
OS/400: Update the command as follows:
CHGCMD CMD(<Essbase installation library>/LODRUNS)
PGM(<Essbase installation library>/LODRUNS)
-
OS/400: Apply the patch as follows. When prompted, enter the name of the
Essbase installation library:
<Essbase installation library>/LODRUNS SAVF(QGPL/EOD060PS)
-
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)
-
We recommend that you run the OPTESSSVR command to optimize your
Essbase programs after installing this patch. By default, these programs
are already optimized for the V4R3 operating system level. While this level
of optimization is good, newer versions of OS/400 may provide better optimizations
and ultimately improve your run time performance. The process of optimizing
the programs for the current release can require a great deal of CPU time
and can significantly affect the performance of other activity on the system.
If you do not want to optimize the programs for your current release at
this time, you can install the programs optimized for V4R3. You may run
the OPTESSSVR a later time when it is more convenient. The format
of the command is:
where essbase_lib is the Essbase library.
The patch process is now complete.
Back
to Patch Description