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.db2ins t4.NODE0000.CAT N0000.200411300 71003.1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200411300 71003.2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 55534.1

/db2backup04/db2inst4/backups/SAMPLE.pipe1I &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 55534.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.db2ins t4.NODE0000.CAT N0000.200411300 71003.1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200
41130071003.2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 53832.1 /db2backup04/db2inst4/backups/SAMPLE.pipe1 &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 53832.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.db2ins t4.NODE0000.CAT N0000.200411300 71003.1.Z

uncompress
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200411300 71003.2.Z

cat
/db2backup04/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 55534.1 /db2backup04/db2inst4/backups/SAMPLE.pipe1I &
cat
/db2backup05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412021 55534.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

3152

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.db2ins t4.NODE0000.CAT N0000.200412070 71004.1.Z
&
cat /db2backup05/db2inst4/backups/SAMPLE.pipe2I | nice -n 10 compress >
/db2back
up05/db2inst4/backups/SAMPLE.0.db2ins t4.NODE0000.CAT N0000.200412070 71004.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

2224

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 incremental only. My question is for the first weekend incremental backup, it took for example 1h, but the second weekend incremental took almost 3 hours. It seems always this way, so I suppose it is not related to the data change. And we almost had some...

DB2 Database

3476

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 - backup - * backup db2 in full * insert record

DB2 Database

3821

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 Oracle database means entire database, i.e.. all tablespaces (including indexes). I see only recover tablespace and recover indexspace (or index) commands in db2. Therefore, one has to specify all the tablespaces and indexspaces and recover them

DB2 Database

786

Recover Using INCREMENTAL AUTOMATIC

by: apple | last post by:

DB2 Database

5831

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 create a dll, using the cl compiler I was getting many unresolved external errors, Example 1 below (8 in total, 7 to do with the registry function calls and 1 from wsprintfA call) as I hadn't included the AdvAPI32.lib file. So I created a LINK...

C / C++

6549

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 (.lib)". My question: Should the linker incrementally link when I make a change to one of the ..cpps in one of my .lib projects? For VC6 the answer is yes.

.NET Framework

4299

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 to do it once. But now it is always giving me error while doing restore from other machine. It gives me this Error:

DB2 Database

3020

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. In C#, there appears to be no analog. I have to compile all my .cs files into a single .dll. This has serious drawbacks in terms of compilation. With Eclipse, I change a file and only that file is re-compiled. With Visual Studio, I

C# / C Sharp

1437

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 visible on the screen? Thank you in advance for your assistance.

General

8403

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8930

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8828

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8677

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7446

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4227

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4417

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2819

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 we have to send another system

C# / C Sharp