Tivoli, Integration and Stuff

f="&{Linux_Disk.Mount_Point}" ;
u=`umount -f $f 2>&1 && echo $f`;
m=`mount $f 2>&1 && echo $f`;
echo -e "umount: $u\nmount:$m" | mail -s "ITM ACTION: Remount $f" junkmail@JdsMedia.net

ITM Host Availability (ping attribute)

2009-07-09T06:50:00.001-07:00

Synopsis

A nice feature which isn't publicized too much in ITM for Linux and Unix agents is the ping capability. They're refrerred to as "Host Availability" for Linux and "Ping Attributes" for Unix Both will accept an input file containing a list of servers to "ping", and both will return status and response time.

Enabling the ping hosts file

Linux

$CANDLEHOME/config/lz.ini: KLZ_PINGHOSTLIST=<path_to_list>

# e.g. KLZ_PINGHOSTLIST=$CANDLEHOME/config/my_hostlist

# Add this to the lz.config if you want to avoid having to reconfig the agent

Unix

$CANDLEHOME/config/ux.ini: KUX_PINGHOSTLIST=<path_to_list>

# e.g. KUX_PINGHOSTLIST=$CANDLEHOME/config/my_hostlist

# Add this to the lz.config if you want to avoid having to reconfig the agent

Extra feature difference

One minor, but important, difference is that the Linux component will only ping servers in the list, while the Unix component has the additional feature using a situation to ping any target host from any managed system. This makes every managed system (agent) a ping source to target critical servers.

Attribute Group: UNIX Ping

Situation Definitions: System_Name == $NODE$, Target_Host == webserver1

IBM Tivoli Monitoring Product Codes

2009-07-08T20:47:00.001-07:00

Obtaining Product Codes for IBM Tivoli Monitoring (ITM v6)

Local method:

Parse the proddsc.tbl file on a UNIX/Linux system to get the list by doing this:

UNIX

awk -F\| '/^[^*#]/ {print $1,$2}' ${CANDLEHOME}/registry/proddsc.tbl | sort | uniq

Or, IBM's site http://www-01.ibm.com/support/docview.wss?rs=2366&context=SSZ8F3&dc=DB520&dc=DB560&uid=swg21265222&loc=en_US&cs=UTF-8&lang=en&rss=ct2366tivoli

ITM Logs Timestamp Conversion

2009-07-08T20:44:00.001-07:00

ITM v6 log files use a hexadecimal timestamp (to save space? who the hell knows), which adds unnecessary effort when the reason you're looking at the logs is to determine an issue in the first place. In any case... Here's the script I wrote when I first encountered the nonsense in ITM v6 logs a few years ago:

#!/bin/perl

foreach (<STDIN>) {

if (/^[^\s\d\w]+([\w\d]*)/) {

@t=localtime(hex($1));

$time=sprintf("%02d:%02d:%02d %02d/%02d/%04d",

$t[2],$t[1],$t[0],$t[4]+1,$t[3],$t[5]+1900);

s/^[^\s\w\d]+[\w\d]*/$time/;

}

print $_;

}

Here's a one-liner that Venkat.Saranathan at Gulfsoft.com cranked out, rending my script pretty much obsolete

perl -lane 'if ($_ =\ /^(.)([\dA-F]+)(\..*)/) { printf "%s%s%s", $1, scalar(localtime(oct("0x$2"))),$3; }'

ITM6 : Take Action : Remount Stale remote filesystems

2009-07-08T20:41:00.001-07:00

Situation

An ITM6 Unix (UX) or Linux (LZ) agent detects that its remote filesystems are unavailable, a "stale" connection.

Automate an action to remount it if possible

Methodology

Two (2) ITM situations are created where

detects the mount point has become stale
the other is triggered by the "correlated situation" condition of #1 being tr

Situation #1 : Detect "Stale" remote FS

Simple enough - if "Space Available" fails collection, there is an issue

Situation #2 : Take Action Script - Stick this following script in your take action

Note: the lines are strung together on one line in the Take Action field, to make it more legible here, newlines are after the semicolons

f="&{Linux_Disk.Mount_Point}" ;
u=`umount -f $f 2>&1 && echo $f`;
m=`mount $f 2>&1 && echo $f`;
echo -e "umount: $u\nmount:$m" | mail -s "ITM ACTION: Remount $f" junkmail@JdsMedia.net

TEPS 6.2 Client Java Upgrade

2008-08-21T13:53:00.001-07:00

In order for clients to access to TEPS upgraded to ITM6.2 for the first time, they'll need to have the IBM JRE 1.5 installed on their system.

It's a very straightforward process, but if you need some guidance, the steps are outlined below.

Have client access TEPS via a browser session: http://<teps_server>:1920///cnp/kdh/lib/cnp.html
TEPS will detect the necessary JRE is not available and push down the ibm-java2.exe
Accept the installation and accept all the defaults EXCEPT in STEP #7
Next
Yeah yeah yeah… select 'Yes' for the EULA
Next
**IMPORTANT** Select 'NO' for SystemJVM
Confirm and select 'Next'
'Next' again…
Select 'Finish'
You should see the "Java Compatible" Logo and progress bar in the browser
Select 'Always trust content…" or not, it really won't matter.
The Java plug-in settings are covered in another post, but you can click 'Help' here for more information

Parse Download Director dlmgr.pro

