Search found 178 matches

by Sreedhar
Mon Mar 22, 2010 11:26 am
Forum: General
Topic: Difference in Server and Datastage Director Time
Replies: 24
Views: 15351

Hi,

we got the problem fixed by adding this to the dsenv file.

export TZ=PST8PDT

Let me know if you need more information.

Regards,
by Sreedhar
Tue Mar 09, 2010 11:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Distributed Transaction Stage
Replies: 4
Views: 4451

Hi, Can we split the MQ and DTS JOBS. What I mean by that is. I want to read from MQ and write to DS/Flat file.(one Job) use Flat file to DTS (Second Job) Does this setup still treat as unit of work from MQ to DTS. i.e if the DTS fails to update/insert then MQ message is rolled back or sent to rejec...
by Sreedhar
Fri Mar 05, 2010 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine Object File
Replies: 8
Views: 8222

Hi,

The program name and the function name should match, in order to exectue that so...


either rename your program name or function.

either both should be ObjectTesting.cpp/ObjectTesting ()
or ObjectTestOne.cpp/ObjectTestOne()

Let know if it still causes you problem.

Regards,
by Sreedhar
Thu Mar 04, 2010 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Distributed Transaction Stage
Replies: 4
Views: 4451

My objective is to see if the update will happen or not on a single data base.
If it does then I will test on two data bases(Tables). And see if one fails the other transaction is rolled back.

Regards,
by Sreedhar
Wed Mar 03, 2010 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Distributed Transaction Stage
Replies: 4
Views: 4451

Distributed Transaction Stage

Hi, I am trying to implement (Distributed Transaction Stage )DTS in V8.1. I get the following error when I run the job. Any Idea of what is going wrong. 1) Warning:Distributed_Transaction_14,0: The Distributed Transaction Stage does not have a status link. 2) Error : Failed to open MQ server library...
by Sreedhar
Thu Feb 11, 2010 5:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Stage
Replies: 5
Views: 2892

Hi,

So we can use either ODBC Stage or an Oracle Enterprise stage to load data into an Oracle Table.

Do we have any advantage of using ODBC Stage over Oracle Enterprise Stage while loading the data. Is that a good Idea to go with ODBC?

Regards,
by Sreedhar
Fri Jan 22, 2010 1:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC error
Replies: 9
Views: 3903

Hi,

does your odbc.ini file has this project listed ?

Regads
by Sreedhar
Fri Jan 22, 2010 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to compare size & count of 2 files through unix scr
Replies: 3
Views: 1797

Hope this helps

File_size=`ls -la | grep $filename | awk 'END { print $5 }'`

row_count='wc -l $filename'

Regards,
by Sreedhar
Fri Jan 22, 2010 1:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parameter between double quote when scheduled
Replies: 20
Views: 5437

One more question before I can talk on that.

What is the scheduling tool that you are using, where is that loaded on unix? or Windows?

Regards,
by Sreedhar
Fri Jan 22, 2010 1:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Istool Export Error
Replies: 6
Views: 3376

Yes it work well with some other projects. In total I had 10 Project 8 of them were small and the other 2 were really big. So the small projects export went fine. But the problem come with that of the Big projects. I understand that it should be a problem with unix file system where the file is grow...
by Sreedhar
Fri Jan 22, 2010 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Istool Export Error
Replies: 6
Views: 3376

One more error,

will this help?

"CORBA NO_MEMORY 0x4942f982 No; nested exception is:
org.omg.CORBA.NO_MEMORY: Unable to read value from underlying bridge : null vmcid: IBM minor code: 982 completed: No"


Regards,
by Sreedhar
Fri Jan 22, 2010 10:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Istool Export Error
Replies: 6
Views: 3376

Istool Export Error

While exporting the jobs from a specific project I am getting the following error

Any Idea of what is going worng


" CORBA TRANSIENT 0x4942fe07 No; nested exception is:
org.omg.CORBA.TRANSIENT: initial and forwarded IOR inaccessible:
Forwarded IOR failed with: null "



Regards,
by Sreedhar
Wed Jan 20, 2010 4:28 pm
Forum: General
Topic: using Istool can I Import Specific Job from .isx file
Replies: 0
Views: 1022

using Istool can I Import Specific Job from .isx file

Hi,

I do an export of jobs using the istool export command. Is there a way to import only a specific job from the bunch of jobs that were exported?

I know that we can do it with dsx file, but not sure of the isx?

Regards
by Sreedhar
Tue Jan 12, 2010 7:49 pm
Forum: General
Topic: Difference in Server and Datastage Director Time
Replies: 24
Views: 15351

Data Stage server gets its time from the operating system time of the machine it's on. I Agree Data Stage clients get the time from the operating system time of the machine they're on. I Agree Both the Server and Client are sitting next to each other. In the same building, On the same floor. With th...
by Sreedhar
Tue Jan 12, 2010 6:35 pm
Forum: General
Topic: Difference in Server and Datastage Director Time
Replies: 24
Views: 15351

Hi, My Unix Server on which Datastage is installed has US PST timing. The Director time is differing by 9 hours. " On the unix box when I type Date Let's say the time is 1:00 pm Now when I run a job in Director is show me a time of 9:00pm." Yes we can set off the option in director but I d...