beautypg.com

5 considerations for a partitioned database – IBM Data Server DB2 User Manual

Page 53

background image

Chapter 2. DB2 server deployment

39

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.