Table D-1 Maximum number of copies of each utility that can be executed concurrently lists and describes the maximum number of copies of each utility that can be executed concurrently. The values shown in the table assume that copies of only one utility are being executed. However, the maximum value for a utility that depends on the pd_max_users operand value also depends on the number of other utilities and UAPs that are executing concurrently.

If the maximum number of concurrent connections is exceeded, one of the following occurs for the affected utility:

• The utility terminates abnormally.
• The utility becomes non-responsive until another executing utility terminates.
• A space shortage occurs in the buffers in the shared memory that are used for storing process allocation request messages and the utility terminates abnormally.
  

  Table D-1 Maximum number of copies of each utility that can be executed concurrently

  Utility	Maximum number of copies that can be executed concurrently
  	pd_utl_exec_mode=0	pd_utl_exec_mode=1
  Database initialization utility (pdinit)	1
  Database definition utility (pddef)#1	pd_max_users operand value
  Database load utility (pdload)	When -b -W -w all is specified MIN(32, pd_max_users operand value) 2 When an option other than -b -W -w all is specified MIN(32, pd_max_users operand value)	When -b -W -w all is specified pd_max_users operand value 2 When an option other than -b -W -w all is specified pd_max_users operand value
  Interactive SQL execution utility (pdsql)	pd_max_users operand value
  Database structure modification utility (pdmod)	1
  Dictionary import/export utility (pdexp)	1
  Rebalancing utility (pdrbal)	MIN(32, pd_max_users operand value)	pd_max_users operand value
  Database reorganization utility (pdrorg)	MIN(32, pd_max_users operand value)	pd_max_users operand value
  Free page release utility (pdreclaim)	MIN(32, pd_max_users operand value)	pd_max_users operand value
  Global buffer residence utility (pdpgbfon)	MIN(32, pd_max_users operand value)	pd_max_users operand value
  Integrity check utility (pdconstck)	pd_max_users operand value/2
  Statistics analysis utility (pdstedit)	No limit
  Database condition analysis utility (pddbst)	MIN(16, pd_max_users operand value)	pd_max_users operand value
  Optimizing information collection utility (pdgetcst)	MIN(16, pd_max_users operand value 2)	pd_max_users operand value 2
  Access path display utility (pdvwopt)	No limit
  Database copy utility (pdcopy)	32 (when the -b option value is 1)#2	pd_max_users operand value
  Database recovery utility (pdrstr)	32	pd_max_users operand value
  Registry facility initialization utility (pdreginit)	1
  Reflection processing for online reorganization (pdorend)	satisfying the following condition: n a b c + d i = 1 a: Number of servers specified in pdorend -s#3 b: Value specified in pdorend -m c: pd_max_users operand value d: pd_max_reflect_process_count operand value
  Audit log output utility for JP1/NETM/Audit (pdaudput)	1

#1

Lock-release wait status occurs because definition SQL statements cannot be executed concurrently.

#2

The maximum number of copies of the database copy utility that can be executed concurrently depends on the number of -b options (number of backup files) specified in pdcopy. This can be determined as follows:

• If each copy of the database copy utility uses one -b option (backup file) and if six copies of the utility are executed concurrently, the maximum number of concurrently executing copies will be 1 6 = 6.
• If each copy of the database copy utility uses two -b options (backup files) and if four copies of the utility are executed concurrently by using a control statements file, the maximum number of concurrently executing copies will be 2 4 = 8.
• If two such sets of copies of the database copy utility are run simultaneously, the number of concurrently executing database copy utility copies will be 6 + 4 = 10, but the maximum number of concurrently executing copies will be 6 + 8 = 14.

#3

If the -s option is not specified, this is the number of servers where the RDAREAs subject to updatable online reorganization are located.

If you execute multiple different utilities and satisfy the formula shown below, specify 1 in the pd_utl_exec_mode operand:

For a HiRDB parallel server configuration

Number of back-end servers in the system 2 number of all utilities that are executed concurrently 824

For a HiRDB single server configuration

2 number of all utilities that are executed concurrently 824

For a HiRDB parallel server configuration, if the number of users connected to the front-end server on the unit where the system manager is located reaches the pd_max_users operand value, as shown in Table D-1 Maximum number of copies of each utility that can be executed concurrently, an excess number of concurrently connected users is detected and the utility terminates with an error.