If your environment allows and you have authority, submit the job to create the database objects. Database security requires that all users have authority, explicitly or implicitly, to do everything they do. For example, to create a DB2 object, a table, table space, or index, requires the authority to create that type of object. Usually, the Database Administrator (DBA) is responsible for granting and revoking DB2 authority. Consult your DBA before creating the database objects.
Note: If you do not intend to submit a job immediately, save it to submit later. CA Gen does not save the job for you.
To run the job that builds the DB2 database, requires DB2 CREATEDBA or SYSADM authority. Many installations restrict the use of these authorities. As an alternative, your DB2 Administrator can define the database for you and can grant you DBADM authority to the database. This allows you to create all of the table spaces, tables, and indexes in the database.
The authorization ID of the person who creates the database objects is the Creator ID. The creator is the owner of the objects. Select authorization ID for object creation carefully considering the following questions:
Know the Creator ID to execute DB2 utilities on the database objects.
Note: For more information about DB2 security, see the IBM DB2 documentation.
When you are satisfied with the content, submit the job to run as a batch process in the background. You can view the results outside of the encyclopedia.
When the job completes, the encyclopedia returns to the Data Base List panel.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|