This chapter provides detailed information for building embedded SQL applications on Silicon Graphics IRIX. In the script files, commands that begin with db2 are Command Line Processor (CLP) commands. Refer to the Command Reference if you need more information about CLP commands.
For the latest DB2 application development updates for Silicon Graphics IRIX, visit the Web page at:
http://www.software.ibm.com/data/db2/udb/ad
DB2 for Silicon Graphics IRIX is client-only. To run DB2 applications, and to build DB2 embedded SQL applications, you need to access a DB2 database on a server machine from your client machine. The server machine will be running a different operating system. See DB2 for UNIX Quick Beginnings for information on configuring client-to-server communication.
Also, since you will be accessing a database on the server from a remote client that is running on a different operating system, you need to bind the database utilities, including the DB2 CLI, to the database. See "Binding" for more information.
DB2 Library Support
Silicon Graphics IRIX provides three separate and incompatible object types: o32 (the default), n32 (the new 32 object type), and n64 (the 64 object type). DB2 does not yet support n64, but does support the o32 and n32 object types.
The operating system also has two separate and incompatible versions of thread APIs: the sproc interface and the POSIX threads API. DB2 provides support for the POSIX threads API.
Applications which use the sproc interface can use the non-threaded versions of the DB2 library, libdb2, which are not thread safe. Care should be taken when using the sproc interface because libdb2 is not sproc safe.
To accommodate this range of functionality, DB2 provides the following library support:
To use the n32 object type, programs must be compiled and linked with the -n32 option, as well as linked with the lib32/libdb2.so or lib32/libdb2_th.so library. To use the default o32 object type, programs must be linked to either the lib/libdb2.so or lib/libdb2_th.so libraries without the -n32 option.