*********************************************************************

IBM DB2 OLAP Server for AS/400 7.1
FixPak 8.5

Release Notes -- Start Here

December, 2002

Welcome to the Release Notes for FixPak 8.5.  This document
is your starting point for downloading and installing the FixPak.

*********************************************************************

Important:

Service Level:

Contents

Before you install

Installing the FixPak

Builder problem summary:  A list of all ShowCase STRATEGY problems fixed by this FixPak.

Before you install

New levels of required server software:

This FixPak requires the following PTFs:

  • For OS/400 V4R5:  IBM PTF SF66229 (Prereq SF66226)
  • For OS/400 V5R1:  IBM PTF SI06320
    • Size of downloadable files:

    The self-extracting EXE files in this FixPak might inflate to 100 MB or more.  Make sure you have enough disk space on your system.

    Back to table of contents

     Installing the FixPak

     
    Components: 
    Languages to choose from
    Files to download
    1. Warehouse Manager server
    Choose 1 of 2: 
    U.S. English
    Uppercase English
    1

    U.S. English

    This section describes how to install the U.S. English FixPak for the Warehouse Manager server.

    Getting the FixPak

    1. Download the FixPak (wuf050us.exe) and save it to a temporary directory on your PC. (If you're installing from a CD, copy the wuf050us.exe file from the CD to a temporary directory.)
    2. In Windows Explorer, double-click wuf050us.exe. This will launch a MS DOS prompt, which will create and inflate the wuf050us.bin file.
    Prerequisites for applying the FixPak
    1. Verify that the version of Warehouse Manager server component installed is V7.1 FixPak 7 or FixPak 8 (ShowCase STRATEGY Warehouse Manager server 4.50.003 or 4.50.024) by using the DSPSCAUT command to look at the RSC910C message in the job log. Type the following:
        2. <SCSERVER>/DSPSCAUT
      where SCSERVER is your Warehouse Manager server library.
    2. To find out if this patch has already been applied, check if the Builder PTF user space exists by running the following command:
        3. DSPOBJD <SCSERVER>/WUF050UU *USRSPC
      where SCSERVER is your Warehouse Manager server library.  If the following message appears, the patch has not been applied.
        CPF9801 - Object WUF050UU in library <SCSERVER> not found.
    3. Ensure that you can use FTP between your PC and your iSeries computer.
    4. You will be required to sign on to your iSeries as QSECOFR to apply the patch.
    5. Run the DSPUSRPRF utility on the patching profile. Look to see if there is a group profile. If there is a group, check the next parameter, OWNER, and make sure it is NOT *GROUP.
    6. Ensure that you end the Warehouse Manager server if it is active by running the following command:
        7. <SCSERVER>/ENDSCSVR
      where SCSERVER is your Warehouse Manager server library.
    7. Ensure that no one is currently using the server. You can issue the following command to detect current server users:
        8. WRKOBJLCK OBJ(<SCSERVER>/SCCONNECT)OBJTYPE(*USRSPC)
      where SCSERVER is your Warehouse Manager server library.
    8. If you have installed the ShowCase STRATEGY Orion server on the same iSeries system as DB2 OLAP Server Builder, ensure that you end the ShowCase Orion server if it is active by running the following command:
        9. <SCSERVER>/ENDORI
      where SCSERVER is your Warehouse Manager server library.
    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)
    DB2 OLAP Server Builder is not the only application that uses these jobs, so you must make sure that there are no other programs using these jobs.  This might require that you dedicate your iSeries.

    Applying the FixPak

    Before installing the patch, read and follow the prerequisites listed above.  Ensure that the FixPak file described in Getting the FixPak has been completely downloaded to your PC and the larger .bin file has been extracted.  In the following steps, you will save the .bin file as an FTP file to the iSeries server, and install it.

    1. On the iSeries: (If you are already in an iSeries session, signoff and sign back on). Create a save file in QGPL:
        2. CRTSAVF QGPL/WUF050US
    2. On the PC: Use FTP to transfer WUF050US.BIN to the iSeries. For example:
        3. C:\>FTP <AS/400 IP Address>
        User (system:(none)): <userid>
        331 Enter password.

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

    3. One the iSeries: Run the following commands. If the Warehouse Manager server library is already in your library list, omit the first command:
        4. ADDLIBLE <SCSERVER>
        APYSCPTF DEV(*SAVF) SAVF(QGPL/WUF050US)
      where SCSERVER is your Warehouse Manager server library.  You will be prompted for the name of your server library. Enter your library name when prompted
    4. On the iSeries: If the restore is correct, the following message displays:
        5. PTF WUF050US Successfully Loaded for <SCSERVER>
      where SCSERVER is your Warehouse Manager server library.
    5. On the iSeries: 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:
        6. DSPJRN JRN(<SCSERVER>/SCPTFLOG) FROMTIME('MM/DD/YYYY' 'HH:MM:SS')
      where SCSERVER is your Warehouse Manager server library. The FROMTIME format must match your system formats. Reference the system values QDATFMT and QTIME. Enter the date you applied the FixPak.
    6. Restart your Warehouse Manager server:
        7. <SCSERVER>/STRSCSVR
      where SCSERVER is your Warehouse Manager server library.
    7. The FixPak process is now complete.
    Back to table of contents

    Uppercase English

    This section describes how to install the uppercase English FixPak for the Warehouse Manager server.

    What is uppercase English? Uppercase English FixPaks are intended for double-byte character systems (DBCS) that require English commands to be in ALL UPPER CASE. These are typically systems that use Kanji characters.

    Getting the FixPak

    1. Download the FixPak (wuf050ps.exe) and save it to a temporary directory on your PC.  (If you're installing from a CD, copy the wuf050ps.exe file from the CD to a temporary directory.)
    2. In Windows Explorer, double-click wuf050ps.exe. This will launch a MS DOS prompt, which will create and inflate the wuf050ps.bin file.
    Prerequisites for applying the FixPak
    1. Verify that the version of Warehouse Manager server component installed is V7.1 FixPak 7 or FixPak 8 (ShowCase STRATEGY Warehouse Manager server 4.50.003 or 4.50.024) by using the DSPSCAUT command to look at the RSC910C message in the job log. Type the following:
        2. <SCSERVER>/DSPSCAUT
      where SCSERVER is your Warehouse Manager server library.
    2. To find out if this patch has already been applied, check if the ShowCase PTF user space exists by running the following command:
        3. DSPOBJD <SCSERVER>/WUF050PP *USRSPC
      where SCSERVER is your Warehouse Manager server library.  If the following message appears, the patch has not been applied.
        CPF9801 - Object WUF050PP in library <SCSERVER> not found.
    3. Ensure that you can use FTP between your PC and your iSeries computer.
    4. You will be required to sign on to your iSeries as QSECOFR to apply the patch.
    5. Run the DSPUSRPRF utility on the patching profile. Look to see if there is a group profile. If there is a group, check the next parameter, OWNER, and make sure it is NOT *GROUP.
    6. Ensure that you end the ShowCase TCP/IP session if it is active by running the following command:
        7. <SCSERVER>/ENDSCSVR
      where SCSERVER is your Warehouse Manager server library.
    7. Ensure that no one is currently using the server. You can issue the following command to detect current server users:
        8. WRKOBJLCK OBJ(<SCSERVER>/SCCONNECT)OBJTYPE(*USRSPC)
      where SCSERVER is your Warehouse Manager server library.
    8. If you have installed the ShowCase STRATEGY Orion server on the same iSeries system as DB2 OLAP Server Builder, ensure that you end the ShowCase Orion server if it is active by running the following command:
        9. <SCSERVER>/ENDORI
      where SCSERVER is your Warehouse Manager server library.
    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)
    DB2 OLAP Server is not the only application that uses these jobs, so you must make sure that there are no other programs using these jobs.  This might require that you dedicate your iSeries.

    Applying the FixPak

    Before installing the patch, read and follow the prerequisites listed above.  Ensure that the FixPak file described in Getting the FixPak has been completely downloaded to your PC and the larger .bin file has been extracted.  In the following steps, you will save the .bin file as an FTP file to the iSeries server, and install it.

    1. On the iSeries: (If you are already in an iSeries session, signoff and sign back on). Create a save file in QGPL:
        2. CRTSAVF QGPL/WUF050PS
    2. On the PC: Use FTP to transfer WUF050PS.BIN to the iSeries. For example:
        3. C:\>FTP <AS/400 IP Address>
        User (system:(none)): <userid>
        331 Enter password.

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

    3. One the iSeries: Run the following commands. If the Warehouse Manager server library is already in your library list, omit the first command:
        4. ADDLIBLE <SCSERVER>
        APYSCPTF DEV(*SAVF) SAVF(QGPL/WUF050PS)
      where SCSERVER is your Warehouse Manager server library.  You will be prompted for the name of your server library. Enter your library name when prompted
    4. On the iSeries: If the restore is correct, the following message displays:
        5. PTF WUF050PS Successfully Loaded for <SCSERVER>
      where SCSERVER is your Warehouse Manager server library.
    5. On the iSeries: 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:
        6. DSPJRN JRN(<SCSERVER>/SCPTFLOG) FROMTIME('MM/DD/YYYY' 'HH:MM:SS')
      where SCSERVER is your Warehouse Manager server library. The FROMTIME format must match your system formats. Reference the system values QDATFMT and QTIME. Enter the date you applied the FixPak.
    6. Restart your Warehouse Manager server:
        7. <SCSERVER>/STRSCSVR
      where SCSERVERis your Warehouse Manager server library.
    7. The FixPak process is now complete.
    Back to table of contents

    Builder problem summary

    For information about fixes and changes in previous FixPaks, see the Release Notes for FixPak 8.

    FixPak 8.5 (STRATEGY 4.50.050) resolves the following problems in the Builder function:

  • Fixed: Getting errors when connecting the Builder client to the Warehouse Manager server on OS/400 V5R2.
  • Fixed: Getting errors when trying to open a model in Analyzer "Enterprise Reporting (DEMO) license has expired". (F10562)
  • Fixed: Caching issue.Run unit ended at 669 in SPTABCACHE, when the user has a large number of files. Usually affects JDE users. (F10400)
  • Fixed: UNINSTSC does not always work on V5R2 when uninstalling a Warehouse Manager library(F10128)
  • Fixed: Migration failing because of encrypted passwords. (F10095)
  • Fixed: Change the help text for the SETJDEOWA command. (F9845)
  • Fixed: Updating WM JDE license passwords via Warehouse Manager Client fails with a function check on the server. (F7479)
    • Also includes the following items fixed in 4.50.040:
  • Fixed: RSTSRVRINF does not work if source and target libraries were created by different users. (F10282)
  • Fixed: Web login performance issue for non Admin profiles. (F10480)
  • Fixed: Can not restore AOS information from a 4.5 server into another 4.5 server on a previous OS release (F10278)
  • Fixed: Customer is reporting that BU security settings are being placed around the wrong fields, such as CCMCUB. (F10231)
  • The code was changed to provide object level security for JD Edwards OneWorld tables. (F9631)
  • Prompting on a field with a Y or W edit code will not cause a SQL error. (F9495)
  • Fixed: Got the error message "Keyword AS not expected. Valid tokens: ) ," when running the following sql in ER: SELECT STATE,CITY,CONAME,SUM (TOTBIL) AS "totbil" FROM SCDB1.CSTHDR CSTHDR,SCDB1.INVHDR INVHDR WHERE CSTHDR.CUSTID=INVHDR.CUSTID AND (REGION='Central') GROUP BY STATE,CITY,CONAME HAVING SUM (TOTBIL)>100 ORDER BY 1,2    (F9382)
  • Null pointer exception when running a report dynamically and multiple ER server PC's exist has been corrected. (F8353)
    • Back to table of contents

    Licensed Material.  Property of IBM.
    © Copyright International Business Machines Corporation 1998, 2002. All rights reserved.
    US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
    Portions © 1997–2002 ShowCase Corporation. All Rights Reserved.
    Portions © Copyright 1991-2002 Hyperion Solutions Corporation. All Rights Reserved.
    Portions © Blue Sky Corporation.  All rights reserved.