IBM DB2 OLAP Server for iSeries 8.1
Fix pack 1

Updated preview - now includes OLAP server fixes

Release Notes -- Start Here

May, 2003

In December 2002, IBM introduced a preview edition of Fix pack 1 for DB2 OLAP Server for iSeries 8.1.  It contained fixes only for the Builder (Warehouse Manager) server component.

This update adds fixes only for the OLAP server, but it does not include any fixes from Hyperion Essbase 6.5.1 (Patch 1).  This update includes all the fixes from the December 2002 preview edition, but it  does not contain any additional Builder server fixes or client fixes.  Client fixes will be delivered in the final edition of Fix pack 1.  The Version 8.1 GA-level clients will continue to work after you install this Fix pack. 

This document is your starting point for downloading and installing this upgrade.  

Service Level:

• OLAP server components:  6.50.010
• Builder (Warehouse Manager) server components:  4.50.050

Contents

• Before you install
• Installing the Fix pack
• OLAP server
• 1.  Update the Service level.
  Then install one of the following versions of the OLAP server:
• 2a. Install U.S. English OLAP server, or
• 2b. Installl the Uppercase English OLAP server
• Warehouse Manager server
• 1a. Install the U.S. English server for Warehouse Manager
• 1b. Install the uppercase English server for Warehouse Manager
• Problem summary:  A list of all problems fixed by this Fix pack.

Before you install

New levels of required server software:

This Fix pack requires the following PTFs:

For OS/400 V5R1:

• IBM PTF SI06320
• If you have defect PTF SI05990 applied on your iSeries, you must also apply PTF SI06743.

For OS/400 V5R2:

• CUM PTF Level TL02260
• Group PTFs:
• SF99502 DB2 Universal Database for iSeries Level 3
• SF99169 JAVA PTF Group Level 2
• Other PTFs:
• 5722SS1/SI05887
• 5722SS1/SI06304
• If you have the defect PTF SI05991 applied on your iSeries, SI06744 is required.
• If you are planning to run DB2 OLAP Integration Server, apply PTF SI07023

Size of downloadable files:

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

Back to table of contents

 Installing the Fix pack

OLAP server

First, you must update the service level number of the OLAP Server.  Then you can install either the U.S. English version or the uppercase English version of the OLAP server.

1.  Update the service level

This Fix pack changes the service level number of the OLAP server from 4.50.032 to 6.50.010.

Update the service number with the CHGOLAPVER command:

This program will need to be run by OLAP administrators over the GA version to change the code level from 4.50.032 to 6.50.010.

1. Create a save file called CHGOLAPVER: CRTSAVF savf_lib/CHGOLAPVER where savf_lib is the location of the save file.
2. Download the CHGOLAPVER.BIN file and use FTP to send it to the iSeries computer into the save file created above.
3. Run restore object: RSTOBJ OBJ(CHGOLAPVER) SAVLIB(QTEMP) DEV(*SAVF) SAVF(<savf_lib>/CHGOLAPVER).
4. Call the program: CALL PGM(QTEMP/CHGOLAPVER) PARM(<OLAP_library>) where OLAP_library is your OLAP Server library.

2a.  Install the U.S. English OLAP server

Apply this Fix pack only to DB2 OLAP Server for iSeries V8.1 (ShowCase Essbase/400 6.5) in U.S. English. 

Downloading the Patch:

1. Download the patch (EwG010US.EXE - 20.5 MB), saving the file in any convenient directory on your PC.
   
2. In Windows Explorer, double-click EwG010US.EXE. When the dialog box appears, click Extract - you will be prompted to save the file in a new directory. Click Yes. The EwG010US.BIN file will be saved.

Prerequisites for Applying the Patch:

1. Verify that the installed version of DB2 OLAP Sever for iSeries is Version 8.1 (ShowCase STRATEGY Essbase/400 6.5). Type the following to display the ESSSVR version:

< OLAP Installation Library>/DSPESSENV

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

DSPOBJD <Essbase installation library>/EwG010UU *USRSPC

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

CPF9801 - Object EwG010UU in library <OLAP installation library> not found.

3. Ensure that you can use FTP between your PC and your iSeries computer.
   
4. You must have QSECOFR authority or equivalent authority to log on to your iSeries and apply the Fix pack.
   
5. Shut down the OLAP server before applying the Fix pack.  Either use your typical method of shutting down, or use the ENDESSSVR command.
   
6. After the OLAP server is shutdown, log off your iSeries session and then log on again.

Installing the Fix pack:

1. On the iSeries computer, create a save file in QGPL: CRTSAVF QGPL/EwG010US
   
2. On the PC: Use FTP to transfer the EwG010US.BIN to the iSeries:
   C:\>FTP<AS/400 IP Address>
   User (system:(none)): <userid>
   331 Enter password.

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

3. On the iSeries computer, apply the patch as follows. When prompted, enter the name of the OLAP installation library.
   <OLAP installation library>/APYSCPTF DEV(*SAVF) SAVF(QGPL/EwG010US)
   
4. On the iSeries computer, a journal is 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(<OLAP installation library>/ SCPTFLOG)
   
5. The Fix pack process is now complete.

2b. Install the uppercase English OLAP server

Apply this Fix pack only to DB2 OLAP Server for iSeries V8.1 (ShowCase Essbase/400 6.5) in uppercase English.

Downloading the Patch:

1. Download the patch (EwG010PS.EXE - 20.5 MB), saving the file in any convenient directory on your PC.
   
2. In Windows Explorer, double-click EwG010PS.EXE. When the dialog box appears, click Extract - you will be prompted to save the file in a new directory. Click Yes. EwG010PS.BIN will be saved.

Prerequisites for Applying the Patch:

