Set up and configure Trade3DB database

 

DB2 Server

We will use the default DB2 instance on the server (db2inst1).

1. In a Windows environment, log on to the database server and start a DB2 shell using the db2cmd command.

AIX: On AIX, first switch to user db2inst1: su - db2inst1

2. Copy the file table.ddl from the Trade3.1 install directory to the DB2 server. Then execute the following DB2 commands to create the Trade3db database:

db2 create db Trade3db

db2 connect to Trade3db

db2 -tvf table.ddl

db2 disconnect all

db2set DB2_RR_TO_RS=yes

db2 update db config for Trade3db using logfilsiz 1000

db2 update db cfg for Trade3db using maxappls 100

db2stop force

db2start

3. From the same shell, change the current directory to <sqllib>\bnd, in our case to C:\Program Files\Sqllib\bnd. Run the following commands to bind DB2 packages for the Trade3db database:

db2 connect to Trade3db

db2 bind @db2cli.lst blocking all grant public

AIX: On AIX, change to the following directory before performing the above commands: /usr/opt/db2_08_01/bnd

Important: Failure to rebind will result in the following runtime error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0805N Package "NULLID.SQLLC300" was not found. SQLSTATE=51002

  Prev | Home | Next

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.