RC/UPDATE Main Menu and the Operational Control options.

Document ID : KB000053169
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

When entering the RC/Update Main Menu, only the Operation Control options are displayed on the screen. Why aren't the other options and objects displayed?

RUPM r11.5  ------------- RC/Update Main Menu ------------ 2009/10/19 11:00:11
COMMAND ===>                                                                  
                                                                               
Option      => B                     Object  => T           Mode  => O ONLINE  
Item Name   => DEPT                > Creator => JANJAA2   > Where => N         
----------------------------------------------------------------------- JANJA02
Location    => LOCAL              DB2 SSID => D81A       DB2 Version: V8R1M0  
 
 Operation Control      
   L  - Log Display     
   P  - Profile         
   BP - Batch Processor 
   IS - Interactive SQL 
   TU - Tutorial  

Solution

The Operation Control options will be the only options displayed if the other options have not been granted. This task can be completed by accessing Product Authorizations off the products main menu or, by simply typing an A at the command line on the products main menu.

Once on the Product Authorizations panel, state the TO ID that needs the access to the options that will be allowed.

Tab down to RC/Update, place and E(xplode) on the CMD line and press enter.

The following will be displayed:

  • RC/Update

  • Product Auths

  • Auth. Options

We need to drill down a bit farther so place a Y next to ____ Auth. Options and press enter.

This will display the following screen:

This will display the following screen:  
RURCUAO R11.5  --------- RC/Update Authorization ---------- 2009/08/05    15:05
COMMAND ===>                                                                  
                                                                              
For User ID ===> PUBLIC                                                        
-----------------------  Use Of RC/Update Subcomponents  --------------------- 
RC/EDIT       ===>     N    RC/SQL   ===>     Y    RC/DATA COMPARE  ===>  N    
RC/BROWSE     ===>     Y    RC/COPY  ===>     Y                                
                                                                               
Object Options                DB2    RC                                        
                      Create  Alter  Alter   Drop  Template                     
Storage Group ===>     Y       Y      Y       Y       Y                        
Data Base     ===>     Y       Y      Y       Y       Y                        
Table Space   ===>     Y       Y      Y       Y       Y                        
Table         ===>     Y       Y      Y       Y       Y                        
Referential   ===>     Y       Y      Y       Y       Y                        
Index         ===>     Y       Y      Y       Y       Y                        
View/Join     ===>     Y       Y      Y       Y       Y                        
Synonym/Alias ===>     Y       Y              Y       Y                        
Trigger       ===>     Y       Y      Y       Y       Y                        
--------------------  RC/Update Administrative Privileges  --------------------
System Defaults Privileges              Drop/Recovery Table Privileges         
System Administrator ===>      N        Restrict Delete Function ===>     Y    
Personal Defaults    ===>      Y        Model Service Privilege  ===>     N  

This gives the RC/Update administrator the ability to determine what access is allowed for a given ID.

In this example PUBLIC could be used as the default user ID. The ID would allow browsing of data but, not the option of edit or data compare:

RC/EDIT       ===>     N    RC/SQL   ===>     Y    RC/DATA COMPARE  ===>  N    
RC/BROWSE     ===>     Y    RC/COPY  ===>     Y            

Going back to the RC/Update Main Menu, it would now display when using the set current sqlid PUBLIC:

RUPM r11.5  ------------- RC/Update Main Menu ------------ 2009/10/19 11:20:31
 COMMAND ===>                                                                  
  Option      => B                     Object  => T           Mode  => O ONLINE  
 Item Name   => DEPT                > Creator => JANJA02   > Where => N         
 ----------------------------------------------------------------------- JANJA02
 Location    => LOCAL              DB2 SSID => D81A       DB2 Version: V8R1M0  
                                                                                
     Object Options             Objects  (for use with Object Options)          
       A  - Alter                 SG - Storage Group     T - Table              
       C  - Create                DB - Data Base         I - Index              
       D  - Drop                  TS - Table Space       V - View               
       T  - Template              TG - Trigger           S - Synonym            
       R  - Drop Recovery         RI - Ref.Integrity     A - Alias              
                                                         J - Join/Edit          
                                                                                
     Operation Control          Table Data Options                              
       L  - Log Display           B  - Browse            FB - Fast Browse       
       P  - Profile               CO - Copy                                     
       BP - Batch Processor       RB - RI Browse                                
       IS - Interactive SQL                                                     
       TU - Tutorial     

You will notice under Table Data Options, the two options that were set to N on the RC/Update Authorization screen are not displayed on the RC/Update Main Menu. These options are as follows:

  E  - Edit
  FE - Fast Edit                                                                             
  DC - Data Compare

Edit and Fast Edit are both controlled by the RC/EDIT === > N