Instructions for installing the Warehouse Manager server component
Service level 4.00.030 - U.S. English
May 2001

Installing the Patch

CAUTION!!! ShowCase 4.00 contains Java code, which entails extra steps for patching. In order for a fix to take affect, you must follow these instructions in order.

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.00, dated 10/16/00. Refer to the instructions below for downloading and applying the patch.

1. Download the patch, saving the file in any convenient directory on your PC.

 
2. In Windows Explorer, double-click WSE030US.EXE. This will launch a MS DOS prompt, which will create and inflate WSE030US.BIN file.

  Prerequisites for Applying the Patch

• Verify that the version of ShowCase STRATEGY Warehouse Manager installed is 4.00 by using the DSPSCAUT command to look at the RSC910C message in the job log. Type the following:


<SCSERVER>/ENDSCSVR, where SCSERVER is your ShowCase library.

• To find out if this patch has already been applied to 4.00, check if the ShowCase PTF user space exists.


DSPOBJD <SCSERVER>/WSE030UU *USRSPC, where SCSERVER is your ShowCase library.

If the following message appears, the patch has not been applied.

CPF9801 - Object WSE030UU in library <SCSERVER> 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:


<SCSERVER>/ENDSCSVR, where SCSERVER is your ShowCase library.

• Ensure no one is currently using the server. You can issue the following command to detect current server users.


WRKOBJLCK OBJ(<SCSERVER>/SCCONNECT) OBJTYPE(*USRSPC), where SCSERVER is your ShowCase library.

• Special Notes

If you are applying a Warehouse Manager patch to a library that has already been connected to, the SQL server jobs (QSQSRVR) must be ended and restarted before you re-start the 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.

(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.)

1. OS/400:(If you are already in an AS/400 session, signoff and sign back on). Create a save file in QGPL


CRTSAVF QGPL/WSE030US

2. PC: Use FTP to transfer WSE030US.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:...\WSE030US.BIN QGPL/WSE030US
ftp> quit
C:\>

3. OS/400: Run the following commands. If the ShowCase library is already in your library list, you may omit the first command.


ADDLIBLE <SCSERVER> ,where SCSERVER is your ShowCase library.
APYSCPTF DEV(*SAVF) SAVF(QGPL/WSE030US)[You will be prompted for the name of your server library. Enter your library name when prompted]

4. OS/400: If the restore is correct, the following message will appear:


PTF WSE030US Successfully Loaded for <SCSERVER>, where SCSERVER is your ShowCase library..

5. 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(<SCSERVER>/SCPTFLOG), where SCSERVER is your ShowCase library.

6. Restart your ShowCase server. <SCSERVER>/STRSCSVR, where SCSERVER is your ShowCase library.
7. ATTENTION!!! New For 4.0, You MUST do the following step:


The ShowCase jar file must be then be recompiled:
ADDLIBLE SCSERVER, where SCSERVER is your ShowCase library.
CMPSCJAR and prompt(F4).
DO NOT JUST HIT ENTER, THIS WILL START THE COMPILE!!!
Enter a time and date for the compile. Since this will take as long as it did for the install, it is advised that this be done on off hours.
Until you recompile, you will experience performance issues.

8. The patch process is now complete.