Effects of starting Performance Analyzer - without installing the Reports and Domain Definitions component.
Here I will describe what are the possible situations where you can possibly get the DB Connection failure message when you click on the Performance Analyzer Configuration button on the TEPS GUI.
This can potentially happen if the PA Report and Domain Defintions component is not installed and the TEPS is reconfigured. Until then this error will occur.
Some of the scenarios:
1. ITM is installed and you clicked on the PA configuration button, without installing the Performance Analyzer Reports and Domains component.
2. ITM is installed, OS Agent is installed an you brought up TEPS and clicked on the PA configuration button. ( without installing the PA Report and Domains component)
3. ITM is installed , OS Agent is installed , PA Reports and Domain Definitions is installed but the TEPS is not reconfigured .
4. ITM is installed, ITPA Reports and Domain is installed - but the OS Agent is not installed !( this was found on one such installation on a Windows server )
Below - I will walk thru the scenarios and show the error messages until the Reports and Domain is installed.
1. ITM installed ( All base components )
2. OS Agent is *not installed.
3. Performance Analyzer Reports and Domain *not installed.
4 PA was configured to a Database successfully and started( I have not installed the Reports and Domain Defn's) but I can start it nevertheless. This can lead to the DB connection failure.
Even starting the Tivoli Performance Analyzer Agent will not help. ( note that I have not installed domain definitions.)
Installing the "lz" oS Agent. and configuring the Linux OS Agent- will not relieve this error either.
[root@nc184132 ~]# diff before afterlz
2c2
< *********** Tue Aug 13 05:22:40 CDT 2013 ******************
---
> *********** Tue Aug 13 07:11:27 CDT 2013 ******************
21a22
> lz Monitoring Agent for Linux OS li6263 06.23.01.00 20471 20130813 0653 <=== Linux OS Agent gets installed
23a25,29
> r2 Agentless Monitoring for Windows Operating Systems li6263 06.23.01.00 201111221341 20130813 0653 <== other OS Agents gets installed as well.
> r3 Agentless Monitoring for AIX Operating Systems li6263 06.23.01.00 201111221343 20130813 0653
> r4 Agentless Monitoring for Linux Operating Systems li6263 06.23.01.00 201111221345 20130813 0653
> r5 Agentless Monitoring for HP-UX Operating Systems li6263 06.23.01.00 201111221347 20130813 0653
> r6 Agentless Monitoring for Solaris Operating Systems li6263 06.23.01.00 201111221348 20130813 0653
27a34
> uf Universal Agent Framework li6263 06.23.01.00 d2025a 20130813 0654
28a36,37
> ul Monitoring Agent for UNIX Logs li6263 06.23.01.00 13531 20130813 0653
> um Universal Agent li6263 06.23.01.00 d2025a 20130813 0654
Notice that the PA still does not have the domain - but the OS Agent attributes show up.
Still the DB COnnection failure occurs.
( configuring TEPS - will not help ). - itmcmd config -A cq - does not help.
The message clearly says " DB Connection failure"
or "PA tables does not exist"
Now, Install the PA "Reports and Domains Definitions component" ,and configure TEPS.
If after installing the ITM, ITPA Reports and Domain Definitions and the OS Agent still gets you to the DB connection failure error, then
1. Check the DB tables and see if the KPA tables are present.
They will typically be listed at the top of the list ( connect to WAREHOUS, list tables for all )
This gets installed as part of the ITM - Base PA component. If they are not - you need to reinstall the ITM PA components.
Reinstall Base ITM Installation ( There is no need to reinstall the ITPA report and Domains, only the Base ITM - PA component is enough. )
./install.sh
Product packages are available for this operating system and component support categories:
1) IBM Tivoli Monitoring components for this operating system <======
2) Tivoli Enterprise Portal Browser Client support
3) Tivoli Enterprise Portal Desktop Client support
4) Tivoli Enterprise Portal Server support
5) Tivoli Enterprise Monitoring Server support
6) Other operating systems
Type the number or type "q" to quit selection
[ number "1" or "IBM Tivoli Monitoring components for this operating system" is default ]: 1
You selected number "1" or "IBM Tivoli Monitoring components for this operating system"
Is the selection correct [ 1=Yes, 2=No ; default is "1" ] ? 1
The following products are available for installation:
1) Summarization and Pruning Agent V06.23.01.00
2) Tivoli Enterprise Monitoring Server V06.23.01.00
3) Tivoli Enterprise Portal Desktop Client V06.23.01.00
4) Tivoli Enterprise Portal Server V06.23.01.00
5) Tivoli Enterprise Services User Interface Extensions V06.23.01.00
6) Tivoli Performance Analyzer V06.23.01.00 <=============
7) Warehouse Proxy V06.23.01.00
8) all of the above
Type the numbers for the products you want to install, type "b" to change operating system, or type "q" to quit selection.
If you enter more than one number, separate the numbers by a comma or a space.
Type your selections here: 6
Type your selections here: 6
The following products will be installed:
Tivoli Performance Analyzer V06.23.01.00
Are your selections correct [ 1=Yes, 2=No ; default is "1" ] ? 1
KCIIN2385W
WARNING - you are about to install the SAME version of "Tivoli Performance Analyzer V06.23.01.00"
Do you want to install the SAME version [ 1=Yes, 2=No ; default is "2" ] ? 1
... installing "Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit)"; please wait.
=> installed "Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit)".
... Initializing component Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit).
... Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit) initialized.
Do you want to install additional products or product support packages [ 1=Yes, 2=No ; default is "2" ] ? 2
... postprocessing; please wait.
Will install the required KPA tables.
[ I have seen that due to some circumstances that this does not happen occasionally, so retry, Stop Database, and so on until this is resolved.]]
[[ If this does not gets installed by the base ITM, then installing the OS agent, or the ITPA reports and domains component will not help - as these are critical for the overlying components to work ]]
KPAATTR ITMUSER T 2013-08-14-04.11.22.449223
KPACONF ITMUSER T 2013-08-14-04.11.24.016938
KPACONSTRAINTS ITMUSER T 2013-08-14-04.11.22.790563
KPADOMAINS ITMUSER T 2013-08-14-04.11.23.864283
KPAEXCCONSTR ITMUSER T 2013-08-14-04.11.23.782160
KPAEXCEPTIONS ITMUSER T 2013-08-14-04.11.23.705660
KPAFOLDERS ITMUSER T 2013-08-14-04.11.23.611851
KPAIDENTDESTS ITMUSER T 2013-08-14-04.11.22.885313
KPAIDENTSRCS ITMUSER T 2013-08-14-04.11.22.974005
KPAJOINS ITMUSER T 2013-08-14-04.11.23.074940
KPALOCK ITMUSER T 2013-08-14-04.11.23.244406
KPANODES ITMUSER T 2013-08-14-04.11.22.592611
KPAOUTPUTS ITMUSER T 2013-08-14-04.11.22.699775
KPAOUTPUTSETS ITMUSER T 2013-08-14-04.11.23.163996
KPAPROPS ITMUSER T 2013-08-14-04.11.22.149638
KPASPSSTASKS ITMUSER T 2013-08-14-04.11.23.517487
KPATASKS ITMUSER T 2013-08-14-04.11.21.940059
KPATFRAMES ITMUSER T 2013-08-14-04.11.23.343293
UTF8TEST ITMUSER T 2013-08-13-06.07.36.412148
WAREHOUSEAGGREGLOG ITMUSER T 2013-08-14-02.00.10.858927
WAREHOUSEID ITMUSER T 2013-08-13-06.07.37.170945
./install.sh
All agents require that application support files that contain agent-specific information be installed on the Tivoli Enterprise Monitoring Server that the agents will connect to, Tivoli Enterprise Portal Server and Tivoli Enterprise Portal desktop and browser client. Install application support before starting to install any Tivoli Enterprise Monitoring Agents.
Product packages are available for this operating system and component support categories:
1) IBM Tivoli Monitoring components for this operating system
2) Tivoli Enterprise Portal Browser Client support
3) Tivoli Enterprise Portal Desktop Client support
4) Tivoli Enterprise Portal Server support
5) Tivoli Enterprise Monitoring Server support
6) Other operating systems
Type the number or type "q" to quit selection
[ number "1" or "IBM Tivoli Monitoring components for this operating system" is default ]: 1
You selected number "1" or "IBM Tivoli Monitoring components for this operating system"
Is the selection correct [ 1=Yes, 2=No ; default is "1" ] ? 1
The following products are available for installation:
1) Summarization and Pruning Agent V06.23.01.00
2) Tivoli Enterprise Monitoring Server V06.23.01.00
3) Tivoli Enterprise Portal Desktop Client V06.23.01.00
4) Tivoli Enterprise Portal Server V06.23.01.00
5) Tivoli Enterprise Services User Interface Extensions V06.23.01.00
6) Tivoli Performance Analyzer V06.23.01.00
7) Warehouse Proxy V06.23.01.00
8) all of the above
Type the numbers for the products you want to install, type "b" to change operating system, or type "q" to quit selection.
If you enter more than one number, separate the numbers by a comma or a space.
Type your selections here: 6
The following products will be installed:
Tivoli Performance Analyzer V06.23.01.00
Are your selections correct [ 1=Yes, 2=No ; default is "1" ] ? 1
KCIIN2385W
WARNING - you are about to install the SAME version of "Tivoli Performance Analyzer V06.23.01.00"
Do you want to install the SAME version [ 1=Yes, 2=No ; default is "2" ] ? 1
... installing "Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit)"; please wait.
=> installed "Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit)".
... Initializing component Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit).
... Tivoli Performance Analyzer V06.23.01.00 for Linux Intel R2.6 (32 bit) initialized.
Do you want to install additional products or product support packages [ 1=Yes, 2=No ; default is "2" ] ? 1
Product packages are available for this operating system and component support categories:
1) IBM Tivoli Monitoring components for this operating system
2) Tivoli Enterprise Portal Browser Client support
3) Tivoli Enterprise Portal Desktop Client support
4) Tivoli Enterprise Portal Server support
5) Tivoli Enterprise Monitoring Server support
6) Other operating systems
Type the number or type "q" to quit selection
[ number "1" or "IBM Tivoli Monitoring components for this operating system" is default ]: 4
You selected number "4" or "Tivoli Enterprise Portal Server support"
Is the selection correct [ 1=Yes, 2=No ; default is "1" ] ? 1
The following application supports are available for installation:
1) Agentless Monitoring for AIX Operating Systems V06.23.01.00
2) Agentless Monitoring for HP-UX Operating Systems V06.23.01.00
3) Agentless Monitoring for Linux Operating Systems V06.23.01.00
4) Agentless Monitoring for Solaris Operating Systems V06.23.01.00
5) Agentless Monitoring for Windows Operating Systems V06.23.01.00
6) Monitoring Agent for IBM Tivoli Monitoring 5.x Endpoint V06.23.01.00
7) Monitoring Agent for Linux OS V06.23.01.00
8) Monitoring Agent for UNIX Logs V06.23.01.00
9) Monitoring Agent for UNIX OS V06.23.01.00
10) Monitoring Agent for Windows OS V06.23.01.00
11) Monitoring Agent for i5/OS V06.23.01.00
12) Summarization and Pruning Agent V06.23.01.00
13) TEC GUI Integration V06.23.01.00
14) Tivoli Performance Analyzer V06.23.01.00
15) Universal Agent V06.23.01.00
16) Warehouse Proxy V06.23.01.00
17) all of the above
Type the numbers for the products you want to install, type "b" to change operating system, or type "q" to quit selection.
If you enter more than one number, separate the numbers by a comma or a space.
Type your selections here: 14
The following products will be installed:
Tivoli Performance Analyzer V06.23.01.00
Are your selections correct [ 1=Yes, 2=No ; default is "1" ] ? 1
KCIIN2385W
WARNING - you are about to install the SAME version of "Tivoli Performance Analyzer V06.23.01.00"
Do you want to install the SAME version [ 1=Yes, 2=No ; default is "2" ] ? 1
... installing "Tivoli Performance Analyzer V06.23.01.00 for Tivoli Enterprise Portal Server support"; please wait.
=> installed "Tivoli Performance Analyzer V06.23.01.00 for Tivoli Enterprise Portal Server support".
... Initializing component Tivoli Performance Analyzer V06.23.01.00 for Tivoli Enterprise Portal Server support.
... Tivoli Performance Analyzer V06.23.01.00 for Tivoli Enterprise Portal Server support initialized.
