DB2 and the MVS System Logger

John Krew

DB2 and the MVS System Logger
Does anyone know if DB2 logging be implemented using the
MVS System Logger, say, in version 8 of DB2?

John Krew

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Cathy Taddei

Re: DB2 and the MVS System Logger
(in response to John Krew)
I have not heard of anything like that. I hope IBM tells us in advance
about such a change, especially if it would affect the way archive logs are
managed. I think it is highly unlikely that this will be implemented in DB2
version 8 -- I've been to several presentations about the new features, and
this was not among them. You might get a definitive answer by asking IBM
directly. Let us know what you find out.

Regards,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of John Krew
Sent: Thursday, December 25, 2003 1:18 AM
To: [login to unmask email]
Subject: DB2 and the MVS System Logger


Does anyone know if DB2 logging be implemented using the
MVS System Logger, say, in version 8 of DB2?

John Krew

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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

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

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

=====

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Wayne Driscoll

Re: DB2 and the MVS System Logger
(in response to Cathy Taddei)
John,
I know that this change has NOT been made in version 8, and I would be
surprised if DB2 ever went to use the MVS system logger since DB2
utilizes its logs in a manner that is much different than other
(non-DB2) logging strategies.
Wayne Driscoll
Sr. Software Developer
Quest Software
[login to unmask email]
NOTE: All opinions are strictly my own. EMail Address in sig must be
modified.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of John Krew
Sent: Thursday, December 25, 2003 3:18 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 and the MVS System Logger


Does anyone know if DB2 logging be implemented using the
MVS System Logger, say, in version 8 of DB2?

John Krew

------------------------------------------------------------------------
---------
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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Max Scarpa

Re: DB2 and the MVS System Logger
(in response to Wayne Driscoll)
Dr Jim Teng said (personal communication during a seminar) that they are
thinking to modify DB2's log mechanism to disable logging under some
circumstances (as ORACLE do), but using the actual logging structure. He
didn't talk about other MVS resources.

Regards

Max Scarpa
DB2 sysprog

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Roger Miller

Re: DB2 and the MVS System Logger
(in response to Max Scarpa)
Why would you want DB2 to use the System Logger? We have looked a couple
of times, and do not see a way of using System Logger to improve DB2
performance or availability. The System Logger does not have many key
functions that allow the current log process its speed. When we see the
ability to write with no force to the log, performance measurements in the
30 MB / sec range, or some major availability improvements, we can look
again.

Roger Miller

On Tue, 30 Dec 2003 14:09:14 +0100, [login to unmask email] wrote:

>Dr Jim Teng said (personal communication during a seminar) that they are
>thinking to modify DB2's log mechanism to disable logging under some
>circumstances (as ORACLE do), but using the actual logging structure. He
>didn't talk about other MVS resources.
>
>Regards
>
>Max Scarpa
>DB2 sysprog
>

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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