onTune Admin User Guide

98 Pages·2014·5.53 MB·English

onTune Version 4

Admin User Guide

Nov. 2013

The Content provided on this document is copyrighted by TeemStone Corporation and is protected from copying,
reproduction, modification, distribution, display, performance or transmittal for any purpose under international
copyright laws. The trademarks, trade names, service marks, product packaging, designs and corporate logos and
emblems displayed on this document belong exclusively to TeemStone Corporation are protected from reproduction,
It is not allowed to copy, reproduce, modify, distribute, display, and transmit this document without written
permission of TeemStone Corporation.
2013© TeemStone All Rights Reserved

Table of Contents
General Information on Conventions, Copyrights, Contacts ................................... 6
1. Introduction to onTune Admin ........................................................................................... 8
1.1 Checklist before executing onTune Admin ........................................................... 10
2. Execution of onTune Admin ............................................................................................... 11
2.1 Main Window and Menu ................................................................................................. 14
2.2 onTune Admin Environments Settings ...................................................................... 16
2.2.1 Environment Settings Manually .............................................................................. 16
2.2.2 Environment Settings at First Execution .......................................................... 16
2.2.3 Environment settings via Config Menu .............................................................. 18
2.3 License Registration ............................................................................................................ 20
2.4 Menus and Icons.................................................................................................................... 21
3. onTune License Management .......................................................................................... 22
3.1 Overall Introduction to onTune License Management ................................... 22
3.2 License Registration and Update ................................................................................ 25
3.3 View Registered License ................................................................................................... 27
4. Functions of Admin Menu ................................................................................................... 29
4.1 Menu Structure ....................................................................................................................... 29
4.2 File Menu..................................................................................................................................... 30
4.2.1 File > Config ........................................................................................................................ 30
4.2.2 File > Upload Update Files ......................................................................................... 30
4.2.3 File > Exit .............................................................................................................................. 30
4.3 View Menu.................................................................................................................................. 31
4.4 License Menu ........................................................................................................................... 33

2
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

4.5 Help Menu .................................................................................................................................. 34
4.6 Admin Icons ............................................................................................................................... 35
4.6.1 onTune Admin Environments Settings .................................................................. 35
4.6.2 Refresh .................................................................................................................................... 35
5. User Management for onTune Viewer ......................................................................... 36
5.1 Creating User Accounts ..................................................................................................... 38
5.2 Modifying User Account Information ........................................................................ 40
5.3 Deleting User Account ....................................................................................................... 41
5.4 Assigning Servers (Hosts) to the User ................................................................... 42
6. Server (Host) Grouping and Performance Monitoring Settings .............. 44
6.1 Server (Host) Navigation Window and Information Window ................... 46
6.2 Server (Host) Items on Information Window .................................................... 47
6.2.1 General Information Items - Common .............................................................. 47
6.2.2 Short Term (Real-time) Performance Data Collection Interval ......... 48
6.2.3 Long Term Performance Data Collection Interval ...................................... 48
6.3 Automatically-Created Server (Host) Tree - Host List ................................. 49
6.3.1 Initial Windows of Host Tree and Server Information Window ......... 49
6.3.2 Host List and Server Information Window when Step-by-step
Unfolding Selected......................................................................................................................... 50
6.3.3 Expanding Whole Tree Icon ....................................................................................... 51
6.3.5 Collapsing whole Tree Icon ........................................................................................ 52
6.4 User Defined Server (Host) Groups .......................................................................... 54
6.4.1 Highest Level Group Management ........................................................................ 55
6.4.1.1 Creating Highest Level Group.............................................................................. 55
6.4.1.2 Modifying Highest Level Group Information .............................................. 56
6.4.1.3 Deleting Highest Level Group .............................................................................. 57

3
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

