Search found 284 matches

by abhilashnair
Fri Oct 28, 2011 9:20 am
Forum: General
Topic: Director shows wrong time in the logs
Replies: 4
Views: 2278

As suggested by Ray, I did a search on dsxchange as well as DeveloperWorks. I added the following in my dsenv file export TZ=ISTIMDT-5:30 (My timezone) Also added the above in the profile of the dsapi_slave Then restarted the engine Now, the server time on the director(below right corner of the wind...
by abhilashnair
Wed Oct 26, 2011 6:58 am
Forum: General
Topic: Director shows wrong time in the logs
Replies: 4
Views: 2278

Director shows wrong time in the logs

We are facing an issue where all jobs in the director show wrong time in the logs. They indicate time which is one hour ahead of actual. I went to Tools - Options and checked the box to show server time. The time shown is one hour ahead I checked the time on the Unix box where the engine is installe...
by abhilashnair
Thu Aug 25, 2011 2:41 am
Forum: General
Topic: Migration Of Metadata Server to different Box
Replies: 5
Views: 1601

arvind_ds wrote:Did you go through the link mentioned above? That was answer your question.
Sorry the link was not clear enough..Could you explain?
by abhilashnair
Wed Aug 24, 2011 8:36 pm
Forum: General
Topic: Migration Of Metadata Server to different Box
Replies: 5
Views: 1601

Is the Un-Register to be performed on Engine Machine or MetaData Machine?
by abhilashnair
Wed Aug 24, 2011 5:02 am
Forum: General
Topic: Migration Of Metadata Server to different Box
Replies: 5
Views: 1601

Migration Of Metadata Server to different Box

Currently we have a two tier architecture with DS Engine on one machine A and metadata repository + WAS(Web Application Server) on another machine B. The user authentication is done thru machine B and jobs run on machine A The customer is planning to migrate machine B to another server with a differ...
by abhilashnair
Thu Jul 07, 2011 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning while updating into SQL server table
Replies: 5
Views: 2565

Please post any other error messages which you see in the log. The above error messages are not complete
by abhilashnair
Thu Jun 09, 2011 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector View Data Error
Replies: 7
Views: 4394

abhilashnair wrote:Just found that the view data works fine via ODBC Enterprise stage. Not sure why the connector is giving issues? As for checking the agent, what is the procedure ?
Any suggestions ?
by abhilashnair
Tue Jun 07, 2011 8:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector View Data Error
Replies: 7
Views: 4394

Just found that the view data works fine via ODBC Enterprise stage. Not sure why the connector is giving issues? As for checking the agent, what is the procedure ?
by abhilashnair
Tue Jun 07, 2011 5:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector View Data Error
Replies: 7
Views: 4394

After compiling when I tried to test connect it gave an error agent not available
by abhilashnair
Tue Jun 07, 2011 12:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector View Data Error
Replies: 7
Views: 4394

ODBC Connector View Data Error

while trying to view data, on ODBC connector stage, we are getting the following error.

"An exception occurred while trying to send the request to the handler.Request timed out"

The job runs fine but view data is not allowd. Any suggestions ?
by abhilashnair
Mon Jun 06, 2011 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Update/Insert Statistics Automatically
Replies: 1
Views: 1788

Capturing Update/Insert Statistics Automatically

We have a requirement where we need to send the number of rows updated/inserted on specific tables to users on a daily basis. There is a set of 8-10 jobs that run everyday. All of these are quite straightforward jobs having source ODBC stage, transformer and target ODBC. The target is set to be Upse...
by abhilashnair
Fri May 27, 2011 7:54 am
Forum: General
Topic: DataStage Backup
Replies: 1
Views: 1303

DataStage Backup

We have a two tier topology where DataStage Metadata repository and application Server reside on System A and engine is on System B. There is only one project on System B. System B is being moved to a new box. The CPU, Ram and the IP will remain intact even on the new box. This movement is only beca...
by abhilashnair
Mon May 09, 2011 11:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Failure
Replies: 3
Views: 5648

This is happening because the lookup stage is beiong told to abort whenever it does not finds a match. As the lookup is able to find only one match and not the other it is failing

Inside Lookup stage, open properties and change the condition for lookup failure. You have to change it to continue
by abhilashnair
Sat May 07, 2011 11:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Weird ODBC Stage Behaviour
Replies: 6
Views: 3276

Re worked the job and used DB2 API stage instead of ODBC Enterprise. It worked fine...Guess something was amiss in ODBC, since the same query and same metadata was used in DB2 API as well
by abhilashnair
Fri May 06, 2011 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Weird ODBC Stage Behaviour
Replies: 6
Views: 3276

The only time I've seen anything remotely like this, it turned out to be a database client software bug. What does your official support provider have to say on the topic? Not gone to them yet..Trying to debug from my end. The source contains 817 rows. This error happens after 809 rows. But it has ...