5 Database Administration

Database Interface Process

~read = the number of read table operations performed on different tables by applications (per channel)

~cursor = the number of cursors involved in the read table

Note: Multiple reads of the same table use only one cursor.

The following are sample calculations using various configurations and numbers of read table operations.

If you have a 24-channel system running an application that performs four read table operations on four different tables per channel, the calculation is:

24 4 1 = 96

Since 96 is less than 500, the database operations proceed properly.

If you have a 36-channel system running an application that performs four read table operations on a single table per channel, the calculation is:

36 1 1 = 36

Since 36 is less than 500, the database operations proceed properly.

If you have a 48-channel system running an application with five read table operations on five different tables per channel, the calculation is:

48 5 1 = 240

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 216