DB2 Warehouse V10.5 Known Issues

News


Abstract

This document contains the known issues for IBM DB2 Warehouse, Version 10.5 for Linux, UNIX, and Windows.

Content

IBM® DB2® Warehouse is a component of IBM DB2 Advanced Enterprise Server Edition V10.5, IBM DB2 Enterprise Server Edition V10.5, and IBM DB2 Advanced Workgroup Server Edition V10.5.
Version 10.5
Oracle Compatibility Support

Problem: In Design Studio, a control or data flow that employs a table that is created in Oracle compatibility mode as a target or a data source, fails to execute.
Resolving the problem: Setup the SQL execution database with a database that is created in Oracle Compatibility mode. The reason for this is that during the flow execution process, a temporary table is created in the SQL execution database. Because the target or a data source table was created in Oracle Compatibility mode, so must the the SQL execution database.
For more information on the SQL execution database, see the DB2 Information Center.

Administration Console

Problem: In the Administration Console, if you run the Optimization Advisor against a cube model that is mapped to a DB2 V10.5 database connection, the Optimization Advisor fails.
Resolving the problem: Before you run the Optimization Advisor, ensure that no explain tables exist in the DB2 database connection. Then, create an explain tables manually. You need to create the explain table only the first time you run the Optimization Advisor.
For more information on creating an explain table, see the DB2 Information Center.

Install

Problem: DB2 warehouse does not support installation on Windows 8.1 or on Windows 2012 R2 platform.
Resolving the problem: To install DB2 Warehouse on Windows, enable compatibility mode by completing the following steps:

  1. Right-click the installer (install.exe or install.bin) and select Properties.
  2. On the Properties page, click the Compatibility tab.
  3. Select the Run this program in compatibility mode for check box.
  4. From the adjacent drop-down menu, select Windows.
  5. Click Apply.
  6. Continue with the installation as outlined in the DB2 Information Center.

Problem: The tar.gz file on the Warehouse Server DVD for an AIX operating system is not unpacked due to the iso file limitation.
Resolving the problem: To install DB2 Warehouse from the DVD:
  1. Ensure you have at least 10 GB of space on the disk that you plan to launch the installer from.
  2. Insert the DVD.
  3. Unpack the tar.gz file to the disk with 10 GB of space.
  4. Continue with your install as usual.
For more information on installation, see the DB2 Information Center.

Problem: The installation fails, despite no warnings or errors being displayed.
Resolving the problem: There may not be enough disk space to complete the installation. Re-install DB2 Warehouse, and during the installation, check the Pre-installation Summary pane for the amount of free disk space. Approximately 1.2 GB of disk space is recommended for the installation images of the data server components. If you plan to install the client components on the same computer, you will need a total of 2.5 GB of disk space.
For more information on installation requirements, see the DB2 Information Center.

Problem: On Linux and AIX platforms, the installation fails, despite no warnings or errors being displayed.
Resolving the problem: There may not be enough disk space in the tmp folder to complete the installation. Re-install DB2 Warehouse, and during the installation, check the Pre-installation Summary pane for the amount of free disk space. Approximately 1.5 GB of disk space is recommended.
For more information on installation requirements, see the DB2 Information Center.

Problem: Following the installation, the log file located in the ISW_INSTALL_PATH/uninstall directory has not been removed.
Resolving the problem: There is no impact to DB2 Warehouse. Ignore the empty directory.
For more information on installation log files, see the DB2 Information Center.

Problem: Silently installing DB2 Warehouse using the WebSphere Application Server profile with standAlone mode under WebSphere Application Server Network Deployment fails.
Resolving the problem: Install DB2 Warehouse, using the WebSphere Application Server profile with standAlone mode under WebSphere Application Server Network Deployment, with either the GUI-based launchpads or by running the GUI-based installation wizards.
For more information on installation methods, see the DB2 Information Center.
An alternative resolution is to create a file named, WSCustomConstants.properties, in the directory <WAS root>/properties with the content, profileType=standAlone. And then re-install silently.

Problem: On Windows 7 32-bit, Windows 8 32-bit, and Linux on X86 32-bit platforms the server images are for non-production use only.
Resolving the problem: 32-bit platforms are intended for development and test only. Please move to a 64-bit platform to take advantage of the full functionality of DB2 Warehouse.
For more information on system requirements, see the DB2 Information Center.

Problem: In DB2 Warehouse Design Studio, if you attempt to create an SQL Script, the error "Script name cannot be empty" displays, despite specifying a script name.
Resolving the problem: No work around is available at this time. One will be available shortly.

APAR Fix List

The following APARs re fixed in DB2 Warehouse Fix Pack 3:

  • PJ40792: Change the current date time format used in Admin Console from "mm/dd/yyyy hh:mm:ss" to a more friendly format to customers like "Dec 4, 2012 3:43:00 PM".
  • PJ41047: When using CreateSchedule command, there is a problem with date format convertion under DE locale. It will cause the schedule creation to fail. After applying the fix, users can use German date format in command line like dd.MM.yyyy.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Warehouse

Software version:

10.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

Edition Independent

Reference #:

1635968

Modified date:

2014-08-12

Translate my page

Machine Translation

Content navigation