DB Admin

Use the DB Admin panel to run simple SQL queries. Ensure that you run queries that do not jeopardize the integrity of the data in the IBM® Product Master database.

Business users should not have access to the System Administrator Console because users can modify and even delete data from the system and from the database. Only administrators or developers should have access to this console. Any access restrictions specified in the product UI have no effect if they can run SQL in the Database Admin console.

The DB Admin panel displays a list of saved SQL queries in the History pane. To run an SQL query, enter the query in the SQL Command pane and click Run Query at the top of the panel. To enter explanation about the SQL query, click Explain Plan at the top of the panel.

To erase an existing SQL query and enter a new query, click CLEAR in the SQL Command pane.