Detailed set up examples for the DB2 Connect performance tests

Edit online

This appendix contains detailed examples of configurations and sample scripts we used in our test runs.

DB2 Connect™ configuration commands for Trade 6

The following commands were used to define the Trade 6 database on the DB2 Connect guest.

db2set DB2COMM=tcpip

db2 catalog tcpip node trade6db remote 10.10.50.110 server 446

db2 catalog dcs database trade6db as DB91ZOS

db2 catalog database trade6db as trade6db at node trade6db authentication DCS
You can issue the following DB2® command to generate the output shown below. 
db2 connect to trade6db user IBMUSER using password
Database Connection Information

 Database server          = DB2 OS/390 9.1.5
 SQL authorization ID     = IBMUSER
 Local database alias     = TRADE6DB
You can issue the following DB2 command to generate the output shown below. 
db2 bind /home/db2inst2/sqllib/bnd/@ddcsmvs.lst grant public blocking all ↓
     sqlerror continue
Note: The ↓ symbol indicates that the text continues on the next line. These lines should be entered on one line, not broken into multiple lines.

LINE    MESSAGES FOR ddcsmvs.lst
------  --------------------------------------------------------------------
        SQL0061W  The binder is in progress.

LINE    MESSAGES FOR db2clist.bnd
------  --------------------------------------------------------------------
        SQL0038W  The bind option SQLERROR CONTINUE has been
                  activated since it is required when binding this DB2-supplied
                  list file to DB2/MVS, SQL/DS, or OS/400.
        SQL0038W  The bind option SQLERROR CONTINUE has been
                  activated since it is required when binding this DB2-supplied
                  list file to DB2/MVS, SQL/DS, or OS/400.

LINE    MESSAGES FOR db2clpcs.bnd
------  --------------------------------------------------------------------
 3521   SQL0199N  The use of the reserved word "UNION" following ""
                  is not valid.  Expected tokens may include:  ", )".
                  SQLSTATE=42601

LINE    MESSAGES FOR db2clprr.bnd
------  --------------------------------------------------------------------
 3521   SQL0199N  The use of the reserved word "UNION" following ""
                  is not valid.  Expected tokens may include:  ", )".
                  SQLSTATE=42601

LINE    MESSAGES FOR db2clpur.bnd
------  --------------------------------------------------------------------
 3521   SQL0199N  The use of the reserved word "UNION" following ""
                  is not valid.  Expected tokens may include:  ", )".
                  SQLSTATE=42601

LINE    MESSAGES FOR db2clprs.bnd
------  --------------------------------------------------------------------
 3521   SQL0199N  The use of the reserved word "UNION" following ""
                  is not valid.  Expected tokens may include:  ", )".
                  SQLSTATE=42601

LINE    MESSAGES FOR ddcsmvs.lst
------  --------------------------------------------------------------------
        SQL0091N  Binding was ended with "0" errors and "6" warnings.

Buffer pools used with the Trade 6 database on z/OS®

Table 1. Buffer pools used with Trade 6 database on z/OS
Buffer Pool ID Size
9 60000
10 60000

DB2 Connect configuration commands for IRWW

db2 catalog tcpip node irwwdb remote 10.10.50.110 server 446

db2 catalog dcs database irwwdb as DB91ZOS

db2 catalog database irwwdb as irwwdb at node irwwdb authentication dcs

Buffer pools used with the IRWW database on z/OS

Table 2. Buffer pools used with IRWW database on z/OS
Buffer Pool ID Size
1 60000
2 60000
3 10000
4 7000
5 10000
6 20000
7 20000
8 60000