Question

db2存储过程中调用sysproc.admin_cmd('reorg table xx.tb ')时报错

存储过程中要做reorg操作，查过sysproc.admin_cmd里面是可以试用reorg的，但是执行后报错，SQL0880N SAVEPOINT "SYSPSM_XX_P0595301_5" does not exist or is invalid in this context .SQLsTATE=3B001
db2版本是8.2.9 按理是可以调用sysproc.admin_cmd的，里面用runstats命令都可以的，就是rerog不行

Answer 1

帮一下包试试？
db2 terminate
db2 CONNECT TO dbname user USERID using PASSWORD
db2 BIND path\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
db2 BIND path\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND path\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 terminate

where dbname represents the name of a database to which the files should be bound, and where path is the full path name of the directory where the bind files are located, such as INSTHOME\sqllib\bnd where INSTHOME represents the home directory of the DB2 instance. db2ubind.lst and db2cli.lst contain lists of required bind files used by DB2 database products. Packages that are already bound will return an SQL0719N error. This is expected.