Migration Information › Rebuild the ALL DBEXCEL Privilege

Rebuild the ALL DBEXCEL Privilege

The next step of the installation process consists of rebuilding the repository ALL DBEXCEL privilege.

1. At the Installation Customization Menu, select option 11 Security. The Grant DB2 Privileges screen appears.

   -------------------------- CA Repository for z/OS --------------------------
    ----------------------------- Grant DB2 Privileges ------------------------
    COMMAND ===>                                                               
                                                                               
     Grant Privileges to...                                                    
                User TSO ID  ===> USER1                                        
                             ===>                                              
                             ===>                                              
                             ===>                                              
                             ===>                                              
                                                                               
              Set SQLID to?  ===> ARZUSER                                      
     Authorize ALL DBEXCEL?  ===> Y (Y-yes,N-no)                               
       GRANT DB2 Privilege?  ===> SELECT (INSERT,UPDATE,DELETE,SELECT,ALL)     
         with GRANT OPTION?  ===> N (Y-yes,N-no)                               
            Edit or Submit?  ===> E (E-edit,S-submit)                          
          Save Output? ===> N       (Y-yes,N-no)                               
       Output Data Set ===>                                                    
                                                                               
    Enter ENTER command to continue or END command to EXIT.                                                                                                
   

2. Enter values into the fields as follows:
   • User TSO ID

     Type your TSO ID in the first field. Leave the remaining ID fields blank.

   • Set SQLID to

     The SQLID you want to use when granting user privileges. If you enter a value in this field, a SET CURRENT SQLID statement is added to the beginning of the job.

   • Authorize ALL DBEXCEL

     Specify Y.

   • GRANT DB2 Privilege

     Leave blank.

   • with GRANT OPTION

     Specify N.

   • Edit or Submit

     Specify E.

   • Save Output

     Specify Y to save the generated JCL in the data set specified in Output Data Set.

     Specify N to discard the JCL after running the job.

   • Output Data Set

     The fully qualified name (without quotation marks) of the partitioned data set you want to use to save the JCL that this step generates. Ensure that you change the names if you do not want to overwrite any previously saved JCL.

3. Once you enter values in all the fields, press Enter. JCL to rebuild the ALL DBEXCEL privilege is generated and displayed.
4. Check the JCL before submission and correct any conflicts with your system environment.
5. Submit the job and check the output for errors. You can ignore any ‑803 SQL codes.
6. Press PF3 to return to the Installation Customization Menu.