Search found 53125 matches

by ray.wurlod
Tue Jun 28, 2011 1:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key Generator questions
Replies: 41
Views: 8392

Of course it's possible to be contiguous. You could run just a single partition. Beyond that you can not guarantee contiguity unless you can also guarantee precisely that there are precisely the same number of rows in every partition. And even then, the Surrogate Key Generator stage is not really th...
by ray.wurlod
Tue Jun 28, 2011 12:59 am
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 10931

So it's clear that uv -admin -info is not able to contact the dsrpcd service through the ipcs mechanism, apparently due to a file being missing from the /unix directory. Therefore the command reports that DataStage is not running. It's now time to take that evidence to your official support provider...
by ray.wurlod
Tue Jun 28, 2011 12:55 am
Forum: General
Topic: Datastage authentication
Replies: 1
Views: 2371

Welcome aboard. "Account" is the same as "project". You are apparently supplying an invalid project name (they are case sensitive) or the client in question can access the domain machine but not the engine machine. Check your client's hosts file (%WINNT_ROOT%\System32\drivers\etc...
by ray.wurlod
Tue Jun 28, 2011 12:53 am
Forum: General
Topic: schedule DSEngine restart using CRON
Replies: 3
Views: 1459

Get yourself a discipline management device, such as a baseball bat.
by ray.wurlod
Tue Jun 28, 2011 12:52 am
Forum: IBM QualityStage
Topic: Issue in name splliting using default usname rule set
Replies: 4
Views: 2043

Good. I wondered about that, but the site where I'm working does not have QualityStage.
by ray.wurlod
Mon Jun 27, 2011 9:27 pm
Forum: General
Topic: schedule DSEngine restart using CRON
Replies: 3
Views: 1459

The obvious question to ask is why?

That said there are only three steps you need to script:
(1) check that no DataStage processes are running or clients connected
(2) stop the engine then wait for a short interval (maybe 2 minutes)
(3) start the engine
by ray.wurlod
Mon Jun 27, 2011 9:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle CASE statement in Datastage
Replies: 23
Views: 16807

You can use a BASIC Transformer stage in a parallel job. To determine whether the value in InLink.code is in a particular range you can use Oconv(InLink.code, "R700,709;800,849;860,867;870,876;880,899") This will return the original value if code falls in any of those ranges, or "&quo...
by ray.wurlod
Mon Jun 27, 2011 9:01 pm
Forum: General
Topic: DS Server is running but showing Not Running.
Replies: 31
Views: 10931

I suspect thje problem is highlighted by the "ipcs: 0515-001 No valid name list found in /unix. " messages - the uv -admin -info command is unable to communicate with the processes.

Can you please execute the following command?

Code: Select all

ipcs -m | grep ade
by ray.wurlod
Mon Jun 27, 2011 5:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle CASE statement in Datastage
Replies: 23
Views: 16807

What are the data types? What are the data volumes? There's a really elegant solution using "R" conversion in Oconv(), but you would need to use a BASIC Transformer stage or server job to take advantage of this. Otherwise (if you can't or won't use a BASIC Transformer stage or server job),...
by ray.wurlod
Mon Jun 27, 2011 3:26 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Looking for field holding the value for BENCHMARK
Replies: 4
Views: 1719

You can perform the same hacks that they performed.
by ray.wurlod
Mon Jun 27, 2011 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can DataStage connect to a J2EE Engine?
Replies: 9
Views: 2887

Do you have the Java PACK ?
by ray.wurlod
Mon Jun 27, 2011 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: VARCHAR data load Vs NVARCHAR data load using DataStage 8.0
Replies: 4
Views: 3078

Please expand on what you mean by "Europe and Asia Pacific language character set".
by ray.wurlod
Mon Jun 27, 2011 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to know the user name who has updated/develped the job
Replies: 8
Views: 13270

Why " - 8 HOURS " ?

And why 15 months after the question was posed?
by ray.wurlod
Mon Jun 27, 2011 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key issue
Replies: 2
Views: 1518

Keys are allocated in blocks. If not all keys in a block are used (due to slight variations in the number of rows per partition) they are discarded.

That DOES NOT MATTER. Surrogate keys provide only uniqueness. They are not - and should not be - guaranteed to be contiguous.
by ray.wurlod
Mon Jun 27, 2011 3:14 pm
Forum: General
Topic: DS 7.5 and 8.1 on same server.
Replies: 10
Views: 3293

I recall (whether accurately or not) that there are scripts with 7.5 for changing the itag without needing to reinstall. Check the scripts directory within DSEngine.