IBM
DB2 OLAP Server for AS/400 1.1
FixPak
14
Instructions
for installing the patch for
the
Warehouse
Manager server component
in
Upper
English
Service
Level 3.01.140
December
2001
These instructions use terminology consistent with ShowCase STRATEGY.
Downloading the Patch
This patch will fix all problems described in the previous
document. The patch must be applied only to the ShowCase STRATEGY 3.01,
dated 12/08/99. Refer to the instructions below for downloading and applying
the patch.
-
Download the patch, saving
the file in any convenient directory on your PC.
-
In Windows Explorer, double-click WOD140PS.EXE. This will
launch a MS DOS prompt, which will create and inflate WOD140PS.BIN file.
Prerequisites
for Applying the Patch
-
Verify that the version of ShowCase STRATEGY Warehouse Manager
installed is 3.01 by using the DSPSCAUT command to look at the RSC910C
message in the job log. Type the following:
<Warehouse Manager Installation
Library>/DSPSCAUT
-
To find out if this patch has already been applied to 3.01,
check if the ShowCase PTF user space exists.
DSPOBJD <warehouse
manager installation library>/WOD140PS *USRSPC
If the following message appears, the patch has not been
applied.
CPF9801 - Object WOD140PS in library
<warehouse manager 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
to apply the patch.
-
Ensure that you end ShowCase TCP/IP if it is active, using
the following command:
<Warehouse Manager Installation
Library>/ENDSCTCP
-
If you use Analyzer, you must also end the AOS server using
the ENDAOSSVR
-
Ensure no one is currently using the server. You can issue
the following command to detect current server users.
WRKOBJLCK OBJ(<warehouse
manager installation library>/SCCONNECT) OBJTYPE(*USRSPC)
-
Special Notes for users of Analyzer OLAP Sever(AOS)
If you are applying a Warehouse Manager patch to a library
that has AOS installed and has already been connected to, the SQL server
jobs (QSQSRVR) must be ended and restarted before you re-start the AOS
server. To properly enable this patch for prestarted server jobs, you will
need to stop and restart the SQL server jobs. Otherwise the prestarted
server jobs may continue to use older versions of programs and unexpected
results may occur. To stop and restart the SQL server jobs, run the following:
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR)
OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
Note: ShowCase is not the only application that
uses these jobs, so you must make sure that there are no other programs
using these jobs. This may require that you dedicate your AS/400.
Installing the Patch
(At this point,
please be sure that Item 2 from "Downloading the Patch" has completed.
That item involves executing the file that was downloaded from the web,
thus creating the larger .bin file that will be saved as an FTP file to
the server.)
-
OS/400: Create a save file in QGPL
CRTSAVF QGPL/WOD140PS
-
PC: Use FTP to transfer WOD140PS.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:...\WOD140PS.BIN
QGPL/WOD140PS
ftp> quit
C:\>
-
OS/400: Run the following commands.
If the ShowCase library is already in your library list, you may omit the
first command.
ADDLIBLE <warehouse manager installation
library>
APYSCPTF DEV(*SAVF) SAVF(QGPL/WOD140PS)
-
NOTE: You will be prompted for the name of your ShowCase
library. Reply by typing in the name of your ShowCase library and press
enter.
-
OS/400: If the restore is correct, the following message
will appear:
PTF WOD140PS Successfully Loaded
for <warehouse manager installation library>.
-
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.
DSPJRN JRN(<warehouse
manager installation library>/SCPTFLOG)
-
If you are not using Analyzer Olap Server, skip to Step
8. If you chose a AOS port other than the default of 23000 during the
install, follow Step 7. To verify the AOS server port, use the following
command:
WRKSRVTBLE SERVICE(SCOLAPSVR<warehouse
manager library>)
If the port is set to 23000, skip to Step 8.
-
Change the port number to the one set for your AOS server.
Use the following command:
CHGAOSA KEYNAME(TCPIPPort)
KEYVAL(<portnumber>) AOSLIB(<warehouse manager library>)
UPHTML(*YES)
-
The patch process is now complete.
-
Restart your server(s).
Back to Patch Description