A new sample file, ibm_db2_sln_upart_smt, is available with |DB2 Universal Database(TM) (UDB) Version 8.2 FixPak 3 (equivalent to V8.1 |Fixpak 10). The following table shows the name and description of the sample |file.
| | |Sample script name | |File description | |
---|---|
ibm_db2_sln_upart_smt | |This Korn shell Dynamic Reconfiguration script (DR script) |for AIX facilitates the use of Dynamic Logical Partitioning (DLPAR) capabilities | provided with AIX Version 5.3 running on POWER5-based pSeries(R) systems, | such as p5 570 and p5 590. This script is similar to the ibm_db2_sln DR script |but is optimized to support POWER5(TM) and AIX V5.3 features such as micropartitioning | and SMT. Further information can be found in the DR script itself. | |
The ibm_db2_sln_upart_smt sample script is in the sqllib/samples/DLPAR directory on DB2 UDB for AIX.
For installation details, refer to "Linux 2.6 kernel installation images" in the DB2 UDB Version 8.2.2 Release Notes (New in this release section).
The following tables describe the DB2 Linux architecture support as of the release of FixPak 9. Check the preceding validate Web site for updates to this support:
http://www.ibm.com/db2/linux/validate
Distributions | Kernel | Library | Comments |
---|---|---|---|
Conectiva Linux Enterprise Edition (CLEE) | 2.4.19 | glibc 2.2.5 | Powered by United Linux 1.0 |
LINX Rocky Secure Server 2.1 | 2.4.21 | glibc 2.2.5 | |
Red Flag Advanced Server 4.0 | 2.4.21-as.2 | glibc 2.2.93-5 | |
Red Flag Function Server 4.0 | 2.4.20-8smp | glibc 2.2.93-5 | |
Red Hat Enterprise Linux 2.1 AS/ES/WS | 2.4.9-e16 | glibc 2.2.4 | |
Red Hat Enterprise Linux (RHEL) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
Red Hat Enterprise Linux (RHEL) 4 | 2.6.9 | glibc-2.3.3 | Also requires the compat-libstdc++-33 package |
SCO Linux 4.0 | 2.4.19 | glibc 2.2.5 | Powered by United Linux 1.0 |
SuSE Pro 8.0 | 2.4.18 | glibc 2.2.5 | |
SuSE Pro 8.1 | 2.4.19 | glibc 2.2.5 | |
SuSE Linux Enterprise Server (SLES) 7 | 2.4.7 | glibc 2.2.2 | |
SuSE Linux Enterprise Server (SLES) 8 | 2.4.19 | glibc 2.2.5 | Validated up to SuSE Service Pack 2 level |
SuSE Linux Enterprise Server (SLES) 9 | 2.6.5 | glibc-2.3.3 | |
Turbolinux 7 Server | 2.4.9 | glibc 2.2.4 | |
Turbolinux 8 Server | 2.4.18-5 | glibc 2.2.5 | |
Turbolinux Enterprise Server 8 | 2.4.19 | glibc 2.2.5 | |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
Distributions | Kernel | Library | Comments |
---|---|---|---|
Red Hat 7.2 | 2.4.9-34 | glibc 2.2.4 | |
Red Hat 7.3 | 2.4.18 | glibc 2.2.5 | |
Red Hat 8.0 | 2.4.18-14 | glibc 2.2.93-5 | |
SuSE 7.3 | 2.4.10 | glibc 2.2.4 |
Distributions | Kernel | Library | Comments |
---|---|---|---|
Red Hat 7.2 | 2.4.9-38 | glibc 2.2.4 | |
Red Hat Enterprise Linux (RHEL) 4 | 2.6.9 | glibc-2.3.3 | Also requires the compat-libstdc++-33 package |
SuSE Linux Enterprise Server (SLES) 7 | 2.4.7-58 | glibc 2.2.4 | compat.rpm contains libstdc++ 6.1. Use JDK 1.3.1 SR 1 for Java(TM) |
SuSE Linux Enterprise Server (SLES) 8 | 2.4.19 | glibc 2.2.5 | Powered by United Linux 1.0 |
SuSE Linux Enterprise Server (SLES) 9 | 2.6.5 | glibc-2.3.3 | |
Turbo Linux Enterprise Server (TLES) 8 | 2.4.19 | glibc 2.2.5 | Powered by United Linux 1.0 |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
Distributions | Kernel | Library | Comments |
---|---|---|---|
Red Hat Enterprise Linux (RHEL) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
Red Hat Enterprise Linux (RHEL) 4 | 2.6.9 | glibc-2.3.3 | Also requires the compat-libstdc++-33 package |
SuSE Linux Enterprise Server (SLES) 8.0 | 2.4.19-SMP | glibc 2.2.5-16 | |
SuSE Linux Enterprise Server (SLES) 9 | 2.6.5 | glibc-2.3.3 |
Distributions | Kernel | Library | Comments |
---|---|---|---|
Red Hat Enterprise Linux (RHEL) 3 AS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
Red Hat Enterprise Linux (RHEL) 4 | 2.6.9 | glibc-2.3.3 | Also requires the compat-libstdc++-33 package |
SuSE Enterprise Server (SLES) 8 | 2.4.19-16 | glibc 2.2.5 | Powered by United Linux 1.0 |
SuSE Linux Enterprise Server (SLES) 9 | 2.6.5 | glibc-2.3.3 | |
Turbolinux Enterprise Server 8 | 2.4.19-16 | glibc 2.2.5 | Powered by United Linux 1.0 |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
Distributions | Kernel | Library | Comments |
---|---|---|---|
Red Hat Enterprise Linux 2.1 AS/ES/WS | 2.4.18-e.12smp | glibc | |
Red Hat Enterprise Linux (RHEL) 3 AS/ES/WS | 2.4.21-7.EL | glibc-2.3.2-95.3 | |
Red Hat Enterprise Linux (RHEL) 4 | 2.6.9 | glibc-2.3.3 | Also requires the compat-libstdc++-33 package |
SuSE Linux Enterprise Server (SLES) 8 | 2.4.19-SMP | glibc 2.2.5 | Powered by United Linux 1.0 |
SuSE Linux Enterprise Server (SLES) 9 | 2.6.5 | glibc-2.3.3 | |
United Linux 1.0 | 2.4.19 | glibc 2.2.5 |
DB2 UDB for Linux 2.6 kernel-based Linux distributions for Intel x86 supports the following programming languages and compilers:
A 32-bit instance on DB2 UDB for 2.6 kernel-based Linux distributions on x86-64 supports the following programming languages and compilers:
A 64-bit instance on DB2 UDB for 2.6 kernel-based distributions for Linux on x86-64 supports the following programming languages and compilers:
The precompile and bind options for SQL procedures can be customized by setting the instance-wide DB2(R) registry variable, DB2_SQLROUTINE_PREPOPTS with the command:
db2set DB2_SQLROUTINE_PREPOPTS=<options>
In addition to the options documented at Version 8.2, the REOPT option is allowed:
BLOCKING {UNAMBIG | ALL | NO} DATETIME {DEF | USA | EUR | ISO | JIS | LOC} DEGREE {1 | degree-of-parallelism | ANY} DYNAMICRULES {BIND | RUN} EXPLAIN {NO | YES | ALL} EXPLSNAP {NO | YES | ALL} FEDERATED {NO | YES} INSERT {DEF | BUF} ISOLATION {CS | RR | UR | RS | NC} QUERYOPT optimization-level REOPT {ALWAYS | NONE | ONCE} VALIDATE {RUN | BIND}
The compiler option "-m64" is required when using gcc/g++ to build C/C++ applications and routines for a 64-bit instance on DB2 Universal Database(TM) for Linux(TM) on POWER.
The compiler option "-q64" is required when using xlc/xlC to build C/C++ applications and routines for a 64-bit instance on DB2 Universal Database for Linux on POWER.
The compile and link command shown in the DB2 Universal Database Version 8.2 documentation for building stored procedures using Micro Focus COBOL on HP-UX is incorrect. The compile command contained in the actual script sqllib/samples/cobol_mf/bldrtn is correct. The compile and link commands are now combined into one single command, using the -y option to specify that the desired output is a shared library.
The minimum supported version of the Micro Focus COBOL compiler and run time on HP-UX is Micro Focus Server Express 2.2 - Service Pack 1 plus Fix Pack Fixpack22.02_14 for HP-UX PA-RISC 11.x (32/64bit). This Fix Pack is available from the Micro Focus Support Line Web site at http://supportline.microfocus.com .
In order to run Micro Focus COBOL external routines on Windows(R), it is necessary to ensure that the Micro Focus COBOL environment variables are permanently set as system variables.
To set environment variables to system variables:
Setting the environment variables in the User variables list, at a command prompt, or in a script is insufficient.