KFAA51231-W

Pre-reading of the range index "aa....aa"."bb....bb" has failed.

               aa....aa:

                  Schema name

               bb....bb:

                  Index identifier

               cc....cc:

                  Cause of the error

               S:

                  Suspends pre-reading of range index "aa....aa"."bb....bb" and continues with the next processing.

               Action:

                  Take one of the following corrective actions based on the cause of the error that is output:

                                 Cause of the error

                                 Corrective action

                                 The specified range index does not exist.

                                 The range index specified in the server definition's adb_sql_rngidx_preread operand has not been defined. Check the defined range index name and correct the adb_sql_rngidx_preread operand specification. For details about how to check the range index names that have been defined, see Searching a dictionary table in the HADB Setup and Operation Guide.

                                 The specified range index is already specified elsewhere.

                                 A single range index name has been specified multiple times in server definition adb_sql_rngidx_preread operands. Delete the duplicate range index names.

                                 The buffer size is insufficient.

                                 There is not enough global buffer to pre-read the range index. Either the -a option (page count for global buffer dedicated to range indexes) has not been specified for the global buffer of the DB area where the range index is stored, or the -a option value is too small. Check the specification of the -a option of the adbbuff operand in the server definition. For details about the -a option of the adbbuff operand, see the topic Operands and options related to global buffers (command format) in Detailed descriptions of the server definition operands in Designing the Server Definition in the HADB Setup and Operation Guide.

                                 Use the following procedure to check the relevant global buffer:

                                       Check the name of the DB area where the range index output in this message is stored. For details about how to check DB areas that store range indexes, see Searching a dictionary table in the HADB Setup and Operation Guide.

                                       Open the server definition file and search for the DB area name found in step 1. This determines which global buffer is involved.

                                 The specified range index is in unfinished status.

                                 The range index specified in the server definition's adb_sql_rngidx_preread operand is in unfinished status. Take one of the following corrective actions:

                                       Check and, if necessary, revise the value of the adb_sql_rngidx_preread operand

                                       Use the adbidxrebuild command to rebuild the index.

Cause of the error	Corrective action
`The` `specified` `range` `index` `does` `not` `exist.`	The range index specified in the server definition's `adb_sql_rngidx_preread` operand has not been defined. Check the defined range index name and correct the `adb_sql_rngidx_preread` operand specification. For details about how to check the range index names that have been defined, see Searching a dictionary table in the HADB Setup and Operation Guide.
`The` `specified` `range` `index` `is` `already` `specified` `elsewhere.`	A single range index name has been specified multiple times in server definition `adb_sql_rngidx_preread` operands. Delete the duplicate range index names.
`The` `buffer` `size` `is` `insufficient.`	There is not enough global buffer to pre-read the range index. Either the `-a` option (page count for global buffer dedicated to range indexes) has not been specified for the global buffer of the DB area where the range index is stored, or the `-a` option value is too small. Check the specification of the `-a` option of the `adbbuff` operand in the server definition. For details about the `-a` option of the `adbbuff` operand, see the topic Operands and options related to global buffers (command format) in Detailed descriptions of the server definition operands in Designing the Server Definition in the HADB Setup and Operation Guide. Use the following procedure to check the relevant global buffer: Check the name of the DB area where the range index output in this message is stored. For details about how to check DB areas that store range indexes, see Searching a dictionary table in the HADB Setup and Operation Guide. Open the server definition file and search for the DB area name found in step 1. This determines which global buffer is involved.
`The` `specified` `range` `index` `is` `in` `unfinished` `status.`	The range index specified in the server definition's `adb_sql_rngidx_preread` operand is in unfinished status. Take one of the following corrective actions: Check and, if necessary, revise the value of the `adb_sql_rngidx_preread` operand Use the `adbidxrebuild` command to rebuild the index.