Configuring Your System for CA Chorus for DB2 Database Management › Set User Parameters

Set User Parameters

You can set user-specific parameters for schema and SQL ID to control the data that appears when you work in the Investigator. These parameters are passed to the database for authorizing.

• Schema shows related objects in the database as part of a logical group. An object is assigned to a schema when it is created.
• SQL IDs grant different levels of access in DB2. Each SQL ID is associated with an authorization identifier, which includes various privileges to perform tasks within a database. As you work in CA Chorus for DB2 Database Management, you can set parameters to change the SQL ID to perform different tasks. The SQL ID field defaults to the last-used SQL ID. If the last-used SQL ID is not available, the SQL ID defaults to the user ID. When you are completing tasks in this discipline, you can select one of these IDs or type in a new one. To request a new SQL ID or to change an existing SQL ID, contact your DB2 system administrator.

  Note: If you log out from CA Chorus when you have two or more modules open in the dashboard with different SQL IDs, the next time that you log in all modules will have the same SQL ID based on the last saved SQL ID.

Follow these steps:

1. Add the Investigator module to a dashboard, and click Start New Investigation.
2. Select DBA from the discipline drop-down list.
3. Navigate to the DBA object in the Objects tree.

   The Data pane displays the data for the selected DBA object.

4. Click the icon in the Investigator toolbar.
5. Define the user parameters in the new dialog, and click Save.

   Note: The SQL ID and SCHEMA default to the user ID.

   If you do not want to save the parameters, clear the applicable check box.