DSXchange

Thanks Ray.

Any idea if a concurrent user license would work instead of Authorized per user license. because we have LDAP-PAM AIX environment. so in that case we can buy 5 user license for developers to share & compile parallel jobs

I am in process of installing DataStage 8.5 on AIX and would like to know licensing details about the compiler IBM documentation says it requires the IBM XL C/C++ Enterprise Edition compiler so if i have 10 concurrent users license do i have to license the compiler for 10 users or is the license par...

BUMP..!!! anyone who has similar Reset job warnings/error on different OS the issue is high priority for DS setup because we are in production with DS85 and production projects are "Protected" . when the project is protected you lose the ability to compile jobs and Reset is only option. An...

i have a similar problem with a migrate 7.5 job to 8.5; the file is tab delimited but when its ftp'ed the header row has tab escape character while the data rows are tab delimited. so did you have something similar i have opened a case with IBM will update before FTP PMI_NO BIRTH_DATE REFERRAL_CODE ...

we are migrating projects/jobs from DS 7.5 to DS8.5 on AIX 6.1 OS platform and we see a different behaviour that all jobs which reset just fine in DS7.5 now get an "Abnormal termination of stage JobName..xfmCopyMbd detected" in DataStage 8.5 The warning goes for all jobs; does not matter i...

I was unable build packages with Information Server manager; thanks to this post i was able to refer the above patch number while talking to Ibm customer service. The patch has been superceded again with patch_JR35301 the readme says REPLACES: JR31444, JR32836, JR31651, JR32840, JR34192, JR34319, JR...

I am having trouble getting ldap to work. my environment is Engine layer - AIX box 1 Logical layer (WAS server) - AIX box 2 MetaData Repository (oracle) - AIX box 3 during installation of engine and WAS i explicitly mention the oracle db and is properly configured. after installation i could test ra...

It happens to me every day. In fact, my first reponse to this went to the login screen. I reported this to Walter in December, but the issue is still unresolved. I haven't had a lot of time to follow up on it.

Stephen

I didn't receive an email notification from an issue I'm monitoring.

Was a cause ever found? We had the same thing happen in a job that has been running for a couple of years without any issue. We are running on AIX with DataStage server version 7.5.1 In the last run, it had an issue in which Inrownum was the same for 2 consecutive records. Seq --> Transformer --> Or...

Look for control characcters or hidden characters. I had this happen and was told the column causing the error was empty. When looking at the column at the source in hex, we found that there were 10 nulls stored in the column and that was causing the error.

All you would need to do is create a output link to a sequential file, set up the constraints appropriately and put the stage variables in the derivation for the appropriate columns in your file.

Also, the formulas can be stored in columns as varchars.

We have been able to increase performance by changing our initial select to have a where clause to loop through partition keys (PARTITION_KEY = #Counter#) and we disable indexes.

The reason you are getting a message in Director is that you checked the reject row box in the constraints. This will generate a warning message if any rejects are encountered.

The on-line documentation is is very helpful for how to use the various functions and possible alternatives to do similar tasks.

It is one of the first pieces I show newbies when they are learning how to use the tool.

Stephen