If you found this SQLCA Information like this after running "db2 list history backup all for (db_name)". This means that the root cause is hard disk if already full.
====================================================================================
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2419 sqlerrml: 37
====================================================================================
Showing posts with label db2. Show all posts
Showing posts with label db2. Show all posts
Tuesday, September 13, 2011
DB2 Backup Status Indicator
This info is generated when running "List History Backup All For (db_name)"
===========================================================================
Comment: DB2 BACKUP ABCD ONLINE
Start Time: 20060823230001
End Time: 20060824001941
Status: A
===========================================================================
A : Active
I : Inactive
E : Expired
D : Deleted
Referrence : http://bytes.com/topic/db2/answers/527376-list-history-backup-status
===========================================================================
Comment: DB2 BACKUP ABCD ONLINE
Start Time: 20060823230001
End Time: 20060824001941
Status: A
===========================================================================
A : Active
I : Inactive
E : Expired
D : Deleted
Referrence : http://bytes.com/topic/db2/answers/527376-list-history-backup-status
How To Check DB2 Backup History
Follow these steps in terminal :
1. su - db2inst1
2. . ./sqllib/db2profile
3. db2 list history backup all for (db name)
Example : db2 list history backup for all user_db
1. su - db2inst1
2. . ./sqllib/db2profile
3. db2 list history backup all for (db name)
Example : db2 list history backup for all user_db
Subscribe to:
Posts (Atom)