A few days ago I had this issue while running a Db2 online backup to TSM.
[email protected]:~ $ db2 "backup db SAMPLE online use TSM compress" SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code :"106"
so I executed db2 ? SQLXXXX to get more information as shown below.
[email protected]:~ $ db2 ? sql2033 SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "<reason-code>". Explanation: Some common TSM reason codes are: 106 The specified file is being used by another process. You tried to read from or write to a file that is currently being used by another process. User response: Responses for common TSM problems are: 106 Ensure that you specified the correct file or directory name, correct the permissions, or specify a new location.
I checked the dsm.opt file, check location of files, however, all looked OK.
So, I kept searching and found the following link and as mentioned in this article
There are numerous triggers of the sqlcode -2033 with a sqlerrmc 106
And after checking even more files and locations, I finally found that my issue was the userprofile (./sqllib/userprofile) file since it was empty.
So I once I set the TSM related variables properly the online backup finished successfully.
[email protected]:~ $ vi ./sqllib/userprofile export DSMI_CON=/usr/tivoli/tsm/client/api/bin64/dsm.opt export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64 export DSMI_LOG=$HOME/log