Expert consultation

jfd3 · *nix forums beginner Joined: 10 Oct 2005 Posts: 2

Hello all,
I'm looking for some expert consultation. This is the 1st time I've had
to deal with an Rdb DB table this large. I want to make sure I'm
setting it up correctly. One of my main concerns is the storing of the
data. We are on a good SAN & DS25 servers. I have it set to spread
the data based upon a field HHNO which can be 1-9999999. I'm not sure
if its better on 1 disk or multiple as I have it. Please look over the
below configuration and advise accordingly. Thanks in advance!
----------------------------------------------------------------------------
80 million rows
record length: 58
index length : 1536
row makeup:
================
HHNO INTEGER (all w/ NOT NULL constraints)
UNIT TINYINT
MSCD TINYINT
COU SMALLINT
RTIME DATE VMS
CTIME DATE VMS
SEQ SMALLINT
LDS SMALLINT
SS SMALLINT
STD INTEGER
RAW INTEGER
DUR INTEGER
CLCOUNT TINYINT
TRANSIND SMALLINT
SSRCXPDD INTEGER

Index:
======
CLEXPAND_INDEX with column HHNO
and column UNIT
and column RTIME
and column SEQ
and column CLCOUNT
No Duplicates allowed
Type is Sorted
Compression is DISABLED
Node size 1536
Percent fill 95
Store clause:
STORE USING (HHNO)
in CLEXPAND_INDEX_STORE1 WITH LIMIT OF (221120)
in CLEXPAND_INDEX_STORE2 WITH LIMIT OF (546163)
in CLEXPAND_INDEX_STORE3 WITH LIMIT OF (729089)
in CLEXPAND_INDEX_STORE4 WITH LIMIT OF (905483)
OTHERWISE in CLEXPAND_INDEX_STORE5
(THRESHOLDS ARE (74, 74, 74))

{storage areas are all UNIFORM 12 blk pages, eg.}
CLEXPAND_INDEX_STORE1
Access is: Read write
Page Format: Uniform
Page Size: 12 blocks
Area File:
$1$DGA507:[CENTRAL_OFFICE.PROD.DBFILES]CLEXPAND_INDEX1.
RDA;1
Area Allocation: 90000 pages
Extent: Enabled
Area Extent Minimum: 99 pages
Area Extent Maximum: 9999 pages
Area Extent Percent: 20 percent
Snapshot File:
$1$DGA508:[CENTRAL_OFFICE.PROD.DBFILES]CLEXPAND_INDEX1.
SNP;1
Snapshot Allocation: 101835 pages
Snapshot Extent Minimum: 99 pages
Snapshot Extent Maximum: 9999 pages
Snapshot Extent Percent: 20 percent
Locking is Row Level
No Cache Associated with Storage Area

Database objects using Storage Area CLEXPAND_INDEX_STORE1:
Usage Object Name Map / Partition
---------------- ------------------------------- -------------------
Index CLEXPAND_INDEX (1)

Storage map:
===============================
CLDATA_EXPAND_MAP
For Table: CLDATA_EXPANDED
Placement Via Index: CLEXPAND_INDEX
Partitioning is: UPDATABLE
Store clause: STORE USING (HHNO)
in CLDATA_EXPAND_STORE1 WITH LIMIT OF (221120)
in CLDATA_EXPAND_STORE2 WITH LIMIT OF (546163)
in CLDATA_EXPAND_STORE3 WITH LIMIT OF (729089)
in CLDATA_EXPAND_STORE4 WITH LIMIT OF (905483)
OTHERWISE in CLDATA_EXPAND_STORE5
(THRESHOLDS ARE (96, 96, 96))
Compression is: DISABLED

{all storage areas are UNIFORM 4 blk pages, eg.}
CLDATA_EXPAND_STORE1
Access is: Read write
Page Format: Uniform
Page Size: 4 blocks
Area File:
$1$DGA505:[CENTRAL_OFFICE.PROD.DBFILES]CLDATA_EXPAND1.R
DA;1
Area Allocation: 739968 pages
Extent: Enabled
Area Extent Minimum: 99 pages
Area Extent Maximum: 9999 pages
Area Extent Percent: 20 percent
Snapshot File:
$1$DGA506:[CENTRAL_OFFICE.PROD.DBFILES]CLDATA_EXPAND1.S
NP;1
Snapshot Allocation: 394971 pages
Snapshot Extent Minimum: 99 pages
Snapshot Extent Maximum: 9999 pages
Snapshot Extent Percent: 20 percent
Locking is Row Level
No Cache Associated with Storage Area

Database objects using Storage Area CLDATA_EXPAND_STORE1:
Usage Object Name Map / Partition
---------------- ------------------------------- ---------------------
Storage Map CLDATA_EXPANDED CLDATA_EXPAND_MAP (1)

Google