1. Verify that the installed version of DB2 OLAP Sever for iSeries is Version 8.1 (ShowCase STRATEGY Essbase/400 6.5). Type the following to display the ESSSVR version:

< OLAP Installation Library>/DSPESSENV

2. To find out if this Fix pack has already been applied, check if the ShowCase PTF user space exists.

DSPOBJD <OLAP installation library>/EwG010PU *USRSPC

3. If the following message appears, the Fix pack has not been applied.

CPF9801 - Object EwG010PU in library <OLAP installation library> not found.

4. Ensure that you can use FTP between your PC and your iSeries.
   
5. You must have QSECOFR authority or equivalent authority to log on to your iSeries and apply the Fix pack.
   
6. Shut down the OLAP server before applying the Fix pack.  Either use your typical method of shutting down, or use the ENDESSSVR command.
   
7. After the OLAP server is shutdown, log off your iSeries session and then log on again.

Installing the Patch:

1. On the iSeries computer, create a save file in QGPL CRTSAVF QGPL/EwG010PS
   
2. On the PC, use FTP to transfer EwG010PS.BIN to the iSeries computer:
   C:\>FTP<AS/400 IP Address>
   User (system:(none)): <userid>
   331 Enter password.

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

3. On the iSeries computer, apply the patch as follows. When prompted, enter the name of the OLAP installation library. <OLAP installation library>/APYSCPTF DEV(*SAVF) SAVF(QGPL/EwG010PS)
   
4. On the iSeries computer, 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(<OLAP installation library>/SCPTFLOG)
   
5. The patch process is now complete.

Back to table of contents

Warehouse Manager server

Install either the U.S. English or Uppercase English server for Warehouse Manager.

1a. Install the U.S. English server for Warehouse Manager

Getting the Fix pack:

1. Download the Fix pack (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 Fix pack:

1. Verify that the version of Warehouse Manager server component installed is V8.1 (ShowCase STRATEGY Warehouse Manager 4.50 server) by using the DSPSCAUT command to look at the RSC910C message in the job log. Type the following:
<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:
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:
<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:
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:
<SCSERVER>/ENDORI
where SCSERVER is your Warehouse Manager server library.

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

Applying the Fix pack:

Before installing the patch, read and follow the prerequisites listed above.  Ensure that the Fix pack file described in Getting the Fix pack 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:
CRTSAVF QGPL/WUF050US
2. On the PC: Use FTP to transfer WUF050US.BIN to the iSeries. 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:...\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:
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:
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:
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 Fix pack.
6. Restart your Warehouse Manager server:
<SCSERVER>/STRSCSVR
where SCSERVER is your Warehouse Manager server library.
7. The Fix pack process is now complete.

1b. Install the uppercase English server for Warehouse Manager

What is uppercase English? Uppercase English Fix packs 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 Fix pack:

1. Download the Fix pack (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 Fix pack:

1. Verify that the version of Warehouse Manager server component installed is V8.1 (ShowCase STRATEGY Warehouse Manager 4.50) by using the DSPSCAUT command to look at the RSC910C message in the job log. Type the following:
<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:
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:
<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:
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:
<SCSERVER>/ENDORI
where SCSERVER is your Warehouse Manager server library.

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

Applying the Fix pack:

Before installing the patch, read and follow the prerequisites listed above.  Ensure that the Fix pack file described in Getting the Fix pack 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:
CRTSAVF QGPL/WUF050PS
2. On the PC: Use FTP to transfer WUF050PS.BIN to the iSeries. 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:...\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:
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:
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:
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 Fix pack.
6. Restart your Warehouse Manager server:
<SCSERVER>/STRSCSVR
where SCSERVERis your Warehouse Manager server library.
7. The Fix pack process is now complete.

Problem summary

This update provide the following OLAP server fixes from Essbase/400 6.50.010:

• Essbase errors 1002111 and 1198020 where being logged incorrectly. (F11301)
• DSN Name list is returned empty. (F11318)
• Error 2003000: IS Error Unable to get tables for pattern name % from Data source. (F11316)
• Addresses V5R2 portability issues with SQL Load and SQL Dim Build.. (F11298)
• Database restructures failed if starting the server with a non *SECOFR profile. (F10452)
• Enhancement 11394: Port OLAPICMD to add job scheduling capability for the iSeries port of Essbase Integration Services.
• Enhancement 11232: Added V5R1 extended password support for Essbase.
• Essbase Integrated Security users can now have passwords with mixed case, special characters of upto 100 character length. Even though OS/400 may supports upto 128 character length passwords, Essbase passwords will be limited to 100 characters. This is due to client side restrictions and is consistent with Essbase running on other platform. Note that QPWDLVL must be set at 2 or 3 for this feature to take affect.

This update also includes the following ShowCase STRATEGY 4.50.050 problems in the Builder (Warehouse Manager) server component:

• Getting errors when connecting the Builder client to the Warehouse Manager server on OS/400 V5R2.
• Getting errors when trying to open a model in Analyzer "Enterprise Reporting (DEMO) license has expired". (F10562)
• Caching issue.Run unit ended at 669 in SPTABCACHE, when the user has a large number of files. Usually affects JDE users. (F10400)
• UNINSTSC does not always work on V5R2 when uninstalling a Warehouse Manager library(F10128)
• Migration failing because of encrypted passwords. (F10095)
• Change the help text for the SETJDEOWA command. (F9845)
• Updating WM JDE license passwords via Warehouse Manager Client fails with a function check on the server. (F7479)

• RSTSRVRINF does not work if source and target libraries were created by different users. (F10282)
• Web login performance issue for non Admin profiles. (F10480)
• Can not restore AOS information from a 4.5 server into another 4.5 server on a previous OS release (F10278)
• 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)

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