[IBM][CLI Driver][DB2] SQL0913N

Hello Everybody,

I'm getting this error when i'm trying to drop table from Z/OS.

" [IBM][CLI Driver][DB2] SQL0913N  Unsuccessful execution caused by deadlock or timeout.  Reason code "00C9008E".  SQLSTATE=57033"

I can run " select * from testtable" successfully but only when I'm trying to drop table I'm getting this error. Does anybody know what could be the reason>

I'm using JDBC Universal driver for UDB.

Who is Participating?
kedluConnect With a Mentor Commented:
If the previous statement is 'Select * from testtble" then I would suspect that, this process is making deadlock happen. I guess you have not closed that statement or resultset properly or you have forgotten it. It is my experience that process will  be in waiting state if you don't close the rs statements. Give a try.
it means some other user is using the same table concurrently as you and other user has locks on row or rows of table
Did you mean to say you were trying to delete all of the rows from the table or are actually trying to drop the table?  As ghp7000 said, there is some contention.  The contention could even be with yourself  ;-)  Depending on how your application is coded, you might to do a commit or otherwise release your own locks.  Otherwise, you better find out who else is accessing the table before truncating it!
Hello Everybody,

I'm trying to drop the table and the matter for the fact is nobody else is working on that table. Thats just my test-table. So I want to release locks on the database.

kedlu, I will try your suggestion.

paluindianAuthor Commented:
hi Kedlu,

thanks for writing remarks on my behalf. I will try your suggestion.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.