Ims Db 简明教程

IMS DB - Secondary Indexing

当我们想访问数据库而不使用完整的串联键，或者当我们不想使用顺序主键字段时，将使用辅助索引。

Secondary Indexing is used when we want to access a database without using the complete concatenated key or when we do not want to use the sequence primary fields.

Index Pointer Segment

DL/I 在单独的数据库中存储指向索引数据库段的指针。索引指针段是辅助索引中唯一一种类型。它由以下两个部分组成 -

DL/I stores the pointer to segments of the indexed database in a separate database. Index pointer segment is the only type of secondary index. It consists of two parts −

  1. Prefix Element

.

  1. Data Element

Prefix Element

索引指针段的前缀部分包含指向索引目标段的指针。索引目标段是可使用辅助索引访问的段。

The prefix part of the index pointer segment contains a pointer to the Index Target Segment. Index target segment is the segment that is accessible using the secondary index.

Data Element

数据元素包含构建索引的索引数据库中段的关键值。这也称为索引源段。

The data element contains the key value from the segment in the indexed database over which the index is built. This is also known as the index source segment.

以下是有关辅助索引的重点注意事项 -

Here are the key points to note about Secondary Indexing −

  1. The index source segment and the target source segment need not be the same.

  2. When we set up a secondary index, it is automatically maintained by the DL/I.

  3. The DBA defines many secondary indexes as per the multiple access paths. These secondary indexes are stored in a separate index database.

  4. We should not create more secondary indexes, as they impose additional processing overhead on the DL/I.

Secondary Keys

重点注意事项：

Points to note −

  1. The field in the index source segment over which the secondary index is built is called as the secondary key.

  2. Any field can be used as a secondary key. It need not be the segments sequence field.

  3. Secondary keys can be any combination of single fields within the index source segment.

  4. Secondary key values do not have to be unique.

Secondary Data Structures

重点注意事项：

Points to note −

  1. When we build a secondary index, the apparent hierarchical structure of the database is also changed.

  2. The index target segment becomes the apparent root segment. As shown in the following image, the Engineering segment becomes the root segment, even if it is not a root segment.

  3. The rearrangement of the database structure caused by the secondary index is known as the secondary data structure.

  4. Secondary data structures do not make any changes to the main physical database structure present on the disk. It is just a way to alter the database structure in front of the application program.

secondary data structure

Independent AND Operator

重点注意事项：

Points to note −

  1. When an AND (* or &) operator is used with secondary indexes, it is known as a dependent AND operator.

  2. An independent AND (#) allows us to specify qualifications that would be impossible with a dependent AND.

  3. This operator can be used only for secondary indexes where the index source segment is dependent on the index target segment.

  4. We can code an SSA with an independent AND to specify that an occurrence of the target segment be processed based on the fields in two or more dependent source segments.

01 ITEM-SELECTION-SSA.
   05 FILLER           PIC X(8).
   05 FILLER           PIC X(1) VALUE '('.
   05 FILLER           PIC X(10).
   05 SSA-KEY-1        PIC X(8).
   05 FILLER           PIC X   VALUE '#'.
   05 FILLER           PIC X(10).
   05 SSA-KEY-2        PIC X(8).
   05 FILLER           PIC X   VALUE ')'.

Sparse Sequencing

重点注意事项：

Points to note −

  1. Sparse sequencing is also known as Sparse Indexing. We can remove some of the index source segments from the index using sparse sequencing with secondary index database.

  2. Sparse sequencing is used to improve the performance. When some occurrences of the index source segment are not used, we can remove that.

  3. DL/I uses a suppression value or a suppression routine or both to determine whether a segment should be indexed.

  4. If the value of a sequence field in the index source segment matches a suppression value, then no index relationship is established.

  5. The suppression routine is a user-written program that evaluates the segment and determines whether or not it should be indexed.

  6. When sparse indexing is used, its functions are handled by the DL/I. We do not need to make special provisions for it in the application program.

DBDGEN Requirements

如前面模块中所讨论的，DBDGEN 用于创建 DBD。当我们创建辅助索引时，涉及两个数据库。DBA 需要使用两个 DBDGEN 创建两个 DBD，用于在已编制索引的数据库和辅助索引数据库之间建立关系。

As discussed in earlier modules, DBDGEN is used to create a DBD. When we create secondary indexes, two databases are involved. A DBA needs to create two DBDs using two DBDGENs for creating a relationship between an indexed database and a secondary indexed database.

PSBGEN Requirements

为数据库创建辅助索引后，DBA 需要创建 PSB。面向程序的 PSBGEN 指定 PROCSEQ 参数中数据库的正确处理顺序的 PSB 宏。对于 PROCSEQ 参数，DBA 编码辅助索引数据库的 DBD 名称。

After creating the secondary index for a database, the DBA needs to create the PSBs. PSBGEN for the program specifies the proper processing sequence for the database on the PROCSEQ parameter of the PSB macro. For the PROCSEQ parameter, the DBA codes the DBD name for the secondary index database.