Search found 42189 matches

by chulett
Fri Sep 01, 2006 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List of JobNames from a Sequnce
Replies: 11
Views: 4286

Those live in the $DSHOME/bin directory, so it either needs to be in your PATH or you'll need to prefix 'uvsh' or 'dssh' with it.
by chulett
Thu Aug 31, 2006 5:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Failing
Replies: 4
Views: 1231

A continuation of this conversation I assume, yes?
by chulett
Thu Aug 31, 2006 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ArraySize and Transaction Size
Replies: 16
Views: 4209

There are way too many variables for anyone to just give you numbers. For array size, play around, run some tests. There is a point of diminishing returns for it... processing speed will increase and then eventually slow back down again as that number goes up. You need to find that sweet spot for ea...
by chulett
Thu Aug 31, 2006 5:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashfile corrupted
Replies: 7
Views: 1213

Rebuild them.
by chulett
Thu Aug 31, 2006 4:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ArraySize and Transaction Size
Replies: 16
Views: 4209

There's no rule for how they 'need' to be set, it's up to you and how you want them set. Array Size controls how many records at a time are written to the database and Transaction Size controls how many records are commited at a time. IMO, TS should be a multiple of AS but other than that...
by chulett
Thu Aug 31, 2006 12:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: corntab scheduling
Replies: 6
Views: 1195

From an ETL perspective you don't really need to know exactly what 'cron' is doing behind the scenes. The Director client tool shields you from all that and automatically interfaces with cron and builds the appropriate crontab entries for you. If you click on Help from the Director toolbar, you'll f...
by chulett
Thu Aug 31, 2006 12:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: corntab scheduling
Replies: 6
Views: 1195

What kind of information, specifically? And 'crontab' is the table that drives 'cron' which is the actual UNIX scheduler... no corn involved. :wink:
by chulett
Thu Aug 31, 2006 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing to unix file from datastage sequence
Replies: 2
Views: 1271

Welcome. :D While both of these can be done, they aren't easily explained in a sentence or two. Rather than reading a list of emails from a file, why not create a 'group' in your email system and use that in the Notification Activity stage instead? That's the way many people tackle this problem, mys...
by chulett
Thu Aug 31, 2006 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Aggregation problem
Replies: 13
Views: 2963

My advice was on how to use the Aggregator stage so it's not a bottleneck in the job and won't fall over dead working a large volume of data. My point was to keep it in mind when the work isn't possible 'up front'. There will be times when you do what you can in the database, then need to do additio...
by chulett
Thu Aug 31, 2006 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml metadata importer tool
Replies: 6
Views: 4528

Why don't you take a step back and tell us what the ultimate goal of all these xml questions you've been asking lately... what in the heck are you trying to accomplish? If the whole point is to drive cetain kinds of changes, like the precision change noted above, why not just do what most people wou...
by chulett
Wed Aug 30, 2006 9:08 pm
Forum: Site/Forum
Topic: Pity you didn't go with DSExchange
Replies: 2
Views: 3053

:lol:

Saw that list earlier... funny stuff.
by chulett
Wed Aug 30, 2006 8:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort the Sequence as soon as job logs 1 warning
Replies: 24
Views: 4753

And saying 'per user' is a little bit of a misnomer - it would have been more proper for me to say per installation of the Director.
by chulett
Wed Aug 30, 2006 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hours to time
Replies: 16
Views: 5771

paddu wrote:I tried exactly what is gave and it works
out_BURT_TOT.DATEFROM[1,4]:"-":out_BURT_TOT.DATEFROM[5,2]:"-":out_BURT_TOT.DATEFROM[7,2] : " " : out_BURT_TOT.ABIC_ZSTARTIME[1,2]:":":out_BURT_TOT.ABIC_ZSTARTIME[3,2]:":":out_BURT_TOT.ABIC_ZSTARTIME[5,2]

So you're fine now, yes?
by chulett
Wed Aug 30, 2006 12:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I process files from a directory with a pattern
Replies: 9
Views: 3072

Yikes... why not simplify your life and 'cd' into the directory before issuing the list command? Stack the commands up like this: cd /xxx/xxx && ls -1 PBRCT* The two ampersands are similar to using a semi-colon to run the two commands one after the other, but the second is only executed if t...
by chulett
Wed Aug 30, 2006 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort the Sequence as soon as job logs 1 warning
Replies: 24
Views: 4753

No such beastie or I would have mentioned it.