[db2inst1@localhost /]$ db2 backup db sample online to /dbbak
Backup successful. The timestamp for this backup image is : 20120523114710
[db2inst1@localhost /]$ db2 backup db sample online to /dbbak include logs
Backup successful. The timestamp for this backup image is : 20120523115500
看下面的include logs
[db2inst1@localhost dbbak]$ db2ckbkp -h SAMPLE.0.db2inst1.NODE0000.CATN0000.20120523114710.001
=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE
Server Database Alias -- SAMPLE
Client Database Alias -- SAMPLE
Timestamp -- 20120523114710
Database Partition Number -- 0
Instance -- db2inst1
Sequence Number -- 1
Release ID -- D00
Database Seed -- 8937DB46
DB Comment's Codepage (Volume) -- 0
DB Comment (Volume) --
DB Comment's Codepage (System) -- 0
DB Comment (System) --
Authentication Value -- -1
Backup Mode -- 1
Includes Logs -- 1
Compression -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 21
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- UTF-8
DB Territory --
LogID -- 1337153185
LogPath -- /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Backup Buffer Size -- 2363392
Number of Sessions -- 1
Platform -- 1E
The proper image file name would be:
SAMPLE.0.db2inst1.NODE0000.CATN0000.20120523114710.001
[1] Buffers processed: ###################################################################################
Image Verification Complete - successful.
[db2inst1@localhost dbbak]$ db2ckbkp -h SAMPLE.0.db2inst1.NODE0000.CATN0000.20120523115500.001
=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE
Server Database Alias -- SAMPLE
Client Database Alias -- SAMPLE
Timestamp -- 20120523115500
Database Partition Number -- 0
Instance -- db2inst1
Sequence Number -- 1
Release ID -- D00
Database Seed -- 8937DB46
DB Comment's Codepage (Volume) -- 0
DB Comment (Volume) --
DB Comment's Codepage (System) -- 0
DB Comment (System) --
Authentication Value -- -1
Backup Mode -- 1
Includes Logs -- 1
Compression -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 20
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- UTF-8
DB Territory --
LogID -- 1337153185
LogPath -- /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Backup Buffer Size -- 2363392
Number of Sessions -- 1
Platform -- 1E
The proper image file name would be:
SAMPLE.0.db2inst1.NODE0000.CATN0000.20120523115500.001
[1] Buffers processed: ###################################################################################
Image Verification Complete - successful.
这里面的log有什么区别？
收起