2008-08-20T18:14:00.001-07:00

If you use the IBM Passport Advantage or PartnerWorld portal to download software, you no doubt want to have the filenames renamed to something more meaningful than the software part number. This script will rename files based on the parsed info in the dlmgr.pro file. Example

jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ ls -1

C1FT9EN.zip

C1FU3EN.tar

C1FU4EN.tar

C473DIE.exe

dlmgr.pro

itmpatchagents.zip

itmsup.zip

jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ /usr/local/bin/parse_ddpro.pl

PWD is /cygdrive/c/DownloadDirector

mv C1FU4EN.tar ITM_Version_6_1_Vol_6_Fixpack_7_Linux_Intel_C1FU4EN.tar

mv C1FT9EN.zip ITM_Version_6_1_Vol_1_Fixpack_7_Windows_Plat_C1FT9EN.zip

mv C1FU3EN.tar ITM_Version_6_1_Vol_7_Fixpack_7_Linux_Intel_P_C1FU3EN.tar

DOWNLOAD: parse_ddpro

Trackback: http://www.jdsmedia.net/miscellaneous/parse-download-director-dlmgrpro-2

Extract TAR files over SSH

2008-08-20T17:21:00.001-07:00

Instead of copying a large tar file over ssh then extracting, take care of the whole process with one command:

cat <tarfile> | ssh –C user@remotehost "(cd <targetdirectory> && tar –xf -)"

This will stream the tarfile over a compressed ssl tunnel and the other side will only extract if the target directory exists. The "targetdirectory" piece I used as a good prevention to blowing files all over an undesired/unexpected location.

Trackback: http://www.jdsmedia.net/tivoli/tivoliscripts/extract-tar-files-over-ssh

Parse Download Director dlmgr.pro

2008-08-20T17:18:00.001-07:00

If you use the IBM Passport Advantage portal to download software, you no doubt want to have the filenames renamed to something more meaningful than the software part number. This script will rename files based on the parsed info in the dlmgr.pro file. Example

jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ ls -1

C1FT9EN.zip

C1FU3EN.tar

C1FU4EN.tar

C473DIE.exe

dlmgr.pro

itmpatchagents.zip

itmsup.zip

jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ /usr/local/bin/parse_ddpro.pl

PWD is /cygdrive/c/DownloadDirector

mv C1FU4EN.tar ITM_Version_6_1_Vol_6_Fixpack_7_Linux_Intel_C1FU4EN.tar

mv C1FT9EN.zip ITM_Version_6_1_Vol_1_Fixpack_7_Windows_Plat_C1FT9EN.zip

mv C1FU3EN.tar ITM_Version_6_1_Vol_7_Fixpack_7_Linux_Intel_P_C1FU3EN.tar

DOWNLOAD: parse_ddpro

TEPS: migrate-export.bat does not export MS-SQL

2008-08-20T17:17:00.001-07:00

Just discovered something which caused me some headache. The migrate-export.bat generates DB2 syntax statements by default, regardless if you're using MS SQL or not for TEPS. Go ahead and try to import the 'saveexport.sql' into your TEPS SQL db, it will cause some fun corruption. An APAR exists, but it still has not made it into ITM6.2.

APAR IZ21307

MIGRATE EXPORT/IMPORT SCRIPTS FAIL FOR MICROSOFT SQL SERVER

Problem Description:

The migrate-export.bat and migrate-import.bat scripts do not

work correctly when the TEPS database is Microsoft SQL Server.

The scripts incorrectly detect the database type to be DB2, and

insert SQL statements in the saveexport.sql file that are

invalid in SQL Server. Attempting to import the saveexport.sql

file into a TEPS using SQLServer will result in several SQL

errors and data will be missing from the TEPS database.

Circumvention:

Manually edit the migrate-export.bat script and change the errorlevel

checks at line 29 and 35 to 1 from 0.

Tivoli, Integration and Stuff

ITM6 : Take Action : Remount Stale remote filesystems

Case statement

Methodology

Situation #1 : Detect "Stale" remote FS

Situation #2 : Remount Situation

Formula Conditions

Take Action

ITM Host Availability (ping attribute)

Synopsis

Enabling the ping hosts file

Linux

Unix

Extra feature difference

IBM Tivoli Monitoring Product Codes

Obtaining Product Codes for IBM Tivoli Monitoring (ITM v6)

Local method:

Parse the proddsc.tbl file on a UNIX/Linux system to get the list by doing this:

ITM Logs Timestamp Conversion

ITM6 : Take Action : Remount Stale remote filesystems

TEPS 6.2 Client Java Upgrade

Have client access TEPS via a browser session: http://<teps_server>:1920///cnp/kdh/lib/cnp.html

TEPS will detect the necessary JRE is not available and push down the ibm-java2.exe

Accept the installation and accept all the defaults EXCEPT in STEP #7

Yeah yeah yeah… select 'Yes' for the EULA

Next

**IMPORTANT** Select 'NO' for SystemJVM

Confirm and select 'Next'

'Next' again…

You should see the "Java Compatible" Logo and progress bar in the browser

Select 'Always trust content…" or not, it really won't matter.

Parse Download Director dlmgr.pro

Extract TAR files over SSH

Parse Download Director dlmgr.pro

TEPS: migrate-export.bat does not export MS-SQL

IMPORTANT Select 'NO' for SystemJVM