DB 2对于许多常见的意外故障类型采取了某些保护措施,但是在使用NOT FENCED例程时无法保证完全的完整性。
DB2 takes some precautions against many of the common types of inadvertent failures that could occur, but cannot guarantee complete integrity when not FENCED routines are used.
在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.
如果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.
应用推荐