Search found 42189 matches

by chulett
Tue Aug 03, 2010 4:18 pm
Forum: General
Topic: Date Formatting in Job Sequencer
Replies: 4
Views: 4541

And Sequence jobs are discussed in the General forum, being job type agnostic. :wink:
by chulett
Tue Aug 03, 2010 1:23 pm
Forum: General
Topic: Too much space in DB XMETA db2
Replies: 20
Views: 11246

So... do we have a resolution now?
by chulett
Tue Aug 03, 2010 1:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tricky job
Replies: 10
Views: 3159

Then look at the various dsjob options as noted, for example -ljobs to get a list of jobs then loop thru them and issue a -jobinfo for each one.
by chulett
Tue Aug 03, 2010 1:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracler stages not working after upgrade to 8.1
Replies: 9
Views: 4293

I have no clue, perhaps others might. Seems to me you are rapidly sliding into Official Support Provider time, if you haven't already contacted them.
by chulett
Tue Aug 03, 2010 1:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tricky job
Replies: 10
Views: 3159

You need to build a job to do this or can you do something from the command line? I ask because you can script this using dsjob which can be simpler for people if they haven't done much work with the DSGet* API functions and BASIC.
by chulett
Tue Aug 03, 2010 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sql from file in DB2/UDB API
Replies: 10
Views: 5078

True... in the intervening years we've figured that out but haven't gone back and tried to back-fill things. Thanks for that. :wink:
by chulett
Tue Aug 03, 2010 9:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WARNING: DataStage has found more CPU's on your system (27)
Replies: 6
Views: 2035

OK... I'll spell it out for you.

1. License the number of CPUs you have on your server
2. Decrease the number of CPUs on your server to your license limit
3. Live with having that warning in every job run
by chulett
Tue Aug 03, 2010 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WARNING: DataStage has found more CPU's on your system (27)
Replies: 6
Views: 2035

Then you've got a problem. You are licensed for X CPUs and have >X on the DataStage server. I'm sure you can figure out what your options are here, yes? :?
by chulett
Tue Aug 03, 2010 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to trim the data -loading into db2 bulk load stage
Replies: 11
Views: 5076

Check and see if your field is indeed being padded with that character, in Oracle I would use the dump() function, hopefully there is some kind of DB2 equivalent.
by chulett
Tue Aug 03, 2010 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WARNING: DataStage has found more CPU's on your system (27)
Replies: 6
Views: 2035

I would start here - "Please contact Ascential Client Support or your Ascential Account Manager". Not sure what the proper answer would be in a grid environment but I'm sure there's some way to handle this.
by chulett
Tue Aug 03, 2010 6:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inactive sessions
Replies: 3
Views: 2430

I'm assuming the "deadlock daemon" is still around in this version, it is something that would periodically clear things of that nature for you. Search here for the details on enabling / configuring it.
by chulett
Tue Aug 03, 2010 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selecting Max(date) column with multiple rows
Replies: 19
Views: 13840

An exact search for "It is not legal to set a reducer" should answer your question.
by chulett
Tue Aug 03, 2010 6:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tranformer stage proframance is not good.
Replies: 4
Views: 1518

Fixed your... rather strange quoting of yourself for you. :?
by chulett
Tue Aug 03, 2010 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to trim the data -loading into db2 bulk load stage
Replies: 11
Views: 5076

Perhaps the API stage is padding with something other than spaces? As noted, it cannot behave as if it were a varchar so something must be there... what is your PADCHAR?