Search found 21 matches

by anitha_casturi
Mon Apr 25, 2011 11:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job executables
Replies: 3
Views: 2679

Re: Job executables

samyamkrishna wrote:Comparing the .dsx files will work fine.
use the diff command
Thank you for the response.

Will comparing dsx of executables really help. I understand we can compare dsx of design information but i am really keen on comparison of dsx executables
by anitha_casturi
Mon Apr 25, 2011 10:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job executables
Replies: 3
Views: 2679

Job executables

hi, We have only executables in Production. We need to check if the design time information in Development is in sync with Production. Will comparing the dsx of executables in Prod and development help? Would it be a good idea to compare executables in different environments to check if they match? ...
by anitha_casturi
Fri Aug 13, 2010 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 6
Views: 8539

ArndW-Thanks for the response. Well bouncing the server may not always be possible in a production environment. Is there any way, we can avoid encountering this error?


Ray-The FIFO file has the name fo the job and the invocation ID as well.
by anitha_casturi
Fri Aug 13, 2010 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 6
Views: 8539

Ray - Thanks for the response. We have all the jobs running in multiple instances but the various instances are identified using Unique invocation id. The job that has got locked, did not abort the last time. Alternately, we tried to delete the fifo file and tried trigerring the job again, but still...
by anitha_casturi
Fri Aug 13, 2010 12:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 6
Views: 8539

Error setting up internal communications

Hi, We have been facing this issue in the QA environment. Error setting up internal communications (fifo RT_SCTEMP/job.fifo)LOCKED STATUS () -1); file is locked The job does not seem to be locked but while we execute this job, we run into this issue. Couple of days back we faced this issue for anoth...
by anitha_casturi
Sun May 16, 2010 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit intervals in ODBC enterprise stage
Replies: 6
Views: 3481

Is there anyway i seta value to this environment variable such that the commit happens only after the job completes? I have been trying to check for this but have been getting to see that if APT_RDBMS_COMMIT_ROWS is set to 0, a negative number, or an invalid value, a warning is issued and each parti...
by anitha_casturi
Thu May 13, 2010 12:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit intervals in ODBC enterprise stage
Replies: 6
Views: 3481

Like so many other things in the parallel execution environment it's managed through environment variables rather than through stage properties. It's probably a good idea to add the environment to th ... Thank you. Can you please help with pointers on the environment variables that have to be set f...
by anitha_casturi
Wed May 12, 2010 7:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit intervals in ODBC enterprise stage
Replies: 6
Views: 3481

Commit intervals in ODBC enterprise stage

We are working on Parallel extender on 8.1 on the AIX environment. We are using ODBC enterprise stage to read and load data into MS SQL Sever 2005 tables. How do we set commit intervals in this stage? We will want commit to happen only after the entire load is complete. Incase the job fails due to v...
by anitha_casturi
Wed May 12, 2010 10:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Commit intervals in ODBC Enterprise stage
Replies: 1
Views: 1537

Commit intervals in ODBC Enterprise stage

We are working on Parallel extender on 8.1 on the AIX environment. We are using ODBC enterprise stage to read and load data into MS SQL Sever 2005 tables. How do we set commit intervals in this stage? We will want commit to happen only after the entire load is complete. Incase the job fails due to v...
by anitha_casturi
Tue Dec 15, 2009 6:48 am
Forum: Site/Forum
Topic: compliation error
Replies: 1
Views: 4143

compliation error

Hi, if i use a transformer in the job i am getting error listed below. ##I IIS-DSEE-TFCN-00006 07:37:59(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=SEW06132; -m=Pentium ##I IIS-DSEE-TOSH-00002 07:37:59(002) <main_program> orchgeneral: loaded ##I IIS-DSEE-TOSH-00002 07:37:59(00...
by anitha_casturi
Wed Nov 11, 2009 12:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ho to to generate XML file
Replies: 1
Views: 1929

Ho to to generate XML file

i need to generate an XML file.can any one help me in this regard from the basics.
by anitha_casturi
Thu Dec 23, 2004 3:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to retrive unmatching records from lookup
Replies: 8
Views: 4269

Ideally IsNull(DSLink.1) should work.
Why not try ISNULL(match column) and check????
by anitha_casturi
Thu Dec 23, 2004 2:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run a datastage job from webserver
Replies: 4
Views: 2777

Thank you Sir for the reference.

But is there anyway for API calls in DS.
by anitha_casturi
Wed Dec 22, 2004 10:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run a datastage job from webserver
Replies: 4
Views: 2777

Run a datastage job from webserver

Hi,
We want to be executing a DS job from a webserver without the involvement of DOS. Is it possible? If yes, please suggest the way.

Thanks in advance
by anitha_casturi
Wed Sep 15, 2004 12:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Learning Basic Programming
Replies: 5
Views: 3199

Ascential have on the books, but not scheduled, a class called Programming with DataStage BASIC . It can be offered on demand, as far as I know. It was most recently revised for version 4.x, but the language hasn't changed that much. UniVerse manuals can be downloaded for no charge from IBM website...