IBM Support

50 DB2 Nuggets #48: Expert Advice - TSAMP Control Flags in a DB2 HA Environment

Technical Blog Post


Abstract

50 DB2 Nuggets #48: Expert Advice - TSAMP Control Flags in a DB2 HA Environment

Body

Hi,

Ever wondered what the TSAMP control flags stand for in a DB2 HA environment? Here are some of the most common ones:

"StartInhibited" - Start of dependent resource is not satisfactory (only displayed if OpState is Offline and DesiredState is Online)

"StopInhibited" - Stop of dependent resource is not satisfactory  (only displayed if OpState is Online and DesiredState is Offline)

"SuspendedPropagated" - A lock request is propagated to this resource

"StartInhibitedBecauseSuspended" - Start of dependent resource is not satisfactory and a lock request is propagated to this resource (only displayed if OpState is Offline and DesiredState is Online)

"StopInhibitedBecauseSuspended" - Stop of dependent resource is not satisfactory and a lock request is propagated to this resource (only displayed if OpState is Online and DesiredState is Offline)

"MemberInProblemState" - A constituent of the resource, a resource, or a resource group is in a problem state. Problem state means that the resource is failed offline or not startable due to another reason. Identify and solve the problem of the resource and enter resetrsrc.

 

Thanks,
John Gera

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141384