Search found 53125 matches

by ray.wurlod
Thu Jul 17, 2008 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TCL WHO command points to different Project
Replies: 8
Views: 3140

Do the two VERIFY.SQL using the pathname and the FIX option and, if necessary, add entries to UV.ACCOUNT to describe any project that is not described there. After that you should have two projects. Then you can use both, or delete one from Administrator client. As usual, take a backup (a UNIX copy)...
by ray.wurlod
Thu Jul 17, 2008 5:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML O/p formatting issue
Replies: 15
Views: 3857

As has so often been explained, we at DSXchange simply don't do "urgent". If it is urgent, as you say, sign up for premium service with your support provider, and learn how expensive "urgent" is. DSXchange is a community of volunteers who post as and when they can, and then only if they have someth...
by ray.wurlod
Thu Jul 17, 2008 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_loadlibrary: error in dlopen
Replies: 1
Views: 1976

Search the forum, you are far from the first to encounter this error. Posting the exact and complete error message would have been useful as well.
by ray.wurlod
Wed Jul 16, 2008 11:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS: junk character removal
Replies: 3
Views: 1631

Premium membership is not expensive, less than 30c (less than Rs12) per day. It is one of the ways that the hosting and bandwidth expenses of DSXchange are funded. I do not intend to create a precedent that would prejudice that funding. Therefore my answer to your latest request must be "no".
by ray.wurlod
Wed Jul 16, 2008 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TCL WHO command points to different Project
Replies: 8
Views: 3140

From that, I deduce that "someone" made an operating system copy of the project, hence the "duplicate schema" reference. I presume that, when you try to delete the obsolete project, that you get an error. Is that the case? If so, what is that error? I think that this is a recoverable situation, thou...
by ray.wurlod
Wed Jul 16, 2008 10:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error running a job through dsjob command in UNIX
Replies: 4
Views: 2441

You have NOT sourced the dsenv file.

If you had, that line in your script would read

Code: Select all

source ${DSHOME}/dsenv
or

Code: Select all

. ${DSHOME}/dsenv
by ray.wurlod
Wed Jul 16, 2008 7:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look Up failure
Replies: 8
Views: 4015

More useful would be to post (or even just to examine) that part of the generated OSH relating to the lookup stage and its inputs and output record schemata.
by ray.wurlod
Wed Jul 16, 2008 7:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between DS 6.0,7.0 and 7.5.2
Replies: 3
Views: 1776

I don't suppose you'd consider "lots" to be an adequate answer? How about 1.0 and 1.5.2 ? Seriously, though, there is a "what's new in this release" that comes out with each release. You should have one for your current release somewhere at your site. For earlier versions you may have some luck traw...
by ray.wurlod
Wed Jul 16, 2008 7:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TCL WHO command points to different Project
Replies: 8
Views: 3140

Before you go any farther, try VERIFY.SQL specifying the pathname of the schema, rather than its name. For example

Code: Select all

VERIFY.SQL SCHEMA /appl/xxxxxx/Ascential/DataStage/DSEngine/projects/MB_WHRCS89_90_DEV 

Code: Select all

VERIFY.SQL SCHEMA /appl/xxxxxx/Ascential/DataStage/DSEngine/projects/WHRCS89_90_DEV 
by ray.wurlod
Wed Jul 16, 2008 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Masking using parallel jobs
Replies: 11
Views: 8369

Others also have data obfuscation routines available. But is that what you mean by "masking"?
by ray.wurlod
Wed Jul 16, 2008 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration File Help
Replies: 5
Views: 1208

That's a feasible configuration file for a four CPU machine, but note that processing nodes are not related to CPUs. For example if monitoring indicates that no CPU is exercised to more than 50% of its capacity, then an eight node configuration file would be just as feasible. For smaller jobs you mi...
by ray.wurlod
Wed Jul 16, 2008 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA error
Replies: 3
Views: 1281

Craig means, of course, that your DBA can tell you, not that your DBA is the cause of the problem!
by ray.wurlod
Wed Jul 16, 2008 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD Stage
Replies: 1
Views: 766

I suspect you've uncovered a bug in the client. Involve your support provider.
by ray.wurlod
Wed Jul 16, 2008 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Masking using parallel jobs
Replies: 11
Views: 8369

Welcome aboard.

Can you be more specific about what you mean by "masking"?