DSXchange

Add one more Specification to the Modify stage, containing the single token NOWARN.

The final line in the file is missing its record terminator. Get a better file.

Monitor, with APT_STARTUP_STATUS, both in the good times and the bad. Try to discover any correlation with the machines' workloads.

Not in any version 7x. There is a glitch that prevents your using the DB2/UDB Enterprise stage with AS/400; you have to use the DB2 API stage, which has no inherent parallel capability.

Whether or not U can do this these things is a matter of little importance. U is one of the infrequent posters at this site. The second person personal pronoun in English is spelled "you", not "u". The plural present tense form of the verb "to be" is spelled "are", not "r". DSXchange is not a mobil...

pdv wrote:In the design at pivot stage it's taking time to convert the number of rows to number of column.

What proof do you have of this assertion?

Check that the -t option does what you think it does, using the man sort command. Options for the sort command differ on different UNIXes.

In particular is anything else occurring at the same time that might be locking that particular record or, indeed, the entire hashed file (e.g. another job executing "clear file before writing"). As Ken suggests, you may have a synchronization issue here.

If this happens frequently you must address the causes. Why is the lock table filling? If you determine that all the locks taken are being taken genuinely, then it becomes time to tune the size of the READU lock table, by adjusting the GSEMNUM and RLTABSZ parameters in uvconfig and regenerating the ...

I haven't looked at the images, but a red line (link?) can mean simply that you've failed to join the link to the downstream stage - maybe pulled up 1mm short.

Interim fix ?!!

Does this mean that they might have to fix it again?

Reminds one of where the name FIAT comes from: "Fix It Again, Tony".

What else is happening in the job? What are your source and target? Where is the alleged slowness? How can you be sure -- have you performed any analysis? Are there any transformations or other computations being carried out? Depending on the total workload combined with everything else happening on...

You can use a UniVerse stage. If the hashed file was created in the account (project) that's fine. If the hashed file was created in a directory you will need to create a pointer in VOC. Search the forum for the SETFILE command and how to use it. The UniVerse stage also supports multi-row return fro...

You can't, using a Hashed File stage.

And it's "hashed" file, not "hash" file.

A parallel job consists of LOTS of processes, not just one. There's a conductor, some section leaders, and quite a few player processes. Which one are you going to kill?