HP-UX Workload Manager Toolkits A.01.06 Release Notes for HP-UX 11.0, HP-UX 11i V1.0 and HP-UX 11i V2.0
HP-UX WLM Toolkits (WLMTK) Release Notes
Known problems and workarounds
Chapter 110
Known problems and workarounds
This section discusses problems and workarounds.
ODBTK: No control of instance on start-up
Issue
Assume a database instance is managed by HP-UX WLM. If WLM starts
before that instance, it sets the CPU allocation for the instance’s workload
group based on the mincpu and maxcpu values in the WLM configuration
file. The instance’s workload group remains at that initial CPU allocation
until the instance starts, allowing wlmoradc to gather metrics on it and pass
the metrics to WLM.
Workaround
Try to minimize the time between WLM start-up and instance start-up.
ODBTK: Problematic SQL statements
Issue
wlmoradc provides minimal checking of the SQL it passes to SQL*Plus. If
SQL*Plus finds problems with the SQL statements, messages are sent to
syslog or stderr. In some cases, SQL*Plus cannot execute the statements,
resulting in a warning and a reported execution time (walltime) of 0
seconds.
Workaround
To avoid such events, always verify your SQL by hand before finalizing your
WLM and wlmoradc configuration files.