DSXchange

The find command is having permissions problems. You should also verify that the user ID under which DataStage jobs execute have at least r-x permission to all directories in the pathname(s) to be searched.

To use dsenv is hard coded in DataStage.

To use additional environment variables files is possible, whether through an Execute Command activity early in a job sequence or possibly by sourcing from dsenv itself.

Extra memory on the client will help when compiling job sequences.

Patches have their own installation scripts that can update the template directly.

Hi, We are in process to make our Prod jobs in non-edit mode. We are planning to assign the support group ods to Datastage Operator role group. My query is can Operator do import/ export (manager utility) of ETL jobs as we have scenarios in prod when we support group has to fix the ETL's in middle ...

Inter-process communication is automatically used in parallel jobs - indeed there is no IPC stage. Timeouts in IPC most usually result from overloaded systems or, in MPP configurations, overloaded or damaged networks. Access to resources is controlled by semaphores, which are implemented differently...

Have you effected the metadata change in all stages that refer to it?

Use the Data Set Management utility (in Manager client, Tools menu) to examine the record schema of the Data Set. Verify the field names used therein.

It's dangerous. A better approach would be output to file 3 then, after the job has completed, delete file 1 and rename file 3 to file 1.[/i]

2 2 means your licence has expired. You can either reinstall the server components, or use a longer form of the uvregen command (not documented in DataStage manuals) to update the licence information. From memory the syntax is bin/uvregen authcode -s serialnumber -d expirydate -l CPUlimit but do che...

Using a message handler.

You can not use a server routine in a parallel Transformer stage. You can only use a server routine in a server job or in a BASIC Transformer stage in a parallel job.
Your alternative is to create a parallel routine.

Does it vanish if you're watching it and not if you're not watching it?

There is no function called Format() unless you have written your own. You may need Fmt(). Research in on-line help or in the DataStage BASIC manual. If you have written your own you need a DEFFUN declaration. Research in the same locations.

jojipjohn wrote:I tried giving all the privilages to the user but its still not working. The Worst thing is its not giving the details of the error.

Does this include privileges to system tables?