Task 2: Editing the rebuilding of access paths

Use this information to edit the rebuilding of access paths if they are marked for rebuilding.

If access paths are marked for rebuilding, you are shown the following display:

                   Edit Rebuild of Access Paths                 SYSTEMA
                                                      05/12/90  13:49:34
 
IPL threshold . . . . . . . . . . . . . 50   0-99
 
Type sequence, press Enter.
Sequence:  1-99, *OPN, *HLD
 
                   ------------Access Paths----------  Unique  Rebuild
Seq   Status       File        Library     Member      Keyed   Time
25__  IPL          QAPZSYM2    QSYS        QAPZSYM2    NO      00:00:01
25__  IPL          QAPZREQ2    QSYS        QAPZREQ2    NO      00:00:01
25__  IPL          QAPZPTF3    QSYS        QAPZPTF3    NO      00:00:01
25__  IPL          QAPZPTF2    QSYS        QAPZPTF2    NO      00:00:01
25__  IPL          QAPZOBJ2    QSYS        QAPZOBJ2    NO      00:00:01
*OPN  OPEN         QTWALL      QSYS        QTWALL      NO      00:00:06
*OPN  OPEN         QASULTEL    QSYS        QASULTEL    NO      00:00:01
*OPN  OPEN         QASULE05    QSYS        QASULE05    NO      00:00:01
*OPN  OPEN         QASULE03    QSYS        QASULE03    NO      00:00:01
*OPN  OPEN         QASULE01    QSYS        QASULE01    NO      00:00:01
More...
F5=Refresh   F11=Display member text   F13=Change multiple  F15=Sort by
F16=Repeat position to   F17=Position to
Note: No access paths are listed if all access paths that are marked for rebuild have a status of SYS, JRN, or SMAPP.

While you are working with this display, the system is rebuilding access paths. You can use this display to perform the following tasks:

  • Change the sequence in which access paths are rebuilt.
  • Delay rebuilding some access paths until after the initial program load (IPL).
  1. If you do not want to make changes to this display, press the Enter key.
    Skip to step 5. If you want to make changes, continue with step 2.
  2. You can change the value of the IPL threshold.
    All access paths with a sequence (SEQ) less than or equal to the threshold are rebuilt during the IPL. Access paths with a greater sequence number are rebuilt after the IPL completes. The default threshold is 50.
  3. You can change the sequence (SEQ) column on the display for specific access paths.
    Initially, the sequence numbers are set in the following way:
    25
    Files with MAINT(*IMMED) and RECOV(*IPL)
    75
    Files with MAINT(*IMMED) and RECOV(*AFTIPL)
    *OPN
    Files with MAINT(*DLY)

    Within a group (same sequence numbers), the system rebuilds access paths according to rebuild time, starting with the longest rebuild time.

    Rebuild time is an estimate, based on the file size and key length. For journaled access paths (status JRN) and access paths protected by system-managed access-path protection (status SMAPP), the rebuild time shows as 0. The system uses the journal entries to recover these access paths rather than rebuilding them. The time that is required is minimal.

    The estimate for rebuild time assumes that the rebuild job is not contending for resources. If an access path is rebuilt after the IPL, the rebuild will probably take longer.

  4. Type your changes and press the Enter key.
    You are shown the Edit Rebuild of Access Paths display again. You see error messages if the system cannot make some of the changes you requested. For example, you might have tried to change the sequence number for an access path that the system rebuilt while you were using the display.

    If you have errors, return to step 2.

  5. When you have finished the display, press the Enter key without making changes.
    You are shown the Display Access Path Status display: 
                         Display Access Path Status
 
IPL Threshold . . . . . . : 50
 
          ----------Access Paths----------   Rebuild     Current
Status    File        Library    Member      Build Time  Run Time
RUN       QAPZSYM2    QSYS       QAPZSYM2    00:00:01    00:00:01
JRN       QAPZREQ2    QSYS       QAPZREQ2    00:00:01
SYS       QASULE03    QSYS       QASULE03    00:00:01
IPL       QASULE01    QSYS       QASULE01    00:00:01

    This display is updated every 5 seconds while the system is rebuilding access paths.

  6. If you want to make changes to the IPL threshold or the sequence for rebuilding access paths, press F12 (Cancel) to return to the Edit Rebuild of Access Paths display.
    Repeat steps 2 through 5.

    If you do not want to make changes, you can allow the Display Access Path Status display to continue updating or you can press F3 (Exit and continue IPL). In either case, the system completes rebuilding access paths before continuing to the next step of the IPL.