How to fix DB2 TSA resource FAILED OFFLINE and MEMBERINPROBLEMSTATE

12 February,2019 by Tom Collins

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 more reading on TSA

TSAMP Cheat Sheet for DBA managing DB2 clustering

Author: Rambler(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to fix DB2 TSA resource FAILED OFFLINE and MEMBERINPROBLEMSTATE

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright