IBM Support

Configuring TXNGROUPMAX when proxy node is involved

Troubleshooting


Problem

When you use the asnodename option to back up a client, you might need to adjust the value of the TXNGROUPMAX parameter for the target node.

Symptom

In this scenario, a Netezza backup was done from Spectrum Protect client NODE1 and the following option was used :
asnodename MYNODE

The backup failed with the following error :
ANS0246E (RC2070) Issue dsmEndTxn and then begin a new transaction session.

Diagnosing The Problem

In this example, the following proxy relationship is configured :

Target Node             Agent Nodes                      
----------------------- -----------------------------
MYNODE                  NODE1

On the Tivoli Storage Manager server, use the QUERY NODE command to verify the value of the TXNGROUPMAX parameter for the nodes. For example :

q node mynode f=d
Node Name: MYNODE
...
Transaction Group Max: 256
...

q node node1 f=d
Node Name: NODE1
...
Transaction Group Max: 4000
...

In this example, because the backup is done with NODE1 using the ASNODENAME MYNODE option, the TXNGROUPMAX value used is 256.

Resolving The Problem

When a backup is done using a proxy node, it is the TXNGROUPMAX value of the target node that is used for the backup. If the ANS0246E error is received, you must update the TXNGROUPMAX value of the target node. For example :

update node MYNODE txngroupmax=1000

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21678305