Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Sqlcode: -30090, sqlstate: 25000

    Hi,

    I am trying to update a federated database table . I m getting this error often. once it will execute successfully & suddenly it will terminate with the below error.

    error:
    Deploy R.T_E
    Running
    R.T_E - Deploy for debug started.
    DB2 SQL Warning: SQLCODE=100, SQLSTATE=02000, SQLERRMC=null, DRIVER=4.17.30
    R.T_E - Deploy for debug failed.
    11
    R.T_E - Roll back failed.
    Error - SQLCODE: -30090, SQLSTATE: 25000

    can someone kindly let me know what is this error & how to overcome this.
    I am using db2 c express on windows & linux. I m getting the same error on both platforms. I m having SYSADM authority.

    Thanks

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Seems that it's sql30090 rc=11
    Have you tried to read about the Reason Code 11 from this:
    db2 "? sql30090"
    and pass-through restriction?
    Regards,
    Mark.

  3. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    As Mark has said, have you looked up the error code. Also, don't assume that sysadm gives you everything. When you post please put db2 version, fixpack level and o/s type
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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