6.4.2 Sub-Group Management ............................................................................................. 57
6.4.2.1 Creating Sub-Group ................................................................................................... 57
6.4.2.2 Modifying Sub-Group Information .................................................................... 59
6.4.2.3 Deleting Sub-Group .................................................................................................... 60
6.4.3 Assigning Servers to the Group .............................................................................. 61
6.5 Select Server (Host) to be Configured ................................................................... 62
6.5.1 Select Server(s) from Host List .............................................................................. 62
6.5.2 Select Server(s) from Group List ........................................................................... 63
6.5.3 Find Server (Host) ........................................................................................................... 65
6.5.4 Server (Host) Filtering .................................................................................................. 68
6.5.4.1 Single Key Filtering ..................................................................................................... 69
6.5.4.2 Multiple Key Filtering ................................................................................................. 71
6.6 Performance Information Collection Settings .................................................... 74
6.6.1 Settings for Single Server (Host) .......................................................................... 74
6.6.2 Settings for Multiple Servers (Hosts) .................................................................. 75
7. Other onTune Admin Functions ....................................................................................... 77
7.1 File Upload and Download, Command Execution ............................................ 77
7.1.1 Accessing to Utility Tab Menu .................................................................................. 77
7.1.2 Upload File ............................................................................................................................ 79
7.1.3 Download File ...................................................................................................................... 80
7.1.4 Command Execution ...................................................................................................... 81
7.2 Defining and Executing User Job ................................................................................ 84
7.2.1 Accessing User Job Scheduling / User Job Scheduling from File Tab
Menu ....................................................................................................................................................... 84
7.2.2 Managing User Job Script – User Job Scheduling ....................................... 86
7.2.2.1 Creating User Job Script ......................................................................................... 87

4
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

7.2.2.2 Editing User Job Script ............................................................................................. 90
7.2.2.3 Deleting User Job Script .......................................................................................... 92
7.2.3 Executing Pre-created Script File – User Job Scheduling to File ...... 93
7.2.3.1 Registering Pre-created Script File Information ...................................... 94
7.2.3.2 Modifying Pre-created Script File Information.......................................... 96
7.2.2.3 Deleting Pre-created Script File Information ............................................. 98

5
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

General Information on Conventions, Copyrights,
Contacts

Conventions

Fonts Contents
Rockwell Italics onTune system, or onTune modules or
subsystems.
MS Reference Sans Serif Regular content
MS Reference Sans Serif Bold with Described separately even if they are
underscore in the same chapter.
MS Reference Sans Serif Bold Menus, buttons, check boxes, radio
buttons on window and TitleBar or
messages on window. Actual file
name.
MS Reference Sans Serif Italics Window messages that are different
from case to case.
MS Reference Sans Serif Bold Red Font Important information to remember
MS Reference Sans Serif Bold Red Font Important information related to
with underscore application execution.
Arial Unicode MS Entry names in configuration file or scripts.
(Not allowed to user to modify.)
Arial Unicode MS Italics User input field in configuration file and/or
runtime script

Copy Rights

onTune® , OnTune® are registered trademark of TeemStone Corp.
All other trademarks or registered trademarks contained and/or mentioned herein
are used for identification purposes only and may be trademarks or registered
trademarks of their respective companies.
AIX® IBM© Copyright IBM Corporation 1994, 2013.
http://www.ibm.com/legal/us/en/copytrade.shtml
Solaris® Oracle Copyright © 2002, 2011, Oracle and/or its affiliates. All rights
reserved.
http://docs.oracle.com/cd/E27449_01/doc/dcommon/html/cpyr.htm
HP-UX® , HP-UX © Copyright Hewlett-Packard Company 1999-2007. All Rights
Reserved.
http://www8.hp.com/us/en/privacy/terms-of-use.html#trademarks
Microsoft® , Windows® , Windows NT® , Windows Server® Microsoft© 2013
Microsoft Corporation. All rights reserved.

6
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

http://www.microsoft.com/en-
us/legal/intellectualproperty/Trademarks/Usage/General.aspx
Redhat® , CentOS® Copyright © 2013 Red Hat, Inc.
https://www.redhat.com/about/mediarelations/trademark.html
SUSE® Copyright © 2011 SUSE, All rights reserved.
http://www.novell.com/company/legal/copyrights/
VMware® Copyright © 2013 VMware, Inc. All rights reserved.
http://www.vmware.com/help/legal.html
Linux is a registered trademark of Linus Torvalds.
MariaDB® , © SkySQL Corporation Ab, 2013. MariaDB is a trademark of SkySQL
Corporation Ab.
https://mariadb.com/about/legal/trademarks
PostgreSQL® Copyright © 1996-2013 The PostgreSQL Global Development Group
http://www.PostgreSQL.org/docs/6.4/static/intro321.htm
Ubuntu © 2013 Canonical Ltd. Ubuntu and Canonical are registered trademarks of
Canonical Ltd.
http://www.ubuntu.com/legal

7
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

1. Introduction to onTune Admin

onTune is a system Performance Monitoring and Tuning Tool. It utilizes Agent
processes on the monitored server(s) to collect and package the information. And
user-defined system events are notified to the user by SMS and/or E-mail.

onTune Admin is used to configure onTune operating environments to meet user
requirements, and user(s) settings as well.

onTune Admin directly operates on the database instance used by onTune
Manager. In multiple onTune Manager usage environments, the user must connect
to each database used by each onTune Manager, and configure each one using
onTune Admin. To configure the settings to connect to the database, please refer
to “2.2 onTune Admin environment settings.

If the run-time environment settings are incorrect, a “connection to database
error” will occur. Ignore this error; modify the settings for connecting to the
database correctly thru the “Configure” menu; stop onTune Admin, and re-execute
onTune Admin.

onTune Admin provides the following functions:

Updating onTune Viewer

onTune Admin updates the onTune Viewer program, which presents system
performance information to the user. The onTune Viewer is updated automatically
via the internet by defining the update URL link, and by the user manually to a
specific version using onTune Admin.

Register and manage onTune License

onTune license is registered by onTune Admin function.

Configure onTune Admin running environments

onTune Admin connects to the database which is used by onTune Manager.
Configuring onTune Admin essentially means to set the database connection
settings.

Manage performance data collection periods of each server to be monitored

onTune Admin provides functions to configure settings of onTune Agent
managed by onTune Manager.

Group definition of servers’ (hosts) for onTune Viewer user(s)

System performance information of servers (hosts) under monitor can be
grouped for viewing on the onTune Viewer. The server group(s) are defined and
managed using onTune Admin. We recommend creating user defined server
group(s) when Agent(s) connect to Manager for the first time. This is specially so
when having a large number of servers under monitor. It becomes complicated to
navigate and find a particular server information under monitor without the
grouping structure.

8
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

User account management (Viewer user)

Only authorized-users are permitted to view and investigate server
performance and event information. User accounts for onTune Viewer are created
and managed by onTune Admin only. This include granting privileges to access
specific server information.

Upload file(s) to the server (host) where Agent runs

Users may upload any file from the onTune Admin operational PC or server to
the Agent operational Server (host). Once the user selects a file to upload and
stores this information, the onTune Manager informs Agent and sends the file.
Optionally, the user may command onTune to execute the file upon finishing the
upload to the Agent Server (host).

Download file(s) from the server (host) where Agent runs

Users may download any file from the Agent server (host) to the user’s PC or
server by executing the download command to onTune Manager via onTune Admin.
The Admin or Viewer window will show the result of this command execution.

Send executable command to the server where Agent runs

An Agent will execute commands received from onTune Manager. The command
may be – stop Agent, update Agents, collect system information at a particular
time, and others.

Create executable script and execute it on the server where Agent runs

The user may create an executable script to be sent and executed on the
Agent Server (host). The Admin or Viewer window will show the result of script
execution.

Send executable script file to the server where Agent runs and execute it

The user may send an executable script to be executed on the Agent Server
(host). The Admin or Viewer window will show the result of script execution.

View onTune Manager runtime logs

onTune runtime logs are shown on Admin message window.

9
onTune V4 Admin User Guide
2013© TeemStone All Rights Reserved

1.1 Checklist before executing onTune Admin

onTune Admin manages onTune runtime environments using onTune Managers’
database(s). Verify the following before executing onTune Admin.

- Execute all onTune Manager(s) database(s) to be managed.
- Execute all onTune Manager(s) to be managed.
- Install and execute Agents that will be connected to the Manager(s). Only
installed and executing Agents prior to executing onTune Admin, are shown
in onTune Admin’s server (host) list – Host List or Group List. We
recommend installing and executing Agents before executing of onTune
Admin. If not, the Server (Host) list will be blank. Newly Agent installed
servers after Admin executing are shown when the Agents execute and
connect to Manager first time.

10
onTune V4 Admin User Guide