DSXchange

Hi everyone, I am constantly getting the following error in my project. Funny thing is that i do not get this error in the same job twice. but whenever i run the project some of the jobs get this error. DSD.SEQOpen Failed to open LT_Gp1b_LtAuditDoc_In2 in directory /Ascential/Datastage/Projects/UNIF...

Instead try this for the last row:

Convert(Char(10):Char(13),"",Field)

thanx a lot . will try this

I want to avoid it because i already have a routine running for each job and i would have to modify them.

Can you guide me how to remove the sequential file in a routine? I would also like to know if i can run two after job subroutines

Hi,

I am extracting a table and then loading it into another with a sequential stage in between.

i want to use the filter option in the sequential stage to delete this file once my load in over. Any suggestions?

Any other way i can delete the file? other than a after job routine?

The performance starts and ends with 200. It vaires a lot with job to job. in some job it goes upto 1700 while in some its 90.

ULOAD.BAT is not running. it says DB not found.

INSERT takes pretty much the same time as UPSERT.

I have the table stats with me. will this be any help to you? Table Name D Size (MB) I Size (MB) Avg Max Min Records lt-condition 684.6 38.6 259 4126 89 2,763,934 Data- New Area Name # of Reads # of Creates 32 101,621,722- 379,187- I also have the following message repeat itself in some job logs SQL...

I have tried it by removing job routine as well as by clearing the log file.
The load is marked as replace.

Still no improovement in load time. Its still stuck at 200 rows per sec.

One more query.

Do we need to clear the table before bulk load? Do you think it will help?

Please provide me a good way to clear the data in tables before bulk load.

the status file never has more than 2-3 entries. right now also it has 3 entires.

Will having all jobs write to different local message file help? currently all jobs are writing to the same file. I have tried did but did not find any considerable differencr

I have a after job routine that writes to a status file. basically it records the job name and time.

I will check that and let you know. Meanwhile i would like to tell you about the load timings: The director says job started at 3:36:01 PM and ended at 3:57:34 PM The highlight of the log file: SQL3500W The utility is beginning the "LOAD" phase at time "06-19-2006 15:32:15.081442"...

I will do the same and let you know.

how do i load through command prompt?

The issue is with Bulk stage only. The job does nothing except bulk loading the file to DB2 table. any parameters which i need to check?

i have increased row buffer size and save count

there are typcally around 200 columns per table. I am sure there are no logs. The rows are loading but slow. From what i have seen, the loggin starts once all the records have been loaded and then the speed decreases. there are just few warnings in manager as i am reading a BIT as integer. nothing m...