DSXchange

Hi,

I am updating a table from a file
Today its taking more time than last night

The only difference is last night the file was fixed-width format and today it is pipe-delimited format

Any insight will be helpful

Thanks

Kishan

Are you trying to insert or delete? Anyways its a database error The ones who have replied before have given you what might be the cause. But you have not explained clearly. Just giving the error is not enough You can get info if you do a google search If you are deleting a record that is linked to ...

Thanks a lot I did this in two steps First selecting from the table and writing to a Seq file Second Seq File to Update the table This has really improved the performance But I have been questioned by my boss that how does a direct update take more time than writing to a file and updating. I am not ...

Thank you very much

I will try to do something like that
Write it to a sequential file and update in a different job

Kishan

Am not able to read the rest of the message I dono when my chartered account will be created I did a ps-ef|grep jobname ps -ef|grep jobname ak77 106358 379828 0 11:31:01 - 0:03 phantom DSD.StageRun jobname. jobname.Transformer_106 2 0/5 0 ak77 198758 1088320 0 11:31:01 - 0:04 phantom DSD.StageRun jo...

Hi everybody, Guess its a better idea to become a charter member as most of the replies doesn't make sense without that. I am reading from a join of two tables. This data is looked up against another hash table. Am using a Link partioner and Link Collector. Finally am updating to a table. Does the l...

Thanks Ray and Chulet,

I didnt try looking into the Shared container
But I just brought this issue because I wanted to know if it was a problem with DataStage

Kishan

Ray - I see what you mean but I was using a LinkCollector to write to a single file and also four different sequential files It does the same meaning it wont show any information on one of the links I am not sure why its happening Initially I had this problem in 6.0.1 and another friend of mine told...

Hi everybody, I created a shared container and am using it in a different job This job has four of this shared containers and they are all writing to one sequential file. The performance characteristics( meaning the Show Performance in the Designer) is not displayed in one of the links but the monit...

Thanks Ray

I will see to that

I thank everybody who is making this forum, a big success

This forum has been of great help

Thanks again
Kishan

Hi Arnd,

If the jobs get locked, the table definition linked with that job also gets locked??

I read before that kill -9 should be avoided but my system analyst did that when I asked her about a dead lock waiting for resource problem

I will try to avoid to this

Thanks again

Kishan

Ray - When a process is finished, and another process starts soon afterwards and is allocated the same DataStage user number, the printer shared memory segment from the previous process has to be removed as part of the login procedure for the new process. The message informs you that this has occurr...

Thanks Am sorry about all the confusion I just left DataStage handle everything I am selecting this date field and just using this as a condition for update Yes, Timestamp helped and DataStage did all the TO_CHAR and TO_DATE and it was a simple thing which I complicated by using all the conversion a...

Hi I am updating an ORACLE 8i table with where date = date Incoming date field is selected in the format TO_CHAR(DATEfield,'YYYY-MM-DD HH24:MI:SS') Then I am using ICONV/OCONV Combo to get this date format in a stage variable Oconv(Iconv(Left(Link1.DATEfield,10), "D-YMD"), "D-DMY[2,A3...

Thanks everybody, That is what I thought and since i started this, i am going to let it finish But when i actually turn it over to the other side, i am going to serialize the two jobs Already it seems like the job s going to take like 10+ hrs to finish, another 3 hrs would not matter i guess This wi...