Search found 15603 matches

by ArndW
Sun Jul 06, 2008 5:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while compiling the job
Replies: 15
Views: 9399

If you open up the transform in the designer are the links red? The error messages regarding "DSLink18" would tend to indicate a naming error.
by ArndW
Fri Jul 04, 2008 3:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle native stage is taking more time to retrieve Data
Replies: 1
Views: 742

TOAD and SQLPLUS do not return all the data immediately, so this time comparison is probably not valid.
by ArndW
Fri Jul 04, 2008 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What does it get better performance? Filter or transformer?
Replies: 7
Views: 3569

I would test this empirically before taking the documentation's word for it.
by ArndW
Fri Jul 04, 2008 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg- JOb design
Replies: 2
Views: 804

V.J., didn't you post the same question in this thread ? The way the question is phrased makes it look just like a test question or an interview question; neither of which are particularly liked on this site. If this question is neither, then it would be worth discussing locking and concurrency, as ...
by ArndW
Fri Jul 04, 2008 12:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to connect client but console ok
Replies: 7
Views: 2660

That sounds like a real bug in the client. Apart from talking to support, can't putty redirect ports, changing a call to 9080 to 59080? I can't check right now, but seem to recall it does off that functionality.
by ArndW
Thu Jul 03, 2008 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Required - Regarding Configuration File
Replies: 11
Views: 3157

DSDexter wrote:Andrw,
All environments are isolated and lie on different servers.
In that case the one machine has less swap space than the others and that is causing your virtual memory issues.
by ArndW
Thu Jul 03, 2008 11:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About Section Leaders
Replies: 4
Views: 2833

5Mb score is pretty large. Is this a big DS Job and is the machine a small one?
by ArndW
Thu Jul 03, 2008 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IS8 Director Run-time error '429'
Replies: 6
Views: 7197

Can you try switching versions with the MCM back and forth one time to see if that might initialize a library.
by ArndW
Thu Jul 03, 2008 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Required - Regarding Configuration File
Replies: 11
Views: 3157

Are all 3 environments on the same machine? Solaris is odd in that it preallocates swap space when memory is allocated.
by ArndW
Thu Jul 03, 2008 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Viewing Datasets
Replies: 6
Views: 2092

DataSets are DataStage objects stored on disk, not in any database.
by ArndW
Wed Jul 02, 2008 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ; queue depth check via DS job
Replies: 3
Views: 2831

You can't do it from the MQ stage. If you have been granted the MQ rights, you can execute the appropriate "runmqsc" UNIX command sequence to return the queue depth to your calling sequence and branch accordingly.
by ArndW
Wed Jul 02, 2008 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Making ReadOnly Jobs NON-ReadOnly In V8
Replies: 5
Views: 6414

Changing the .dsx attributes globally ought to do the trick. With V8 you don't have a choice - the metadata goes into an SQL Compliant database of your choice (as long as you choose DB2 or Oracle).
by ArndW
Wed Jul 02, 2008 6:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Age calculation from Date Of Birth
Replies: 6
Views: 2141

The simplest way is to extract the YYYY portion from the birthdate string and subtract it from the numeric YYYY current year value. But is this acceptable according to your business rules? Does the current month/day make a difference?
by ArndW
Wed Jul 02, 2008 5:12 am
Forum: General
Topic: conversion of string to timestamp with microseconds
Replies: 1
Views: 3710

The target column attribute "Extended" for milliseconds needs to be enabled.
by ArndW
Wed Jul 02, 2008 5:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Big file process with Aggregator stage - New big problem !
Replies: 12
Views: 4548

In the aggregator, did you specify the "sort" and "sort order" for any of your columns? If you didn't then the Aggregator stage has no way of knowing that the data is sorted and it doesn't have to store the data in memory for group changes.