Use this wizard to create an index on a table.
PCB Selection page
Use this page to specify the
method that Classic federation can use to select a PCB to access your IMS™ database.
This page applies only to Classic federation.
- PCB selection method and PCB selection criteria
- Verification
- PCB selection by verification involves the query processor issuing DL/I
calls to verify that the PCB selected can successfully access the database
path for the table that the index is based on. PCB verification also requires
the proper PROCSEQ to be specified if columns that map to an XDFLD is specified
in a WHERE clause. This is the default method that the query processor uses
to select a PCB for processing.
- Prefix
- Indicates that you want to provide a prefix for use in identifying the
PCB to use to access or update your IMS database.
- PCB prefix
- Type the PCB prefix that you want to use.
- Name
- Specify up to five PCB names that Classic federation can use to access
your IMS database
for the table that the index is based on. Multiple names are required if this
table is referenced more than once in an SQL statement, or when the same PCB
name is associated with more than one table and these additional tables are
referenced in a single SQL statement.
- PCB name 1 through 5
- Type the PCB names.
- Number
- Specify up to 10 PCB numbers that Classic federation can use to access
your IMS database
for the table that the index is based on. Specifying multiple numbers is required
if the this table is referenced more than once in an SQL statement, or when
these three conditions are true:
- The same PSB is associated with more than one table
- The PCBs in the PSB have sensitivity to the segments that the table is
accessing
- The same PCB ordinal numbers are specified for these tables and these
additional tables are referenced in a single SQL statement
You can specify up to ten ranges of PCB numbers. These PCB numbers can
be listed in any order and represent the order in which a PSB is checked to
determine whether a PCB can be used to access the IMS database.- PCB range 1 through 10
- Specify the ranges of PCB numbers.
Index Type page
If the index is on a CICS® VSAM or
VSAM table, use this page to specify whether the index is a primary index
or an alternate index.
If you are creating an alternate index for a CICS VSAM
table, in the FCT name field specify the name of the CICS table
that contains the information used by CICS file control for accessing the VSAM
file.
If you are creating an alternate index on a VSAM table, specify
these values:
- Data set
- Use these controls to specify the data set in which the information for
the index is located.
- DS
- Specifies that the information from which to create
the index is contained in a data set.
- DD
- Specifies that the information from which to create
the index is contained in a data set with a DD name.
- Name
- Type the name of the data set or DD card in which
the information for the index is located.