Create Two-tier Access Path Definition
Two-tier access path defines the translate table fields that will be searched first for tier-one access and the access type for tier-two access to the translate table.
To create a Two-tier Access Path definition:
- From the Resource Administration stack bar on the Data Privacy Menu, select Manage Translate Tables. The Manage Translate Tables view appears.
- Select the desired translate table. Click the Access Paths' Add button and select Two Tier. The Two Tier Access Path dialog box appears.
- In the Tier-one: Table Access Options area, select the Translate Table Fields to be searched for tier-one access to the table.
- In the Tier-two Options area, select Hash, Sequential, or Random access type for tier-two access to the table.
- Optionally, select a user defined hash function from the Optional Custom Hash drop-down list.
- Click OK. Your access path now appears in the Access Path list.
Related Topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*