The first step of the test procedure is to create a custom
SQL query to the WAREHOUSELOG table.
Procedure
- Start the Tivoli Enterprise Portal using
the desktop or browser client. See Starting the Tivoli Enterprise Portal client for
instructions.
Log in as the system administrator. (The
default system administrator ID is sysadmin.)
- Click
Query
Editor on the Tivoli Enterprise Portal tool bar.
- In the Query Editor window, click Create New Query.
The Create Query window is displayed.
Figure 1. Create Query window
- Enter a name and description for the query. For this test,
enter WAREHOUSELOG for the query name.
- From the Category drop-down list,
select the folder where you want the WAREHOUSELOG query to appear
in the Query tree.
For example, select a folder name
that corresponds to the operating system (Windows OS or UNIX OS)
where the Tivoli® Data Warehouse
is installed.
- Select the name of the data source for the Tivoli Data Warehouse in the Data
Sources list.
- Click OK.
The WAREHOUSELOG
query appears in the Query tree in the Custom_SQL folder under the
category that you selected. The Specification tab
opens with a Custom SQL text box for you to
enter an SQL command.
- Enter the following SQL statement in the Custom
SQL text box to select all columns of the WAREHOUSELOG
table:
select * from WAREHOUSELOG
- Click OK to save the query and close
the Query Editor window.
