Filter
Top Products
4. Open an DB2 command window and run the cr_db2db_lmm.bat or cr_db2db_lmm.sh file. For example:
cr_db2db_lmm.bat > lms_db.log. This creates a database named lmm, and creates the buffer pools
required for any Learning Management System schema.
5. If desired, edit the lmm_db2.sql script for file size and placement. From a DB2 command window, run the
script with the following command: db2 -tvf lmm_db2.sql > lms_schema.log
6. From the DB2 command window run the seed data scripts. For example: db2 -tvf
permission_data.sql AND db2 -tvf settings_init.sql.
Creating the DS database(s)
1. Copy the script files to the database server. The files required are: cr_db2db_ds.bat (for Windows) or
cr_db2db_ds.sh (for UNIX) and ds_db2.sql.
Note: When UNIX shell scripts are copied, they may need to be made executable by using the following
command: chmod +x *.sh
2. Log into the DB2 server using the DB2 administrator account. Database creation must happen on the actual
database server. The script cannot be run from a database client machine.
3. If desired, edit the cr_db2db_ds.bat or cr_db2db_ds.sh file. Changes that might have to be made include
specifying multiple database files, increasing file size, and increasing bufferpool size - temporary and
database tablespaces with a 16K blocksize, and bufferpools with a 16K blocksize. Your database
administrator should review and edit this file for your environment.
4. Open a DB2 command window and run the cr_db2db_ds.bat or cr_db2db_ds.sh file. For example:
cr_db2db_ds.bat > ds_db.log. This creates a database named ds, and creates the buffer pools required
for any Learning Management System schema.
5. If desired, edit the ds_db2.sql script for file size and placement. From a DB2 command window, run the
script with the following command db2 -tvf ds_db2.sql > ds_schema.log.
6. From the DB2 command window, run the DS seed data script. For example: db2 –tvf
settings_init_ds.sql.
Connecting the DB2 client to a remote database
In order to run applications using remote DB2, you must do the following:
• Install the DB2 client on the same machine where the WebSphere Application Server (WAS) is installed (see
“Chapter 6 Installing the WebSphere Core” for more information).
• Verify the DB2 client (UNIX only).
• Add the remote databases to the DB2 client’s catalog.
• Modify WAS environment to use DB2 drivers.
Installing the DB2 client
Use the following instructions to install the DB2 client for AIX:
1. Refer to the IBM DB2 Universal Database for Unix Quick Beginnings for requirements and change the kernel
parameters as needed.
2. If DB2 has not been installed run db2setup from the directory where DB2 is located and install the
Administration client. If DB2 is already installed run /usr/lpp/db2_07_01/install/db2setup.
3. Select the “To create a DB2 instance” option, Admin Server and click Enter.
4. Select the “To create a DB2 instance” option. A panel for db2inst1 user is presented.
Chapter 9: Installing and Configuring Database Servers and Schema 41