DSXchange

This is a topic for an orphaned message.

Hi Gujjala, Thanks for instant responce. But both stages are very straight forward and no complexicities. infact the faster one has constraint not other one.both jobs ran at the same time and lesser one ran several times, but still same results. Thanks Ramesh Surendranath Gujjala wrote: > From the d...

>From the datastage perspective It could be because of: 1. Complexity of the logic 2. Types of stages you are using like -aggregator/sort etc 3. hash files if any There may be several other reasons for this like: network traffic, your server availability at the time of your run, sql logic etc regard...

Hi,

I am loading two flat files into two oracle tables, one file is loaded
at the rate of 370 rows/sec and other one loaded at the rate of
1336rows/sec. both flat files are located in the same folder on unix
box. Any light on this.


Thanks
Ramesh

DS.TOOLS is just "there" in each DataStage project. Wolfgangs reply misses one vital step. DS.TOOLS does not exist in the UV project, so that a LOGTO step is required. cd `cat /.dshome` . ./dsenv bin/uv LOGTO projectname Hi Waren, > > as far as I know it is not in any DataStage Manual. "DS.TOOLS" is...

Does anyone know what files need to be modified (such as dsenv) for Parallel Extender as well as how to change the default environment settings so all new projects inherit them (an example would be the C compiler path)? We have DS 6.0 w/ the Parallel Extender option. It doesnt seem to be working cor...

This is a topic for an orphaned message.

Hi Waren, as far as I know it is not in any DataStage Manual. "DS.TOOLS" is a menu with a lot of helpful tools for administration and errorhandling. One way to use it is: Start: administrator Choose a Project and start with DS.TOOLS (capital letters) as command. Then you get a menu and you can act a...

The DS.TOOLS is command that you can run by Administrator Client Interface. After you are logged in (by dsadm user for DS 5.x or uvadm for DS 4.x) you select the Project that you want check and using "Command" button you can use this command on "Command" Field. You can also run this command connecti...

Hi Ramesh, DataStage is a Server-Tool. The DataStage Clients (Director, Manager, Admin, Designer ....) are only windows you use for to see on the server. You have to check if the ORA-DataStage-Link is okay on the serverside. Telnet to the server on Unix or go to the Server on Windows and see if ther...

And what about the "View Data" on designer?? I thing that this is the best way to check what the process will do. Could be some error in the stage (DSN, UserId, Passwd....) Best Regards Giovanni ----- Original Message ----- From: "ramesh pothuru" To: Sent: Thursday, December 19, 2002 3:22 PM Subject...

Hi, I am able to import target table in to manager and able develop a job. But while running the job, its giving the fallowing message. codes.ORAOCI83: Error while trying to retrieve text for error ORA-12154 I know, this is TNS issue, But from my desktop, I am able to access those tables from datast...

We have been having problems releasing locks and I think we missed something basic based on a recent response of Rays: "... in a project in which DS.TOOLS options to administer locks/processes has been executed, ..." What is DS.TOOLS and how does one go about executing/installing/using it? Is it in ...

This is a topic for an orphaned message.

There are quite a few ways you can do this. The simplest (max use of DataStages GUI) is a first job that gets the value by whatever means, and loads it into the user status area (via DSSetUserStatus in a routine called from a Transformer). The controlling routine can then use DSGetJobInfo to retriev...