Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2612
  • Last Modified:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0913N

Hello Everybody,

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

"COM.ibm.db2.jdbc.DB2Exception: [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.

Thanks,
P
0
paluindian
Asked:
paluindian
1 Solution
 
ghp7000Commented:
it means some other user is using the same table concurrently as you and other user has locks on row or rows of table
0
 
bondtraderCommented:
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!
0
 
kedluCommented:
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.
0
 
kedluCommented:
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.

Thanks
0
 
paluindianAuthor Commented:
hi Kedlu,

thanks for writing remarks on my behalf. I will try your suggestion.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now