Migration 7.2 to 8.1 stored procedure error

[casaben]

We have been able to restore a database backup made on DB 7.2 in DB2
8.1. But now, while trying to rebuild the stored procedures which
reside
in our database, we receive the following error :

Error: -rootpkgname value must be between 1 and 7 characters

And the build fails.

If we look at the packagename we see this is 8 characters long (e.g.
S1234567).
This was no problem in the previous DB2 7.2 version. Just changing the
package name (by deleting the last
character) doesn't resolve the issue, we just get a different error :

[IBM][CLI Driver][DB2/NT] SQL20204N The user defined function or
procedure "UBENCH.UBS_SALE_GETDATA" was unable to map to a single Java
method. LINE NUMBER=6. SQLSTATE=46008

and the build fails, no matter how many methods there are in the Java code...

We use DB2 8.1.5 Enterprise Edition for Windows, running on Windows
2000
Server SP4.

 

[sathyarams]

If this works on V7.2 and not in 8.1, then contact IBM support ... It may be a bug

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8