DB2 V7 z/OS - active log switching

john matthews

DB2 V7 z/OS - active log switching
We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DB2 V7 z/OS - active log switching
(in response to john matthews)
check point freq is both in time and log records, and each checkpoint puts
out a significant number of records.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Matthews, John
Sent: Tuesday, January 17, 2006 6:55 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 z/OS - active log switching

We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for
the use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may subject
you to federal and state penalties. If you are not the intended recipient,
please immediately notify us by return email, and delete this message from
your computer.
----------------------------------------------------------

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DB2 V7 z/OS - active log switching
(in response to Mike Bell)
John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was compressed.
In the compressed data world having more index (total) than data is not uncommon.
This could account for the 2x or 3x increase in 'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:
We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

john matthews

Re: DB2 V7 z/OS - active log switching
(in response to Avram Friedman)
You are right - indices were not considered because we don't use COPY YES
option on indices. Are indices logged even though we don't take image copies
of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was compressed.
In the compressed data world having more index (total) than data is not
uncommon.
This could account for the 2x or 3x increase in 'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical! facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the
use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may subject
you to federal and state penalties. If you are not the intended recipient,
please immediately notify us by return email, and delete this message from
your computer.
----------------------------------------------------------

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave th! e list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email] <mailto:[login to unmask email]>
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >


----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steen Rasmussen

Re: DB2 V7 z/OS - active log switching
(in response to john matthews)
Hi John -



This is a surprise to many people (including me until I started to
research a couple of years ago) - but DB2 is logging the index updates
no matter if COPY YES is specified or not.

That is why the LOG COMPRESS products in the market still are very
valid. This is a unique way to eliminate the index log records, but
unfortunately this will not help you in this specific scenario (but
recovery will spin through the logs faster).



Kind regards
Steen Rasmussen
CA
Senior Consultant

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Matthews, John
Sent: Tuesday, January 17, 2006 9:20 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching



You are right - indices were not considered because we don't use COPY
YES option on indices. Are indices logged even though we don't take
image copies of them? Is there a reference to this in a DB2 manual?

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Vaughan

Re: DB2 V7 z/OS - active log switching
(in response to Steen Rasmussen)
Rollbacks will still need to operate on indexes, regardless of the copy yes/no setting, so they do need to be logged. There might be more complete doc somewhere else in the manuals, but a quick search of the admin guide brough up the following... http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/APPENDIX1.3.1.1.4?ACTION=MATCHES&REQUEST=logging+index&TYPE=FUZZY&SHELF=&DT=20050721100022&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

________________________________

From: DB2 Data Base Discussion List on behalf of Matthews, John
Sent: Tue 1/17/2006 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


You are right - indices were not considered because we don't use COPY YES option on indices. Are indices logged even though we don't take image copies of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was compressed.
In the compressed data world having more index (total) than data is not uncommon.
This could account for the 2x or 3x increase in 'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical! facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: DB2 V7 z/OS - active log switching
(in response to Mike Vaughan)
Rollback of an uncommitted unit of work and recovery of committed work that has not yet been externalized to table / index-spaces in the case of a DB2 restart both require logging regardless of how INDEX COPY YES / NO is coded.

I think psychic recovery / integrity is being considered for a DB2 after Vnext but you did not hear it here first.

"Matthews, John" <[login to unmask email]> wrote:
You are right - indices were not considered because we don't use COPY YES option on indices. Are indices logged even though we don't take image copies of them? Is there a reference to this in a DB2 manual?
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was compressed.
In the compressed data world having more index (total) than data is not uncommon.
This could account for the 2x or 3x increase in 'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:
We asked for years for users to delete data and now they are starting to.
But now our active logs are filling up and switching much more frequently. I
guestimated the space for one delete job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very low activity period and it seems
the DB2 logs were filling up 2 to 3 times quicker than I had guessed based
on average compressed row length of deleted rows. Have I forgotten some
critical! facts about active log capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
----------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com



