Application development: Building and Running Applications

Dynamic reconfiguration samples (AIX)

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.

The ibm_db2_sln_upart_smt sample script is in the sqllib/samples/DLPAR directory on DB2 UDB for AIX.

Linux supported development software

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

DB2 UDB for Linux 2.6 kernel-based Linux distributions for Intel x86 supports the following programming languages and compilers:

C

GNU/Linux gcc version 3.3

C++

GNU/Linux g++ version 3.3

COBOL

Micro Focus COBOL Server Express Version 2.2 with Service Pack 1

Java^(TM)

IBM^(R) Developer Kit and Runtime Environment for Linux, Java 2 Technology Edition, Version 1.3.1 and 1.4.1 Service Release 1, 32-bit version

Note:

DB2 UDB installs the latest supported version of the developer kit if it is not already installed, unless the DB2 UDB installation is an update of a previous DB2 UDB Version 8 installation. If a previous DB2 UDB Version 8 installation is being updated, the supported developer kit must be manually installed from the CD-ROM.

Perl

Perl 5.004_04 or later, DBI 0.93 or later

PHP

PHP 4.3.4 or later

REXX

Object REXX Interpreter for Linux Version 2.1

A 32-bit instance on DB2 UDB for 2.6 kernel-based Linux distributions on x86-64 supports the following programming languages and compilers:

C

GNU/Linux gcc version 3.3

Note:

The "-m32" compiler option must be used to generate 32-bit applications or routines (stored procedures and user-defined functions).

C++

GNU/Linux g++ version 3.3

Notes:

1. These versions of the GNU/Linux g++ compiler do not accept integer parameters for some fstream functions. Consult the compiler documentation for more information.
2. The "-m32" compiler option must be used to generate 32-bit applications or routines (stored procedures and user-defined functions).

Java

IBM Developer Kit and Runtime Environment for Linux x86, Java 2 Technology Edition, Version 1.3.1 Service Release 4, 32-bit version, and Version 1.4.1 Service Release 1, 32-bit version.

Note:

DB2 UDB installs the latest supported version of the developer kit if it is not already installed, unless the DB2 UDB installation is an update of a previous DB2 UDB Version 8 installation. If a previous DB2 UDB Version 8 installation is being updated, the supported developer kit must be manually installed from the CD-ROM.

Perl

Perl 5.8

PHP

PHP 4.3.4 or later

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:

C

GNU/Linux gcc version 3.3

C++

GNU/Linux g++ version 3.3

Note:

These versions of the GNU/Linux g++ compiler do not accept integer parameters for some fstream functions. Consult the compiler documentation for more information.

Java

DB2 UDB does not currently support any 64-bit Java Developer Kit for Linux on x86-64.

Perl

Perl 5.8

PHP

PHP 4.3.4 or later

Customizing precompile and bind options for SQL procedures

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}

C/C++ compile option required (Linux on POWER 64-bit)

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.

Compile and link command for Micro Focus COBOL stored procedures (HP-UX)

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.

Minimum supported version of Micro Focus COBOL (HP-UX)

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 .

Setting environment variables for Micro Focus COBOL stored procedures (Windows)

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.