Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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

TSAMP Cheat Sheet for DBA managing DB2 clustering



This post first appeared on DBA-DB2.com, please read the originial post: here

Share the post

How to fix DB2 TSA resource FAILED OFFLINE and MEMBERINPROBLEMSTATE

×

Subscribe to Dba-db2.com

Get updates delivered right to your inbox!

Thank you for your subscription

×