Warehouse Manager server patch - Upper English
 

Downloading the Patch

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 WOD060PS.EXE. This will launch a MS DOS prompt, which will create and inflate WOD060PS.BIN file.

• 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>/WOD060PS *USRSPC

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

CPF9801 - Object WOD060PS 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.)

1. OS/400: Create a save file in QGPL


CRTSAVF QGPL/WOD060PS
 

2. PC: Use FTP to transfer WOD060PS.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:...\WOD060PS.BIN QGPL/WOD060PS
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 <warehouse manager installation library>
APYSCPTF DEV(*SAVF) SAVF(QGPL/WOD060PS)
 

4. 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.
5. OS/400: If the restore is correct, the following message will appear:


PTF WOD060PS Successfully Loaded for <warehouse manager installation library>.\
 

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

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

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)
 

9. The patch process is now complete.

 
10. Restart your server(s).