如果Oracle数据库是源数据库，要确保设置大约10000个打开的游标。
Make sure your have around 10000 open cursors setting for the Oracle database if that is the source.
不可重复的读取：A 1中重新打开的游标检索a 2对符合资格的行的更新。
Non-repeatable reads: The reopened cursor in A1 retrieves updates of A2 on qualifying rows.
默认情况下，AUTOCOMMIT处于启用状态，并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
打开将被返回的游标。
对于OLTP应用程序，所需的排序和临时空间会比较少，一次只打开少数并发游标。
For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time.
在前面的示例中，两个用户交互之间将保持数据库游标打开，从而防止其他用户访问被锁定的数据段。
The previous example held the database cursor open between user interactions, preventing other users from accessing database segments that are locked.
这两种类型的不同之处是：它们在游标打开时对底层数据的变化是否敏感。
These two types differ in whether they're sensitive to changes made to the underlying data while the cursor is open.
ALTERTABLE等一些操作要求不打开游标，而CREATEINDEXONLINE等其它操作则允许表上的游标。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
对于游标，这就是打开和关闭游标之间所经过的时间。
For a cursor this is the elapsed time between open and close.
然后，DB2打开从过程中返回的游标，并处理分配给结果集的定位器。
Then DB2 opens the cursor returns from the procedure and processes the locator allocation to the result set.
另一种方法是在ROLLBACK之后再次显式地打开游标，然后在ROLLBACK时把游标指针跳到读取的记录。
Another approach is to explicitly open the cursor again after ROLLBACK and skip the cursor pointer till the record read at the time of ROLLBACK.
敏感游标将提供底层数据的一个动态视图，而不敏感游标通常对游标打开时数据库的变化不敏感。
A sensitive cursor provides a dynamic view of the underlying data, whereas an insensitive cursor generally isn't sensitive to any changes made to the database while the cursor is open.
注意，对于游标声明，该值为打开游标的次数，不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
注意，对于游标声明，该值为打开游标的次数，不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
应用推荐