The following RDAREAs can be added:

• Data dictionary LOB RDAREA
• Data dictionary RDAREAs^#
• User RDAREAs
• User LOB RDAREAs
• List RDAREAs

#

These are the data dictionary RDAREAs for storing dictionary tables related to stored procedures, stored functions, and triggers, as well as the database state analyzed table and database management table, which are used by the facility for predicting reorganization time.

A new RDAREA should be added in the following cases:

1. When a new table or index is to be created in a new RDAREA, rather than in an existing RDAREA
2. When free space is to be created in an existing RDAREA by moving part of a table or index to a new RDAREA
3. When a narrowed search is to be performed or when the number of created lists exceeds the maximum (add a list RDAREA)

When adding an RDAREA, keep in mind the values of the following operands. If either of these operand values is exceeded, RDAREAs cannot be added.

• Maximum number of RDAREAs, as specified in the pd_max_rdarea_no operand in the system definition
• Maximum number of HiRDB files comprising RDAREAs, as specified in the pd_max_file_no operand in the system definition

If you plan to use the RDAREA that was added right away, you must allocate a global buffer by means of one of the methods described below.

(a) Allocating a global buffer when the pdmod command is executed

With this method, you allocate global buffers using the globalbuffer operand of the create rdarea statement in the pdmod command. However, this method can be used only to allocate existing global buffers (global buffers that have been specified with the -r or -o option of the pdbuffer operand in the system definition). This method cannot be used in any of the following cases (in these cases, you must use one of the methods described in (b) or (c) below):

• When the page length of the RDAREA being added is equal to or greater than the buffer size of the global buffer
• When an index or LOB global buffer is being allocated
• When a newly added global buffer is being allocated

Global buffers that are allocated using this method become invalid when HiRDB terminates normally or by means of a planned termination, so you will have to change the pdbuffer operand specification while HiRDB is stopped. Note also that you might be able to use the system reconfiguration command (pdchgconf command) to change the value specified in the pdbuffer operand while HiRDB is running.

Reference note

• If you do not change the value specified in the pdbuffer operand, the RDAREA that was added will be allocated a global buffer specified with the -o option when HiRDB is started subsequently.
• If you restart HiRDB, a global buffer specified with the globalbuffer operand remains allocated.

(b) Allocating a global buffer with the pdbufmod command

With this method, you allocate global buffers with the pdbufmod command. This method can also be used to allocate newly added global buffers. However, in order to add global buffers using this method, both of the following conditions must be satisfied:

• HiRDB Advanced High Availability is installed.
• The value Y is specified in the pd_dbbuff_modify operand.

For details about allocating global buffers with the pdbufmod command, see 9.3 Adding, modifying, and deleting global buffers while HiRDB is running (dynamic updating of global buffers).

(c) Allocating a global buffer with the system reconfiguration command (pdchgconf command)

With this method, you allocate global buffers by using the system reconfiguration command (pdchgconf command) to change the value specified in the pdbuffer operand. You can also use this method to allocate newly added global buffers, in addition to existing global buffers. Note that HiRDB Advanced High Availability must be installed in order to use this command.

For details about changing HiRDB system definitions using the system reconfiguration command, see 9.2 Modifying HiRDB system definitions while HiRDB is running (system reconfiguration command).

1. When a data dictionary LOB RDAREA is added, a data dictionary table for routine management is also created. If there is not enough space in the data dictionary RDAREA, it must first be expanded.
2. When a data dictionary LOB RDAREA is added, data dictionary RDAREAs for storing the data dictionary table for routine management can also be added at the same time.
3. When a data dictionary LOB RDAREA is added, two RDAREAs must be added at the same time.