Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Post Unanswered: SQLerror code -913

    Hi All,

    After migration from neon driver to jdbc driver we are getting time out exception

    "SEVERE: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000302;BBBD02P .BBBS0287.X'000012', DRIVER=3.52.95
    com.ibm.db2.jcc.a.SqlException: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000302;BBBD02P .BBBS0287.X'000012', DRIVER=3.52.95
    at com.ibm.db2.jcc.a.ad.a(ad.java:669)
    at com.ibm.db2.jcc.a.ad.a(ad.java:60)
    at com.ibm.db2.jcc.a.ad.a(ad.java:127)
    at com.ibm.db2.jcc.a.rl.c(rl.java:2424)
    at com.ibm.db2.jcc.a.rl.a(rl.java:1929)
    at com.ibm.db2.jcc.t4.db.n(db.java:739)
    at com.ibm.db2.jcc.t4.db.i(db.java:257)
    at com.ibm.db2.jcc.t4.db.c(db.java:52)
    at com.ibm.db2.jcc.t4.t.c(t.java:44)
    at com.ibm.db2.jcc.t4.sb.i(sb.java:153)
    at com.ibm.db2.jcc.a.rl.ab(rl.java:1924)
    at com.ibm.db2.jcc.a.sl.e(sl.java:3286)
    at com.ibm.db2.jcc.a.sl.Ob(sl.java:569)"

    Why this causing please help me here before we never got such kind of exception.

    Thanks in Advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    message is very clear :
    SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason
    code "<reason-code>".
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    you should take a look at what process is running against that BBBS0287 tablespace and not letting you in.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •