Ibm Data Server DB2 Instrukcja Użytkownika Pobierz pdf (Strona 53)

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.

1 2 ... 48 49 50 51 52 53 54 55 56 57 58 ... 297 298

Brak uwag

Ibm Data Server DB2 Instrukcja Użytkownika Strona 53