Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: stored procedure error on 8.1 fp 18 ( 64 bit)

    Hi, we just migrated from 32-bit 8.1 FP 15 db2 udb to 64-bit 8.1 FP 18 db2 udb on linux. I successfully restored the backup image of the 32-bit machine to the 64-bit machine, when I call a stored procedure on the new ( 64-bit) machine.. I get the error below... any ideas? thanks!!



    db2 "call db2inst1.SAMPLEPROC (2238, 'Name', '2011-07-11-04.00.00.000000', '2011-07-13-04.00.00.000000', '1 DAY', 'US/Eastern', 0)"
    SQL0901N The SQL statement failed because of a non-severe system error.
    Subsequent SQL statements can be processed. (Reason "Sdir len bad:
    1535!=1520+13".) SQLSTATE=58004

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I bet that if you thought about this, you could come up with some things to try that might fix the Stored Procedure.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by db2user24 View Post
    I successfully restored the backup image of the 32-bit machine to the 64-bit machine

    What did you have to do to get it successfully restored?

  4. #4
    Join Date
    Nov 2007
    Posts
    265
    Quote Originally Posted by BELLO4KA View Post
    What did you have to do to get it successfully restored?

    Hi,

    Our restore failed on Lenny and Squeeze so I eventually found an article where someone mentioned that he had successfully restored the image on CentOS.. so we pretty much changed the operating system to CentOS and it worked! So a 32-bit restore on 64-bit CentOS works... thanks for all your help!

  5. #5
    Join Date
    Nov 2007
    Posts
    265
    Quote Originally Posted by Marcus_A View Post
    I bet that if you thought about this, you could come up with some things to try that might fix the Stored Procedure.
    And you're absolutely right! I think with the slight change in versions.. there was a problem with an underlying the sproc on 8.1 FP 18 where if I try to reuse the same prepare statement, then it would complain saying that it's already in use. So all I had to do was create another prepare statement with another variable name and it fixed it!

Posting Permissions

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