Display Catalog Copy Versions (ADB2CCD) panel

The Display Catalog Copy Versions (ADB2CCD) panel lists the Db2 catalog copies that are available to be used by Db2 Admin Tool.

Figure 1. Display Catalog Copy Versions (ADB2CCD) panel

 DB2 Admin ------------ DD1A Display Catalog Copy Versions --------- Row 1 of 6   
 Command ===>                                                  Scroll ===> CSR    
                                                                                  
                                                          DB2 System: DD1A        
 Line commands:                                           DB2 SQL ID: ADM001       
                                                                                  
  D - Delete  I - Insert  J - Create Copy, Bind Jobs                              
                                                                                  
        Copy      Planname                                                        
 Select Owner     Suffix   Timestamp                Type   Location               
        *         *        *                        *      *                      
 ------ --------  -------- ------------------------ ------ ----------------       
        V6ALI0    A6       ?                        A      STPLEX4A_DSN6          
        V7COPY2   02       2001-07-16-13.57.16.2180 C                             
        V7COPY3   03       2001-07-16-16.34.55.7003 C                             
        V7COPY4   04       2002-04-04-16.56.19.5425 C                             
        V7COPY7   07       2003-04-11-16.33.37.6884 C                             
        V7NEW11   11       2003-04-14-17.21.05.2860 C                             
 ******************************* END OF DB2 DATA ****************************

This panel includes the following columns:

Select

An input field where you can enter a line command.

Copy Owner

The Db2 authorization ID of the creator of the copy. This field must be unique within the table.

Planname Suffix

The suffix that is appended to the name of certain plans and the collection that are bound with the Copy Owner qualifier. This value can be any two characters. This field must be unique within the table.

Timestamp

The time when the copy of the catalog was last refreshed. When inserting an entry, leave this field blank.

Type

The type of catalog copy:

C: A copy of the local Db2 catalog. When creating an entry for a copy of a local catalog, enter the copy owner, plan name suffix, and type.
A: An alias for a catalog at a remote site. When creating an entry for a remote catalog, enter the copy owner, plan name suffix, type, and location of the remote catalog.
V: A view of a local Db2 catalog. When creating an entry for a view of a local catalog, enter the copy owner, plan name suffix, and type.

Location Name

The location of a remote catalog. This field applies only if Type is A.

This panel supports the following line commands:

D: Delete a catalog copy entry from the table.
I: Insert a new catalog copy entry into the table.
J: Generate create, bind, and copy jobs to copy the Db2 catalog. The jobs that Db2 Admin Tool generates are decribed in Making copies of the Db2 catalog for Db2 Admin Tool.