Accessing a remote subsystem

You can use Db2 Admin Tool to access the catalog on a remote Db2 subsystem.

1. On the DB2 Administration Menu (ADB2) panel, specify option DD, and press Enter.
2. On the Distributed DB2 Systems (ADB2DDF) panel, issue the S line command next to the remote Db2 subsystem for which you want to access the catalog.

    DB2 Admin ----------------- Distributed DB2 Systems -------  ROW 1 TO 19 OF 19	 
    Command ===>                                                  Scroll ===> PAGE  
   														 
    Select the location you wish to use:                     DB2 System: DD1A
                                                             DB2 SQL ID: ADM001
    Line commands:                                                             
       S - Use DDF to access remote catalog  CO - Connect to remote subsystem  
     DIS - Display threads for remote system                                   
   Select Location                                                             
           *										 
    ------ -----------------						
           DENMARK_DB2M							
           DENMARK_DB2X							 
           DENMARK_DB2D								 
    S      DENMARK_DB2T								 
           DENMARK_DB2W							 
           DENMARK_DB2P							 
           STOCKHLM_DB2B								 
           BELGHOLL_DB2							
           OSLOMVSA_DB2T							
           STOCKHLM_DB2C						
           GER2_DSNS						
           FINLAND_DB2						
           LUBDB2								 
           NORDIC_DB2T                                                 
   

   The System Catalog (ADB21) panel is displayed for the selected location: The release level and mode of your Db2 subsystem affect the options that are available. All generated batch utility jobs, ALTER commands, and MIGRATE commands are sent to the remote subsystem (or the target system for the migrate jobs) for execution after the jobs have been submitted on the local subsystem.

    DB2 Admin --------------------- DD1A System Catalog --------------------- 15:47
    Option ===>                                                                    
                                                                                   
    At location: DENMARK_DB2T                                DB2 System: DD1A      
      AO - Authorization options                             DB2 SQL ID: ADM001     
       G - Storage groups                 P - Plans                                
       D - Databases                      L - Collections                          
       S - Table spaces                   K - Packages                             
       T - Tables, views, and aliases     M - DBRMs                                
       V - Views                          H - Schemas                              
       A - Aliases                        E - User defined data types              
       Y - Synonyms                       F - Functions                            
       X - Indexes                        O - Stored procedures                    
       C - Columns                        J - Triggers                             
       N - Constraints                    Q - Sequences                            
      DS - Database structures          DSP - DS with plans and packages           
                                                                                   
    Enter standard selection criteria (Using a LIKE operator, criteria not saved): 
    Name  . . . .                    >  Grantor . . .          >                   
    Owner . . . .          >            Grantee . . .          >                   
    In D/L/H  . .                    >                                             
    And/or other selection criteria (option xC shows you columns for option x)     
    Column  . . .                    >  Operator  . .        Value  . .            
   

3. After connecting to the remote subsystem, issue OPTIONS BP to set up JOB cards for the remote subsystem. The last JOB card that is used remains active until another BP command is issued. If you have not set up a JOB card for the remote subsystem, the JOB cards for the local subsystem are used on the remote subsystem.