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
How a table or a row or a column gets unlocked?
Moderators: chulett, rschirm, roy
How a table or a row or a column gets unlocked?
Last edited by deepesh on Wed Sep 21, 2005 3:44 am, edited 1 time in total.
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,
(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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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
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 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.
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
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