How a table or a row or a column gets unlocked?

deepesh · Post by **deepesh** » Mon Sep 19, 2005 1:52 am

The table which i am using through my job is used by other users through some other jobs.

I think,when other users use the same table which i am using,through jobs, the table gets locked or the particular row or column gets locked.
So when i execute the job,the following warning comes.

Could not position within a table in informix stage.

Tell me how to come out this problem in data stage

Is this case related to array size, or transaction size, or transaction isolation

roy · Post by **roy** » Mon Sep 19, 2005 5:12 am

Hi,
(3rd time I try answering so I hope no one bothers me again and my IE won't close and finally I can acomplish answering this)

Can you please give a correct definition of DS version,Job type?
(windows parllel jobs were not executable on 6 version!)

As for your question of locks If they in fact should be there then there is not much you can do, except consult your DBA's to verify they are not some left-overs from a process no longer working or one that should not be locking the resources you need.

Using dirty-read is not always apropriate there for not advised blindly.

IHTH,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Sep 19, 2005 6:05 am

If I am guessing correct, you are in Server edition on Unix.

mpauls · Post by **mpauls** » Tue Sep 20, 2005 1:07 pm

am working in the same issue.
Question is why is this error happpening
[Informix][Informix ODBC Driver][Informix]Could not position within a table
This happens only for certain table at certain time sonly not always

Further details are below

The job is basically updating a table based on a condition.
Many other applications might work on these tables at the same time but not
always
columns are 2 charcter 1 integer and a date
it say At row 250 link Row rejcted

has this error got to do with array size and transaction size properties

mpauls · Post by **mpauls** » Tue Sep 20, 2005 1:08 pm

version is 7

adhrijaa · Post by **adhrijaa** » Tue Sep 20, 2005 2:11 pm

mpauls wrote:version is 7

Transaction and Array size doesnt have any relation with this problem. Just check out whether are you able to query the table. If you are not able to query the table, ask your DBA to release the lock.

This problem will occur in DS server edition job where if you are using the same table to read and update or write the data.

mpauls · Post by **mpauls** » Wed Sep 21, 2005 1:52 am

database is informix
error message is
[Informix ODBC Driver][Informix]Could not position within a table

it does not occur if we change the transaction size and array size

The jobs has 2 links into one odbc stage each having update statements
to same table but different tables.
both have separate transaction size/array size as 10,20 and 1,1
it fails but
when i change it to 10,20 and 20,20 it works and nor error