AD: datastage performance
AD: datastage performance
This is a topic for an orphaned message.
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/
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/
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/
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/
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/
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/
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
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