--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality may subject you to federal and state penalties. If you are not the intended recipient, please immediately notify us by return email, and delete this message from your computer.
---------------------------------------------------------- --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David S. Waugh

Re: DB2 V7 z/OS - active log switching
(in response to Avram Friedman)
On occasion, whilst poking around through log records, I've noticed that
index page splits are also logged (from 3 to 5 log records per page split,
if I remember right). I've always assumed that on rollback they need to
be "unsplit" as part of the undo process, and this is one of the reasons
they're logged. I imagine these log records are also needed when DB2
recovers from a crash. Can anyone confirm this?
.
.
Thanks,
.
David Waugh
IM-3 DB2 Database Administration
Los Alamos National Laboratory




"Vaughan, Mike" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/17/2006 10:12 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 V7 z/OS - active log switching






Rollbacks will still need to operate on indexes, regardless of the copy
yes/no setting, so they do need to be logged. There might be more
complete doc somewhere else in the manuals, but a quick search of the
admin guide brough up the following...
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/APPENDIX1.3.1.1.4?ACTION=MATCHES&REQUEST=logging+index&TYPE=FUZZY&SHELF=&DT=20050721100022&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT


________________________________

From: DB2 Data Base Discussion List on behalf of Matthews, John
Sent: Tue 1/17/2006 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


You are right - indices were not considered because we don't use COPY YES
option on indices. Are indices logged even though we don't take image
copies of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume
calculation.
I did notice that you mentioned that the data was
compressed.
In the compressed data world having more index (total)
than data is not uncommon.
This could account for the 2x or 3x increase in
'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete
data and now they are starting to.
But now our active logs are filling up
and switching much more frequently. I
guestimated the space for one delete
job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise
very low activity period and it seems
the DB2 logs were filling up 2 to 3 times
quicker than I had guessed based
on average compressed row length of
deleted rows. Have I forgotten some
critical! facts about active log
capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any
attachments) is only intended for the use of the person or entity to which
it is addressed, and may contain information that is privileged and
confidential. You, the recipient, are obligated to maintain it in a safe,
secure and confidential manner. Unauthorized redisclosure or failure to
maintain confidentiality may subject you to federal and state penalties.
If you are not the intended recipient, please immediately notify us by
return email, and delete this message from your computer.
----------------------------------------------------------


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To
unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join
or Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for
the use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may
subject you to federal and state penalties. If you are not the intended
recipient, please immediately notify us by return email, and delete this
message from your computer.
----------------------------------------------------------
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David S. Waugh

Re: DB2 V7 z/OS - active log switching
(in response to Mike Bell)
On occasion, whilst poking around through log records, I've noticed that
index page splits are also logged (from 3 to 5 log records per page split,
if I remember right). I've always assumed that on rollback they need to
be "unsplit" as part of the undo process, and this is one of the reasons
they're logged. I imagine these log records are also needed when DB2
recovers from a crash. Can anyone confirm this?


Thanks,

David Waugh
IM-3 DB2 Database Administration
Los Alamos National Laboratory




"Vaughan, Mike" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/17/2006 10:12 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 V7 z/OS - active log switching






Rollbacks will still need to operate on indexes, regardless of the copy
yes/no setting, so they do need to be logged. There might be more
complete doc somewhere else in the manuals, but a quick search of the
admin guide brough up the following...
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/APPENDIX1.3.1.1.4?ACTION=MATCHES&REQUEST=logging+index&TYPE=FUZZY&SHELF=&DT=20050721100022&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT


________________________________

From: DB2 Data Base Discussion List on behalf of Matthews, John
Sent: Tue 1/17/2006 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


