Displaying or updating the LOCATIONS table

Use the Display/Update LOCATIONS panel to update the LOCATIONS table.

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
    The System Administration (ADB2Z) panel is displayed.
  2. Specify option DU, and press Enter.
    The Display/Update CDB panel is displayed, as shown in the following figure.
    Figure 1. Display/Update CDB panel (ADB2Z5)
     DB2 Admin ------------------- DD1A Display/Update CDB ------------------- 17:34
 Option ===>                                                                    
                                                                                
                                                          DB2 System: DD1A      
    L - Display/update LOCATIONS                          DB2 SQL ID: ADM001    
    1 - Display/update LUNAMES                                                  
    2 - Display/update IPNAMES                                                  
    3 - Display/update LUMODES                                                  
    4 - Display/update MODESELECT                                               
    5 - Display/update USERNAMES                                                
    6 - Display/update LULIST                                                   
    7 - DISPLAY/UPDATE IPLIST                                                   
                                                                                
Option xI can be used to insert rows into empty tables (x= option number)       
                                                                                
Switch Catalog Copy  ===>  N   (N/S/C)
  3. Select L, and press Enter.
    The Display/Update LOCATIONS panel is displayed, shown in the following figure.
    Figure 2. Display/Update LOCATIONS panel (ADB2Z5L)
    ADB2Z5L n ------------ DD1A Display/Update LOCATIONS ------- Row 1 to 11 of 20
Command ===>                                                  Scroll ===> PAGE
                                                                              
                                                         DB2 System: DD1A     
Line commands:                                                                
 D - Delete  I - Insert  U - Update  DIS - Display location  S - Select       
 ALIAS - Aliases for location  LU - LU name  IP - IP name                     
 ILU - Insert LU  IIP - Insert IP name                                        
                                                                              
                        Link                                                  
Select Location         Name     Port       TP Name  DBALIAS   TRUSTED SECURE 
       *                *        *          *        *         *       *      
------ ---------------> -------> ---------> -------> --------> ------- ------ 
       STLEC1           QMFEC01  446                           N       Y      
       DSN8             STM4DSN8 8028                          N       N      
       STPLEX4A_DSN7    STM4DSN7 8020                          N       N      
       DSN9             STM4DSN9 8016                          N       N      
       QMFAIX82         RSNAKE   50002                         N       N      
       SQLV73A          VMRACFDB 7300                                         
       SQLV74A          VMRACFDB 7400
  4. Optional: Update the table by using the following line commands, and press Enter.
    D
    Deletes the row.
    I
    Inserts a new row. Row values can be entered on the next panel.
    U
    Updates the row. Row values can be changed on the next panel.