Installing PHP 5.3 on Windows 7 Professional.

Installing PHP on windows. ( since I want to set up my own WAMP server i.e Windows - Apache-MySQL and PHP  )

Go to this link where the PHP installer can be downloaded.

http://in.php.net/downloads.php



Download the installer



Run the executable
Accept the License Agreement.
( I did not accept any web server to be setup - as I had my own TomCat Apache web server. )

No changes here.


Run the installer - by choosing my directory to be installed and that was it.

This installs the PHP.

How to disable sysadmin password on ITM .

(Opinions and views are my own and not of my employer )

This was tested on ITM (IBM TIVOLI MONITORING ) 6.2.3 and I  believe it holds true for later versions also.

If after configuring the ITM and you want to disable the password , go to MEMS-> TEMS  Right click -> Configure and check on the "Advanced Settings Tab" and uncheck the "Security Validate User" checkbox.
Save and restart the TEMS.

This will let you login to ITM without entering the password.

See second snapshot below:




Not required.

Historical Data collection database query failed on the Perfomance Analyzer.

[Views and opinions are my own and not of my employer ]

Troubleshooting tips on the Performance Analyzer


This is an error you get if the ODBC connection is not configured right.
I found this on Windows and below are some details.
tested on : ITM 623fp1

See, the Usernameand schema - and the last Error - there is some error.




To resolve this.
Go to the MEMS console and Performance Analyzer and I had to change it to the appropriate user.


test the connection and restart the Performance Agent.
This should resolve the issue.

Changing/resetting sysadmin password on Tivoli Enterprise Portal Server.

[ Opinions and views expressed are my own and does not reflect my employer )

( This article is written for Windows. )
ITM : IBM Tivoli Monitoring

If after installation of ITM 6.x ( in my case it was 623 fp1 ) you forgot the 'sysadmin' password during startup of the Tivoli Enterprise Portal Server , then open a command prompt and issue this command

net user sysadmin <new_password>

This should reset the password,and start loading the workspaces.

Stopping and Deleting Performance Analyzer Historical Collections.

Simple script to stop the ITPA ( performance Analyzer) Historical Collection  using the tacmd command.

This was tested on a AIX server and on ITM 623FP1.


Stop Historical Collection of Tivoli Performance Analyzer.

tacmd   histstopcollection

#!/bin/bash

DOMCODE=KP3
export PATH=$PATH:/opt/IBM/ITM/bin:.


# If you want to specify user and password apennd the following parameters after %COMPUTERNAME%:
# -u sysadmin -p password
tacmd tepslogin -s `hostname`

tacmd histstopcollection -a System_Health -m *AFT_PERF_ANALYZER_WHSE_AGENT

.... Likewise other Attribute Groups.
 

