Hardware configuration

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
bikan
Premium Member
Premium Member
Posts: 128
Joined: Thu Jun 08, 2006 5:27 am

Hardware configuration

Post by bikan »

Hi All,

We are planning to load 10 to 12 Million record per night. I'm planning to have below Server configuration. Pls let me know will suit my
requirement? What should be the standard configuratio for loading 10 to 12 million records overnight?

4 CPU
4 GB RAM 1 GB per CPU
1 TB Hard Disk
.5TB Scratch Disk
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sorry, but there's no such thing as a 'standard configuration' and no way to tell you what hardware is needed to load X rows in Y hours. There's far too many variables in 'loading' data for that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
bikan
Premium Member
Premium Member
Posts: 128
Joined: Thu Jun 08, 2006 5:27 am

Post by bikan »

Agree with you.

But for a planning purpose is it Ok to prepare a machine with the given configuration?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Probably. For planning purposes. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

"records" and "rows" are meaningless by themselves. How many Mb or Gb must be transferred? What are you writing into and where are you reading from?
Post Reply