How to fix DB2 TSA resource FAILED OFFLINE and MEMBERINPROBLEMSTATE

Question: During a change on a server , I had to do a TSA failover as part of testing . For various reasons - outside of TSA - the failover failed. Using lssam - one of the resources - ended up in MemberInProblemState and Failed offline Both the network and virtual ip resources are in a state of equivalency How can I fix and reset ? Answer: When a resource is marked as failed offline:clear the state and return that resource to normal operation #resetrsrc -s 'Name =="resource1"' IBM.Application #resetrsrc -s "Name like 'db2_db2inst1_0-rs' AND NodeNameList in {'MY_HOST_NAME'}" IBM.Application For... Read more →

DB2 TSAMP Clustering - Resource marked as OFFLINE

Question: I've installed the latest security vulnerability patching for jdk on DB2 TASMP clustering - and while running some tests i.e fail over and fail back , I'm getting a Resource Marked as offline. I've investigated the root cause - and fixed , and now I'm trying to reset the resource back as ONLINE. How can reset the resource? Answer: Without knowing anything about how the root cause and what steps you took to fix the underlying cause, the typical steps to take is to use the resetrsrc command. This is an example of how you might reset the value... Read more →

TSAMP command - lsrg and awk

Question: How can I list out information in a tabular format using the TSAMP lsrg command ? I’d like to parse the information. This is part of setting up a monitoring tool Answer: The lsrg command is useful for listing information about resource groups in IBM Tivoli System Automation for Multiplatforms (TSAMP). There are different ways of using lsrg command. Combining lsrg and awk will list out the member resource information. With columns : Class:Resource:Node[ManagedResource] Mandatory MemberOf OpState WinSource Location AutomationDetails[CompoundState] [ObservedState] [BindingState] lsrg -m -D, -V | awk -F, '{print $1,$2,$3,$4,$5,$6,$7,$9,$10}' Read more →

Methods to find TSAMP error details and return codes

Question: How can I find details about TSAMP (Tivoli System Automation for Multiplatforms) failover details? I discovered that a failover occurred and need, what sources will give me details? I have a TSA single storage solution in place Answer: There are multiple methods to extract details about a failover details. If you troubleshooting , it may be necessary to correlate details from different sources. These sources of information are a good starting point for diagnostics. /var/ct/IBM.RecoveryRM.log Linux error logs on /var/logs/messages tail -f /var/log/messages Db2diag log files Instance_name.nfy file Read More on TSAMP TSAMP Cheat Sheet for DBA managing DB2... Read more →

How to put TSAMP into maintenance mode

A common problem for managing TSMAMP DB2 high availability is how to deal with non DB2 maintenance. An example is OS patching. Let's say there is a 2 node clustering architecture set up. The OS administrators will want to patch the servers, but there is a requirement to maintain uptime on the DB2. If using TSAMP a straightforward plan, could be based on these steps The basic idea is to change the Automation mode to manual mode . Step 1 : Manually move the DB2 instance to the required node. Use the rgreq command . Read more on TSAMP Cheat... Read more →