Delete Historical Collection
(you don't need the -t and the -o option )

tacmd tepslogin -s `hostname`  -u sysadmin -p ' '

tacmd histdeletecollection -u sysadmin -w ' ' -a "Disk_Health"

After this there should not be any entries in the TEPS Historical Collections GUI.

Deleting Tivoli Performance Analyzer Historical Collections ( Performance Analyzer )

Simple script to delete the historical collections being set up on ITPA.

This was tested on ITM/ITPA 623FP1 and should work for Unix and Linux platforms.

Make relevant changes for the path and the tacmd teps login prompts. ( in my case - there is no password for user sysadmin )


#!/bin/bash

DOMCODE=KP3
export PATH=$PATH:/opt/IBM/ITM/bin:.

tacmd tepslogin -s `hostname`  -u sysadmin -p ' '

tacmd histdeletecollection  -a "Disk_Health"
tacmd histdeletecollection -a "System_Health"
tacmd histdeletecollection -a "CPU_Utilization_LT_Status"
tacmd histdeletecollection -a "Disk_Utilization_LT_Status"
tacmd histdeletecollection -a "Mem_Utilization_LT_Status"
tacmd histdeletecollection -a "Net_Traffic_In_LT_Status"
tacmd histdeletecollection -a "Net_Traffic_Out_LT_Status"
tacmd histdeletecollection -a "CPU_Utilization_LT_Fcast"
tacmd histdeletecollection -a "Disk_Utilization_LT_Fcast"
tacmd histdeletecollection -a "Mem_Utilization_LT_Fcast"
tacmd histdeletecollection -a "Net_Traffic_In_LT_Fcast"
tacmd histdeletecollection -a "Net_Traffic_Out_LT_Fcast"

tacmd histdeletecollection -a "CPU_Utilization_NLT_Status"
tacmd histdeletecollection -a "CPU_Utilization_NLT_Fcast"
tacmd histdeletecollection -a "Mem_Utilization_NLT_Status"
tacmd histdeletecollection -a "Mem_Utilization_NLT_Fcast"
tacmd histdeletecollection -a "Disk_Utilization_NLT_Status"
tacmd histdeletecollection -a "Disk_Utilization_NLT_Fcast"
tacmd histdeletecollection -a "Net_Traffic_In_NLT_Status"
tacmd histdeletecollection -a "Net_Traffic_In_NLT_Fcast"
tacmd histdeletecollection -a "Net_Traffic_Out_NLT_Status"
tacmd histdeletecollection -a "Net_Traffic_Out_NLT_Fcast"

How to get the List of Historical Data Collections configured for Tivoli Performance Analyzer or other products.

If an user is interested in checking out the list of Historical Data Collections configured for Tivoli Performance Analyzer and would like to a run some commands instead of viewing the graphical output, then you can use the tacmd histlistcollections.

This command lists the exact output just like in when the user would have gone to TEPS ( Tivoli Enterprise Portal Server )and clicking on the Historical Collections button. ( as seen in the left window)


This was tested on ITM ( Tivoli Monitoring 623FP1 )
KP3 is the product code for domain support for OS Agent.







Similarly, if the user is interested in seeing the list of Historical Data Collections setup for the Linux Agent ( Product Code=lz ) -then use this command
 ./tacmd histlistcollections -t klz -u sysadmin
User has to enter the password command line in the above command.

This will list the following output
Collection Name        : Linux_CPU_SS
Collection ID          : KLZ_LNXCPU
Description            :
Product Name           : Linux
Attribute Group Name   : Linux CPU
Collection Location    : TEMA
Status                 : Started(*LINUX_SYSTEM, lin02-tfam:LZ, unity:LZ)
Filter                 :

Collection Name        : IVT_LIN_CPU_AV_SS
Collection ID          : KLZ_LNXCPUAVG
Description            : IVT_LIN_CPU_AV_SS
Product Name           : Linux
Attribute Group Name   : Linux CPU Averages
Collection Location    : TEMA
Status                 : Started(*LINUX_SYSTEM, lin02-tfam:LZ, unity:LZ)
Filter                 :

Installing the Desktop session for VNC on AIX

To get the Desktop session when you bring up the vncsession on an AIX, do this.,
Go to .vnc/xstartup file

Add these few lines.
-------X--------- X- Cut and Paste --X------
#!/bin/sh
/usr/dt/bin/Xsession

-X--------------------Done ------------X
Check that the execute permissions are present for the xstartup file.

execute the vncserver command,
From there on you should be able to bring up the XSession on an AIX platform
 

ITPA Short term historical directory size , KHD_HISTSIZE_EVAL_INTERVAL , ITPA

On a ITM 623 FP1 / 630 and on a Linux environment...

Symptom:

If the  TEPS GUI does not show any data after ITPA agent is brought up - it could be that the data is clogged.
And you have checked that the 'itpa' agent is running, ware house proxy, S&P ( Summarization and Pruning ) hd, sy and others are all running - and there is disk space.
BUT the ITPA GUI for Performance Analyzer is not rendering the data or the statistics.



If you happen to look at the logs files ITM_FOLDER/logs/*_pa* - and in the last file

If this error shows up in the _pa_*.log file.
(not in the kpacma.log file )

(5061DAD9.000A-B:khdxhwst.cpp,96,"CTHistWriteStatus") KHD_HISTSIZE_EVAL_INTERVAL (20) < 60, defaulting to 900
(5061DAD9.000B-B:khdxhwst.cpp,263,"setHistWriteStatus") ATTENTION: Stopped writing short-term historical data to files in directory /opt/IBM/ITM630/lx8266/pa/hist//.
(5061DAD9.000C-B:khdxhwst.cpp,265,"setHistWriteStatus") Total size of historical files 64284KB exceeded the maximum of 2048KB.


This is because of the following lines in the ITM_FOLDER/config/pa.ini

The KHD_HISTSIZE_EVAL_INTERVAL=20   <== Incorrect.        

It means the interval cannot be set to 20 secs.

It has to be above 60. ( or else it sets it self to 15 mins , 15 * 60 )


2. ( the sample I am showing here is on a Linux server )
The size of the historical folder ( Directory Size - "du -s" ) has to be 2M  after which the WPA sends it to the DB.
KHD_TOTAL_HIST_MAXSIZE=2

du -s  on the hist folder shows

[root@lin02-tfam config]# du -s
6560    .  <== this is why the data collection was stopped in the short term historical folder.

Resolution:
http://pic.dhe.ibm.com/infocenter/tivihelp/v15r1/index.jsp?topic=%2Fcom.ibm.itm.doc_6.2.2fp1%2Fitm_historyshortterm_limitgrowth.htm


3. Tip : to see what the Warehouse proxy is doing - then set this ....

In the ITPA you can set a trace unit of (unit:khdx all) to see history-related (KHD) processing.. maybe that will give more information.

Installation of SPSS on ITM for predicting the Non-Linear Trending of computer resources.

Note : Views are my own and not that of my employer.

Here I am giving some tips on installation of the SPSS component on ITM . ( IBM Tivoli Monitoring)
ITM support both the Linear Trending and the Non-Linear trending of data.
For more on the product : refer to

 http://www-01.ibm.com/software/analytics/spss/support/spss_license.html
(SPSS = Statistical Package for Social Sciences )
Below you will see how to install this, and also some graphs of the resources from a beginner stand point.
( SPSS component is a add-on component  license that one has to buy  to install on top of ITM which will give the Non -Linear trending.)
The Linear trending however does not require any special license and will be installed as part of the ITM.
SPSS gives the ability to do Non-linear predictive analysis and is better than Linear prediction.
Licensing:
http://www-01.ibm.com/software/analytics/spss/support/spss_license.html

Product Downloads for evaluation :
http://www-01.ibm.com/software/analytics/spss/downloads/


Installing SPSS component on a Linux Server RHEL 64 bit

Download the SPSS package, and unzip and start the installer ( X session - required )

Some installation snapshots are put up here for easier installation process.







Go to MEMS Tool ( or the itmcmd manage ) and configure the ITPA .



Go up to the configuration page and validate the SPSS path.



Click on Validate - if the default path was set during the installation, then it will prompt  a valid response.




Save and restart the agent.

Now, on the TEPS GUI, open the Performance Analyzer configuration button.
and drill down to the OS Linux - you will see the new Non- linear Analytic tasks being configured.
Here in this example, I concentrate on Linux OS only.



The new tasks end with the NLT suffix indicates that the Non-Linear tasks are created.

Click on the tasks and check that the 'run at startup' button is set, ( If the active button is not set - then enable this option to activate it )
Set the task interval to desired time ( in my case I set it to 1 hr- so that this task runs every 1 hr )
(Start with one of the NLT Tasks and then replicate this to other NLT tasks )




Click on the Distribution tab, and select the managed servers and move it under Assigned. So that the collections happen for this managed servers.

Next,
( my choice ) set the granularity to Hourly.
and Compute trend on 'all available data'



Click 'Apply',

Now. assuming that the historical collections is configured. check the MOS WOS panel.
This lists the different states the analytical tasks are in.



The possible messages are COMPUTED or FAILED.
Computed means that the resource was computed, but there was not.



To speed things up - we can start and stop the PA ( since we have configured the NLT task to 'Run at Startup' )

Let's take just the Disk Utilization for example.

Go to Performance Analyzer Configuration window and click on Disk Utilization, The input data selection window pops up.
Check if the History collection have been set up for this attribute.



(If not, Go to History collection and check that the Linux Disk (Superseded ) is set to collect history data )

If the data collection is in progress and the Disk Utilization NLT is computed, this is the message that should show up if your cursor is on

Performance Analyzer Warehouse Agent.










If the state is computed. move the cursor to


and click on the 'Workspace Gallery'  
This will pop-up a new window. In this select the
'Disk Utilization Non Linear Trending '   button .

This should render the  Disk Utilization Non Linear report.

This is for Space Used Percent Input attribute.

A sample graph for "Space Used Percent' would be like

indicating that the disk forecast based on the past data will be at 10%.


Now, I change the input attribute from  Space Used Percent to 'Space Available'

History Collection Configuration :

Tips to check if the NLT historical collection is configured.

Go to History Collection and click on Tivoli Perf domain for OS Agent:
and verify
a) Collection Interval  ( this means that the collection is being done - once a day and also saved in the Agent once a day )


and just to speed it up
set the Collection interval to 5 minutes and move it to Warehouse DB once every 15 minutes.


Click on the Distribution tab and remember to assign the server under the "Start Collection on"

Repeat this for all the resource NLT  tasks like CPU, DIsk, Memory etc.

ITPA : Not sufficient data points

Note : This scenario was tested on  ITM 6.2.3 FP1 and also an example is for "CPU Utilization"

One may use similar configuration for other domains like ITCAM and others that ITPA supports.

If this message appears on the TEPS GUI  for a certain task -  it means that a) either the Historical Collections was not configured  or b ) there was insufficient Historical data to do its' computations.
 
E.g:  

This means that the CPU Utilization for the OS agent was not configured. ( in this case I am testing it on  a RHEL 5.8 - Linux )

The message can be either a "FAILED  - Not Sufficient Data Points"
or "COMPUTED - Not Sufficient Data Points"


The "Failed" message (as seen above ) means that the historical configuration was not done.
 
The second error message you could see is "COMPUTED" however,it will show Not Sufficient data -points as seen below. This means that there are not sufficient collections for the Performance Analyzer to do computations on.




To fix this:

Click on the History Collection button :



Go to Linux : and create a new collection for Linux CPU (Superseded.)
 Right click on "Linux" and Create a new Collection. ( if not done already )


Basic Tab:


Collection configuration:


Distribution tab: Move your server or the group under "Start Collection on"


Set up the configuration for Warehouse and the Summarization Agent.
Enable the Daily, Weekly, Hourly and also Detailed data on Summarization and Pruning Agent.








Now, setup similarly the History collection on ITPA Domain ( in this case the OS Agent):

Click on the Tivoli Performance Analyzer Domain for OS Agent.





Check that the managed server/Group is configured for collection, under the distribution tab.


Set up History collection settings.




Now, let the analytical task for this agent run,
After the task is run, the TEPS GUI ->Performance Analyzer -> OS - will show a different message.
It did compute - however

Yet, the "Not sufficient Data points"  is still showing- because ITPA needs a certain amount of data before it can analyze and predict the trend for this instrument.
Once the data is there - this message should go away. 

How to resolve error KFWITM217E Create Request Failed rc=209

After the installation of the Base ITM, and when you start TEPS, if you notice the KFWITM217E error ,  the problem could be that the TEMS support for the products was not configured.

So, to resolve this : go to the Base ITM Installer and execute this command.

./install.sh
and choose the Tivoli Monitoring Server Support ( Option '5')
Re-install ( if the prompt ask do you want to reinstall the SAME Version - say yes')
Seed it. ( accept this prompts during configuration )

Restart all the processes
This should resolve it.

Starting DB2CC Control Center in Linux.

On a DB2 V9.5

Troubleshooting db2cc on a Linux server.

The db2cc is installed automatically when DB2 V9.5 is installed in the default /opt/IBM/db2/V9.5 folder. So, if you try to start it in a VNC session, then if you get this message.




That means the JDK_PATH is not set right.

This is how you check the path is correct or not.

Login to the db2instance
( su - db2inst1 )

db2 get dbm cfg  - look for JDK_PATH



If the path above does not have the JRE - then reset it to the correct JRE location  using this command.
( in my case - the JRE path was found in the below path )

Update it using the below command.



Validate it by running the  'get dbm cfg ' again



In the root window in VNC,  export the DISPLAY=<IPaddress>:0.0
cd to /opt/ibm/db2/V9.5/bin  (or wherever the DB2 is installed ) 
./db2cc
should launch the DB2 Control Center.

Changing VNC desktop to gnome-session& in xstartup

change the twm & to
gnome-session & in the xstartup file in .vnc folder
To start the vnc
vncserver

to stop
vncserver -kill :1

SQL0970N The system attempted to write to a read-only file. SQLSTATE=5500

I got this message when I removed the earlier installed DB2 and installed V9.5  of DB2 and I wanted to create a WAREHOUS user  ( db2 create database WAREHOUS )

SQL0970N The system attempted to write to a read-only file. SQLSTATE=5500

Turns out that I did not have the write perms on the /tmp folder on my RHEL server where I was installing.

chmod ugo+w /tmp - did it.

Looking at the dbinst1/sqllib/db2diag.log - told something about the permission in that folder.

Configuring DB2 on a Linux for Tivoli Enterprise Monitoring and Portal Server

[ Views and opinions are my own and does not reflect my employer IBM - there may be better ways to do this, but  this below worked for me ]

How to install DB2 Express on a Linux RHEL 32 bit.

Create a separate folder.
See that you have at least 900 MB free.
Untar this first in the new folder.
DB2_Exp_Ed_97_Linux_x86.tar.gz

Pre-reqs:
1. Check that the dasadm ( administration server ) is not running from an earlier installation.
it is usually in the /home/dasadm folder.
Stop it first.  /opt/ibm/db2/V9.x/das/bin/db2admin



http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fr0002037.htm

If you do not - during installation - you will get this message

ERROR: ## call function cleanup_reg_list das crt dasusr1
DBI1103E  The Administration Server already exists.

2. Also, check that there are no users like itmuser, in /etc/passwd
3. cd /opt/ibm and check that there is no db2 folder
4. clean up any older db2 log files in the /tmp folder.
(5. /tmp has the rwx perms )




See that you have the xsession on a Linux server up and vnc to that server. 

Execute    db2setup

Things to remember - so make notes.
What was the instance name during creation : 

What was the password for dasusr1.
What was the password for db2inst1
What was the password for db2fenc1.
 



su - db2inst2
db2start -
ps -ef |grep db2 - there will be a few processes running
db2stop - all these should be down.
this should give an indication that the installation is good.


Uninstalling tips -
I had to  db2stop and then remove the folder /opt/ibm/db2
There was one nagging process db2fmcd - that would start over and over again - although I killed it, so ......
I had to search for this executable and do this 'db2fmcu -d ( this is an entry in inittab ) which keeps respawning.

Configuring the TEPS 'cq' on a Linux .

( Views are my own - and does not reflect that of my employer)

Some configuration steps I used when I was configuring the TEPS agent.
if the DB2 was configured with the defaults - then the itmuser passwd is itmpswd1.
This was on a RHEL 32 bit.
Important This is for the Embedded Database. and not the DB2 database.




Typically, I'd watch for the last step Installation Presentation part- where it says the status.