EDTRBDAP for IASP During Vary On

This document explains how to get the new function to see EDTRBDAP for an IASP during IASP vary on.

This new function came in for R54x and later.

The required PTFs are as follows:
 

o R54x - SI42346
o R61x - SI42529
o R710 - SI42560

What is changing?

During the VARY ON process of allowing an IASP to become AVAILABLE, all access paths with a RECOVER(*IPL) parameter (that are invalid)
will be rebuilt before the IASP can become AVAILABLE. A change is being made to allow a user to use the EDTRBDAP command during the VARY ON so the sequence number of the objects to be handled can be changed. To use the EDTRBDAP commands after loading the PTF, you should do the following:

(note EDTCPCST works the same way)

CRTDTAARA DTAARA(QTEMP/QDBIASPEDT) TYPE(*DEC) LEN(4) VALUE(YYY)

DLTDTAARA DTAARA(QTEMP/QDBIASPEDT) to delete the data area.

Example of DSPASPSTS screen:

                            Display ASP Vary Status                      
                                                                         
 ASP  . . . . . . . . . . . . . . . . . :   NON_SWITCH                    
 Step - current / total . . . . . . . . :   29 / 32                      
 Total time - current / previous  . . . :   00:13:36 / 00:03:11          
                                                                         
                               ASP Vary Progress                          
                                                                         
       Step                                                   Elapsed time
       Cleaning up journal receivers                                      
       Cleaning up cross-reference files                                  
       UID/GID mismatch correction                              00:00:00  
 >     Database access path recovery                            00:13:27  
       Database cross-reference file merge                                
       SPOOL initialization                                              
       Command analyzer recovery                                          
                                                                         
 Press Enter to continue                                                  
                                                                         
 F3=Exit   F5=Refresh   F12=Cancel   F19=Automatic refresh    

 
Example of the EDTRBDAP screen (using the data area):

                         Edit Rebuild of Access Paths                 RCHASK50
                                                            03/10/11  07:49:07
Type sequence, press Enter.                                                  
Sequence:  1-99, *OPN, *HLD                                                  
                                                                             
                       -----------Access Paths-----------  Rebuild   Elapsed  
Seq   Status           File        Library     Member      Time      Time    
25    RUN              INDEX1      VPKNS       INDEX1      35:17:36  00:13:27
                                                                             
                                                                             
                                                                        Bottom
F3=Exit   F5=Refresh   F11=Display member text   F12=Cancel                  
F13=Change multiple    F15=Sort by   F16=Repeat position to   F17=Position to 

Note that if the access path recovery for the file is *AFTIPL, it will start rebuilding during the IPL/vary on; however, it will not stop the vary on from continuing. If, however, it is set to *IPL, the IPL/vary on will not leave this step until the access path rebuild is done.

With or without the PTF, SQL can be run to get the access path count to be rebuilt:
 

SELECT COUNT(INDEX_ASP)  
FROM    QRECOVERY/QADBERAP        
WHERE  INDEX_ASP > 32   and WDBISTS > 34

That shows all access paths to be rebuilt for all IASPs.

If you change INDEX_ASP to the primary IASP number, in this case, 146, similar to the following, you can see just the access paths for the one IASP:

SELECT COUNT(INDEX_ASP)
FROM QRECOVERY/QADBERAP
WHERE INDEX_ASP = 146 and WDBISTS > 34

If the IASP number is not known, if a user has BRMS installed, they can issue WRKASPBRM. OR if the user is at R610 and above you actually look closer at the DSPASPSTS and get the ASP number:

Display ASP Vary Status

ASP Device . . . . : HASIASP Step . . . . . . . : / 34
ASP Number . . . . : 33 Current time . . . : 00:02:03
ASP State . . . . : VARIED OFF Previous time . . : 00:02:03

If BRMS is not installed, you can perform the following steps:

1. Issue the STRSST command
2. Select Option 1. Start a service tool
3. Select Option 4. Display/Alter/Dump
4. Select Option 1. Display/Alter storage
5. Select Option 2. Licensed Internal Code (LIC) data
6. Select Option 14. Advanced analysis
7. On the top blank line, type 1 for option, and type GEOSTAT for the command
8. For options, type -all

There will be Clustering and Geo-mirroring information for all IASPs, but you need to look for the following:

Processing IAsp: 146 NON_SWITCH Active Primary ASP

Which shows the IASP number and name. In this case, IASP 146 is called NON_SWITCH.