Search found 42189 matches

by chulett
Fri Feb 19, 2010 9:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: License Agreement
Replies: 5
Views: 1476

OK. Of course I didn't mean person when I said people like it somehow knew who you were, that's a different kind of license - a named license rather than a concurrent one. Here the userid doesn't matter. :wink: And from what I recall, yes, up to 10 client connections from the same IP address are con...
by chulett
Fri Feb 19, 2010 8:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Common routine among projects
Replies: 4
Views: 2089

You have to 'duplicate the code'. Treat one project as the 'master' project and promote the common routine everywhere else (read only) that it needs to be used.
by chulett
Fri Feb 19, 2010 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dscmdexport - is not exporting job and the job executables
Replies: 4
Views: 2768

That's odd. I would assume that your repository indexes for the Project in question are corrupted. In your shoes I would try a DS.REINDEX ALL but first make sure you search for the here and understand all of its caveats. Biggest of which is which no / none / nada / zero processes can exist in the pr...
by chulett
Fri Feb 19, 2010 8:43 am
Forum: General
Topic: OCI-04030: out of process memory
Replies: 7
Views: 4685

It's an operating system process memory issue from the OCI (client) software rather than the database itself. What exactly are you doing in this job? Giant array sizes? CLOB fields? Details, please.
by chulett
Fri Feb 19, 2010 8:39 am
Forum: General
Topic: Adding PX to Server DataStage
Replies: 6
Views: 2926

You were doing fine right up until this point: "The server jobs will perform much more better than, what they were previously due to the addition of PX edition license." No. As you noted, at a high level Server jobs will be unaffected. Now, if you start running a crap-load of PX jobs on th...
by chulett
Fri Feb 19, 2010 8:33 am
Forum: General
Topic: Send the mail from After-Job-Subroutine using DSSendMail
Replies: 4
Views: 2123

Open up the DSSendMailTester routine and use that code. Check the INTERIMSTATUS there to see if the job is going to abort or not.
by chulett
Thu Feb 18, 2010 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target XML file not Creating after Successful Job
Replies: 4
Views: 2398

No, nothing special. However, if all you put for the output file was "output.xml" then that being a relative path would put the file in the job's Project. Did you look for it there?
by chulett
Thu Feb 18, 2010 11:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: License Agreement
Replies: 5
Views: 1476

It is a concurrent license, so it controls how many people can connect at the same time.
by chulett
Thu Feb 18, 2010 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target XML file not Creating after Successful Job
Replies: 1
Views: 914

Sorry to do this on your first post but you've put it in the completely wrong forum. :( This one is for testimonials rather than problems, there are two (well, three) dedicated to problems based on job type - Server or Parallel - plus a General one for stuff that doesn't fit in one or the other. Ple...
by chulett
Thu Feb 18, 2010 5:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error loading special chars using oracle enterprise stage
Replies: 3
Views: 1293

Meaning you need to know the character set of your source and you need to know the characterset of your target and handle any mapping issues appropriately.
by chulett
Thu Feb 18, 2010 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Encrypt DB Password using Oracle Wallet
Replies: 5
Views: 2354

Hmmm... true. There is a place for DB Options in the Connection category: DB Options Specify a user name and password for connecting to Oracle in the form: <user=< user >,password=< password >[,arraysize= < num_records >] Is that where you're trying to leverage the Wallet connectivity?
by chulett
Thu Feb 18, 2010 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence hanging
Replies: 17
Views: 5204

I was just being snarky about the "check" since it's a fairly trivial thing to add. :wink: Without knowing exactly what your script is doing, it's not really possible to say this with authority but in general - no, an attempt to run an already running job of any kind should just generate a...
by chulett
Thu Feb 18, 2010 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle enterprise
Replies: 5
Views: 1154

If you have the client, you should have the manuals as well. They install on your PC as pdf documents.
by chulett
Thu Feb 18, 2010 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem importing XML Table defs...
Replies: 12
Views: 4685

I didn't realize there were tools out there that would do this, here I thought I was the tool. So to speak. :wink:

Any that you would recommend, Ernie?
by chulett
Thu Feb 18, 2010 11:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dscmdexport - is not exporting job and the job executables
Replies: 4
Views: 2768

Silly question, perhaps, but have you actually opened up the .dsx file (it is just a plain text file) and confirmed exactly what is and is not in there?