Application Building Guide

Setup

Creating a proper environment for building and running DB2 applications requires properly setting up the following:

1. Compiler or interpreter
2. DB2 (database manager, DB2 AD Client, and client connection)
3. Operating system environment
4. DB2 Sample database (optional)

Checking your Compiler or Interpreter Environment

To develop DB2 programs, you must use a compiler or interpreter for one of the supported programming languages for your operating system, listed in "Supported Software by Platform". It is recommended that you ensure your existing compiler or interpreter environment is correctly set up by first building a non-DB2 application. Then, if you encounter any problems, please see the documentation that comes with your compiler or interpreter.

Setting Up the DB2 Environment

To set up your DB2 environment, the following must be installed and working:

• The database manager on the server with the database instance for your environment. Refer to Appendix A, "About Database Manager Instances" if you need information about database instances.
• The DB2 AD Client on the client or server workstation on which you are going to develop applications.
• The connection to the remote server, if you are developing on a client workstation.

Updating the Database Manager Configuration File

This file contains important settings for application development. You can change these settings by entering:

   db2 update dbm cfg using <keyword> <value>

and you can view the settings by entering:

   db2 get dbm cfg

See the Command Reference for more information on using these commands.

• For stored procedures, the keyword KEEPDARI has the default value yes. This keeps the stored procedure process alive. If you are developing a stored procedure, you may want to test loading the same stored procedure library a number of times. This default setting may interfere with reloading the library. Its best to change the value of this keyword to no while developing stored procedures, and then change it back to yes when you are ready to load the final version of your stored procedure.
• For Java, update the JDK11_PATH keyword. See "Setting the Environment" for details.

For more detailed information on installation and setup, refer to the Quick Beginnings book for your operating system.

When the above are installed and working, you can set up your operating system environment by following the steps in one of the following sections:

• "Setting the OS/2 Environment"
• "Setting the UNIX Environment"
• "Setting the Windows 32-bit Operating Systems Environment"

After you set up your operating system environment, you may want to create the sample database, which is used by the sample programs in this book. To create the database, see "Creating, Cataloging, and Binding the Sample Database"