DSXchange

Etler21 wrote:I wonder why nobody has suggested me here that there is a liscenceadmin.sh which activate parallel canvas.

Perhaps because it is new and not many people are aware of it? Out of the almost 300,000 posts here, yours is the first to mention it.

First time my process was creating hash file under project directory. Can that be a reson for creation of record in VOC file. What is Account based Hash file. Please confirm for us exactly what you mean by "under project directory". You only have two options in the Hashed File stage when ...

Something doesn't add up. If you created the Hashed File as 'pathed', i.e. in a specific directory, then there is no VOC record created nor needing to be deleted. So if what you have outlined is accurate, then you shouldn't be getting that error message as it should only happen with account-based ha...

Why the need to delete the hashed file? Do you really need to do that rather than just truncating it before each load? :? Using the "rm -r" method is your problem, that is not the way to be deleting an account-based hashed file. A pathed one, yes, but not when a VOC record is involved. For...

Good to know.

Talk to your DBA about the best ways to load that table. There's no magic to what DataStage does, so their advice could be key. For example, are there a large number of indexes on the table? Can the table be bulk loaded rather than using conventional inserts? I also be curious how 'wide' the records...

Still, seems like it could be read without any column delimiters and then have the quotes removed in job before loading.

You can't, at least not just the time by itself, you'll need to combine it with something in the way of a valid date. Were you given any business rules on how to populate that field?

Which is why you really should start your own post, even when you find someone else with "the same issue".

If you really think the older post is relevant to your discussion, link to it.

Any stage with a timeout option will eventually timeout. I never found much use for those stages for that very reason. Best approach in my mind is to remove them from the job and determine where your process is bottlenecking, then 'tune' that aspect of it. As I mentioned in the other post, I doubt t...

Thanks for posting your resolution. :D

You could increase the timeout value in the stage but I personally wouldn't bother going down the Link Paritioner route. As asked in that other thread, what are your target OCI settings - array size, transaction size, update action, etc?

That sounds remarkably like this problem:

viewtopic.php?p=382748

Same issue?

I wonder if there is a command line option to override that check or otherwise force the install?