How To
Summary
Users can use db2ckbkp to list the table space names included in a backup file.
Steps
db2ckbkp -a returns all the table space name in the database. The table space included in the backup image has "tbspInImage" value "T" while "F" for the table spaces not included in the backup.
(AIX)
db2ckbkp -a backup_file | grep -p "tbspInImage: T"
(Linux)
db2ckbkp -a backup_file | grep -B 1 "tbspInImage: T"
The output might include Temporary table spaces, which can be ignored.
The transaction log necessary for the online backup can be verified by checking the "Head Extent ID" and "Backup End Marker" value.
For more information, check the following technote.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m3p0000006wjpAAA","label":"Backup"},{"code":"a8m500000008PmdAAE","label":"Recovery-\u003ERestore"}],"ARM Case Number":"TS013331293","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0"}]
Was this topic helpful?
Document Information
Modified date:
25 June 2023
UID
ibm17006473