Setting up a IBM DB2® connection

10 reasons for using DBSP®

DBSP® FAQs

DBSP® Versions

400 users using DBSP now!

Home I Company I Services I Documentation I Downloads I E-Support

home -> documentation -> environment guide -> setting up a IBM DB2® connection

Prerequisites

The DB2 client must be installed and properly configured in order to set a successful connection. If you want more information about this topic, see the DB2 documentation.

Configuring the connection

If you want to configure a new DB2 connection, follow these steps:

1. On the DBSP Configuration tool, select the DB Connections tab and press New.

2. On the name field type the name of the connection as it will be referenced in the DBSP pages, for example: DB2EXAMPLE.

3. In the driver name list box, select DB2.

4. In the user name field, type a valid user for the database that you are trying to access. For the simplicity of the example, we will use the DB2ADMIN user.

Note: The user that you type in the User Name field will be the user that the DBSP Engine will use when the pages are interpreted. If this is the first time that you are connecting to the database, you will need a user with table creation privileges. Later on you can change these privileges according to your security necessities.

5. Type the password in the Password field. In order to prevent errors, the password will be displayed. You will need to do this process only once per connection.

6. Type in the Database field the name of the database, for example: SAMPLE.

7. If you want to modify the advanced parameters of the connection, press the Advanced button.

8. When done, press the Ok button. The new connection appears on the connection list.

9. Press the Test button in order to test that your server connection is established properly.

Previous | Next