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

I bet that if you thought about this, you could come up with some things to try that might fix the Stored Procedure.

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!

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!