473,320 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

When does LOAD COPY YES write the backup image ?

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
1 5119
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*******@email.coma écrit dans le message de news:
11**********************@m58g2000cwm.googlegroups. 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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
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,...
4
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...
3
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?
5
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...
8
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...
3
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. ...
4
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...
5
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...
2
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" ?
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.