By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,077 Members | 1,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,077 IT Pros & Developers. It's quick & easy.

Backup with logs included

P: n/a
Is there a way to determine if a backup image includes logs, i.e. was
produced by BACKUP DB command with INCLUDE LOGS option

Thanks,
-Eugene

Aug 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This will tell you ....got this from DB2 Information Center

db2ckbkp -h SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909 .001

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE2
Server Database Alias -- SAMPLE2
Client Database Alias -- SAMPLE2
Timestamp -- 19990818122909
Database Partition Number -- 0
Instance -- krodger
Sequence Number -- 1
Release ID -- 900
Database Seed -- 65E0B395
DB Comment's Codepage (Volume) -- 0
DB Comment (Volume) --

DB Comment's Codepage (System) -- 0
DB Comment (System) --

Authentication Value -- 255
Backup Mode -- 0
Include Logs -- 0
Compression -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 11
System Cats inc -- 1
Catalog Database Partition No. -- 0
DB Codeset -- ISO8859-1
DB Territory --
LogID -- 1074717952
LogPath --
/home/krodger/krodger/NODE0000/
SQL00001/SQLOGDIR
Backup Buffer Size -- 4194304
Number of Sessions -- 1
Platform -- 0
Check for INCLUDE LOGS

cheers...
Shashi Mannepalli
Eugene F wrote:
Is there a way to determine if a backup image includes logs, i.e. was
produced by BACKUP DB command with INCLUDE LOGS option

Thanks,
-Eugene
Aug 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.