DSXchange

I agree with Ray. " Why reinvent the Wheel"

What I understand is that IBM does not support or the License does not allow us to do that way. So before I ask IBM I want to know if that is true. Hope that is called as sub capacity(Correct me if I am wrong).

I am surprised. When I get that error the job does not even compile. what all Stages does that job have?

Does IBM support Sub capacity on the same Server. I don't know if that makes sense to you. Let me elaborate. As of now we have Engine Tier and Services Tier installed on the same Machine (AIX) Now we have upgraded our Engine tier (got License for 4 core from 2 core), to 4 core, Service tier still is...

Hi,

1) Force compile your job
2) If that doesn't work, save the job with a different name and compile.

You said output you see junk values what is the data type of the output field you have used?

I hope you are converting a Char to a VarChar
Secondly the Value coming from the COBOL is not 20 bits long?

Before I can answer you question I would like to know the source of your data.

Is that impacting your program? To get rid of it use, proper partitions.
Within the Join Stage go to Advance and set the proper Partition or clear it.

Populate Default values (Ask your Business) like Spaces or Default Dates. Which ever are applicable?

The error message says

"Assignment of a NULL value to a NOT NULL column "

So that is your clue...

Do we have any documentation on how to go about that. Installing Services on Windows and Engine on AIX?

I have been looking in IBM's Website didn't find any.

ps: Sorry about that. Yes it is Tier

[*Note - DataStage is also one word. Corrected both - Andy*]

Hi,

Currently we are running DataStage on a 2 tier Arch.

We now want to move onto 3 tier Architecture.

Can I install DataStage engine on AIX and Services on Window Operating System box?

This is the log <AF[74]: Allocation Failure. need 32784 bytes, 16403 ms since last AF> <AF[74]: managing allocation failure, action=2 (75621192/492042752)> <GC(1222): GC cycle started Fri Jun 4 13:56:14 2010 <GC(1222): freed 111180408 bytes, 37% free (186801600/492042752), in 787 ms> <GC(1222): mark...

I am getting the same error. Can you give me an Idea of where you found that Error message or how did you find that is the cause?

I assume that you have just like

Read Oracle -> Load Oracle.

Can you provide with your Job design.
That should help us give some Idea of what is going wrong.