PSDB Maximum Cursors

Enables you to configure the maximum number of cursors opened at one time. In general, the maximum number of cursors that can be open at one time within PeopleTools is 64,000. However, some database platforms place greater restrictions on the number of cursors that can be open at one time. By default, if no value is provided, the system allows a maximum of 1024 cursors.

To increase or decrease the default value, assign your custom value to this parameter. The value you set should be determined on multiple factors including:

• Any predefined limits imposed by your database platform.

• Internal testing of your PeopleSoft application(s).

Always refer to your database documentation for the latest recommendations related to maximum cursors settings. The following information can be used as a guideline.

Database	Maximum Cursors Limit
Oracle	No predefined limit.
IBM Db2 z/OS	Limited only by available storage.
Microsoft SQL Server	No predefined limit.

Note:

When running Application Engine programs or Data Mover scripts you may see the following message in your log files:

Initializing PSDB maximum cursor = 1024

This is an informational message, not an error.