DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

TSM error 11 when log archiving


Hi, we have old DB2 system with DB2 v8 on AIX. Due to financial constraints this hasn't been updated yet but works fine.
However TSM password has expired and stopped backup and log archiving. TSM staff reset the password and now backup works but log archiving still failed with the following error. This happened long time ago and resetting the password resolved the issue. However the TSM staff is a new member for the company. Could you give some advice please ?
Extract from the db2diag.log :
PID : 2703600 TID : 1 PROC : db2logmgr (PRD001) 2
INSTANCE: db2prd1 NODE : 002
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 150 due to rc 11 for LOGARCHMETH1
using method 2 and target STANDARD.
MESSAGE : Failed to archive log file S0000150.LOG to TSM chain 0 from
/db/db2prd1/db2prd1/NODE0002/SQL00001/SQLOGDIR/ with rc = 11.
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1030
MESSAGE : sqluvint failed! Vendor rc:
TSM RC 11 means there isn't space available for storage. Possibly backups and logs belong to different TSM policies and are stored in different pools, this is why backups succeed and log archiving does not.
0011 E
DSM_RC_ABORT_NO_REPOSIT_SPACE
Explanation:
The server does not have any space available to store the object.
System action:
Tivoli Storage Manager ended the current operation.
User response:
You can take any of the following actions:
Request the system administrator to add space to the storage pool.
For Tivoli Storage Manager client, set COMPRESSALWAYS=NO and COMPRESSIon=YES in the options file (DSM.OPT), then the file will be resent uncompressed if it grows during compression.
For API Applications, consult the application's documentation for recommendations regarding compression.
Turn off disk caching in the disk storage pool, and issue MOVE DATA commands to each disk pool volume to clear out the cached bitfiles.
rc = 11 is not the real RC coming back from TSM. You need to check the RC after the following line:
MESSAGE : sqluvint failed! Vendor rc:
See this technote for more info:
IBM Interpreting Vendor API return codes from db2diag.log messages - United States
Originally Posted by stj20
However TSM password has expired and stopped backup and log archiving. TSM staff reset the password and now backup works but log archiving still failed
DB2 loads TSM API when the backup is initiated, but DB2 logger loads it when the instance is started and a portion of it is held in memory until instance recycle. You can try restarting the instance. The real RC from TSM will tell you why it's failing.
Hi, This is the TSM message based on 'sqluvint failed! Vendor rc'
2041 E: DSM_RC_BAD_CALL_SEQUENCE The sequence of calls is invalid.
This does not say much. Backups and the Logs go to the same storage pool and it's unlikely that this is a Storage issue. Thanks in advance for your help.
Have you tried restarting the instance?
Because backup is working and log archival is failing, I suspect that instance recycle will help here.
for backup you need backup stgpool and for logs you need archive stgpool
usually that can not be the same
we had a similar problem and killed the db2vend process for that db - it will restart
for pw problem it is better to use the generated option and execute dsmapipw
Thanks all and the restart works and do not see any messages on db2diag.log. By the way how should I make sure archiving are happening into TSM without depend on DB2diag.log. In other words how can I prove the issue has resolved.
we use the db2diag command to find messages from last hour that have the text archive in it and ship mail whenever we found this message
Originally Posted by stj20
Thanks all and the restart works and do not see any messages on db2diag.log. By the way how should I make sure archiving are happening into TSM without depend on DB2diag.log. In other words how can I prove the issue has resolved.
Hi,
You can check if LOG files are going into TSM with this command :
db2adutl query logs
(with db2adutl query command, you can check also the backups)
I appreciate this is fixed now. I just wanted to add that when we got a RC 11 and archive logs failing (and backup failing as well) it was because the db2 instance owner could not write to the dsierror.log. (AIX server)
There are two db2 instances on the server and only one of them could write to the log file as it was in it's home directory. In the end we put this line in dsm.sys:
ERRORLOGNAME /var/log/tsm/dsierror.log
ensured it was opened to both instances and it all worked again.
Thanks everyone for your valuable inputs .
Another way to to use "list history archive log" command. When you migrate to v9.x (I think this is not in v8), you will see messages about logs getting archived in the db2diag.log.

Related Links

Convert Date to Varchar
how to copy dbm cfg parameters?
How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
Timestamp column and null indicators
Looking for DB2 UDB 7.1 Trial Version
Weird Problem while retrieving data via php
Migrate DB2 8.1 Tables to DB2 9.5 with partitioning
Federated Stored Procedure - parameters
Federation Server to Oracle 10g - Sequences
ADM1832E error got ????
whats SQL Error: -1131, SQLState: 38503 ???
help: A speech interface for information retrieval using .db2 file
Select
DB2 Federation
Data loading from DB2 UDB to DB2/MVS
Regarding LOAD ...

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App