The generated sample.ddl is shown in Example 2-2.When using this script to configure a new database, remember to change the database name if it is different from the old one.

Example 2-2 db2look output

--This CLP file was created using DB2LOOK Version 9.5

--Timestamp: Thu 15 Mar 2007 02:47:52 AM PDT

--Database Name: SAMPLE

--Database Manager Version: DB2/LINUXX8664 Version 9.5.1

--Database Codepage: 1208

--Database Collating Sequence is: IDENTITY

CONNECT TO SAMPLE;

--------------------------------------------------------

--Database and Database Manager configuration parameters

--------------------------------------------------------

UPDATE DBM CFG USING cpuspeed 4.000000e-05;

UPDATE DBM CFG USING intra_parallel NO;

UPDATE DBM CFG USING comm_bandwidth 1.250000;

UPDATE DBM CFG USING federated NO;

UPDATE DBM CFG USING fed_noauth NO;

UPDATE DB CFG FOR SAMPLE USING locklist 100;

UPDATE DB CFG FOR SAMPLE USING dft_degree 1;

UPDATE DB CFG FOR SAMPLE USING maxlocks 10;

UPDATE DB CFG FOR SAMPLE USING avg_appls 1;

UPDATE DB CFG FOR SAMPLE USING stmtheap 4096;

UPDATE DB CFG FOR SAMPLE USING dft_queryopt 5;

---------------------------------

--Environment Variables settings

---------------------------------

COMMIT WORK;

CONNECT RESET;

TERMINATE;

2.1.5 Considerations for a partitioned database

The Database Partitioned Feature offers you a way to implement a highly scalable and high performance database system. A DB2 partitioned database system is often seen in the warehouse/Business Intelligence (BI) system.

Chapter 2. DB2 server deployment 39

Page 53
Image 53
IBM DB2 manual Considerations for a partitioned database, Example 2-2 db2look output