Multiple DB layout for AIX F80 ?

From: Don Dealy II <dondealy_at_teleport.com>
Date: Thu, 25 May 2000 19:24:59 -0700
Message-Id: <10508.106808@fatcity.com>

Hello,

I'm squeezing in a lot of info here, so please read it all before trying to=  formulate a response.

We are in the planning stages for moving from 8.0.5 to 8.1.6. At the same=  time we are moving up to an AIX F80 with 1CPU and at least 2G RAM and 14=  9G drives (DASD) on 3 controllers.

The question: Suggested DB ts layout on these drives for 3 DB.

3 instances 98% READ ONLY DB

DB1 3G data (in-line LOB document reading) DB2 800M data (text fill-in to web page) DB3 500M data (x-ref 4-6M row / 2 col tables)

Uptime: 0600 EDT - 2000 PDT M-F

Same user community web accessing each DB. All queries are done on a key.=  No full table scans at all.

Max users =3D 300 - 350
Max concurrent =3D 50 - 75
Max active =3D 15 - 20

Web response time is the #1 concern. We need sub-second response from the=  server so that the Internet response is under 5 seconds. The server sits=  in the IBM cloud at White Plains with a hot-backup in Boulder. We have no=  control over bandwidth from server to the Internet.

Infrequent updates are planned for "off hours" batch insert / delete.

I'm thinking no archive log mode with striping, but we need protection from=  a stripped disk crashing.

Is it reasonable to think that the various TS for each DB could share the=  same spindles?

Example:

Drive 1-4 DATA ts for all three DB
Drive 5-7 INDX ts for all three DB
Drive 8-9 O/S and SWAP

etc...

Thanks for your timely thoughts and ideas. Received on Thu May 25 2000 - 21:24:59 CDT