Send SQL Queries to the UIM Database

The SLM portlet includes a SQL Query tool that you can use to enter custom SQL queries for testing and verification. From the SLM portlet, select the Tools tab > SQL Query to access the tool.
uim901
The SLM portlet includes a SQL Query tool that you can use to enter custom SQL queries for testing and verification. From the SLM portlet, select the
Tools
tab >
SQL Query
to access the tool.
The SQL Query tool in SLM is intended for experienced users only.
Select a query from the pull-down box and click the
Start Query
button to execute the query.
With the SQL Query tool, you can:
  • Use any SQL command.
  • Enter carriage returns.
  • Enter queries that consist of multiple statements.
    To use multiple statements, separate each statement with a semicolon.
  • Run queries with multiple statements
    and
    a query selected from the combo box simultaneously.
  • Enter multiple statements, then highlight one or more of the statements to run only the highlighted statements.
  • Stop a query that is running by clicking the
    Stop Query
    button.
The result of a query appears in a table under the
Recordset
tab. When you run a query that consists of multiple statements, a separate
Recordset
tab appears for each statement. The number of rows found is displayed in the tab header.
Size Limits for SQL Queries
In environments with extensive monitoring, database tables can contain a large number of rows. To maintain UMP response time, SLM SQL queries in UMP version 6.0 and later are now limited to 1000 rows and columns to 1024 bytes.
To override the limits, edit the
<slm>
section of wasp.cfg,
add the following parameters, and restart the wasp probe:
  • max_rows
    The maximum number of rows returned
  • max_field
    The maximum length of any column
For example
   <slm>
      reloadable = true
      cross_context = true
      load_on_startup = true
      unpack_war = true
      path = /slm
      max_rows = 10      
      max_field = 2048
   </slm>