468,292 Members | 1,841 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,292 developers. It's quick & easy.

Backup with logs included

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
1 1417
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.

Similar topics

6 posts views Thread by paul | last post: by
10 posts views Thread by Konstantin Andreev | last post: by
2 posts views Thread by clilush | last post: by
1 post views Thread by heyzulu59 | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.