DEFINE COPYGROUP domain_name policyset_name mgmtclass_name TYPE=ARCHIVE DESTINATION=archive_stgpool_name RETVER=NOLIMIT IBM recommends that you make archive logs go to a different storage pool that the DB2 database backups. There is usually nothing on either the TSM server or the TSM client logs to indicate that archiving is working, and usually no error messages if it fails. If you miss this out you will see the environment variables for root. Please Give Thanks to Those Sharing Their Knowledge Forum Rules (PLEASE READ BEFORE POSTING) DB2 tsm backup error Reason code: "406" Discussion in 'DB2' started by sk121, Jan 14, 2008. http://u2commerce.com/tsm-error/tsm-error-codes-104.html
export DSMI_DIR=/usr/tivoli/tsm/client/opt/bin64 export DSMI_LOG=/path to your log files export DSMI_CONFIG=/usr/tivoli/tsm/client/ba/bin64/dsm_db2.opt File permissions The TSM1_QPRD10_DB2 stanza in the example above has two log files, /path/tsm.db2.dsmerror.log and /path/tsm.b2.dsmsched.log where /path is the path If neither of these cases is met, you receive this error message. DB2 errors RC 406 If the backup is not working but there is nothing in the tsm logs then you need to look at the DB2 logs. In general you do not want just anyone to be able to update these files, so owner write and everyone else read; or chmod 644 is considered appropriate.
backup hasnt started because... I am new to DB2 and to the admin portion of databases so any help on the above error message would be appreciated. System Action: The ITSM client ends.
A return code 0168 means that DB2 cannot find the password file. The real error is that 406 in the hex dump and this comes from the TSM API. Alternatively, you can just check the archive dates. LAN-free will speed up backups of DB2 databases, but is not suitable for smaller files like archive logs.
I sure there is not problem with my TSM Client as there are two db2 instances running on the same system with same TSM Client. Recent releases of DB2, certainly from DB2 9.7 onwards, have several types of object, and the backups of eacjh object must be directed to a LAN free management class. fidel replied Oct 28, 2016 at 5:04 AM RMAN archive logs stuck ? https://www.ibm.com/developerworks/community/forums/thread.jspa?threadID=367742 You would do this using a TSM command like the one below, with suitable names that fit your site's conventions.
Reason code: "406". Also you need to cofigure the 64 bit files umder the bin64 at the client level. marclant replied Oct 27, 2016 at 12:47 PM Loading... To start viewing messages, select the forum that you want to visit from the selection below.
Scheduling First, you need to define a different dsmcad for DB2 to allow you to pick up the DB2 option file. http://www.lascon.co.uk/tsm-and-db2.php DB2 errors If the backup is not working but there is nothing in the tsm logs then you need to look at the DB2 logs. The problem was that the filespace that was mounted with the nosuid parameter set, which meant that password worked for root only. Most likely you have not set the password for the TSM DB2 client, or just possibly, the file system is mounted with nosuid set.
Could you please verify the same? this content Regards Top This thread has been closed due to inactivity. sk121, Jan 14, 2008 #1 ADSM.ORG Sponsor nottins ADSM.ORG Member Joined: Nov 7, 2007 Messages: 57 Likes Received: 1 What do you get when you issue "db2 get db It's considered good practice to make all your TSM log files read/write to everyone with chmod 666.
If neither of these cases is met, you receive this error message. Check for the permissions. To segregate the two, you need to define two TSM clients, one for backups, and one for archives. weblink Otherwise you run it as the db2 user as shown in the second example below - your DBA will supply you with the correct username.
You need to define an archive copygroup in the DB2 management class, otherwise archiving will fail. db2 update db cfg for db_name using logarchmeth1 TSM: mgmtclass_name You can find out if TSM is working by running the following select statement twice, an hour or so apart. Some components may not be visible.
You may have to register before you can post: click the register link above to proceed. The "-c" means switch back to the root userid when the command completes. SystemAdmin 110000D4XK 2011-04-18T07:04:40Z The TSM log would provide you with more information regarding the error codes. If you have an ERRORLOGNAME specified in the dsm.sys file, then DB2 writes errors to this file, otherwise it uses the value in the DSMI_LOG environment variable.
Assuming the script is in /usr/local/scripts/db2backup.ksh, the command is something like /usr/local/scripts/db2backup.ksh or su - db2user -c "/usr/local/scripts/db2backup.ksh" In the second example, the '-' means run the command as db2user RC 0168 A return code 0168 means that DB2 cannot find the password file. Problems with excludes If you see an error like this (from Windows - other operating systems will differ a bit) SQL2062N An error occurred when accessing media "C:\PROGRA~1\SQLLIB|bin\db2tadsm.dll". check over here You will need a DB2 policy set and management class, with a backup copy group with the parms set to 1,0,0,0.
If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful. You might see this error on a DB2 archive. All product names are trademarks of their respective companies. I've found this technote: http://www-1.ibm.com/support/docvie...0&loc=en_US&cs=UTF-8&lang=en&rss=ct1019tivoli This was my case.
This is an IBM product for use in conjunction with OnDemand product. You can find out if TSM is working by running the following select statement twice, an hour or so apart. If it is not set, then TSM looks for the file dsm.opt in the current directory.