The DB2 Alphablox 8.4.0.1 (8.4 Fix Pack 1) release applies fixes for the customer-reported bugs (APARs) listed below. DB2 Alphablox 8.4.0.1 also adds support for the following:
Important: The 8.4.0.1 version can only be installed on existing DB2 Alphablox 8.4 installations.
For system requirements and installation steps (including any required pre-installation steps), see the Installation Guide (English, German, Japanese, Korean, Brazilian Portuguese, Simplified Chinese, Traditional Chinese).
For new features, bug fixes, and potential upgrade and migration information that apply to the DB2 Alphablox 8.4 release, see the Release Overview (English, Czech, French, Hungarian, Japanese, Korean, Brazilian Portuguese, Polish, Russian, Spanish, Simplified Chinese, Traditional Chinese).
Before you install or upgrade to DB2 Alphablox V8.4.0.1, make sure that you review the upgrade and migration information described in the Release Overview and review the following information.
Note: For Solaris installations only, you need to use the console installer to upgrade to V8.4.0.1.
The DB2 Alphablox installer for the UNIX platforms expects an executable
file "./bin/java
" to exist relative to the main JDK
directory. Some JDKs might not contain this file by default. In such cases,
you can create a symbolic link to point to the Java file under the jre
directory. For example, from the main JDK directory:
cd bin
ln -s ../jre/bin/java java
If you are upgrading to V8.4.0.1 on x86_64 Linux and PPC64 Linux systems, always choose the step-by-step installation option to ensure the installer gathers the current settings correctly and that any additional JDBC drivers are added properly.
-Dabx.ws.admin.port.override=<port-number>
-Dabx.cluster.log.file.suffix=serverName
<port-number>
is usually generated when the server instance is created in WebSphere.
This value can be found when you select the server's name under Servers
> Application Servers, and click on Ports.
The value to use in <port-number>
above is the
port number for the SOAP_CONNECTOR_ADDRESS port name.Warning: If you used the NativeConvert utility to convert an existing DB2 Alphablox 8.4 file-based repository to support UTF-8, do not run the NativeContervert utility again after installing the DB2 Alphablox 8.4.0.1 release.
If you will be using a file-based DB2 Alphablox Repository on a Linux or
UNIX system, make sure the LANG
environment variable for your
operating system is set to UTF-8 so the repository data is stored and retrieved
properly. See your server documentation for information on how to install
and configure locale support.
If you are upgrading from a previous release using a file-based DB2 Alphablox Repository, make sure that you run the NativeConverter utility to convert your repository to support UTF-8. See the Installation Guide > "Post-installation tasks" > "General post-installation tasks" > "Migrating a DB2 Alphablox Repository to support multiple locales."
IBM(R) JDK V1.4.2 and Tomcat 3.2.4
The latest version of IBM JDK v1.4.2 SR4 works with Tomcat 3.2.4, but SR3 or SR2 does not. You can use either SR4 or the earlier GA version (Windows/IA32, cn1420-20040626).
Sybase for database repository
Starting this release, Sybase as a database repository is no longer supported
(connection to Sybase for data analysis is still supported). You should
use the Repository Conversion Utility to convert to a different database
or to a file system for your repository BEFORE you upgrade
to DB2 Alphablox V8.4. The utility is located in the <alphablox_dir>/tools/convert/
directory in your existing DB2 Alphablox installation.
DB2 OLAP Server or Hyperion Essbase data sources
No Hyperion Essbase runtime client library is included with DB2 Alphablox installation. You need to install the Essbase runtime client library first and run theChangeEssbase.bat
or ChangeEssbase.sh
script to have the ARBORPATH point to your Essbase client library before DB2
Alphablox is started. The ChangeEssbase utility is located in <alphablox_dir>/bin.
If you are upgrading, you can copy your previous client library under
<alphablox_dir>/bin/{nt, eds}
to another location and then
run the ChangeEssbase utility. The utility no longer allows storing of the
library files in the <alphablox_dir>/bin
directory. See
Administrator's Guide > "Basic Administration Tasks"
> "Using the Essbase Client Library Utility" for details. -input.encoding
option. Instead of
double-clicking ChangeEssbase.bat
from an Explorer window, in
a DOS window, enter: ChangeEssbase.bat -input.encoding <encoding>
ChangeEssbase.bat -input.encoding cp866
DataBlox.getQuery()
method are built from result set
API calls. Therefore, they ignore the perspective specified in the query
and return all hierarchies defined for the underlying cube.If you use Microsoft SQL Server for your DB2 Alphablox Repository and need to provide multi-locale support, you should use the NVARCHAR field instead of VARCHAR to ensure bookmark information entered by users is saved correctly.
On a new installation, follow the steps below:
<alphablox_dir>/repository/servers/mssql.dmlsql
and
mssqlv2005.dmlsql
files:
DDL.
"
and change all occurrences of VARCHAR to NVARCHAR.Important: If you enable both the Microsoft SQL Server 2000
JDBC Driver and the Microsoft SQL Server 2005 JDBC Driver, there is a known
issue with the 2000 version of the JDBC driver incorrectly accepting the "jdbc:sqlserver://
"
URL prefix if it is loaded first. When you use the Repository Conversion Utility
to convert the file repository to a Microsoft SQL Server 2005 database, the
utility will connect to the Microsoft SQL Server 2000 JDBC Driver first. As
a result, you are likely to encounter errors stating that the Microsoft SQL
Server 2000 JDBC Driver is unable to perform the operation. The workaround
is to temporarily hide the 2000 version of the JDBC driver from the Repository
Conversion Utility by either renaming the SQL Server 2000 JDBC Driver or deleting
it before starting the utility.
If you are upgrading from a previous release, contact DB2 Alphablox technical support. If you intend to support only one native language, make sure the Microsoft SQL Server database collation is set correctly. No further changes are necessary.
ReportBlox does not support multiple locales.
Query Builder and FastForward do not support bi-directional languages.
csGrdFnt
class definition in your <theme>_dhtml.css
file:
When using DB2 Alphablox in a WebLogic horizontal cluster, you should use the WebLogic Admin Console to deploy new applications to the cluster to ensure proper deployment to the cluster.
During migration of earlier cube definitions to DB2 Alphablox V8.4, level keys will be automatically generated and added. The generated level key of a level at the top of a hierarchy will consist of one level key expression that matches the level expression. Any level below the top level will have level key expressions that correspond to the level expressions of itself and all of its ancestors.
<null>
, even though the <null>
members are not visible when you query the cube at runtime.
-Dabx.cubing.temp.directory=<directory>
<directory>
must be different for each vertical
node in the cluster. APAR |
Abstract |
---|---|
PJ31104 | Column sort option on an Alphabox Cube bookmark is not being applied when the bookmark is restored |
PJ31413 | When it meets the following requirements, an alias and a peculiar name cannot change over |
PJ31309 | legendStyle should be a valid chart property |
PJ31310 | Legend incorrectly visible on dial charts |
PJ31290 | BookmarkMatcher performance makes it unusable |
PJ31211 | More errors drilling down on waterfall members |
PJ31222 | Dial charts don't work on Japanese and Chinese windows |
PJ31231 | ReportBlox interaction stops after query is issued via a select list |
PJ31233 | The default query in Query Builder is translated |
PJ31247 | Histogram Pareto (sorted histogram) checkbox does not persist |
PJ31311 | Incorrect axis information on Waterfall Chart |
PJ31407 | Traffic lights fail with aliases and removeSuffix |
PJ31414 | PersistenceBlox and DB2 Connection staying open |
PJ31439 | Toggling parentFirst and parentLast gives incorrect order |
PJ31483 | Using an FormEventListener to display the visibility of a MemberSelectFormBlox causes the PresentBlox Menu/Data list not to appear |
PJ31490 | Cannot get user credentioals from Windows 2003 Active Directory LDAP |
PJ31494 | Default for setAxisLabelLayout documented incorrectly |
PJ31520 | Placing 5 slicer dimensions on the PageBlox cause adjacent cell to be black on selection |
PJ31526 | Excel template - Too many different cell formats |
PJ31523 | Render to XML of DataBlox fails |
PJ31302 | resolveMember does not work against [cubeName].memberName with relational cube |
PJ31537 | ReportBlox PDF requests Chinese font for Japanese data |
PJ31545 | render=html causes sorted headers to use larger font |
PJ31563 | Member Filter only contains calculatedMember if in first position |
14739,344,0 | WL SERVER CRASHES WHEN CONNECTION ATTEMPT IS MADE TO SSAS (MSOLAP 2005) IF DOMAIN IN USER NAME OMITTED |
PJ31575 | FATAL error if connecting to WebSphere before initialization complete |
PJ31589 | Shipped EMail bean class files generate bad table+chart email attachment |
PJ31615 | getChartCurrentDimensions returns incorrect members if dimensions moved via data layout panel. |
PJ31428 | Grid lines broken in PDF file when using expand/collapse mode (or other images in cells) |
PJ31626 | Code conversion error (mis-mapping) problem in ABX with Essbase bridge. |
PJ31633 | NullPointerException when replaceMembers is called on SerializedMDBQuery |
PJ31648 | y1FormatMask cannot handle division |
PJ31668 | DBCS not working in ReportBlox in FastForward to Excel |
PJ31247 | Histogram Pareto (sorted histogram) checkbox does not persist |
PJ31693 | Alphablox loops when BFO does not find a useable font. |
PJ31682 | java.lang.NullPointerException at com.ibm.icu.util.TimeZone.getDefault(TimeZone.java:700) with icu4j_3_4_2 |
PJ31707 | GridBlox columns misaligned in portlet with BiDi |
PJ31324 | axis labels overlap in histogram, horizontal with 90 degree angle |
PJ31044 | cellFormat not() clause fails when multiple members are specified |
40,951,122 | Repository Conversion Utility Memory Consumption Prevents Upgrades |
PJ31138 | PageBlox Diminsions and PageBlox members containing DBCS as null characters |
PJ31139 | Wide ReportBlox PDF output overlaps |
PJ31140 | Suppressed rows showing on chart legend - regression |
PJ31141 | Specifying a page break on a column member breaks after first row member |
PJ31158 | ReportBlox should use the external PDF server |
PJ31159 | Regression - editing a cell with String data causes ParseException |
PJ31160 | Refreshing page which deletes and defines DataBlox crashes server |
PJ31161 | No ChartBlox.getHistogramOptions() |
PJ31162 | PDF pageBreak property is one member off |
PJ31148 | PresentBlox render=printer produces incorrect HTML when used to create the body of an e-mail message |
PJ31129 | render=printer concatenates previous Blox component |
PJ31242 | nullPointerException on render=printer in frameset |
PJ31268 | Scrollbar within table nearly disappears when screen is resized |
PJ31315 | Error when member filter page is started |
PJ31388 | Negative Scale error using Oracle database |
PJ31364 | Support for spanning of data cells |
PJ31374 | Rapid connections to the Alphablox server causes RenderManager Could not find object |
CSD PJ3135 | <blox:toolbar visible=false/> within a PresentBlox no longer makes a toolbar disappear. |
PJ31363 | alphablox calc editor issue |
PJ31390 | Regression: Traffic lighting doesn't work properly with textual data in cells |
PJ31386 | Formatting issue when export to default Excel template is selected. |
PJ31416 | PDF rendering breaks if report is more than one page |
PJ31452 | Invalid scope built for format mask and traffic lights when member contains parentheses |
PJ31454 | Sort is retained on wrong member when sort on opposite axis is removed |
PJ31470 | Wrap cells containing very long strings of data for PDF so that data does not overlap |
PJ31482 | Cube Manager dialog will not start |
PJ31476 | Combo bar/line charts do not display line against RDB data |
PJ31500 | Using percentage format mask multiplies value by 100 in Excel |
PJ31511 | Excel properties tab shows garbage for DBCS in PageFilterDimension and PageFilterSelection |
PJ31538 | Change of behavior in QueryFilter object |
PJ31590 | Collapse not working on mergedHeaders if inner dimension is drillable |
PJ31579 | Issue with render=xls with GroupBlox (ReportBlox) |
PJ31624 | MSAS dimensions are showing up as parents when they are leaf members |
PJ31647 | Show siblings will only perform a single level drill down with AsyncDataNavigation example |
To access the most current information about the product, go to:
For DB2 Alphablox information center, go to:
The PDF version of the information is located in the pdf/
directory
on this CD. The documentation set includes the following books:
Javadoc documentation is available in the documentation/javadoc/
directory. Included in this directory is Javadoc documentation for:
For web-based access to DB2 Alphablox Customer Support, go to:
To contact DB2 Alphablox Customer Support, call:
1-800-IBMSERV
(c) Copyright 1996, 2007 International Business Machines Corp. All rights reserved.