DSXchange

Please execute the following commands and post the results. The WHO command determines whether the LOGTO command worked successfully. LOGTO EDWPROD WHO LIST.ITEM VOC 'LOGIN' LOGTO UV LOGTO EDWPROD Examining the LOGIN item in VOC is to try to determine whether the read operation failure is occurring ...

Do you have the eCase number for this bug?

My apologies, I was describing DataStage 390 (rather than QualityStage).
I imagine that the equivalent of JCL_TEMPLATES would be in the MDB file but this, as you are aware, is password protected. Have you looked around the client software for anything with jcl in the file name?

1(a) A wat is a Buddhist place of worship. Please strive for a professional standard of written English on DSXchange, for reasons elucidated elsewhere. 1(b) The SCD stage requires two output links. One goes to the dimension table, the other (eventually) to the fact table. The Select Output Link allo...

No it hasn't. All you have done with UVFIXFILE is a trace of RT_CONFIG62 to prove that it is not internally corrupted. That, in turn, meant that when you recompiled the job, correct details could be written into RT_CONFIG62 and when you scheduled the job the JOBPARAMINSTS record could also be writte...

No, but you can pass a parameter value from one activity to another in a job sequence. (A sequencer is a component that may occur IN a job sequence.) If this is a top level parameter - that is, a parameter of the job sequence itself - then it's immediately available through the "add parameter&q...

Not really. The simplest thing to do would be to save the sequence with a new name, delete all activities except Job3, then run the sequence.

Otherwise you're up for at least a Nested Condition activity per job activity. Messy.

Of course you can run the actual Job3 in isolation.

You can test for a corrupted RT_CONFIG62 using UVFIXFILE RT_CONFIG62 command, executed from the Administrator client Command window.

Either that or you are not a DataStage Administrator.

I have no idea what you mean by "performance". How would you propose to measure it? (A quick search will tell you of my firmly held belief that rows/sec is an almost toally meaningless metric.) My previous answer was that of an economist - the performance monitor requires some resources; i...

The connection (presumably between client and server) is broken. At some point the network connection has had a glitch. Or your inactivity timeout expired.

Yes, you can dump and inspect the Score.

Try a Search for "vertical pivot".

You can, but one has to be in a non-default location. As do its DLLs and other supporting files. I guess it was easier for IBM to make the blanket statement.

No. A hashed file is simply a mechanism by which a database table is implemented. Any valid UPDATE statement will work, provided no table security or integrity constraints are violated (and, by default, there aren't any of these).