Search found 11 matches

by loucas
Wed Jun 10, 2009 9:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to improve performance in BW Hub Extraction Stage
Replies: 1
Views: 2002

kashif007,

I have encoutered the same question with yours. Our job can only process about 300 rows per second.

So I want to know whether you have got any solution for this question.

Regards,
Loucas
by loucas
Wed May 20, 2009 7:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Memory size issue
Replies: 4
Views: 6247

Re: Memory size issue//fixed

IBM provide a patch. This issue is fixed
by loucas
Tue Apr 01, 2008 3:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One more sql sentence should be exec
Replies: 6
Views: 3279

Long time no logon, Thanks for your advice! Your method is perfectly fine, just needs a little tweak. I wouldn't use 'After' anything for this, what would you do if only the after part failed? Rerun everything? :? Take your Sequential to ODBC job and remove the Sequential stage. Add a stage variable...
by loucas
Mon Mar 31, 2008 11:23 pm
Forum: General
Topic: MQ plug-in usage(message format: MQHRF2)
Replies: 0
Views: 1190

MQ plug-in usage(message format: MQHRF2)

I cann't push MQHRF2 format msg to MQ. I have view all docs, but can not find any advice about MQHRF2. error message: Failed to put message on the queue. Reason code 2334 My question is : I want to add custom defined header to message. But I can not find some interface or element to add it; Any advi...
by loucas
Mon Jul 16, 2007 9:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One more sql sentence should be exec
Replies: 6
Views: 3279

Any advice?
by loucas
Wed Jul 11, 2007 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One more sql sentence should be exec
Replies: 6
Views: 3279

Thanks for your reply, Hemant_Kulkarni! you can call multiple sql statements in "After" part of the Target. your meaning is that I should write some post logic Routine? or you can write a stored procedure for the same and use the stored procedure in datastage jobs. If I add an stage which ...
by loucas
Wed Jul 11, 2007 9:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One more sql sentence should be exec
Replies: 6
Views: 3279

One more sql sentence should be exec

I have developed one job, and now I should exec one more user define sql sentence after the job. The sentense is not row based and it's bulk update and insert. The How can I do it? Which stage can I use?

Thanks for your attention!
by loucas
Sat Mar 03, 2007 11:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Info in an job about SAP BAPI stage
Replies: 7
Views: 4094

BAPI stage logon profile cannot be changed. When I tried to use another higher level user to do that work. I changed another user profile and test the connection. Then one window poped up and alert the user or passwd is incorrect. But using the same user profile, I can logon in SAP GUI. I don't know...
by loucas
Fri Mar 02, 2007 11:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Info in an job about SAP BAPI stage
Replies: 7
Views: 4094

Target stage replace

Hello, kumar I had replace the bapi stage to Sequential file stage or other stage. They all be ok. Generally there wont be any problem during reading a data. Because datastage can read only to its possible extend. As you say, if it may be due to writing the data to SAP, you can do a test, by elimina...
by loucas
Fri Mar 02, 2007 10:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Info in an job about SAP BAPI stage
Replies: 7
Views: 4094

To DSguru2B

There is no useful info when I reset the aborted job.
DSguru2B wrote:Did you get any additional messages when you reset the aborted job?
by loucas
Fri Mar 02, 2007 3:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Info in an job about SAP BAPI stage
Replies: 7
Views: 4094

Error Info in an job about SAP BAPI stage

Hello everyone! I develop one job which will write table data to Sap Input is an table file. If just one row, the job can exec success. But there are many rows, the job will abort. and the info from director is listed below: DataStage Job 113 Phantom 3096 Program "JOB.1798313313.DT.1430659827.T...