Search found 52 matches

by jojipjohn
Wed Aug 05, 2009 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Documents on Capcity Planning for DataStage Server
Replies: 1
Views: 1118

Documents on Capcity Planning for DataStage Server

Hi,

Does anyone know of any documents on Capcity Planning for DataStage Server. Could you please let me know of any books, documents, website where I can get a framework for DataStage Capacity Planning.

Thanks & Regards
Joji John
by jojipjohn
Wed Apr 16, 2008 7:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file compile.tmp
Replies: 3
Views: 2835

Yes Ray... I do have full rights on the project directory
by jojipjohn
Tue Apr 15, 2008 4:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file compile.tmp
Replies: 3
Views: 2835

Cannot open file compile.tmp

I am getting this error when I am trying to compile a job with parallel transformer. I have installed MS .Net framework 1.1 and jobs without transformer stage are compiling without any errors. Can someone help me please Output from transformer compilation follows: Cannot open file compile.tmp (Trans...
by jojipjohn
Wed Mar 26, 2008 3:18 am
Forum: General
Topic: How can I get the evaluation version of DtaStage 8.x
Replies: 4
Views: 2734

How can I get the evaluation version of DtaStage 8.x

Can anyone tell me how to get an evaluation version of DataStage 8.x (website address). My company has a partner license of IBM, but I am not sure where can I download this. In the following link I could see the zip files but its disabled. http://www-1.ibm.com/support/docview.wss?uid=swg24015106 I a...
by jojipjohn
Tue Mar 20, 2007 2:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv returns Null
Replies: 3
Views: 1788

Its Resolved.... We were using NLS setting and I Changed the settings to default for this job and it is working.
by jojipjohn
Tue Mar 20, 2007 1:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv returns Null
Replies: 3
Views: 1788

We are using NLS setting in our server. Does this creates a problem
by jojipjohn
Tue Mar 20, 2007 1:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv returns Null
Replies: 3
Views: 1788

Iconv returns Null

I have a strange problem. When I am using Iconv function in our production system, What ever be the format I give Its giving me NULL as output. For Example I used Iconv("31 DEC 1967","D") ( This is an example given in the Online Manual) Ideally I should get 0 as output, but I am ...
by jojipjohn
Sun Mar 04, 2007 8:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Order by Clause in Oracle Enterprise stage of Parallel jobs
Replies: 5
Views: 2602

Order by Clause in Oracle Enterprise stage of Parallel jobs

Can we give Order by clause in oracle Enterprise stage of parallel jobs. If yes where are we giving this property.
by jojipjohn
Thu Dec 14, 2006 10:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to access metadata using Universe stage
Replies: 5
Views: 2327

But if I use localuv I am getting only Example1, none of the metadata information are there
by jojipjohn
Thu Dec 14, 2006 3:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to access metadata using Universe stage
Replies: 5
Views: 2327

Should I Create a DSN If so how... I adding an entry to the UVODBC.CONGFIG file but I am not getting this DSN while importing the table definitions.
by jojipjohn
Thu Dec 14, 2006 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to access metadata using Universe stage
Replies: 5
Views: 2327

How to access metadata using Universe stage

Hi,

Can anyone tell me how to use Universe stage to access the metadata. I want to get the source and target tables or files and the SQL used.

Thanks & Regards
Joji John
by jojipjohn
Thu Nov 30, 2006 12:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dstelnet service not starting.
Replies: 1
Views: 1130

Dstelnet service not starting.

Hi, When I reinstalled Datastage on my machine the telnet service is not starting. it is giving the error " Run a DLL as an App has encountered a problem and needs to close. We are sorry for the inconvenience." I tried starting the services seperately from services window in control panel ...
by jojipjohn
Wed Nov 22, 2006 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to enter job run details to audit table
Replies: 8
Views: 3218

Yes this is true but the in built routine write these into a file. since the server is in windows I cabn not use shell script to grep the relevent information from this file and load it to database. Is there a way I can enter these information direcly to database
by jojipjohn
Wed Nov 22, 2006 12:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to enter job run details to audit table
Replies: 8
Views: 3218

Need to enter job run details to audit table

Hi, In my project there is a requirement to load the job start time, endtime, status and records loaded to a audit table each time the job runs. Anyone who have done a similar job, could you please tell me how to do this. If you have similar jobs, could you please send me the dsx of these jobs to jo...
by jojipjohn
Sun Oct 08, 2006 11:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error connecting to Oracle database"Fatal Error: Caught
Replies: 18
Views: 6613

I tried giving all the privilages to the user but its still not working. The Worst thing is its not giving the details of the error.