MergeCopy Question - DB2 V8 on z/OS

Carol Anne Sutfin

MergeCopy Question - DB2 V8 on z/OS
I have a dilemia with one of the application DBA.'s.

I am attempting to get them to use incremental copies for daily processing
and fill for weekly.

Some of the tablespaces do not have changes every day.
They still create an "emtpy" incremental copy daily.

They are also doing a MERGECOPY daily, with NEWCOPY YES to get a new FULL
copy.

The problem (for them) is if the incremental copy is empty, then DB2 does
not copy the Full Copy to the COPYDDN file specified on the MERGECOPY.

I understand why this happens.

But my application DBA's don't.
They want to use the output copy for more processing (UNLOADs)
They also expect this output copy to be used for Recovery.

Has anyone else encountered this problem.

I would appreciate any help here

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Lockwood Lyon

Re: MergeCopy Question - DB2 V8 on z/OS
(in response to Carol Anne Sutfin)
Carol,

That's ... interesting. We are just starting to get into Incremental
ICs, and I didn't know about this 'problem'. I took a look at the
Utility Guide and didn't see any mention of this; what error message(s)
do you get?

Of course, one way to fix this is to ensure that 'something' gets
updated in each of the tablespaces every day. I know it sounds foolish,
but would an Insert / Commit / Delete of a bogus row solve the issue?

Lock Lyon, Principal Database Administrator
Fifth Third Bancorp
616.653.8528

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Friday, November 28, 2008 12:19 PM
To: [login to unmask email]
Subject: [DB2-L] MergeCopy Question - DB2 V8 on z/OS

I have a dilemia with one of the application DBA.'s.

I am attempting to get them to use incremental copies for daily
processing and fill for weekly.

Some of the tablespaces do not have changes every day.
They still create an "emtpy" incremental copy daily.

They are also doing a MERGECOPY daily, with NEWCOPY YES to get a new
FULL copy.

The problem (for them) is if the incremental copy is empty, then DB2
does not copy the Full Copy to the COPYDDN file specified on the
MERGECOPY.

I understand why this happens.

But my application DBA's don't.
They want to use the output copy for more processing (UNLOADs) They also
expect this output copy to be used for Recovery.

Has anyone else encountered this problem.

I would appreciate any help here

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Roger Hecq

Re: MergeCopy Question - DB2 V8 on z/OS
(in response to Lockwood Lyon)
What is being specified for the ChangeLimit parameter on the Copy
statement? The default is (1,10), which will only produce an incremental
IC if 1%, or more, of the pages are changed. I believe that if you
change the values to (0,10) you will get an incremental, even if there
are no changed pages. You need not use 10% for the upper range, I used
it because that is what is in the doc.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Friday, November 28, 2008 12:19 PM
To: [login to unmask email]
Subject: [DB2-L] MergeCopy Question - DB2 V8 on z/OS

I have a dilemia with one of the application DBA.'s.

I am attempting to get them to use incremental copies for daily
processing and fill for weekly.

Some of the tablespaces do not have changes every day.
They still create an "emtpy" incremental copy daily.

They are also doing a MERGECOPY daily, with NEWCOPY YES to get a new
FULL copy.

The problem (for them) is if the incremental copy is empty, then DB2
does not copy the Full Copy to the COPYDDN file specified on the
MERGECOPY.

I understand why this happens.

But my application DBA's don't.
They want to use the output copy for more processing (UNLOADs) They also
expect this output copy to be used for Recovery.

Has anyone else encountered this problem.

I would appreciate any help here

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms