visual message center tools user guide
TRANSCRIPT
VISUAL Message Center ToolsUser Guide
VMC-GEN
VISUAL Message Center Tools User Guide
The software described in this book is furnished under a license agreement and may be used only in
accordance with the terms of the agreement.
Copyright Notice
Copyright © 2013 Tango/04 All rights reserved.
Document date: June 2012
Document version: 2.1
Product version: All products
No part of this publication may be reproduced, transmitted, transcribed, stored in a retrieval system, or translated into any language or computer language, in any form or by any means, electronic mechani-cal, magnetic, optical, chemical, manual, or otherwise, without the prior written permission of Tango/04.
Trademarks
Any references to trademarked product names are owned by their respective companies.
Technical Support
For technical support visit our web site at www.tango04.com.
Tango/04 Computing Group S.L. Avda. Meridiana 358, 5 A-B Barcelona, 08027 Spain
Tel: +34 93 274 0051
Table of Contents
Table of Contents
Table of Contents .............................................................................. iii
How to Use this Guide.........................................................................v
Chapter 1
Introduction ...................................................................................... 1
Chapter 2
Installation ...................................................................................... 2
Chapter 3
Running the Tools.............................................................................. 33.1. T4ChangeProcessPriority ...............................................................................3
3.2. T4ProcessNew................................................................................................4
3.3. T4ProcessKill ..................................................................................................6
3.4. T4Shutdown....................................................................................................7
3.5. ODBCTest.......................................................................................................8
3.6. CommandSender............................................................................................8
3.6.1. Connection Configuration Editor ...............................................................9
3.6.2. Command Creation Tool .........................................................................10
3.6.3. Configuring SmartConsole .....................................................................12
© 2013 Tango/04 Computing Group Page iii
Table of Contents
Appendices
Appendix A: Contacting Tango/04 ..................................................... 16
About Tango/04 Computing Group .................................................... 18
Legal Notice .................................................................................... 19
© 2013 Tango/04 Computing Group Page iv
How to Use this Guide
© 2013 Tango/04 Computing Group Page v
How to Use this Guide
This chapter explains how to use Tango/04 User Guides and understand the typographical conventions
used in all Tango/04 documentation.
Typographical Conventions
The following conventional terms, text formats, and symbols are used throughout Tango/04 printed
documentation:
Convention Description
Boldface Commands, on-screen buttons and menu options.
Blue Italic References and links to other sections in the manual or further documentation containing relevant information.
Italic Text displayed on screen, or variables where the user must substitute their own details.
Monospace Input commands such as System i commands or code, or text that users must type in.
UPPERCASEKeyboard keys, such as CTRL for the Control key and F5 for the function key that is labeled F5.
Notes and useful additional information.
Tips and hints that will improve the users experience of working with this product.
Important additional information that the user is strongly advised to note.
Warning information. Failure to take note of this information could potentially lead to serious problems.
Introduction
© 2013 Tango/04 Computing Group Page 1
Chapter 11 Introduction
VISUAL Message Center comes with a set of external tools, which you can launch in alarm actions. The
tools can be used to manage Windows processes and for managing databases using SQL statements
over ODBC. The tools can be used both on local and remote machines.
The following tools are currently available:
• T4ChangeProcessPriority: Change the priority of a process in a local or remote system
through WMI (Windows Management Instrumentation).
• T4ProcessNew: Create processes in a local or remote system through WMI (Windows
Management Instrumentation).
• T4ProcessKill: Kill all processes with a specified name on a local or remote system.
• T4Shutdown: Stop and restart Windows machines using WMI.
• ODBCTest: Run any SQL statement using an ODBC DSN connected to any database system.
The statement can retrieve data or perform a change in the database.
• iSeriesCommandSender: Run any command or series of commands on a remote iSeries. It
can be used in conjuction with SmartConsole to create iSeries alarms and actions (plus action
sets).
Note The ChangeProcessPriority tool only works on Windows XP or later.
Installation
© 2013 Tango/04 Computing Group Page 2
Chapter 2 2 Installation
The tools are installed as part of VISUAL Message Center. By default they are located in the directory
C:\Program Files\Tango04\VISUAL Message Center\Tools. There is a separate directory for each
tool.
Running the Tools
Chapter 3 3 Running the Tools
The tools are normally run as part of an action script in VISUAL Message Center Alarms. In Alarm
actions you can launch an application. Simply enter the desired tool and parameters in this action and
the tool will run when required.
To test your action you can run any tool from the command line.
For more details regarding alarms and actions see the VISUAL Message Center SmartConsole User
Guide.
3.1 T4ChangeProcessPriorityT4ChangeProcessPriority.exe changes the priority of a process in a local or remote system through
WMI (Windows Management Instrumentation). This program uses the library ProcessPriority.dll
To run the program you must provide the domain, user and password once you start the program. If you
leave them blank the user profile that launches the program is used. If this user profile privileges are not
sufficient, you must provide a different user profile with the appropriate privileges.
The options when running T4ChangeProcessPriority.exe are listed in the following table:
Field Name Function Example More information
HostSpecify computer Name/IP address
SERVER1 or 192.168.0.16
Obligatory field. For local computer enter “”
DomainEnter the name of the domain of the user profile.
Tango
Obligatory field. Enter the domain name of the user profile. To use the informa-tion for the user profile enter “”
UserUsername needed to change process
administratorObligatory field. To use the information for the current user profile enter “”
PasswordPassword for the username
pass1Obligatory field. To use the information for the current user profile enter “”
ProcessId Unique process id 3443
Obligatory field. You can find this value in the VISUAL Message Center SmartCon-sole.
© 2013 Tango/04 Computing Group Page 3
Running the Tools
To run the tool call the executable and enter the following parameters:
T4ChangeProcessPriority.exe Host Domain User Password ProcessID +- Silent
For example:
T4ChangeProcessPriority.exe SERVER1 Tango administrator pass 3443 - 0
This will decrease the priority of process 3443 by one step on SERVER1 using the profile of user
administrator on the Tango domain.
The program will return a result as specified in the following table:
Each time you run T4ChangeProcessPriority.exe the process priority increases or decreases a step.
When decreasing priorities it will change values in the following order: Real Time, High Priority, Above
Normal, Normal, Below Normal and Idle. When increasing priorities it will change values in the following
order: Idle, Below Normal and Normal. You cannot increase the priority of a process above Normal.
This is to prevent a process with heavy CPU usage hanging the system.
3.2 T4ProcessNewT4ProcessNew.exe creates a new process on a local or remote system through WMI (Windows
Management Instrumentation). This program uses the library: ProcessCreate.dll
An interactive process is one that has interaction with the user and the user sees on the user’s desktop.
For security reasons, you cannot run an interactive process on a remote host or an interactive process
on a local host with a different user profile. However you are allowed to program programmed tasks that
are executed soon afterwards. We’ve added the parameter interactive that allows the user to force an
interactive process.
+-Increment + or decrease - pro-cess priority
+ or -Obligatory field. Normally used to decrease process priority.
Silent Show Messages 0 or 1Optional field.
Default (silent) =”1”
To show messages =”0”
Field Name Function Example More information
Return Code Description
0 Successful completion
2 Access denied
3 Insufficient privilege
8 Unknown failure
9 Path not found
21 Invalid parameter
Note Interactive remote processes have a maximum lag of one minute to start. Non-interactive
processes start right away.
© 2013 Tango/04 Computing Group Page 4
Running the Tools
When using this tool you can provide the domain, user and password required to start the program. If
you leave them blank the user profile that launches the program is used. If this user profile’s privileges
are not sufficient, you must provide a different user profile with the appropriate privileges.
The options when running T4ProcessNew.exe are listed in the following table:
To run the tool call the executable and enter the following parameters:
T4ProcessNew.exe Host User Domain Password Execpath Interactive Silent
For example:
T4ProcessNew.exe SERVER1 administrator Tango pass1 backup.exe 0 0
This will run backup.exe not interactively on server1 as administrator in the Tango domain.
If you tried to create a non-interactive process, the possible results are:
Field Name Function Example More information
HostSpecify computer Name/IP address
SERVER1 or 192.168.0.16
Obligatory field. For local computer enter “”
UserUsername needed to change process
administra-tor
Obligatory field. To use the information for the current login: “”
DomainEnter the name of the domain of the user profile
Tango
Obligatory field. Enter the domain name of the user profile. To use the informa-tion for the current login: “”
PasswordPassword for the username
pass1Obligatory field. To use the information for the current login: “”
ExecpathAbsolute or relative path for program execution
calc.exe or C:\Program Files\Tango04\VMC
Obligatory field.
InteractiveForce interactivity with remote pro-gram
0 or 1Obligatory field.
0 = not interactive
1 = interactive.
Silent Show Messages 0 or 1Optional field.
Default (silent) =”1”
Show messages =”0”
Return code Description
0 Successful completion
2 Access denied
3 Insufficient privilege
8 Unknown failure
9 Path not found
21 Invalid parameter
© 2013 Tango/04 Computing Group Page 5
Running the Tools
If you forced interactivity and therefore added a programmed task, the possible results are:
3.3 T4ProcessKillThis program allows you to kill all the processes with a specified name in a local or remote system
through WMI (Windows Management Instrumentation). This program uses the library:
WMIProcessKill.dll and stlport_vc646.dll.
You can provide the domain, user and password once you start the program. If you leave them blank the
user profile that launches the program is used. If this user profile’s privileges are not sufficient, you must
provide a different user profile with the appropriate privileges.
The options when running T4ProcessKill.exe are listed in the following table:
To run the tool call the executable and enter the following parameters:
T4ProcessKill.exe Host Domain User Password ProcessName
For example:
T4ProcessKill.exe SERVER1 Tango administrator pass1 calc.exe
Return code Description
0 The request is accepted.
1 The request is not supported.
2 The user does not have the necessary access.
8 Interactive Process.
9 The directory path to the service executable file cannot be found.
21 Invalid parameters have been passed to the service.
22The account that this service runs under is invalid or lacks the per-missions to run the service.
Field Name Function Example More information
HostSpecify computer Name/IP address
SERVER1 or 192.168.0.16
Obligatory field. For local computer enter “”
DomainEnter the name of the domain of the user profile
Tango
Obligatory field. Enter the domain name of the user profile. To use the infor-mation for the current login: “”
UserUsername needed to change process
administra-tor
Obligatory field. To use the information for the current login: “”
PasswordPassword for the username
pass1Obligatory field. To use the information for the current login: “”
ProcessNameUnique process name
calc.exe
Obligatory field. You can get this value from VISUAL Message Center SmartConsole
© 2013 Tango/04 Computing Group Page 6
Running the Tools
This will try to kill process calc.exe on SERVER1 in domain Tango with the user logged on as
administrator with password Pass1. The program will return a message to indicate whether a process
has been killed. This message also serves as verification that the program ran.
3.4 T4ShutdownT4Shutdown can shutdown or restart a Windows machine through WMI (Windows Management
Instrumentation). This program uses the libraries: T4Shutdown.dll and stlport_vc646.dll.
To run the program you must provide the server, domain name, user name, and password once you
start the program. If you leave them blank, program will use the user profile that launches the program.
If this user profile’s privileges are not sufficient, you must provide a different user profile with the
appropriate privileges.
The options when running T4Shutdown.exe are listed in the following table:
Command line options for T4Shutdown.exe
To run the tool call the executable and enter the following parameters:
T4Shutdown.exe Server DomainName UserName Password -r/-h ?Silent
For example:
T4Shutdown.exe mich TANGO marc passwordcorativo -r 0
This will reinitiate the machine MICH and a message will appear informing the user whether the server
received the command to restart.
T4Shutdown.exe mich TANGO marc passwordcorativo -h
Note You must check on the remote machine whether the process has been killed.
Field Name Function Example More information
ServerSpecify computer Name/IP address
SERVER1 or 192.168.0.16
Obligatory field. For local computer enter “”
DomainEnter the name of the domain of the user profile
Tango
Obligatory field. Enter the domain name of the user profile. To use the infor-mation for the current login: “”
UserUsername needed to change process
administra-tor
Obligatory field. To use the information for the current login: “”
PasswordPassword for the username
pass1Obligatory field. To use the information for the current login: “”
Halt/restartIndicate whether to halt (-h) or restart (-r) the machine
-r or -h Obligatory field.
SilentSilentor Show Mes-sages
0 or 1Optional field.
Default (silent) =”1”
Show messages =”0”
© 2013 Tango/04 Computing Group Page 7
Running the Tools
This command will shut down the machine MICH and a message appears informing the user whether
the command to shutdown arrived at the server.
3.5 ODBCTestODBCTest allows you to run any SQL Statement using an ODBC DSN connected to any database
system. The statement can retrieve data or perform a change in the database. This program uses the
libraries: ODBCQuery.dll, odbc++.dll and stlport_vc646.dll
You must provide the DSN name, user and password to connect to the database system, maximum
number of rows to retrieve (when statement retrieves data), the SQL statement and the execution mode.
If the silent flag is enabled, the statement does not generate any output.
The options when running ODBCTest.exe are listed in the following table:
To run the tool call the executable and enter the following parameters:
ODBCTest.exe DSName User Password NumberOfRows SQLStatement Silent
For example:
ODBCtest.exe SQLServer1 Administrator pass1 0 “update alarms set status = ‘SUCCESS’ where alarmcode = 2354’” 0
This will perform the update query on ODBC DSN SQLServer1 using the user profile administrator.
The program will return a message to indicate whether the statement has run successfully. This
message also serves as verification that the program ran.
3.6 CommandSenderThis tool uses two Java GUIs—the Connection Configuration Editor and the Command Creation Tool.
Using the iSeries Remote Command Sender to create automated actions that can be applied to any
iSeries host from a remote system, is a 3 step process:
Field Name Function Example More information
ODBCName DSN name SQLServer1Obligatory parameter that finds Data Source Names on your machine.
UserUsername needed to change process
adminis-trator
Obligatory parameter. To use the information for the current login: “”
PasswordPassword for the username
pass1Obligatory parameter. To use the information for the current login: “”
NumberOfRows
Returns specified number of Rows
50Obligatory parameter. Note that the number of rows only works for Select queries.
QuerySQL statement to exe-cute
select * from T4EventLog
Obligatory parameter.
Silent Show Messages 0 or 1Optional parameter.
Default (silent) =”1” To show messages =”0”
© 2013 Tango/04 Computing Group Page 8
Running the Tools
Step 1. Create a list of iSeries hosts – Using the Connection Configuration Editor
Step 2. Create a list of commands – Using the Command Creation Tool
Step 3. Configure SmartConsole to use the commands on the selected iSeries hosts—using
Command Sender
Each of these steps is explained in detail in this section.
3.6.1 Connection Configuration EditorThis application is located here:
C:\%Program Files%\Tango04\VISUAL Message Center\SmartConsole\Tools\ iSeriesCommand Sender
Using the Connection Configuration Editor, a Java application in which you enter Java System i Server
host name and port, you can retrieve a list of your remote iSeries hosts (with their IPs, user names and
passwords) and (later, with the Command Creation tool) apply as many commands as you wish to as
many of the hosts as you wish. The Connection Configuration Editor produces AES-encrypted files in
the following file format:
[IP]_[username].icd
Double-click the ConnectionConfigurationEditor.jar file to open it. The following window will
appear:
Note For ThinkServer versions lower than V1.6 SP03 HF05, the CommandSender tool is based
on Apache’s Axis1 technology. However, beginning with ThinkServer V1.6 SP03 HF05, the
CommandSender tool is based on Axis2 technology, and therefore another
CommandSender tool must be used: it can be found in the folder:
C:\%Program Files%\Tango04\VISUAL Message Center\SmartConsole\ Tools\v2\iSeriesCommand Sender
© 2013 Tango/04 Computing Group Page 9
Running the Tools
Figure 1 – The Connection Configuration Editor lets you generate a list of iSeries hosts that you can run commands on
To add an iSeries host:
Step 1. In the Hostname and Port fields, enter a desired Java System i Server host name and
port.
Step 2. In the System i Hostname or IP Address field, enter the name of the iSeries hosts
that share the same username and password, and click the Add button.
Step 3. The iSeries appears in the list box, and then, you can enter a username and password
required to access the iSeries.
After completing the list of iSeries hosts to be available to the Command Sender tool, press the Save
button. When you press the Save button, the application will ask you where you want to store the icd
files. Select a location and an encrypted icd file will be created for each of the iSeries hosts in the list.
If you wish to create a new list on a new Java System i Server, click the New button: all the fields will be
reset and ready to add a new configuration.
Using the Load button to load an .icd file will restore all the configuration settings, including all the
iSeries hosts available, not just the host for the icd file you have chosen to open.
3.6.2 Command Creation ToolThe Command Creation Tool is a Java application that uses the Java toolbox to create commands,
which can later be used by the Command Sender in VISUAL Message Center SmartConsole. These
commands are stored in a .txt file.
© 2013 Tango/04 Computing Group Page 10
Running the Tools
The application is located here (depending on your version of ThinkServer):
C:\%Program Files%\Tango04\VISUAL Message Center\SmartConsole\ Tools\iSeries CommandSender
or
C:\%Program Files%\Tango04\VISUAL Message Center\SmartConsole\ Tools\v2\iSeriesCommand Sender
Double-click the CommandCreationTool.jar file to open it, the following window will open:
Figure 2 – Entering commands
To use the Command Creation Tool you have to connect to an iSeries host for validation purposes.
To create a command:
Step 1. Enter the host name, username and password in the fields provided, then
Step 2. Either:
− select a command to add to the list from the Command list-box; or
− select Custom Command from the drop-down list box and enter a command in the Custom
Command field.
Step 3. Click the Add button. The application will use the iSeries host details to connect to the
iSeries to verify the command, and open the following window, where you are prompted
to enter further details for the command. Click the Advanced button to see further
details about the command.
Tip It is not necessary to use the Command Creation Tool to create commands, you can also
create the commands manually if you prefer and save them in a .txt file. In the .txt file, the list
of commands has to be inside double quotation marks, and commands must be separated
from each other with %%%. For example: DLYJOBDLY(300)%%%HLDJOBHLD(50)
Note This host is only used to validate the commands you create; it does not restrict the use of the
command in SmartConsole to this host exclusively.
© 2013 Tango/04 Computing Group Page 11
Running the Tools
Figure 3 – Advanced command details
After completing the list of commands to be available to the Command Sender tool, press the Save
button, and enter the name and location of the .txt file.
A list of all the available commands created will appear In the Selectable command string field.
If you wish to create a new list of commands, click the New button: all the fields will be reset and ready
to add a new configuration.
3.6.3 Configuring SmartConsole Inside SmartConsole we can now bring all the elements together:
• Configure a new Action Set and specify the path to the CommandSender.exe.
• Specify which of the icd files (created using the Connection Configuration Editor) to use in
order to connect to the appropriate iSeries host.
• Add the list of commands (created using the Command Creation Tool).
Command Sender Action Sets
An Action Set is used in the SmartConsole to combine all the elements needed for sending remote
commands.
To create a new Action Set in VISUAL Message Center SmartConsole:
Step 1. Click Change from the menu bar and select Action Sets to open the ‘Action Sets’
configuration menu (you can also click the Action sets icon in the toolbar)
Step 2. Click Options from the menu bar and select New > Action Set (alternatively click the
New icon in the toolbar)
To configure the Action Set:
Step 1. Select the Execute a PC Program check box
Step 2. Click the PCProgram tab
Step 3. In the Command field, enter the location of the CommandSender.exe: The default location, depending on your version of ThinkServer is:
Note You can copy and paste the string of commands directly into SmartConsole. Remember to
separate commands from each other with %%%.
© 2013 Tango/04 Computing Group Page 12
Running the Tools
C:\%Program Files%\Tango04\VISUAL Message Center\Tools\ iSeriesCommandSender
or
C:\%Program Files%\Tango04\VISUAL Message Center\SmartConsole\Tools\ iSeriesCommandSender
Step 4. In the Parameters field, enter:
− &EVENTID
− The name of the .icd file. The icd files are stored in the ‘iSeriesCommandSender’
folder; you can browse this folder to check the correct name of the file.
− The commands to run (commands must be separated by %%%). Refer to the .txt file
containing the commands created using the Command Creation Tool.
Figure 4 – Configure the Action Set
Step 5. Click OK
Step 6. Enter a name for the new Action Set (iSeries Command Sender, for example).
© 2013 Tango/04 Computing Group Page 13
Running the Tools
Figure 5 – The new ‘iSeries Command Sender’ Action Set in the Action Set list
Command Sender Alarms
Alarms are used to automate the actions specified in the Action Sets configured for the Command
Sender.
To set an alarm to use the Command Sender Action Set:
Step 1. Click Change from the menu bar and select Alarms to open the ‘Alarms’ configuration
menu (you can also click the Alarms icon in the toolbar)
Step 2. Click Options from the menu bar and select New > Alarm (alternatively click the New
icon in the toolbar)
Step 3. In the ‘Alarm filters’ window, select the system to include in the alarm from the System
filter option in the General tab, and Click OK
Step 4. Click the Action Sets tab of the ‘Alarm Actions’ configuration window, select the ‘iSeries
Command Sender’ Action Set that you previously configured, from the drop-down list
box, and click Add.
© 2013 Tango/04 Computing Group Page 14
Running the Tools
Figure 6 – Select the ‘iSeries Command Sender’ Action Set to use with the alarm from the list box
Step 5. Click OK and enter a name for the new alarm.
Figure 7 – The new ‘Command Sender’ alarm in the Alarms list
© 2013 Tango/04 Computing Group Page 15
Appendix A : Contacting Tango/04
Appendix AAppendix A: Contacting Tango/04
North America
Tango/04 North America
PO BOX 3301
NH 03458 Peterborough USA
Phone: 1-800-304-6872 / 603-924-7391
Fax: 858-428-2864
www.tango04.com
EMEA
Tango/04 Computing Group S.L.
Avda. Meridiana 358, 5 A-B
08027 Barcelona Spain
Phone: +34 93 274 0051
Fax: +34 93 345 1329
www.tango04.com
Italy
Tango/04 Italy
Viale Garibaldi 51/53
13100 Vercelli Italy
Phone: +39 0161 56922
Fax: +39 0161 259277
www.tango04.it
Sales Office in France
Tango/04 France
La Grande Arche
Paroi Nord 15ème étage
92044 Paris La Défense France
Phone: +33 01 40 90 34 49
Fax: +33 01 40 90 31 01
www.tango04.fr
Sales Office in Switzerland
Tango/04 Switzerland
18, Avenue Louis Casaï
CH-1209 Genève
Switzerland
Phone: +41 (0)22 747 7866
Fax: +41 (0)22 747 7999
www.tango04.fr
Latin American Headquarters
Barcelona/04 Computing Group SRL (Argentina)
Avda. Federico Lacroze 2252, Piso 6
1426 Buenos Aires Capital Federal
Argentina
Phone: +54 11 4774-0112
Fax: +54 11 4773-9163
www.barcelona04.com
© 2013 Tango/04 Computing Group Page 16
Sales Office in Peru
Barcelona/04 PERÚ
Centro Empresarial Real
Av. Víctor A. Belaúnde 147, Vía Principal 140 Edificio Real Seis, Piso 6
L 27 Lima
Perú
Phone: +51 1 211-2690
Fax: +51 1 211-2526
www.barcelona04.com
Sales Office in Chile
Barcelona/04 Chile
Nueva de Lyon 096 Oficina 702,
Providencia
Santiago
Chile
Phone: +56 2 234-0898
Fax: +56 2 2340865
www.barcelona04.com
© 2013 Tango/04 Computing Group Page 17
About Tango/04 Computing Group
Tango/04 Computing Group is one of the leading developers of systems management and automation
software. Tango/04 software helps companies maintain the operating health of all their business
processes, improve service levels, increase productivity, and reduce costs through intelligent
management of their IT infrastructure.
Founded in 1991 in Barcelona, Spain, Tango/04 is an IBM Business Partner and a key member of IBM's
Autonomic Computing initiative. Tango/04 has more than a thousand customers who are served by over
35 authorized Business Partners around the world.
Alliances
Awards
Partnerships IBM Business Partner
IBM Autonomic Computing Business Partner
IBM PartnerWorld for Developers Advanced Membership
IBM ISV Advantage Agreement
IBM Early code release
IBM Direct Technical Liaison
Microsoft Developer Network
Microsoft Early Code Release
© 2013 Tango/04 Computing Group Page 18
Legal Notice
The information in this document was created using certain specific equipment and environments, and it is limited in
application to those specific hardware and software products and version and releases levels.
Any references in this document regarding Tango/04 Computing Group products, software or services do not mean
that Tango/04 Computing Group intends to make these available in all countries in which Tango/04 Computing Group
operates. Any reference to a Tango/04 Computing Group product, software, or service may be used. Any functionally
equivalent product that does not infringe any of Tango/04 Computing Group's intellectual property rights may be used
instead of the Tango/04 Computing Group product, software or service
Tango/04 Computing Group may have patents or pending patent applications covering subject matter in this
document. The furnishing of this document does not give you any license to these patents.
The information contained in this document has not been submitted to any formal Tango/04 Computing Group test
and is distributed AS IS. The use of this information or the implementation of any of these techniques is a customer
responsibility, and depends on the customer's ability to evaluate and integrate them into the customer's operational
environment. Despite the fact that Tango/04 Computing Group could have reviewed each item for accurateness in a
specific situation, there is no guarantee that the same or similar results will be obtained somewhere else. Customers
attempting to adapt these techniques to their own environments do so at their own risk. Tango/04 Computing Group
shall not be liable for any damages arising out of your use of the techniques depicted on this document, even if they
have been advised of the possibility of such damages. This document could contain technical inaccuracies or
typographical errors.
Any pointers in this publication to external web sites are provided for your convenience only and do not, in any
manner, serve as an endorsement of these web sites.
The following terms are trademarks of the International Business Machines Corporation in the United States and/or
other countries: iSeries, iSeriese, iSeries, i5, DB2, e (logo)®Server IBM ®, Operating System/400, OS/400, i5/OS.
Microsoft, SQL Server, Windows, Windows NT, Windows XP and the Windows logo are trademarks of Microsoft
Corporation in the United States and/or other countries. Java and all Java-based trademarks and logos are
trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and/or other countries. UNIX is a
registered trademark in the United States and other countries licensed exclusively through The Open Group. Oracle
is a registered trade mark of Oracle Corporation.
Other company, product, and service names may be trademarks or service marks of other companies.
© 2013 Tango/04 Computing Group Page 19