Hi,
I want to discuss a scenario, I want to take incremental backup and below are steps which i considered to achieve this but having confusion.
Firstly I took an full offline backup on sunday through below mentioned command and verify it's integrity, Backup size was 1.1 TB.
db2 "backup database db1 user user1 using pauser1 to /backup/offlineBkp/29nov2020_AR/ with 3 buffers buffer 1000 without prompting"
======================================================
Secondly today (on Monday) I took an incremental backup through below mentioned command and i was thinking that it's size would be in 15 - 20 GB but it is taking more space, So i cancelled the online backup.
db2 "backup database db1 user user1 using pauser1 online incremental to /backup/offlineBkp/29nov2020_AR/ include logs without prompting"
======================================================
Why i assumed about it's size in 15 - 20 GB as per definition inremental backup takes backup from the last full backup till end.
TRACKMODE parameter is set to ON.
=========================================================================================================
As you can see around 90 GB was the backup size when I cancelled it and as per Total Work it is showing around 1.1 TB
febinst:~> db2 list utilities show detail
ID = 2389
Type = BACKUP
Database Name = FEBDB
Member Number = 0
Description = online incremental db
Start Time = 11/30/2020 21:04:58.543612
State = Executing
Invocation Type = User
Throttling:
Priority = Unthrottled
Progress Monitoring:
Estimated Percentage Complete = 8
Total Work = 1124302279067 bytes
Completed Work = 94980345731 bytes
Start Time = 11/30/2020 21:04:58.543626
#Db2#Db2forLUW#Support#SupportMigration