Search found 42189 matches

by chulett
Mon Jul 20, 2009 6:38 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: shared memory file is wrong size
Replies: 3
Views: 3632

Moderator, please move to the Parallel forum.

Or the General forum... at least out of this one. :wink:
by chulett
Mon Jul 20, 2009 6:36 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: shared memory file is wrong size
Replies: 3
Views: 3632

Re: shared memory file is wrong size

I have created a Parallel Job that executes a Server Shared Container (ie which is a server job). I am running it in a loop with a sleep of 10 seconds. Why not use a Sequence job with the Start/End Loop stages? Seems like it would be a more appropriate way to loop around a job. Server Shared Contai...
by chulett
Mon Jul 20, 2009 6:33 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: We need the purpose of the file DSD.RUN_*
Replies: 5
Views: 3337

4. Corrected my typo of "once associated the" to "once the associated".
by chulett
Mon Jul 20, 2009 6:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Functionality
Replies: 11
Views: 3712

'Dynamic' is fine as long as you know or can define a maximum number of columns to pivot - can you?
by chulett
Mon Jul 20, 2009 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle EE Stage: SQL Loader Error
Replies: 2
Views: 1700

Any other error messages logged? Does the connected user have the grants needed to disable constraints and rebuild indexes?
by chulett
Mon Jul 20, 2009 6:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DATETIME/INTERVAL datatype conversion error
Replies: 3
Views: 2217

There's really no need to start another topic on the same subject. :?

Of course 8.1 supports DATE data types, bulk loader or otherwise.
by chulett
Mon Jul 20, 2009 6:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date format not supported
Replies: 11
Views: 3708

I've already given you the answer, not sure why you'd choose to ignore that. That is not the format I suggested you use, hence your error. :?
by chulett
Mon Jul 20, 2009 6:12 am
Forum: General
Topic: Version control and documentation of DS
Replies: 4
Views: 1199

Version Control is free and installed separately on your PC from the Client CDROM. It is fully documented and is used to manage versions and migrate objects from project to project. There is no "check in / check out" but rather "Initialize" to capture a version and "Promote...
by chulett
Mon Jul 20, 2009 6:08 am
Forum: General
Topic: how to Run DSjobs on command prompt on Unix machine
Replies: 7
Views: 5927

Re: how to Run DSjobs on command propmt and Unix machine

ragasambath wrote:dsjob -run -jobstatus -wait [ -param Parametername=value] $PROJECT $DSJOB
:!: You should use one or the other (or neither) of the "wait" options but not both.
by chulett
Mon Jul 20, 2009 6:05 am
Forum: General
Topic: how to Run DSjobs on command prompt on Unix machine
Replies: 7
Views: 5927

"Didn't work out"? Come on. :? Yes, dsjob is the right command and the job's folder doesn't matter. Type the command by itself to get a usage statement. Read the Command Line Interface chapter in either Developer's Guide pdf or search here for all the details. After you've checked your syn...
by chulett
Sun Jul 19, 2009 10:17 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: We need the purpose of the file DSD.RUN_*
Replies: 5
Views: 3337

The information in that %PH% "Phantom" directory isn't really needed once the associated job completes so feel free to purge them on a regular basis - typically once a day for any over X days old where X can be any number you are comfortable with: 2, 5, etc.
by chulett
Sun Jul 19, 2009 2:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SCD type 2 in server jobs in DS 7.1....Need help
Replies: 3
Views: 2428

Sort by pol no and original seq no, then use stage variables to assign the new seq nos: new pol = 1, not new pol = previous seq + 1. Stage variable Derivation Initial value svNewPol Link.PolNo <> svOldPol @FALSE svSeqNo If svNewPol Then 1 Else svSeqNo + 1 0 svOldPol Link.PolNo 0
by chulett
Sun Jul 19, 2009 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset stage: Input-file data set does not exist
Replies: 8
Views: 11035

All you really did is repeat yourself, which is not all that helpful. :? How exactly does this 'scheduler' run 'one after another'? Without more specifics I'm guessing that at some point one or the other starts taking more than an hour and you get some kind of 'overlap' where they run out of sequence.
by chulett
Sat Jul 18, 2009 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fault Type 11
Replies: 18
Views: 6517

I got 36 matches when I searched for "Fault type is 11. Layer type is BASIC run machine." - did none of them help you out at all? :?
by chulett
Sat Jul 18, 2009 7:40 am
Forum: IBM QualityStage
Topic: Connection problem in Datastage administration
Replies: 4
Views: 4122

:!: First off, this has nothing to do with Quality Stage so we're in the wrong forum. Secondly, this issue of "ports" has been discussed here before so try searching for pieces of your message - for example "A bootstrap address with no port specification defaults to port 2809" - ...