Search found 42 matches

by gaya3
Tue Apr 03, 2007 10:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

This was not a problem related to the DataStage. It was due to a firewall block in the network.

Thanks a lot for ur responses.

Thanks,
Gayathri
by gaya3
Tue Apr 03, 2007 3:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

Yes I am able to connect to the project.

As I had mentioned in the first post itself, I am even able to run the jobs using 'dsjob' from the unix box.

Thanks,
Gayathri
by gaya3
Tue Apr 03, 2007 2:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

Hi,

It says uv not found.

Can you please once again clearly explain how to log into UV?

I guess the method I use to log into UV is not correct.

Thanks,
Gayathri
by gaya3
Tue Apr 03, 2007 2:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

After switching to the DS home directory,
I gave this command

/bin/uv

Is this what you wanted me to do?

I am not able to log into uv.

Thanks,
Gayathri
by gaya3
Tue Apr 03, 2007 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

Hi, Thanks for the immediate response The error message is Failed to coonect to host: <host name>, project :UV [The connection was refused or the RPC daemon is not running [81016]] Yes. I am able to connect to the DS server from the unix box. I tried to execute the dsjob functionality and it works. ...
by gaya3
Tue Apr 03, 2007 1:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to connect to onsite servers
Replies: 12
Views: 2764

Not able to connect to onsite servers

Hi, I have installed DS 6.0 in my machine. Using this client I am not able to connect to any of my client's servers (onsite servers). But I am able to connect to all the local servers. When I try to connect to that server it shows an error message as given below Can you please let me know what could...
by gaya3
Thu Jan 25, 2007 6:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORAOCI 9i stage -- ABnormal Termination
Replies: 1
Views: 907

ORAOCI 9i stage -- ABnormal Termination

Hi, Iam trying to load records into an oracle table using the bulk load ORAOCI stage. I am using this stage for the first time. I am getting the following error. Abnormal Termination of stage (Bulk Stage name) detected. When I reset the job it doesnt give any other information. Please provide me wit...
by gaya3
Tue Jan 09, 2007 3:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Job hangs for a while and then aborts
Replies: 10
Views: 2408

Hi All, Thanks for the suggestions you all provided. Currently the DBA is trying to fine tune one of the queries that is used in the oracle stage. Are there any restrictions on the time taken by the query to run on the oracle database from the ds client. And if there are any such restrictions, will ...
by gaya3
Fri Jan 05, 2007 5:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Job hangs for a while and then aborts
Replies: 10
Views: 2408

Thanks for the suggestions Kumar.

I will try it out during the next run and get back to you with the details.

Thanks,
Gaya3
by gaya3
Fri Jan 05, 2007 4:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Job hangs for a while and then aborts
Replies: 10
Views: 2408

The data file is not created.

But the performance statistics in the designer show the number of records inserted into the output file.
by gaya3
Fri Jan 05, 2007 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Job hangs for a while and then aborts
Replies: 10
Views: 2408

Hi, The data does not cross 2 GB. When I reset the job it jus gives a message that looks something like this. Resetting stage JobName.TransformerStageName and Finished resetting stage JobName.TransformerStageName. No other information is seen in the log after the reset. We have been noticing this pr...
by gaya3
Fri Jan 05, 2007 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Job hangs for a while and then aborts
Replies: 10
Views: 2408

Server Job hangs for a while and then aborts

Hi, We have a server job, which loads temporary files with data from the various oracle tables. There are nine different oracle source stages and data from these tables are populated into different hashfiles. All these nine transformations are done in the same job. The job looks like this. Oracle 8 ...