Number of FCM Request Blocks (fcm_num_rqb)

Configuration Type
Database manager

Applies To

Parameter Type
Configurable

Default [Range]

UNIX 32-bit platforms
256, 512, 2 048 [ 128 -- 120 000 ]

UNIX 64-bit platforms
256, 512, 2 048 [ 128 -- 524 288 ]

OS/2 and Windows NT
10 000 [ 250 -- 2 097 152 ]

On non-partitioned database systems, the intra_parallel parameter must be active before this parameter can be used.

This parameter specifies the number of FCM request blocks. Request blocks are the media through which information is passed between the FCM daemon and an agent, or between agents.

The requirement for request blocks will vary according to the number of users on the system, the number of database partition servers in the system, and the complexity of queries that are run. Initially, start with the default number, and use the results from the Database System Monitor when fine tuning this parameter.