|
Larger Default Database Page Sizes:
The default database page size in DB2 UDB
has been fixed at 4k (4096 bytes) since Database Manager v1.1 shipped back in the late 1980's. If you have one or more
tables that are wider than 4k, you have to create a separate table space using a larger 8k, 16k, or 32k page size. The new
larger table space also required that you create a separate temporary table space and buffer pool with matching page sizes
for the larger table space.
DB2 UDB v8.2.2 (a.k.a. Fixpak 9) now
allows you to create a database with an 8k, 16k, or 32k default page size allowing you to have consistent page sizes for
the system catalog, system temporary table spaces, user temporary table spaces, and user index, data, and large table
spaces.
Example 1: Create a database with 8k default table spaces size.
CREATE DATABASE TENDIGIT ALIAS TENDIGIT PAGESIZE 8192
CATALOG TABLESPACE MANAGED BY SYSTEM USING ('SYSCATSPACE')
EXTENTSIZE 32 PREFETCHSIZE 32
TEMPORARY TABLESPACE MANAGED BY SYSTEM USING ('TEMPSPACE1')
EXTENTSIZE 32 PREFETCHSIZE 32
USER TABLESPACE MANAGED BY SYSTEM USING ('USERSPACE1')
EXTENTSIZE 32 PREFETCHSIZE 32 WITH 'Ten Digit Database';
Note: To find out more about this new feature go to the DB2 Information Center and search on CREATE DATABASE Command.
Tracking of Instance and Database Configuration Changes:
One of the new and improved features
included in Stinger (a.k.a. DB2 UDB v8.1 Fixpak 7) is the automatic logging of changes made to the instance (DBM) and
database configuration parameters. Prior to Stinger changes to these critical configuration parameters where not recorded
and only sure way to automatically track changes was to schedule a nightly GET DBM CFG or GET DB CFG script to pipe the
current values of theses parameters to a history file. Now DB2 UDB v8.2 keeps track of these changes for you in the DB2
diagnostic log file.
Example 1: Update DBM Configuration using diaglevel 4
2005-04-29-18.16.32.647000-240 I5099589H359 LEVEL: Event
PID : 2312 TID : 3756 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-405 APPID: *LOCAL.DB2.050729184736
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Diaglevel" From: "3" To: "4"
|