scripts to automate

oraora · #1 (**permalink**) 01-10-07, 12:38

any one have scripts or any experience for automating takeover for HADR?

any suggestins or ideas would be appreciated to get us started.

Currently IBM does not have anything like that.

TIA.

Marcus_A · #2 (**permalink**) 01-10-07, 12:58

IBM supplies a two server license for TSA (Tivoli Server Automation) with each HADR license (with ESE or purchased separately for WSE, Express).

TSA is not foolproof, and determines whether a takeover is necessary based on certain resources defined, such as network connections, etc. It does not actually attempt to connect to a primary database to see if it responds. In the case of an instance crash, TSA will restart the instance instead of doing a takeover.

The scripts that TSA uses are supplied in the following directory path (may be slightly different for AIX):
/opt/IBM/db2/V8.1/ha/salinux

oraora · #3 (**permalink**) 01-10-07, 13:12

Thanks for such a prompt respose!
I really appreciate it.

but we do not have TSM so I am looking for some scripts or related.
Can i find those is normal installation of db2 in aix?
Thanks!

Marcus_A · #4 (**permalink**) 01-10-07, 13:27

It is not TSM (Tivoli Storage Manager) it is TSA. Correction to my first post: TSA is Tivoli System Automation for Multiplatforms.

If you have a license for HADR, then you entitled to a license for TSA. TSA comes included on CD-ROMs for DB2 8.2 ESE or later, or you can get it with Passport Advantage at the IBM website.

I don't know where the scripts are in AIX, but they should be under a directory called HA.