在DB 2 9.7内有一个名为admin_move_table的新例程，可用来自动更改表的分区键，同时又能保持表对读写的完全可访问性。

A new routine in DB2 9.7 named ADMIN_MOVE_TABLE allows you to automatically change the partitioning key of a table while keeping the table fully accessible for reads and writes.

youdao

如果DML sql语句、触发器、视图或例程内引用了一个全局变量，将为语句或对象记录关于完全限定全局变量名的依赖关系。

When a global variable is referenced within a DML SQL statement or within a trigger, view or routine, a dependency on the fully-qualified global variable name is recorded for the statement or object.

youdao

文中所示的简单例程能够完全实现上述思路，并证实具有良好的移植性和可扩展性。

The simple example can realize the solving way, and it also has good portability and scalability.

youdao