DSXchange

Hi Julio,

Were you able to migrate the metadata repository from DB2 to Oracle? Would you kindly let us know how you did the migration as we're planning to do a similar task.

Thank you.

Not sure about 8.0.1; the only thing IBM confirmed was that "it's still a 32bit implementation, operated on 64bit platform".

We had to call support to get this information.

No it is not; neither is 8.1. From what we heard, 8.1 will be supported in March this year.

We have linkxlC on AIX5.3. We installed Information Server - DataStage 8.0.1. The compiler environment variables were set to: APT_COMPILER = /usr/vacapp/bin/xlC_r APT_COMPILE_OPTIONS = -O -m APT_LINKER = /usr/vacapp/bin/xlC_r APT_LINKER_OPTIONS = -G The job with the transformer did not compile thoug...

Thanks Ernie for the reply. This is an EE job (7.5x2) with QualityStage plugin, transformations and 2 DB2 lookups. Even if the extra instances never receive rows, shouldn't there be logs like "Starting job ...." and so on. There was nothing in the log though; they were empty for those orph...

The minimum instance is 4. Prior to this, we had the minimum set to 1 but at that setting, the client application receives time out and no new job instance was ever created. We felt that the only way to get around the "failure to spawn new instances" was to set the minimum to more than 1. ...

We have an RTI job that is "Always On" that runs on a minimum of 4 instances, maximum of 10. The job design is RTI Input -----> Stages --------> RTI Output Service requests as of now is very low, up to 2500 per day on small bursts every 5 minutes. The problem we have now is, there are job ...

I tried using Handle_Null as above but it doesn't work. TRANSACTION_DATE=Handle_Null(TRANSACTION_DATE,CREATED_TIMESTAMP) TRANSACTION_DATE AND CREATED_TIMESTAMP are TIMESTAMP columns The job fails with the following error: check_nulls: Error when checking operator: When binding output schema variable...

Does the source_date argument of days_since_from_date function accept only hard-coded value? I want to use it but when I pass a date column for source_date, I get the following error. It works though if I use a hard-coded date like "2007-01-01" but this is not the way I want it. NEW_DATE a...

You should be able to get what you want with change capture. We have jobs with quite the same logic and it works fine. This is how we implement the job. after ---> cdc --> transformer ↑ ↓ ----> funnel before ---> copy -------> join Split 'before' data so you can keep the old columns. In your transfo...

Hi! I am appending to a dataset and I want to keep the partitioning on the dataset. My dataset is hash-partitioned on Key1. If I append to the dataset, will it keep the same keys on the same partition? I would think the sorting will be lost, is that correct? I'm planning to hash-partition on Key1 pr...

benny.lbs' case happens to us too and restart only works for 1 level down the top sequence. When one of the grandchildren fails, all the jobs under the level 2 that finished successfully prior to the abort runs again when restarted. All our sequences have these properties: -'Add checkpoints..' is en...

We decided not to use the functionality. :( Instead, we put another SEQUENCER that triggers a common Routine for aborting jobs when ANY of the child sequences fail. I tried using the Exception Handler but it behaves exactly as when 'Automatic handle activities that fail' is checked. Btw, the routine...

The log that I mentioned above that is of type INFO is for the Master Sequence. The child sequence log is still ABORT.

Thanks.

We tried using 'Automatically handle activities that fail' (v7.1) and the Master Sequence aborts when the child sequences abort. This is ok when the routine activity in the Master Sequence returns zero. However, when the routine activity returns non-zero, the Master Sequence fails when it should not...