Recover Using INCREMENTAL AUTOMATIC

apple

UDB v8 fp 6a on AIX 5.1.0.0

Below is a manual incremental recover from compressed backup datasets.
With external compress backup datasets, can it be coded to do an
automatic incremental recover? The manual incremental recover works
just fine, but having trouble getting the automatic incremental recover
to work. Thanks for your help

# INCREMENTAL BACKUP
mkfifo /db2backup04/db2inst4/backups/SAMPLE.pipe1I
mkfifo /db2backup05/db2inst4/backups/SAMPLE.pipe2I

uncompress
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041130071003 .1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041130071003 .2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202155534 .1

/db2backup04/db2inst4/backups/SAMPLE.pipe1I &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202155534 .2 /db2backup05/db2inst4/backups/SAMPLE.pipe2I &
nice db2 restore database SAMPLE incremental from
/db2backup04/db2inst4/backups/SAMPLE.pipe1I ,
/db2backup05/db2inst4/backups/SAMPLE.pipe2I taken at 20041202155537
with 2 buffers buffer 2048 parallelism 1 without prompting
rm /db2backup04/db2inst4/backups/SAMPLE.pipe1I
rm /db2backup05/db2inst4/backups/SAMPLE.pipe2I
#FULL BACKUP
mkfifo /db2backup04/db2inst4/backups/SAMPLE.pipe1
mkfifo /db2backup05/db2inst4/backups/SAMPLE.pipe2

uncompress
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041130071003 .1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.200
41130071003.2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202153832 .1 /db2backup04/db2inst4/backups/SAMPLE.pipe1 &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202153832 .2 /db2backup05/db2inst4/backups/SAMPLE.pipe2 &
nice db2 restore database SAMPLE incremental from
/db2backup04/db2inst4/backups/SAMPLE.pipe1 ,
/db2backup05/db2inst4/backups/SAMPLE.pipe2 taken at 20041202153835 with
2 buffers buffer 2048 parallelism 1 without prompting

rm /db2backup04/db2inst4/backups/SAMPLE.pipe1
rm /db2backup05/db2inst4/backups/SAMPLE.pipe2

# INCREMENTAL BACKUP

mkfifo /db2backup04/db2inst4/backups/SAMPLE.pipe1I
mkfifo /db2backup05/db2inst4/backups/SAMPLE.pipe2I

uncompress
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041130071003 .1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041130071003 .2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202155534 .1 /db2backup04/db2inst4/backups/SAMPLE.pipe1I &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041202155534 .2 /db2backup05/db2inst4/backups/SAMPLE.pipe2I &

nice db2 restore database SAMPLE incremental from
/db2backup04/db2inst4/backups/SAMPLE.pipe1I ,
/db2backup05/db2inst4/backups/SAMPLE.pipe2I taken at 20041202155537
with 2 buffers buffer 2048 parallelism 1 without prompting

rm /db2backup04/db2inst4/backups/SAMPLE.pipe1I
rm /db2backup05/db2inst4/backups/SAMPLE.pipe2I

Nov 12 '05 #1

Subscribe Reply

3127

Ian

apple wrote:

UDB v8 fp 6a on AIX 5.1.0.0

Below is a manual incremental recover from compressed backup datasets.
With external compress backup datasets, can it be coded to do an
automatic incremental recover? The manual incremental recover works
just fine, but having trouble getting the automatic incremental recover
to work. Thanks for your help

If you modify (i.e. compress, relocate, etc) the files that DB2 produces
during a backup, I would be flabbergasted if DB2 can automatically
recover.

You might try using the COMPRESS option on backup, so you don't have to
manually compress the backups after the fact.

Nov 12 '05 #2

apple

Thanks Ian for the reply.

Where is the Compress option on the backup that you specified. I don't
see it in the manuals. Here's how we backup:

mkfifo /db2backup04/db2inst4/backups/SAMPLE.pipe1I

mkfifo /db2backup05/db2inst4/backups/SAMPLE.pipe2I

cat /db2backup04/db2inst4/backups/SAMPLE.pipe1I | nice -n 10 compress >
/db2back
up04/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041207071004 .1.Z
&
cat /db2backup05/db2inst4/backups/SAMPLE.pipe2I | nice -n 10 compress >
/db2back
up05/db2inst4/backups/SAMPLE.0.db2inst4.NODE0000.CATN0000.20041207071004 .2.Z
&
nice db2 backup database SAMPLE online INCREMENTAL to
/db2backup04/db2inst4/backups/SAMPLE.pipe1I ,
/db2backup05/db2inst4/backups/SAMPLE.pipe2I with 2 buffers buffer 1024
parallelism 1

rm /db2backup04/db2inst4/backups/SAMPLE.pipe1I
rm /db2backup05/db2inst4/backups/SAMPLE.pipe2I

Nov 12 '05 #3

apple

Never mind. I found it.

Nov 12 '05 #4

Similar topics

2214

about incremental backup

by: jane | last post by:

HI, I had a question on incremental backup. We had an incremental backup every weekend. We did full backup every other week. That is one week incremental + full , the other week is...

DB2 Database

3456

db2 full-incremental-delta restore/recovery question

by: Jimmy Chen | last post by:

Recently I've done a db2 backup and restore/recovery, but the process for recovering the database was different than what I thought to be. here is what I did: DB2 is set in online mode -...

DB2 Database

3808

is there a recover "db2 subsystem" command in DB2 for OS/390 ..?

by: Prem K Mehrotra | last post by:

I come from Oracle background. In Oracle, when one wants to do a point in time recovery, one can specify recover database until timestmap. Oracle's database maps to a db2 subsystem, i.e., in...

DB2 Database

786

Recover Using INCREMENTAL AUTOMATIC

by: apple | last post by:

UDB v8 fp 6a on AIX 5.1.0.0 Below is a manual incremental recover from compressed backup datasets. With external compress backup datasets, can it be coded to do an automatic incremental recover?...

DB2 Database

5817

LNK 2001 error using the cl compiler??

by: Mary | last post by:

Hello, I am having a problem with the cl compiler. I have written a C class (RegConnect.c) which uses Win32 API functions such as RegOpenKey, RegCloseKey etc. Initially when I was trying to...

C / C++

6524

Incremental linking and multiple projects

by: Rudy Ray Moore | last post by:

I work with a multi-project workspace. One project (the "startup" project) has a "Configuration Type" of "Application (.exe)". The other 40 projects have a "Configuration Type" of "Static Library...

.NET Framework

4257

DB2 Incremental BackUP / Restore problem from one machine to another

by: prerak_v_shah | last post by:

Hi All, These days I was working on IBM DB2 database for windows with my .Net Application. Now, it was required to backup database created on one machine to the other machine. I was also able...

DB2 Database

2984

Why doesn't C# allow incremental compilation like Java?

by: mwelsh1118 | last post by:

Why doesn't C# allow incremental compilation like Java? Specifically, in Java I can compile single .java files in isolation. The resulting individual .class files can be grouped into .jar files....

C# / C Sharp

1427

ms word text box and content disappeared - recover?

by: ghardaway | last post by:

My text box and all of its content disappeared from my screen. It is still there in print preview mode, and my automatic pagination does account for the page. How do I recover it so that it is...

General

7254

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7153

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7432

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7094

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7519

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5079

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4743

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

1585

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

796

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP