Messaging Servers in the Db2 for z/OS Environments

For Db2 for z/OS environments, PeopleSoft delivers messaging servers with persistent cursors off. Therefore, all SQL statements are compiled each time they are invoked.

To change the persistent cursors setting:

1. In PSADMIN locate the Values for config section — Publish&Subscribe.

2. Set the Persistent Cursors on DB2/OS390 option. The values are:

   • 0: Persistent cursors off.

   • 1: Persistent cursors on.