CM22 IMS Physical Organization of Databases Unit 11 (Secondary Indexing)

From 5500031CVP 5500031CVP

This unit discusses the use of secondary indexes as an aid in

database design.

Topics include:

• Secondary Index concept

• The utilities used to create and maintain secondary index databases

• Format of Secondary Index Pointer Segment

• DBD and PSB specifications

• Data restructuring

• Sparse secondary indexes

After completing this unit, you should be able to

•Identify differences between a Secondary Index and a HIDAM Primary Index

•Describe the sequence of utilities required to construct a secondary index database

•State the difference in an application program's processing of a database using the primary processing sequence and using a secondary processing sequence

•Code a DBD with parameters required for secondary indexing

•Code a DBD for a Secondary Index database

•Code a PSB for use with a Secondary Index

Student Notes : https://ibm.box.com/s/z7yf7vrj1t7lyfeg4q1fj4psf428azv3

0:00:13 Secondary Index definition

0:06:39 INDEX databases

0:31:43 Segments used for Secondary Indexes

0:41:26 Secondary Index creation/DBIL

0:56:48 Secondary Index creation/DBR

1:08:35 Secondary Index creation/HISAM Unload

1:12:13 Secondary Index creation/HISAM Reload

1:14:22 IMS Index Builder for z/OS (IBM tool)

1:27:24 Secondary Indexing

1:32:43 Contents of Index Pointer Segment

1:47:49 Secondary Index on Course Name: non-unique key

2:11:31 Secondary Index on Course Name: unique key

2:21:20 PCB for secondary PROCessing SEQuence

2:23:11 Secondary Index calls

2:30:42 Update calls

2:32:33 Restructured hierarchy

2:35:25 Secondary data structure

2:37:01 Sparse Secondary Indexes

2:44:19 System-related fields

2:51:08 Different Target and Source segments

2:58:23 Secondary Index as a Stand-Alone database

2:59:20 Secondary Index on Student segment

3:00:36 Secondary Index Design considerations

Tags

CM22 IMS Physical Organization of Databases Unit 11 (Secondary Indexing)

Related Media