Product Documentation
Abstract
This techdoc summarizes the platforms and data sources supported by IBM Optim
Content
Hardware Considerations
The memory required for acceptable performance depends upon factors such as the number of open dialogs, number of tables in the database, etc. that are active, and memory demands from other active applications and services.
Minimum hardware requirements for an Optim workstation are:
Pentium, 600 MHz or greater with 1 GB disk;
256 MB RAM;
10BaseT or 100BaseT network connection.
Minimum hardware requirements for an Optim server are:
IBM AIX
350 MHz Power 3 Dual Processor with 1 GB for Optim and 60 GB (or as required) for Archive Files;
1 GB RAM for testing environment and 2 GB RAM for production environment;
100BaseT network connection;
HP-UX Server:
HPIB 550 MHz Dual Processor with 1 GB for Optim and 60 GB (or as required) for Archive Files;
1 GB RAM for testing environment and 2 GB RAM for production environment;
100BaseT network connection.
Sun Solaris:
450 MHz Dual Processor Ultra SPARC with 1 GB for Optim and 60 GB (or as required) for Archive Files;
1 GB RAM for testing environment and 2 GB RAM for production environment;
100BaseT network connection.
Windows:
1 GHz dual Processor Pentium with 1 GB for Optim and 60 GB for Archive Files;
1 GB RAM for testing environment and 2 GB RAM for production environment;
100BaseT network connection.
Software Requirements
Unless installing the Optim server (or absent the server, the workstation) on the database server, client software for the database management system is required.
Platform Considerations
Supported Platforms | ||||
Platform and Version | Optim Server | Optim Work station | An uncompress utility is a prerequisite to installation on most platforms. Where required, the utility is in the /usr/bin directory in the following packages. | |
Package | Description | |||
AIX 5.1 | Yes | No | bos.rte.archive | Base Operating System Runtime, Archive Commands |
AIX 5.2 | Yes | No | ||
AIX 5.3 | Yes | No | ||
AIX 6.1 | Yes | No | ||
HP-UX 11.11 | Yes | No | OS-Core.CMDS-MIN and PHCO_26898.CMDS-MIN | Minimum HPUX commands with Patch (11.11) |
HP-UX 11.23(PA-RISC)1 | Yes | No | ||
Red Hat Enterprise Linux 3.0 | Yes | No | ncompress | Fast compression and decompression utilities |
Red Hat Enterprise Linux 4.0 | Yes | No | ||
Solaris 8 | Yes | No | SUNWesu | Extended System Utilities |
Solaris 9 | Yes | No | ||
Solaris 10 | Yes | No | ||
Windows 2003 Server2 | Yes | Yes | not required | |
Windows XP Professional2 | Yes | Yes | ||
Windows Vista Enterprise Edition SP22 | Yes | Yes |
1Optim supports the HP-UX Itanium® architecture if running the PA-RISC emulator. You must perform special installation steps to run Optim using the PA-RISC emulator. Currently only Oracle is supported in this environment. Optim supports 32–bit DBMS clients.
2At least one workstation is required for each Optim implementation.
Database considerations
Supported Databases | |
DBMS and Version | Support Level |
DB2 for Linux, UNIX, and Windows 7.2 | Full support |
DB2 for Linux, UNIX, and Windows 8.1 | Full support |
DB2 for Linux, UNIX, and Windows 8.2 | Full support |
DB2 for Linux, UNIX, and Windows 9.1 | Full support |
DB2 for Linux, UNIX, and Windows 9.5 | Toleration support |
DB2 for iSeries 5.3 | Toleration support (Requires add'l programs, services, or both) |
DB2 for iSeries 5.4 | Toleration support (Requires add'l programs, services, or both) |
DB2 for z/OS® 7.1 | Full support |
DB2 for z/OS 8.1 | Full support |
DB2 for z/OS 9.1 | Toleration support |
Informix® 7.3.1 | Full support |
Informix 9.4 | Toleration support |
Informix 10 | Toleration support |
Informix 11 | Toleration support |
Oracle 8.1.7 | Full support |
Oracle 9.0 | Full support |
Oracle 9.2 | Full support |
Oracle10.1 | Full support |
Oracle11.1 | Toleration support |
SQL Server 2000 | Full support |
SQL Server 2005 | Full support |
SQL Server 2008 | Toleration support |
Sybase 11.9.2 | Full support |
Sybase 12.0 | Full support |
Sybase 12.5 | Full support |
Sybase 15 | Full support |
Teradata 2.5 | Toleration support (Requires add'l programs, services, or both) |
Teradata 2.6 | Toleration support (Requires add'l programs, services, or both) |
Supported MBCS Code Pages
Optim (when running on Windows or AIX) supports the following multi-byte character sets (MBCS) within DB2 for Linux, UNIX, and Windows by using the International Components for UNICODE (ICU) libraries.
Chinese | 936 [Windows Simplified Chinese] 950 [IBM Chinese Big-5] 1386 [IBM Simplified Chinese] |
Korean | 949 [Korean (KS Code 5601-89)-including 1880 UDC] 970 [Korean (EUC)] |
Optim supports the following multi-byte character set (MBCS) within Oracle.
Chinese | ZHS32GB18030 [GB18030-2000] ZHT16MSWIN950 [Microsoft Windows Code Page 950 Traditional Chinese] ZHS16GBK [GBK 16-bit Simplified Chinese] |
Korean | KO16MSWIN949 [Microsoft Windows Code Page 949 Korean] |
Setup Considerations for UNIX
If you are upgrading the Optim server on a UNIX platform, you must first shut down the server, following the steps in the Installation and Configuration Guide.
By default, the Optim setup program requires a connection that supports a graphical interface. In the absence of a graphical interface or for convenience, you may also install from the command line, running a file that provides a response to all prompts. Both methods are described in detail in the Installation and Configuration Guide as are troubleshooting tips for using a graphical interface.
Original Publication Date
05 May 2009
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg27014811