DSXchange

Please post the complete, unedited error and also let us know if this is the first time anyone is trying to connect to DB2 with DataStage.

Interesting... so something specific to RAC, it seems. Do let us know how this all works out!

You would need to run the job with a low warning threshold so the job aborts because of the warnings but I don't believe there is a way you could abort the job because of this specific warning. :? You've got other options in a Server job, the OCI stage has an option to 'treat warnings as fatal' (so ...

XMETA is a specific 8.x concept but there is always a 'repository service' that runs regardless of version and you access the DSEngine repository via the Administrator or from a TCL prompt launched via 'dssh'.

hellboy wrote:friends its a strange way of dealing data by Data Stage or may be i am wrong. please suggest me to complete the job without the aborts.

You are... and I already did.

Do an exact search here for "the record is too big to fit in a block".

I'm not seeing any unusual behaviour today.

A) You've posted in the wrong forum.

B) You can only have one column marked as a Key.

What is "new" about this New Oracle Database? Is it a different version from the OLD Oracle Database? One 9i and one 10g for example?

Stage variables. Simplest answer would be a value that is incremented only when Id = 1. What happens when there are more than three ids in a 'batch'?

How about inactive sessions? Have you tried to do this after bouncing the services?

You need to ensure there are zero connections to the repository, defunct or otherwise, before the REINDEX will fix things. I find it best to do it immediately after bouncing DataStage.

Memory is a little fuzzy but I think that was a fairly stable release. We had good luck with 9.2.0.6 from what I recall but weren't on RAC... though I'm not sure that would be an issue here.

9.2.what.what?

Hi Chulett, I had post with the subject time conversion in general forum in dsxchange, I couldn't get the solution for the problem. I request you to go through that and provide me an solution for that. I really got strucked with my work. Please help me regarding this. Request away, but that's not t...