db2 backup failing error TSM reason code: "258"

[johnski]

db2 backup db DATABASE online use TSM


SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "258".
Backup was not successful

Recently the TSM server was upgraded to the latest version. After that we get this problem.

DSM_RS_ABORT_NOT_ROOT 258 this is all i can find!

Some new security in the NEW TSM server apparntly, which doesn't allow backup clients to run as any other user than ROOT.

System is AIX with DB2, also upgraded the TSM client to 7.1.1 ( and still the same error)

I can't find anywhere to make it run as root as the db2 instance is own by a db2 instance owner!

Help please


This also happened on our ORACLE db's.... That was easy to fix in the tpo options file and set the owner to root!

 

[fylion]

We were encountering this error after our upgrade too. Full details of this "feature" are here: http://www-01.ibm.com/support/docview.wss?uid=swg21686874

Basically, to stop arbitrary users from backing up multiple copies of a file and making old versions roll off, only some users are allowed to iniate backups.
This is controlled on a per-node basis with "update node <node> BackupInitiation=all|root". The parameter defaults to all.
However, this setting is overridden by a server option described at the link above. Run "setopt BackupInitiationRoot no" to disable this feature and allow the local node policy to determine if non-root accounts can initiate backups.

 

[Mita201]

Thanks fylion, it also took several hours of my life, with db2 backup...