You are right - indices were not considered because we don't use COPY YES
option on indices. Are indices logged even though we don't take image
copies of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume
calculation.
I did notice that you mentioned that the data was
compressed.
In the compressed data world having more index (total)
than data is not uncommon.
This could account for the 2x or 3x increase in
'expected' volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete
data and now they are starting to.
But now our active logs are filling up
and switching much more frequently. I
guestimated the space for one delete
job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise
very low activity period and it seems
the DB2 logs were filling up 2 to 3 times
quicker than I had guessed based
on average compressed row length of
deleted rows. Have I forgotten some
critical! facts about active log
capacity? CHECKPOINT frequency is 15
minutes.

----------------------------------------------------------
IMPORTANT WARNING: This email (and any
attachments) is only intended for the use of the person or entity to which
it is addressed, and may contain information that is privileged and
confidential. You, the recipient, are obligated to maintain it in a safe,
secure and confidential manner. Unauthorized redisclosure or failure to
maintain confidentiality may subject you to federal and state penalties.
If you are not the intended recipient, please immediately notify us by
return email, and delete this message from your computer.
----------------------------------------------------------


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To
unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join
or Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for
the use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may
subject you to federal and state penalties. If you are not the intended
recipient, please immediately notify us by return email, and delete this
message from your computer.
----------------------------------------------------------
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DB2 V7 z/OS - active log switching
(in response to David S. Waugh)
Not since type2 indexes - splits are always kept. The data value will be
removed but the split stays. That was part of removing the index locking
way back when type2 indexes came out.
They are needed to rebuild the split if you lose the dataset and have to
recover but that is all.

Mike
HLS Technologies


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of David S. Waugh
Sent: Wednesday, January 18, 2006 10:30 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


On occasion, whilst poking around through log records, I've noticed that
index page splits are also logged (from 3 to 5 log records per page split,
if I remember right). I've always assumed that on rollback they need to be
"unsplit" as part of the undo process, and this is one of the reasons
they're logged. I imagine these log records are also needed when DB2
recovers from a crash. Can anyone confirm this?
.
.
Thanks,
.
David Waugh
IM-3 DB2 Database Administration
Los Alamos National Laboratory




"Vaughan, Mike" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

01/17/2006 10:12 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>

To
[login to unmask email]
cc
Subject
Re: [DB2-L] DB2 V7 z/OS - active log switching






Rollbacks will still need to operate on indexes, regardless of the copy
yes/no setting, so they do need to be logged. There might be more complete
doc somewhere else in the manuals, but a quick search of the admin guide
brough up the following...
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/APPENDIX1.3.1.1
.4?ACTION=MATCHES&REQUEST=logging+index&TYPE=FUZZY&SHELF=&DT=20050721100022&
CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTO
P=FIRSTHIT#FIRSTHIT

________________________________

From: DB2 Data Base Discussion List on behalf of Matthews, John
Sent: Tue 1/17/2006 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


You are right - indices were not considered because we don't use COPY YES
option on indices. Are indices logged even though we don't take image copies
of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was
compressed.
In the compressed data world having more index (total) than
data is not uncommon.
This could account for the 2x or 3x increase in 'expected'
volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete data
and now they are starting to.
But now our active logs are filling up and
switching much more frequently. I
guestimated the space for one delete
job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very
low activity period and it seems
the DB2 logs were filling up 2 to 3 times
quicker than I had guessed based
on average compressed row length of deleted
rows. Have I forgotten some
critical! facts about active log capacity?
CHECKPOINT frequency is 15
minutes.


----------------------------------------------------------
IMPORTANT WARNING: This email (and any
attachments) is only intended for the use of the person or entity to which
it is addressed, and may contain information that is privileged and
confidential. You, the recipient, are obligated to maintain it in a safe,
secure and confidential manner. Unauthorized redisclosure or failure to
maintain confidentiality may subject you to federal and state penalties. If
you are not the intended recipient, please immediately notify us by return
email, and delete this message from your computer.

----------------------------------------------------------


----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To
unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or
Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The
IDUG List Admins can be reached at [login to unmask email] Find out
the latest on IDUG conferences at http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >



----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the
use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may subject
you to federal and state penalties. If you are not the intended recipient,
please immediately notify us by return email, and delete this message from
your computer.
----------------------------------------------------------
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DB2 V7 z/OS - active log switching
(in response to David S. Waugh)
Not since type2 indexes - splits are always kept. The data value will be
removed but the split stays. That was part of removing the index locking
way back when type2 indexes came out.
They are needed to rebuild the split if you lose the dataset and have to
recover but that is all.

Mike
HLS Technologies


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of David S. Waugh
Sent: Wednesday, January 18, 2006 10:30 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


On occasion, whilst poking around through log records, I've noticed that
index page splits are also logged (from 3 to 5 log records per page split,
if I remember right). I've always assumed that on rollback they need to be
"unsplit" as part of the undo process, and this is one of the reasons
they're logged. I imagine these log records are also needed when DB2
recovers from a crash. Can anyone confirm this?


Thanks,

David Waugh
IM-3 DB2 Database Administration
Los Alamos National Laboratory




"Vaughan, Mike" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

01/17/2006 10:12 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>

To
[login to unmask email]
cc
Subject
Re: [DB2-L] DB2 V7 z/OS - active log switching






Rollbacks will still need to operate on indexes, regardless of the copy
yes/no setting, so they do need to be logged. There might be more complete
doc somewhere else in the manuals, but a quick search of the admin guide
brough up the following...
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/APPENDIX1.3.1.1
4?ACTION=MATCHES&REQUEST=logging+index&TYPE=FUZZY&SHELF=&DT=20050721100022&
CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTO
P=FIRSTHIT#FIRSTHIT

________________________________

From: DB2 Data Base Discussion List on behalf of Matthews, John
Sent: Tue 1/17/2006 9:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


You are right - indices were not considered because we don't use COPY YES
option on indices. Are indices logged even though we don't take image copies
of them? Is there a reference to this in a DB2 manual?

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Avram Friedman
Sent: Tuesday, January 17, 2006 6:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V7 z/OS - active log switching


John,
I did not see indexes listed in your log volume calculation.
I did notice that you mentioned that the data was
compressed.
In the compressed data world having more index (total) than
data is not uncommon.
This could account for the 2x or 3x increase in 'expected'
volume.

"Matthews, John" <[login to unmask email]> wrote:

We asked for years for users to delete data
and now they are starting to.
But now our active logs are filling up and
switching much more frequently. I
guestimated the space for one delete
job(using cursor and DELETE WHERE
CURRENT) that ran during an otherwise very
low activity period and it seems
the DB2 logs were filling up 2 to 3 times
quicker than I had guessed based
on average compressed row length of deleted
rows. Have I forgotten some
critical! facts about active log capacity?
CHECKPOINT frequency is 15
minutes.


----------------------------------------------------------
IMPORTANT WARNING: This email (and any
attachments) is only intended for the use of the person or entity to which
it is addressed, and may contain information that is privileged and
confidential. You, the recipient, are obligated to maintain it in a safe,
secure and confidential manner. Unauthorized redisclosure or failure to
maintain confidentiality may subject you to federal and state penalties. If
you are not the intended recipient, please immediately notify us by return
email, and delete this message from your computer.

----------------------------------------------------------


----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To
unsubscribe, go to the archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or
Leave th! e list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The
IDUG List Admins can be reached at [login to unmask email] Find out
the latest on IDUG conferences at http://conferences.idug.org/index.cfm





Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com < http://www.ibmsysprog.com/ >



----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


----------------------------------------------------------
IMPORTANT WARNING: This email (and any attachments) is only intended for the
use of the person or entity to which it is addressed, and may contain
information that is privileged and confidential. You, the recipient, are
obligated to maintain it in a safe, secure and confidential manner.
Unauthorized redisclosure or failure to maintain confidentiality may subject
you to federal and state penalties. If you are not the intended recipient,
please immediately notify us by return email, and delete this message from
your computer.
----------------------------------------------------------
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [login to unmask email] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm