Where do I get ODBTK?

ODBTK is installed at:

/opt/wlm/toolkits/oracle/

If it is not already installed on your system, download it free of charge from the following Web site:

http://www.hp.com/go/wlm

What comes with ODBTK?

ODBTK comes with two utilities (wlmoradc and smooth), their manpages, and a number of example configuration files. Table 2-1 “ODBTK directories and files” lists many of the included files.

Table 2-1 ODBTK directories and files

Directory/file	Description
/opt/wlm/share/man/man5.Z/wlmtk.5	Manpage that provides an overview of the HP-UX Workload Manager Toolkits
/opt/wlm/toolkits/oracle/	Directory for ODBTK and all its files
/opt/wlm/toolkits/doc/WLMTKug.pdf	WLMTK User’s Guide (PDF)
/opt/wlm/share/man/man1m.Z/wlmoradc.1m	Manpage for the HP-UX WLM Oracle data collector
/opt/wlm/share/man/man1m.Z/smooth.1m	Manpage for `smooth`
/opt/wlm/toolkits/README	Readme for all the WLM toolkits
/opt/wlm/toolkits/oracle/README	Readme for the HP-UX WLM Oracle Database Toolkit
/opt/wlm/toolkits/oracle/bin/wlmoradc	The HP-UX WLM Oracle data collector, which provides data to WLM
/opt/wlm/toolkits/oracle/bin/smooth	Utility for computing a running average, which is useful for smoothing out extreme values in data
/opt/wlm/toolkits/oracle/config/alpha_shares_per_user.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/batchuser_boost.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/manual_payroll_boost.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/process_cnt.oradc	Example configuration file^*
/opt/wlm/toolkits/oracle/config/select_scott_resptime.oradc	Example configuration file^*
/opt/wlm/toolkits/oracle/config/shares_per_process.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/shares_per_user.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/sys_table_resptime.oradc	Example configuration file^*
/opt/wlm/toolkits/oracle/config/timed_select_scott.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/timed_sys_table.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/config/user_cnt.oradc	Example configuration file^*
/opt/wlm/toolkits/oracle/config/user_cnt_boost.wlm	Example configuration file^*
/opt/wlm/toolkits/oracle/install/create_hp_wlmuser.sql	SQL file for creating the default user and role that `wlmoradc` uses to connect to database instances
/opt/wlm/toolkits/oracle/install/drop_hp_wlmuser.sql	SQL file for removing the default user and role used by `wlmoradc`

* For descriptions of the example configuration files, see Table 2-2 “WLM example configuration files described” and Table 2-3 “wlmoradc example configuration files described”.

How do I install ODBTK?

Use the SD-UX swinstall command to install ODBTK, which is part of the WLM Toolkits product (product number WLMToolkits).

The toolkit is installed at:

/opt/wlm/toolkits/oracle/

The manpages are installed at:

/opt/wlm/share/man/

For more information about installation procedures and related issues, see the following documentation:

Managing HP-UX Software with SD-UX
swinstall (1M)

Giving ODBTK access to the database instances

Before you use the ODBTK utility wlmoradc, you must provide it with access to the database instances. You do this in one of two ways:

Using an existing username/password combination
Using the default wlmoradc username/password combination hp_wlmuser/hp_wlmuser

ODBTK comes with a script that creates a user and role for hp_wlmuser, as explained in the next section.

After granting ODBTK access to your instances, see the section “How do I use the metrics?” for information on using wlmoradc with WLM.

Creating a user and role for hp_wlmuser

The wlmoradc utility, by default, attempts to connect to database instances with the username/password combination hp_wlmuser/hp_wlmuser. For convenience, the DBA may wish to create a user and role for hp_wlmuser. Creating this user allows wlmoradc to connect and query the V$ tables for SLOs based on SQL values; however, hp_wlmuser is not allowed to create any tables. To create the user and role, connect to each instance with SQL*Plus to execute create_hp_wlmuser.sql, as shown below.




	NOTE: Be sure to run create_hp_wlmuser.sql against each instance for which you want to use hp_wlmuser, setting `$ORACLE_HOME` appropriately.

$ whoami
oracle
$ ORACLE_HOME=/oracle/app/oracle/product/8.1.5
$ ORACLE_SID=instance1
$ $ORACLE_HOME/bin/sqlplus system/manager
 
SQL*Plus: Release 8.1.5.0.0 - Production on Thu Feb 22 17:32:53 2001
 
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
 
Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
 
SQL> @ /opt/wlm/toolkits/oracle/install/create_hp_wlmuser.sql
DOC> * @(#) HP WLMTK A.01.01 (2001_10_05_15_05_23) hpux_11.00
DOC> *
DOC> * (c) Copyright 2000, Hewlett-Packard Company, all rights reserved.
DOC> *
DOC> * $RCSfile: create_hp_wlmuser.sql,v $
DOC> * $Date: 2001/03/23 18:43:21 $
DOC> * $Revision: 1.4 $
DOC> */
 
Role created.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
User created.
 
 
Grant succeeded.
 
 
USERNAME                       ACCOUNT_STATUS                   CREATED
------------------------------ -------------------------------- ---------
HP_WLMUSER                     OPEN                             14-MAR-01
 
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

Removing the user and role for hp_wlmuser

To remove the user and role for hp_wlmuser, use the script drop_hp_wlmuser.sql against each affected instance:

SQL> @ /opt/wlm/toolkits/oracle/install/drop_hp_wlmuser.sql
DOC> * @(#) HP WLMTK A.01.01 (2001_10_05_15_05_23) hpux_11.00
DOC> *
DOC> * (c) Copyright 2000, Hewlett-Packard Company, all rights reserved.
DOC> *
DOC> * $RCSfile: drop_hp_wlmuser.sql,v $
DOC> * $Date: 2001/03/23 18:43:21 $
DOC> * $Revision: 1.2 $
DOC> */
 
User dropped.
 
 
Role dropped.
 
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

Where can I find example files showing how to set up metrics?

The directory /opt/wlm/toolkits/oracle/config/ is filled with example WLM configuration files as well as wlmoradc configuration files. Copy these files to a working directory and modify them to match your environment.

For an overview of the example WLM configuration files, see Table 2-2 “WLM example configuration files described”.

For an overview of the example wlmoradc configuration files, see Table 2-3 “wlmoradc example configuration files described”.