DSXchange

Is it a complex query? The same query is executed on every node - can your database handle identical copies of the same query without locking itself up?

Was this job run or created by a different user? The message suggests that you do not have W permission to the RT_SC817 directory or that the job is currently running, or that the jp... file is currenly open elsewhere, so that the jp... file can not be removed.

Check whether the Execution Mode for your Pivot stage is set to Sequential. Is there a "collection" (fan-in) on the link that is input for the Pivot stage?

The Orchestrate Operators manual. These can be had from IBM for the asking - ask your support provider to supply a set.

That error suggests that you have used a reference to the XXX parameter in an expression somewhere in the job design. Don't forget to open the stage properties of any Lookup or Transformer stage that may be part of that design, and where expressions often occur. Also stage variable initialization an...

Welcome aboard. :D

Can you please explain how you are designing the job, and how you are importing the "table" (file) definition?

Working storage is not available within a file, so it is very unusual to find a file definition for an actual (physical) file that contains level 88 items.

I don't have access to DataStage this week - hence the question rather than the research.

There is no NAME in DS_JOBOBJECTS.

DSJ.LOGRESET is a constant for selecting log events of type "job has been reset" using DSGetNewestLogId(). It is not a command.

ArndW wrote:You use the Hashed File stage to access the Db directly

In a PARALLEL job?!!

Can the Enterprise ODBC stage "see" the localuv DSN and, if so, can it make any sense of "DBMSTYPE = UNIVERSE" in uvodbc.config ?

ramank1981 wrote:I need to generate report by querying metadata in UNIVERSE database....is there any way to query universe database?

Why do you need to do it that way?
Perfectly good tools are provided "out of the box".

Post on the correct forum. A tutorial ships with DataStage. Work through that.

No-one, not even the DBA, is permitted to edit data in the system tables. They carry extra-special protection within the engine. But, if you are logged in as a user with DBA privilege, then you can GRANT and REVOKE to your heart's content (except that you can not revoke DBA privilege so that no DBA ...

There's no bug. You must log in as ADM\evans036 to be able to grant DataStage SQL privileges.

Welcome aboard. :D

Are you logged in as superuser?