Quick Beginnings for DB2 Connect

Running Your Own Applications

Various types of applications can access DB2 databases:

• Applications developed using the DB2 Software Developer's Kit that include embedded SQL, APIs, stored procedures, user-defined functions or calls to the DB2 CLI.

• ODBC applications such as Lotus Approach.

• JDBC applications and applets.

• Net.Data macros containing HTML and SQL.

An application on a DB2 client can access a remote database without knowing its physical location. The DB2 client determines the location of the database, manages the transmission of the requests to the database server, and returns the results.

In general, to run a database client application, use the following steps:

1. Ensure the server is configured and running.

   Be sure that the database manager is started on the database server to which the application program is connecting. If it is not, you must issue the db2start command at the server before starting the application.

2. Ensure that you can connect to the database that the application uses.

3. Bind the utilities and the applications to the database. See Binding Database Utilities for information about binding the utilities.

4. Run the application program.

[ DB2 List of Books | Search the DB2 Books ]