Page 1 of 1

AD: datastage performance

Posted: Sun Aug 12, 2001 7:37 am
by admin
This is a topic for an orphaned message.

Posted: Sun Aug 12, 2001 7:37 am
by admin
Ray,

So these performance related documents dont normally
come with the DataStage literature ?

Thanks
Bibhu
--- Ray Wurlod wrote:
> There is a whole section called "Designing and
> Performance" in the "Advanced
> DataStage" class offered in the Asia-Pacific region.
> Note that this is NOT
> the same class as DS305 offered in the USA.
>
> -----Original Message-----
> From: Bibhu C [mailto:bibhuds@yahoo.com]
> Sent: Saturday, 11 August 2001 02:55
> To: datastage-users@oliver.com
> Subject: datastage performance
>
>
> Hi All,
>
> Even when I am in the design phase of my ETL jobs, I
> was curious to know about the ways to improve
> performance of DataStage jobs. I understand that use
> of hash files is one of ways, but the manuals are
> really tightlipped about them and any other paths
> that
> one would want to tread to improve load performance.
>
> I am looking to the knowledgeable group to tell me
> about the various performance enhancing strategies
> in
> DataStage, also tell me if I have missed something
> in
> the manuals.
>
> Thanks
> Bibhu
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
>


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

Posted: Sun Aug 12, 2001 7:42 pm
by admin
Bibhu,

Design and Performance are ideal bed fellows in a course to give understanding.

Design choices always involve a trade of a number of issues:
- Performance,
- Maintian Ability,
- Re-useability,
- Standards,
- Aesthetics.

It should come as no surprise that the choice of which is most important will change in a different situations. Not much point in optimising a job for performance if it only processes 10 rows. Not point in optimising for Maintian Ability in a job that will never change.

Jack


----- Original Message -----
From: "Bibhu C"
To:
Sent: Sunday, August 12, 2001 5:07 PM
Subject: Re: AD: datastage performance


> Ray,
>
> So these performance related documents dont normally
> come with the DataStage literature ?
>
> Thanks
> Bibhu
> --- Ray Wurlod wrote:
> > There is a whole section called "Designing and
> > Performance" in the "Advanced
> > DataStage" class offered in the Asia-Pacific region.
> > Note that this is NOT
> > the same class as DS305 offered in the USA.
> >
> > -----Original Message-----
> > From: Bibhu C [mailto:bibhuds@yahoo.com]
> > Sent: Saturday, 11 August 2001 02:55
> > To: datastage-users@oliver.com
> > Subject: datastage performance
> >
> >
> > Hi All,
> >
> > Even when I am in the design phase of my ETL jobs, I
> > was curious to know about the ways to improve
> > performance of DataStage jobs. I understand that use
> > of hash files is one of ways, but the manuals are
> > really tightlipped about them and any other paths
> > that
> > one would want to tread to improve load performance.
> >
> > I am looking to the knowledgeable group to tell me
> > about the various performance enhancing strategies
> > in
> > DataStage, also tell me if I have missed something
> > in
> > the manuals.
> >
> > Thanks
> > Bibhu
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> > with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/

Posted: Mon Aug 13, 2001 12:58 am
by admin
No, theyre part of the Education curriculum.

Ray

-----Original Message-----
From: Bibhu C [mailto:bibhuds@yahoo.com]
Sent: Sunday, 12 August 2001 17:37
To: datastage-users@oliver.com
Subject: Re: AD: datastage performance


Ray,

So these performance related documents dont normally
come with the DataStage literature ?

Thanks
Bibhu
--- Ray Wurlod wrote:
> There is a whole section called "Designing and
> Performance" in the "Advanced
> DataStage" class offered in the Asia-Pacific region.
> Note that this is NOT
> the same class as DS305 offered in the USA.
>
> -----Original Message-----
> From: Bibhu C [mailto:bibhuds@yahoo.com]
> Sent: Saturday, 11 August 2001 02:55
> To: datastage-users@oliver.com
> Subject: datastage performance
>
>
> Hi All,
>
> Even when I am in the design phase of my ETL jobs, I
> was curious to know about the ways to improve
> performance of DataStage jobs. I understand that use
> of hash files is one of ways, but the manuals are
> really tightlipped about them and any other paths
> that
> one would want to tread to improve load performance.
>
> I am looking to the knowledgeable group to tell me
> about the various performance enhancing strategies
> in
> DataStage, also tell me if I have missed something
> in
> the manuals.
>
> Thanks
> Bibhu
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
>


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

Posted: Tue Aug 14, 2001 6:04 pm
by admin
Ray is absolutely right..I use Rays material (Advanced DataStage) as part
of my lectures very often (Thanks Ray).

We might be offering similar courses in the very near future here in US.

Pavan Marpaka
Datawarehouse Trainer
Education Services
Ascential Software Inc.
804-677-3346 (Cell)



----Original Message Follows----
From: "Ray Wurlod"
Reply-To:
To:
Subject: RE: AD: datastage performance
Date: Mon, 13 Aug 2001 10:58:58 +1000

No, theyre part of the Education curriculum.

Ray

-----Original Message-----
From: Bibhu C [mailto:bibhuds@yahoo.com]
Sent: Sunday, 12 August 2001 17:37
To: datastage-users@oliver.com
Subject: Re: AD: datastage performance


Ray,

So these performance related documents dont normally
come with the DataStage literature ?

Thanks
Bibhu
--- Ray Wurlod wrote:
> There is a whole section called "Designing and
> Performance" in the "Advanced
> DataStage" class offered in the Asia-Pacific region.
> Note that this is NOT
> the same class as DS305 offered in the USA.
>
> -----Original Message-----
> From: Bibhu C [mailto:bibhuds@yahoo.com]
> Sent: Saturday, 11 August 2001 02:55
> To: datastage-users@oliver.com
> Subject: datastage performance
>
>
> Hi All,
>
> Even when I am in the design phase of my ETL jobs, I
> was curious to know about the ways to improve
> performance of DataStage jobs. I understand that use
> of hash files is one of ways, but the manuals are
> really tightlipped about them and any other paths
> that
> one would want to tread to improve load performance.
>
> I am looking to the knowledgeable group to tell me
> about the various performance enhancing strategies
> in
> DataStage, also tell me if I have missed something
> in
> the manuals.
>
> Thanks
> Bibhu
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
>


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp