WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


New Index wizard

Use this wizard to create an index on a table.

Index Information page

Use this page to specify the schema in which to create the index, the name of the index, whether to make the index a unique index, and the columns that you want to base the index on.

Schema
Select or type the name of the schema in your project in which you want to create the index. If a schema with the name that you provide does not exist in your project, Classic Data Architect creates the schema.
Index
Specify a name for the index.
Unique
Select to create a unique index.
Select Key Columns icon (Select Key Columns icon)
Click to open the Select Columns window and select the columns that you want to base the index on.
Up arrow icon (Up arrow icon)
Moves the selected column up in the list of columns.
Down arrow icon (Down arrow icon)
Moves the selected column down in the list of columns.

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.


Feedback

Update icon Last updated: 2007-10-09