Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Maintenance Considerations for zSeries >

About Cursor Close


Cursor close allows you to regulate system resource utilization by Siebel clients in an OS/390 or z/OS environment by setting cursor configuration parameters.

NOTE:  If you want to configure cursor close, a white paper on that topic is available on Siebel SupportWeb.

The cursor configuration parameters specify the number of database rows a Siebel client cursor can set from a user-entered query or a Siebel operation that generates a SQL query. The number of rows is directly related to the length of time a Siebel Web Client occupies an active DB2 thread.

The cursor configuration parameters DSMaxCursorSize and DSPreFetchSize are read at startup from the following places:

The default value for both DSMaxCursorSize and DSPreFetchSize is 48.

Siebel Systems recommends that your corporate IT department and Siebel administrator collaborate to determine the values for these parameters that are most appropriate for each class of user connecting to DB2 UDB for OS/390 and z/OS. These guidelines are not mandated, but provide a balance between system resource utilization, user responsiveness, and productivity. Your enterprise might have unique requirements beyond the scope of this chapter. For assistance, contact Siebel Expert Services.


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003