IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions: common procedures > Test the connection between the portal server and the Tivoli Data Warehouse
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
1. Create the query
The first step of the test procedure is to create a custom SQL query to the WAREHOUSELOG table.
- Start the Tivoli Enterprise Portal using the desktop or browser client. See Start 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.
Parent topic:
Test the connection between the portal server and the Tivoli Data Warehouse