Application Service Guide > Updating the DynamicSections Parameter of a DB2 Database > Updating the DynamicSections Parameter
  

Updating the DynamicSections Parameter

Use the DataDirect Connect for JDBC utility to raise the value of the DynamicSections parameter in the DB2 database.
To use the DataDirect Connect for JDBC utility to update the DynamicSections parameter, complete the following tasks:

Downloading and Installing the DataDirect Connect for JDBC Utility

Download the DataDirect Connect for JDBC utility from the DataDirect download web site to a machine that has access to the DB2 database server. Extract the contents of the utility file and run the installer.
    1. Go to the DataDirect download site: http://www.datadirect.com/support/product-documentation/downloads
    2. Choose the Connect for JDBC driver for an IBM DB2 data source.
    3. Register to download the DataDirect Connect for JDBC Utility.
    4. Download the utility to a machine that has access to the DB2 database server.
    5. Extract the contents of the utility file to a temporary directory.
    6. In the directory where you extracted the file, run the installer.
The installation program creates a folder named testforjdbc in the installation directory.

Running the Test for JDBC Tool

After you install the DataDirect Connect for JDBC Utility, run the Test for JDBC tool to connect to the DB2 database. You must use a system administrator user account with the BINDADD authority to connect to the database.
    1. In the DB2 database, set up a system adminstrator user account with the BINDADD authority.
    2. In the directory where you installed the DataDirect Connect for JDBC Utility, run the Test for JDBC tool.
    On Windows, run testforjdbc.bat. On UNIX, run testforjdbc.sh.
    3. On the Test for JDBC Tool window, click Press Here to Continue.
    4. Click Connection > Connect to DB.
    5. In the Database field, enter the following text:
    jdbc:datadirect:db2://HostName:PortNumber;databaseName=DatabaseName;CreateDefaultPackage=TRUE;ReplacePackage=TRUE;DynamicSections=3000
    HostName is the name of the machine hosting the DB2 database server.
    PortNumber is the port number of the database.
    DatabaseName is the name of the DB2 database.
    6. In the User Name and Password fields, enter the system administrator user name and password you use to connect to the DB2 database.
    7. Click Connect, and then close the window.