Retrieving a saved query

After you save the selection criteria used to produce an ISMF data set list as a data set query, you can retrieve that saved query at any time to regenerate the data set list.

Regenerating the data set list from the data set query produces a new data set list. All data sets that match the query's selection criteria are included in the new data set list.

Type the QRETRIEV command on the command line of the ISMF "DATA SET SELECTION ENTRY PANEL" and enter the name of the query you wish to retrieve on the Query Name to Save or Retrieve field. This command fills in all selection criteria fields with the values that were saved in the specified query.

ISMF searches the data sets allocated to the ISPTLIB ddname for the specified query. Ensure that the data set allocated to the ISPTABL ddname that contains the ISMFQDSN member is also allocated to the ISPTLIB ddname.

Figure 1. ISMF DATA SET SELECTION ENTRY PANEL with QRETRIEV command
 Panel  Defaults  Utilities  Scroll  Help                                       
-------------------------------------------------------------------------------  
                         DATA SET SELECTION ENTRY PANEL              Page 1 of 5  
 Command ===> QRETRIEV__________________________________________________________________                                                                                                 
 For a Data Set List, Select Source of Generated List  . . 2  (1 or 2)            
                                                                                  
   1  Generate from a Saved List         Query Name To                            
        List Name  . .                   Save or Retrieve LIST3___                     
                                                                                  
   2  Generate a new list from criteria below                                     
        Data Set Name . . .                                                       
        Enter "/" to select option   _  Generate Exclusive list                   
                                                                                  
        Specify Source of the new list  . . 2    (1 - VTOC, 2 - Catalog)          
        1 Generate list from VTOC                                                 
           Volume Serial Number . . .            (fully or partially specified)   
        2 Generate list from Catalog                                              
           Catalog Name . . .                                                     
             Catalog Password . . . .            (if password protected)          
           Volume Serial Number . . .            (fully or partially specified)   
           Acquire Data from Volume . . . . . . . N  (Y or N)                     
           Acquire Data if DFSMShsm Migrated  . . N  (Y or N)                     
 Use ENTER to Perform Selection; Use DOWN Command to View next Selection Panel;   
 Use HELP Command for Help; Use END Command to Exit.                              
                                                                                  
       .                                                                          
       .                                                                          
       .                                                                          
                                                                                  
 To further limit the Generated List, Specify a single value or list of values    
 in any of the following:                                                         
                                Rel Op   Value     Value     Value     Value      
                                ------  --------  --------  --------  --------    
     Entry Type . . . . . . . .                                                   
      .                                                                           
      .                                                                           
      .                                                                           

After all of the search criteria fields are filled in with the values retrieved from the specified query, press Enter to produce a new list of data sets that match the selection criteria.

ISMF displays a list of all of the data sets that match the selection criteria on the ISMF "DATA SET LIST" panel. To replace the contents of the original data set list with the currently displayed list, type the SAVE listname REPLACE list command. This command replaces the contents of the saved ISMF data set list with the data sets currently listed on the ISMF "DATA SET LIST" panel.

Figure 2. ISMF DATA SET LIST panel with SAVE list command
 Panel  List  Dataset  Utilities  Scroll  Help                                 
------------------------------------------------------------------------------   
                                 DATA SET LIST                                  
Command ===> SAVE LIST3 REPLACE                               Scroll ===> HALF
                                                        Entries 1-7 of 7        
Enter Line Operators below:                             Data Columns 3-4 of 39  
                                                                                
     LINE                                                     ALLOC   ALLOC     
     OPERATOR                  DATA SET NAME                  SPACE   USED      
    ---(1)----  --------------------(2)--------------------- --(3)-- --(4)--    
                EXMPHLQ.CLUSTER1                             ------- -------    
                EXMPHLQ.CLUSTER2                             ------- -------    
                EXMPHLQ.CLUSTER3                             ------- -------    
                EXMPHLQ.CLUSTER4                             ------- -------    
                EXMPHLQ.CLUSTER5                             ------- -------    
                EXMPHLQ.CLUSTER6                             ------- -------    
                EXMPHLQ.CLUSTER7                             ------- -------    
    ----------  ------  -----------  BOTTOM  OF  DATA  ----- -------  ---- ---- 
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
F1=Help    F2=Split   F3=End     F4=Return  F7=Up      F8=Down    F9=Swap      
F10=Left   F11=Right  F12=Cursor
Use ISMF queries in conjunction with CICS® VR as part of your plans for the recovery process. Then, if data is lost, the recovery process is much faster and easier. The following steps show an example of how you can use ISMF queries to prepare for a simple recovery:
  1. Enter the selection criteria necessary to produce a list of data sets that meet your requirements such as all data sets updated by a particular application.
  2. Save the selection criteria as a query using the QSAVE queryname command.
  3. Generate the ISMF data set list and save it using the SAVE listnam list command.

    Result: An ISMF data set list and an ISMF data set query are available if you have to perform a recovery.

If data is lost or corrupted and VSAM data sets in an ISMF data set list need to be recovered, complete the following steps:
  1. Determine which saved ISMF data set lists contain the VSAM data sets that need to be recovered. Verify whether any new data sets match the original selection criteria of the saved ISMF data set lists.

    For example, there might be data sets that were created since the original ISMF data set list was created. If these new data sets match the original selection criteria, continue to step 2. If there are no new data sets, display the contents of the saved ISMF data set list using the LIST line operator and continue to step 5.

  2. Regenerate the data set list using the saved query. Enter the QRETRIEV queryname command from the ISMF "DATA SET SELECTION ENTRY PANEL".
  3. Press Enter on the ISMF "DATA SET SELECTION ENTRY PANEL" to produce a new list of data sets that match the original selection criteria.
  4. Replace the original data set list with the currently displayed data set list by entering the SAVE listname REPLACE command
  5. Enter the VSAMREC list command to create a recovery job for all of the VSAM spheres within the data set list.

    Result: A recovery job is created for all of the VSAM spheres within the data set list.


Information Information

Feedback


Timestamp icon Last updated: Friday, 29 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///dwwug/dwwug00095.html