Search found 82 matches

by gomez
Thu Apr 02, 2009 2:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: bapi load
Replies: 4
Views: 3048

Hi: I am facing a similar situation. In Datastage the job completes successfully but the Return file from BAPI has Error code E. I am trying create a material record on SAP using BAPI_Material_savedata. The values I pass in DataStage are correct since I am able to create a material using the same va...
by gomez
Thu Apr 02, 2009 2:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: bapi load
Replies: 4
Views: 3048

Hi: I am facing a similar situation. In Datastage the job completes successfully but the Return file from BAPI has Error code E. I am trying create a material record on SAP using BAPI_Material_savedata. The values I pass in DataStage are correct since I am able to create a material using the same va...
by gomez
Fri Dec 12, 2008 4:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Preferred method to read DB2 tables on Mainframes
Replies: 1
Views: 1466

Preferred method to read DB2 tables on Mainframes

Hi: We have DB2 tables on mainframe as source. We are working on different ways of reading the data. (1) We get a flat file report from QMF tool on mainframe. This is not fixed width or delimited. Hence metadata definition is a manual effort. (2) We are working on reading using a DB2 stage. For this...
by gomez
Wed Nov 26, 2008 3:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file stage - Filter option
Replies: 8
Views: 6834

That would mean the file that you are testing with is empty. Please check
by gomez
Wed Nov 26, 2008 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rows per transaction in ODBC stage
Replies: 3
Views: 2229

Say if I want to commit every 10000 rows, what should I do?

Thanks!
by gomez
Wed Nov 26, 2008 12:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rows per transaction in ODBC stage
Replies: 3
Views: 2229

Rows per transaction in ODBC stage

Hi: We are loading about 8555555 records into a DB2 table in a Parallel job. I get an error "transaction log is full". Looks like if I do a frequent commit while the data load is happening, I might not get this error. However I am not able to find a property like "Rows per transaction...
by gomez
Sat Aug 16, 2008 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project/ Jobs replication
Replies: 1
Views: 1911

Project/ Jobs replication

Hi: We are setting up a Disaster Recovery(DR) environment for our Production DataStage server. I have installed WAS and DataStage on the server. The next step is to replicate Projects and jobs as in the Production environment. Is there any way to get them to the DR environment by way of file copy? I...
by gomez
Fri Aug 08, 2008 11:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: High CPU Utilization - wait for file routine
Replies: 2
Views: 2833

Thanks Ray. I wasnt able to test this until now. Increasing the sleep time solvedthe problem. The CPU usage went down to 6 - 8% from 100%.
Thanks again for your help!
by gomez
Fri Jul 25, 2008 1:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: LDAP Security in IIS
Replies: 3
Views: 2988

Did you get this resolved? You might have to open a new thread because people might think this is a resolved thread and not look at it.
IIS is case sensitive, so try giving the name as defined in your Local OS
IHTH
by gomez
Tue Jun 17, 2008 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error writing to ROOT
Replies: 5
Views: 3578

Thanks everyone. I checked the WAS system logs (SystemOut.log and SystemErr.log) and I dont find any entries relating to this Condition. In fact there are no Error entries in the log around the time I had this error coming up. I shall check back with IBM support as you had suggested and post the res...
by gomez
Mon Jun 16, 2008 11:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SAP R/3 listener on DataStage does not trigger jobs
Replies: 0
Views: 2218

Our SAP administrator enabled the listener on SAP and it works now
by gomez
Mon Jun 16, 2008 11:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Real time processing of IDOCs
Replies: 3
Views: 1965

Thats correct. If you build your DataStage job using the listener connection, it will be called whenever there is an Idoc sent from SAP
by gomez
Mon Jun 16, 2008 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception raised in GCI subroutine: Access violation
Replies: 0
Views: 1626

Exception raised in GCI subroutine: Access violation

Hi: In one of our Production jobs, there is an abort raised in transformer quite often - once a week or so. When I rerun the job, there is no error. This leads me to think that there is no data condition that causes the error. DataStage Job 69 Phantom 412 Program "JOB.1016617828.DT.1475253350.T...
by gomez
Fri Jun 13, 2008 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error writing to ROOT
Replies: 5
Views: 3578

Error writing to ROOT

Hi: When I make changes to a one particular job and save the changes, I get the message Error writing to ROOT This prevents me from saving changes. I deleted the job and imported from backup. I still get the error. Has anybody come across this error? Appreciate any suggestions on why this is happeni...
by gomez
Thu Jun 12, 2008 5:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error - DSP.Close
Replies: 5
Views: 5081

I also had to mention, the abort occurs after all the Idocs are written to SAP. Do you say SAP has to send some status back after it received all the Idocs?