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

Set User Parameters

As you drill down into the data, the Investigator table header includes information to indicate how you arrived at the data. If you filter data, those values appear as header information in your results. Use the Actions pane on the right of the table data to view complementary displays, or other CA Chorus functions, such as Time Series.

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 Investigation Launcher module to a dashboard, and click Start New Investigation.
2. Select DB2 for DBA from the discipline drop-down list.
3. Navigate to the DB2 for z/OS Catalog category, a DB2 version, and a DB2 object in the object tree.

   The Data pane displays the data for the selected DB2 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.