Connecting Tech Pros Worldwide Forums | Help | Site Map

Backup with logs included

Eugene F
Guest
 
Posts: n/a
#1: Aug 23 '06
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


Shashi Mannepalli
Guest
 
Posts: n/a
#2: Aug 23 '06

re: Backup with logs included


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:
Quote:
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
Closed Thread