Locking the Table Jobs Failed
Moderators: chulett, rschirm, roy
Locking the Table Jobs Failed
Hello sirs,
My Job failed beacuse of Locking table please advise me how to set the job
means i have to set some properties,i am using ODBC Stages.
Please advise me.
Thanks in advance.
Thanks
Narasa
My Job failed beacuse of Locking table please advise me how to set the job
means i have to set some properties,i am using ODBC Stages.
Please advise me.
Thanks in advance.
Thanks
Narasa
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi Sai,Sainath.Srinivasan wrote:Try resetting the job after it aborts.
You may have to reconsider your job design to avoid locking.
Thanks for quick response.
While running my job some are locking the table while updating,how can i
tell with datastage hey wait some time like that.
are there any transaction handling techinques or isolation level types
helps on this.
please advise.
Thanks alot
narasa
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Sai,Sainath.Srinivasan wrote:You can define isolation levels for transactions in ansi standards. But before that, you need to check whether your job locks the table within itself. i.e. even if no other job is running which can lock them against yours.
If that is the case, you may have to change your design.
because of some other mainframe jobs locking the table so please help me out.
Thanks
Narasa
Sai,Sainath.Srinivasan wrote:You can define isolation levels for transactions in ansi standards. But before that, you need to check whether your job locks the table within itself. i.e. even if no other job is running which can lock them against yours.
If that is the case, you may have to change your design.
because of some other mainframe jobs locking the table so please help me out.
Thanks
Narasa
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If something external to DataStage is locking the table there is nothing DataStage can do except wait for that lock to be released. All YOU can do is scheduled the DataStage job to run at a time (and lock the table) when the mainframe is not locking the table.
This isn't a DataStage problem. You would experience exactly the same problem with anything that was trying to update the table while it is locked.
This isn't a DataStage problem. You would experience exactly the same problem with anything that was trying to update the table while it is locked.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks for response.ray.wurlod wrote:If something external to DataStage is locking the table there is nothing DataStage can do except wait for that lock to be released. All YOU can do is scheduled the DataStage job to run at a time (and lock the table) when the mainframe is not locking the table.
This isn't a DataStage problem. You would experience exactly the same problem with anything that was trying to update the table while it is locked.
But actual problem is datastage job is not waiting it's simply aborted..
please help me how to set job waited.
Thanks
Narasa
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom