Tuesday, March 25, 2014

Performance Analyzer Related Configuration Files.

 /opt/IBM/ITM/li6263/pa/bin/kpacma -d -f /opt/IBM/ITM/li6263/pa/config >> /opt/IBM/ITM/logs/nc9118041057_pa_1395381161.log 2>&1


Performance Analyzer Backend related files.

/opt/IBM/ITM/li6263/pa/bin/kpa.ref ( to be completed )

History files.
/opt/IBM/ITM/li6263/pa/hist
This will contain the DB files as shown:
LTCDSKUTIL      LTCNETTIN       LTFCPUUTIL      LTFMEMUTIL      LTFNETTOUT
DISKHEALTH    KPAMAGENT.hdr   LTCDSKUTIL.hdr


Logging files:  to increase the logging statements in kpacma.log

Linux
/opt/IBM/ITM/li6263/pa/config

Windows
c:\IBM\ITM\TMAITM6\config

1.
init.cfg

AgentIdUniqueId__file=local.cfg
ConsolePassword__file=local.cfg
DisableVACM=true
EngineBoots__file=local.cfg
LogCount=3
LogFile=/opt/IBM/ITM/logs/kpacma.log
LogLevel=Debug  <=============          Default is 'Info'
LogSize=10000000
NotificationQueueLimit=50
UdpPort=-1

2.
agent.cfg ( will contain all the necessary conffigurations to the Database )

#
# HARMONi Suite 2.1 configuration file
#
set verbose off

#
# Default Communities
#
community add default public RC
community add default private RC

#
# Subagent Section
#
subagent load analytic
subagent load fastira
subagent load fastarithmetic
subagent load fastlineartrend
#subagent load spsstrend
subagent load tasksimp

analytic NLT_DELETE_TEMP_FILES=true
# TDW Database Connection
TDW_DB_TYPE=ORACLE
analytic TDW_DB_TYPE=ORACLE
analytic TDW_DB_CONN_TYPE=JDBC
analytic TDW_DB_DRIVER=oracle.jdbc.driver.OracleDriver
analytic TDW_DB_DSN="jdbc:oracle:thin:@9.118.40.55:1521:WAREHOUS"
analytic TDW_DB_USER=ITMUser
analytic TDW_DB_PASSWD={AES256:keyfile:a}9CkT33tCZk4crv846GvEAw==
analytic TDW_DB_SCHEMA=ITMUser
analytic SPSS.Home=/opt/IBM/SPSS/StatisticsServer20
analytic SPSS.Enabled=false
analytic TEP_TMSC=ip.pipe:nc9118041057
analytic start




Configuration Files used during startup:

pa.config   pa_dd_062301000.xml  
pa_dd.properties  
pa.ini  


pa_dd_062300.xml has
<label msgKey="KPA3000">Data Warehouse</label>

                <property name="TDW_AGNT_DB_CONNTYPE" editable="false" type="restricted"
                        required="true" defaultValue="odbc">
                        <label msgKey="KPA3015">Agent Database Connection Type</label>
                        <description msgKey="KPA3016">The agent supports JDBC and ODBC connections</description>
                        <values>
                                <value name="jdbc">

This helps during the launching of the MTEMS and PA configuration.
If you remove this file -then

pa.config
You can delete it  - then gets recreated again - and again every time you restart the PA agent.
It looks at the pa.ini file and recreates the file.

pa.ini   Investigating who creates this, but PA reads it every time it starts
Windows :


Linux:  
# =============================================
# Generic Settings
# =============================================
KGL_KGLMSGBASE=$CANDLEHOME$/$ARCHITECTURE$/bin/KGLMSENU
ATTRLIB=$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/tables/ATTRLIB
CT_CMSLIST=$NETWORKPROTOCOL$:$HOSTNAME$;$HSNETWORKPROTOCOL$$MIRROR$
CTIRA_HIST_DIR=$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/hist/$INSTANCE$
CTIRA_LOG_PATH=$CANDLEHOME$/logs
CTIRA_SIT_PATH=$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/bin
KBB_SIG1=-asyncoff -syncoff -dumpoff
KBB_ACF1_PATH=$CANDLEHOME$/$ARCHITECTURE$/bin
KBB_RAS1=ERROR
KBB_ENVPATH=$CANDLEHOME$/config/pa.config
JAVA_HOME=$JAVAHOME$
KDC_FAMILIES=$NETWORKPROTOCOL$
LOGSHOME=$CANDLEHOME$/logs
LD_LIBRARY_PATH=$ICCRTE_DIR$/$GSKLIB$:$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/lib:$CANDLEHOME$/$ARCHITECTURE$/lib:$JAVAHOME$/bin:$JAVAHOME$/bin/classic:$JAVAHOME$/lib/sparc/client:$JAVAHOME$/lib/sparc
LIBPATH=$ICCRTE_DIR$/$GSKLIB$:$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/lib:$CANDLEHOME$/$ARCHITECTURE$/lib:$JAVAHOME$/bin:$JAVAHOME$/bin/classic:$JAVAHOME$/lib/ppc:$JAVAHOME$/lib/ppc64
PATH=/bin:/usr/bin:$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/bin:$CANDLEHOME$/$ARCHITECTURE$/bin
SHLIB_PATH=$ICCRTE_DIR$/$GSKLIB$:$CANDLEHOME$/$BINARCH$/$PRODUCTCODE$/lib:$CANDLEHOME$/$ARCHITECTURE$/lib
SQLLIB=$CANDLEHOME$/tables/cicatrsq/SQLL

pa_dd.properties :
Mappings .

# NLS_MESSAGEFORMAT_VAR
# NLS_ENCODING=UNICODE

KPA1000=Tivoli Performance Analyzer
KPA1001=DB2
KPA1002=MSSQL
KPA1003=ORACLE
KPA1004=JDBC
KPA1005=ODBC
KPA1006=YES
KPA1007=NO
KPA1008=YES
KPA1009=NO
KPA1010=TRUE
KPA1011=FALSE

KPA2023=Initialize PA tables
KPA2027=This removes the existing PA tables in the database and recreates them.


KPA3000=Data Warehouse
KPA3001=Database Type
KPA3002=Choose the Tivoli Data Warehouse database type.
KPA3003=Hostname
KPA3004=The Tivoli Data Warehouse database hostname
KPA3005=Port
KPA3006=The Tivoli Data Warehouse database port number
KPA3007=Database Name
KPA3008=The name of the Tivoli Data Warehouse database
KPA3009=Schema
KPA3010=The Tivoli Data Warehouse database schema
KPA3011=Username
KPA3012=The Tivoli Data Warehouse database username

==============================


Windows :
c:\IBM\ITM\TMAITM6\
 
kpaconf.properties
DB.ConnectionType=jdbc
DB.Hostname=co9118051168.in.ibm.com
DB.Portnum=1521
DB.UrlPrefix=jdbc:oracle:thin:@
DB.JDBCDriverClass=oracle.jdbc.driver.OracleDriver
DB.Database=:WAREHOUS
DB.Username=system
DB.Password={AES256:keyfile:a}C40MDNfQnPXXpFimWxRUnw==
DB.Data.Database=WAREHOUS
Show.Unconfigured.HistGroups=true
ITM.Home=C:\\IBM\\ITM



kpacma.log
Linux:
/opt/IBM/ITM/logs

Windows :
c:\IBM\ITM\TMAITM6\logs
A sample of what PA reads - is in the "kpacma.log" after the logs are enabled.
....
....
 
2014-03-24 15:06:55: TImpMainTask: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: TImpMainTask: CANDLEHOME is C:\IBM\ITM
2014-03-24 15:06:55: TImpMainTask: config dir C:\IBM\ITM\TMAITM6\Config
2014-03-24 15:06:55: TImpMainTask: root dir C:\IBM\ITM\TMAITM6\
2014-03-24 15:06:55: TImpMainTask: todeploy dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: deployed dir C:\IBM\ITM\TMAITM6\Config/deployed
2014-03-24 15:06:55: TImpMainTask: No sql files found in dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: processFiles failed.
2014-03-24 15:06:55: DONT_TRIM_MSNS=
2014-03-24 15:06:55: MSN trimming is enabled
2014-03-24 15:06:55: Using jvm classpath C:\IBM\ITM\TMAITM6\kpaxjdbc.jar;C:\Downloads\ojdbc5.jar
2014-03-24 15:06:55: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-24 15:06:55: Cannot find JNI_CreateJavaVM function in loaded jvm !
2014-03-24 15:06:55: JNI_CreateJavaVM returns 0
2014-03-24 15:06:55: Error loading VM
2014-03-24 15:06:55: Adding Task <ConfigParser>
2014-03-24 15:06:55: Adding Task <GarbageCollectorTask>
2014-03-24 15:06:55: OUTPUT_KEEPER_DUMP is ''
2014-03-24 15:06:55: Entering task controller execution loop
2014-03-24 15:06:55: Checking config parser task: <ConfigParser>
2014-03-24 15:06:55: JDBCConnection::Connect: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS
2014-03-24 15:06:55: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS connected
2014-03-24 15:06:55: Failed to connect to TEPS database
2014-03-24 15:06:55: Checking if there is any user task going to be run 



I was able to resolve the above message by installing the 32 bit Oracle ODBC client on the server.

The updated log file now shows:

2014-03-25 15:18:52: Agent running - 6 subagents active
2014-03-25 15:18:52: [TRAPS] Could not find any trap targets
2014-03-25 15:18:52: TImpMainTask: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-25 15:18:52: TImpMainTask: CANDLEHOME is C:\IBM\ITM
2014-03-25 15:18:52: TImpMainTask: config dir C:\IBM\ITM\TMAITM6\Config
2014-03-25 15:18:52: TImpMainTask: root dir C:\IBM\ITM\TMAITM6\
2014-03-25 15:18:52: TImpMainTask: todeploy dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-25 15:18:52: TImpMainTask: deployed dir C:\IBM\ITM\TMAITM6\Config/deployed
2014-03-25 15:18:52: TImpMainTask: No sql files found in dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-25 15:18:52: TImpMainTask: processFiles failed.
2014-03-25 15:18:53: LoadAgents called
2014-03-25 15:18:53: DONT_TRIM_MSNS=
2014-03-25 15:18:53: MSN trimming is enabled
2014-03-25 15:18:53: Using jvm classpath C:\IBM\ITM\TMAITM6\kpaxjdbc.jar;C:\Downloads\ojdbc5.jar
2014-03-25 15:18:53: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-25 15:18:53: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-25 15:18:54: Returned from kramain()
2014-03-25 15:18:54: GenIraManager::CreateCtira() called
2014-03-25 15:18:54: RequestDetail {
2014-03-25 15:18:54:    sample_type = 0x1
2014-03-25 15:18:54:    interval = 3600000 ms
2014-03-25 15:18:54:    situation = 'CPU_NLT_TimeToWarnTh_1W'
2014-03-25 15:18:54:    predicates = 0x2390042a
2014-03-25 15:18:54:    destination =
CO9118051168:PA
2014-03-25 15:18:54:    } 
 




 

Summarization and Pruning log file:

Windows :
c:\IBM\ITM\logs
e.g: 
<hostname>-sy-<number>.log
co9118051168_sy_532ab2bb-01.log 

Linux :
/opt/IBM/ITM/logs
e.g: nc9118041057_sy_xa_531d9029-01.log


Trouble shooting PA :
To install the 32bit ODBC connection, please visit my other blog on installing the Oracle Client.

No comments:

Post a Comment