When does LOAD COPY YES write the backup image ?

Joachim Klassen

Hi all,

a couple of questions regarding LOAD COPY YES:
when does a LOAD COPY YES start to write its backup image ? After LOAD
Phase or after BUILD or DELETE phase?
What gets backed up - data pages only or index pages as well?
When I use TSM as backup target, will DB2 send an estimate of the
backup size to TSM before backup starts?

TIA for any answer

Joachim

Jan 24 '07 #1

Subscribe Reply

5209

Pierre Saint-Jacques

As far as I understand, the COPY YES just generates a straight copy of the
source file. It is made up of each successfully parsed record (parsing is
in phase on of the load) and is concurrent with the building of the uinput
buffers that are smashed into the target table.
When phase one is done, load has to deal with index build and so on and by
that time, I believe the copy is done.
This is not being copied in page, extent struture. I think that each
succesfully parsed record is structured properly to be moved into the row in
the target table and it is that structure which is also copied, record by
recordm, into the target copy file.

I don't know TSM and DB2 well enough to say but at least as the file is
ready, its size is known and TSM could be told. I just don't know if DB2
does that with TSM.
Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Joachim Klassen" <Jo*******@emai l.coma écrit dans le message de news:
11************* *********@m58g2 00...legr oups.com...

Hi all,

a couple of questions regarding LOAD COPY YES:
when does a LOAD COPY YES start to write its backup image ? After LOAD
Phase or after BUILD or DELETE phase?
What gets backed up - data pages only or index pages as well?
When I use TSM as backup target, will DB2 send an estimate of the
backup size to TSM before backup starts?

TIA for any answer

Joachim

Jan 24 '07 #2

Similar topics

17855

LOAD vs. IMPORT

by: usenet | last post by:

Hi. Can any of you explain the major differences in LOAD and IMPORT in laymen terms? I've read the DB2 docs: " Inserts data from an external file with a supported file format into a table, hierarchy, or view. A faster alternative is LOAD; however, the load utility does not support loading data at the hierarchy level."

DB2 Database

3732

Of Icon handle lifetime and when is it truly disposed

by: Terry | last post by:

There are a number of things about using unmanaged resources in Windows Forms programming that is unclear to me. In C++, if you loaded an icon resource using "ExtractIcon()", the resource was valid until you called "DestroyIcon()". If you didn't, you had a leak. In C#, I need to load icons from unmanaged programs (.exe, dll) at run time and I want to make sure I'm not leaking resources, but it's not clear to me how to insure that I'm...

C# / C Sharp

7039

nonrecoverable load during backup

by: db2freak | last post by:

What happens if a nonrecoverable load is running when an online backup is running? What would happen to the table and data if we have to use that backup to restore the database?

DB2 Database

3113

db2 database online copy help?

by: kebuchan | last post by:

Hi all, I know this is possible in Oracle but has anyone done it in DB2 and could you maybe direct me to some documentation or let me know how I would go about doing it? In the oracle world you would basically need to do the following: 1. Set tablespace to backup mode 2. Copy associated data files to new directory/system

DB2 Database

13256

Preventing Access from crashing, when it looses connection to the database

by: mark_aok | last post by:

Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there are no local copies. When connection to this drive is lost, Access CRASHES. It does it every single time. Does anyone know if there is a way to check if

Microsoft Access / VBA

12861

copy few lines from one file to another file.

by: maheshkadam | last post by:

Hi friends I am new to perl so please guide me. I have one application which created backup log file every day.But it appends that file so you can see logs for different day in one file only. My requirement is to copy backup log for the specific day (yesterday) and write in other file. That file will be mailed to admin for ready reference. So here is some text from that log file

Perl

1940

Does anyone know how to make a piece of software an Evaluation Copy

by: johnguilbert | last post by:

Hi, I have developed an application that I want to make an Evaluation Copy for 1 week. In the past I have used one of the following techniques with each having a drawback: 1. Write to Registry - Problem: Can use before and after image to see changes 2. Use of Windows Clock - Problem: Clock can be changed 3. Write to file - : Problem - Can perform a search on files changed

C# / C Sharp

6080

tablespace queisced after load fail in partioned db

by: danfan46 | last post by:

Hi. I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four partitions where catalog is on partion 0 and user data on 1 thru 3. After a load failure (path to load file was wrong) I cannot access the tables, even though the loads have been rerun with success. set integrity for ..table..

DB2 Database

4518

How to "LOAD COPY NO" without backup ?

by: mvsmsh | last post by:

Hi , How can I load without copy in UDB V8/AIX , I don't want copy or backup after load. Are there any command in UDB , like Z/OS DB2 "repair tablespace nocopypend" ?

DB2 Database

10211

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++

10045

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

9994

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

9863

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

8870

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

7408

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6673

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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3958

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

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General