Quick question on OUTBUFF parameter Z/OS DB2 V8

Martin Hubel

Quick question on OUTBUFF parameter Z/OS DB2 V8
I've spent a lot of quality time with the manuals, but I'm having trouble with being definitive regarding the V8 values for this parameter, and whether it's in pages or K.

My DSNTIJUZ job says OUTBUFF=4000,

The output on a customer's system, using the DSNWZP stored procedure is OUTBUFF 0000004000

My questions are:
1) is this in pages or K? The range is 40K to 400000K

2) I think the default is 4000K. Has this parameter been set to the minimum, or below it according to this output?

Many TIA,
Martin

===========
Martin Hubel
MHC Inc.
www.mhubel.com
+1 905-764-7498
+1 416-670-7498 Mobile

Check out www.db-hq.net Your Headquarters of How-To for DB2
=========== IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Brian Bear

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Martin Hubel)
The way I read it, it's bytes. Quoting the Installation Guide:

"You can enter the value in bytes (for example, 40960) or use the
abbreviation K for kilobytes (for example 40K).



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Martin Hubel
Sent: Friday, November 30, 2007 12:58 PM
To: [login to unmask email]
Subject: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8



I've spent a lot of quality time with the manuals, but I'm having
trouble with being definitive regarding the V8 values for this
parameter, and whether it's in pages or K.

My DSNTIJUZ job says OUTBUFF=4000,

The output on a customer's system, using the DSNWZP stored procedure is
OUTBUFF 0000004000

My questions are:
1) is this in pages or K? The range is 40K to 400000K

2) I think the default is 4000K. Has this parameter been set to the
minimum, or below it according to this output?

Many TIA,
Martin

===========
Martin Hubel
MHC Inc.
www.mhubel.com < http://www.mhubel.com >
+1 905-764-7498
+1 416-670-7498 Mobile

Check out www.db-hq.net < http://www.db-hq.net > Your Headquarters of
How-To for DB2
===========

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- 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 NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Joel Goldstein

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Brian Bear)
Unless things have changed, and it's not likely at this level,
4000 is 4,000K or 1000 4K buffers

Regards,
Joel

Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Martin Hubel
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Friday, November 30, 2007 12:57 PM
Subject: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8


I've spent a lot of quality time with the manuals, but I'm having trouble with being definitive regarding the V8 values for this parameter, and whether it's in pages or K.
My DSNTIJUZ job says OUTBUFF=4000,

The output on a customer's system, using the DSNWZP stored procedure is OUTBUFF 0000004000

My questions are:
1) is this in pages or K? The range is 40K to 400000K

2) I think the default is 4000K. Has this parameter been set to the minimum, or below it according to this output?

Many TIA,
Martin

===========
Martin Hubel
MHC Inc.
www.mhubel.com
+1 905-764-7498
+1 416-670-7498 Mobile

Check out www.db-hq.net Your Headquarters of How-To for DB2
=========== IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

--------------------------------------------------------------------------------- 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 NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Martin Hubel

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Joel Goldstein)
Hi Brian,
Yes, I read it that way too. In 2 shops recently, I have seen this value at 4000 and 40000. Both seem to be below the minimum value of 40960, which means these people have probably received the minimum value for this parameter. Small log buffers are normally a sign of problems.

Thanks--Martin


>> The way I read it, its bytes. Quoting the Installation Guide:

>> You can enter the value in bytes (for example, 40960) or use the
>> abbreviation K for kilobytes (for example 40K).



>> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
>> Of Martin Hubel
>> Sent: Friday, November 30, 2007 12:58 PM
>> To: [login to unmask email]
>> Subject: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8



>> I've spent a lot of quality time with the manuals, but I'm having trouble
>> with being definitive regarding the V8 values for this parameter, and
>> whether it's in pages or K.

>> My DSNTIJUZ job says OUTBUFF=4000,

>> The output on a customer's system, using the DSNWZP stored procedure is
>> OUTBUFF 0000004000

>> My questions are:
>> 1) is this in pages or K? The range is 40K to 400000K

>> 2) I think the default is 4000K. Has this parameter been set to the
>> minimum, or below it according to this output?

>> Many TIA,
>> Martin





===========
Martin Hubel
MHC Inc.
www.mhubel.com
+1 905-764-7498
+1 416-670-7498 Mobile
Check out www.db-hq.net Your Headquarters of How-To for DB2
=========== IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

William Favero

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Martin Hubel)
I'm not sure if this helps..

From the description portion of the DSN6LOGP macro,

A DECIMAL VALUE IN THE RANGE OF 40 TO 400000 SPECIFYING THE OUTPUT LOG
BUFFER POOL SIZE IN K-BYTES.

Willie Favero

Original Message:
-----------------
From: Martin Hubel [login to unmask email]
Date: Fri, 30 Nov 2007 14:41:08 -0500
To: [login to unmask email]
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8



IMPORTANT NOTICE:
<p>
IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the overall
user experience of DB2-L. These changes are coming on November 30th.
Details at http://www.idug.org
<p>
----------------------------------------------------------------------------
-----
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

--------------------------------------------------------------------
mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Joel Goldstein

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to William Favero)
That is certainly what the manual states for V7 and later.
It also says the default now is 4000K.

Going back several versions of DB2, the default was 400 (not K).
Which I always used as 400K....

The old default of 400 should have caused instantaneous and massive log performance problems, even on a small system.
Many small to medium systems ran quite happily with that value. Of course we have to consider the amount of data being changed.
Inserts required a full 4096 bytes.

SO - based on the doc, a value of 4000 without a K on the end implies we should see serious logging delays, and buffer unavailable
during any heavy insert/update workload.

If a system has a value of 4000 specified, substantial updates, and no occurrences
of Log Buffer Unavailable - it's questionable if log buffer size is really only 4000 bytes.

Can anybody verify the amount of memory used for the log buffer based on the specification in your zparm?

While the manuals are usually correct, there are cases where the doc is not correct and DB2 functions differently.
Then sometimes it's a DB2 bug...

Regards,
Joel



Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Bear, Brian
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Friday, November 30, 2007 1:10 PM
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8


The way I read it, it's bytes. Quoting the Installation Guide:

"You can enter the value in bytes (for example, 40960) or use the abbreviation K for kilobytes (for example 40K).




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

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Martin Hubel
Sent: Friday, November 30, 2007 12:58 PM
To: [login to unmask email]
Subject: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8



I've spent a lot of quality time with the manuals, but I'm having trouble with being definitive regarding the V8 values for this parameter, and whether it's in pages or K.

My DSNTIJUZ job says OUTBUFF=4000,

The output on a customer's system, using the DSNWZP stored procedure is OUTBUFF 0000004000

My questions are:
1) is this in pages or K? The range is 40K to 400000K

2) I think the default is 4000K. Has this parameter been set to the minimum, or below it according to this output?

Many TIA,
Martin

===========
Martin Hubel
MHC Inc.
www.mhubel.com
+1 905-764-7498
+1 416-670-7498 Mobile

Check out www.db-hq.net Your Headquarters of How-To for DB2
===========

IMPORTANT NOTICE:
IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

--------------------------------------------------------------------------------- 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 NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

--------------------------------------------------------------------------------- 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 NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Joel Goldstein

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Joel Goldstein)
Please not that I had an incorrect statement in my earlier reply, a small brain f**rt.

The amount of data logged for an insert is the row, not the whole page. (Thanks for alert Phil).

Joel

Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Brian Bear

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Joel Goldstein)
I don't know how to verify the actual amount of log buffer allocated but my zparms show



* PARM TYPE SCP MIN MAX CURRENT-VALUE *

LOGOUTPT NUM M 40960 409600000 409600



DSNTIPL

2 OUTPUT BUFFER ===> 409600 Size in bytes (40K-400000K)



And Mainview for DB2 shows:

- - - - - - - - - - - - - - - - - BUFFERS - - - - - - - - - - - - - - - - - -

BUFFER SIZE(K) 400



________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Joel Goldstein - Responsive Systems
Sent: Friday, November 30, 2007 2:51 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8

That is certainly what the manual states for V7 and later.
It also says the default now is 4000K.
 
Going back several versions of DB2, the default was 400  (not K).
Which I always used as 400K....
 
The old default of 400 should have caused instantaneous and massive log performance problems, even on a small system.
Many small to medium systems ran quite happily with that value.  Of course we have to consider the amount of data being changed.
Inserts required a full 4096 bytes.
 
SO - based on the doc, a value of 4000  without a K on the end implies we should see serious logging delays, and buffer unavailable
during any heavy insert/update workload.
 
If a system has a value of 4000 specified, substantial updates, and no occurrences
of Log Buffer Unavailable - it's questionable if log buffer size is really only 4000 bytes.
 
Can anybody verify the amount of memory used for the log buffer based on the specification in your zparm?
 
While the manuals are usually correct, there are cases where the doc is not correct and DB2 functions differently.
Then sometimes it's a DB2 bug...
 
Regards,
Joel
 
 
 
Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
         Performance software that works......
   Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

*****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Martin Hubel

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Brian Bear)
Thanks Brian,
As I suspected, your values are 10X bigger than my customer's. I thought so.
Best regards,
Martin

>> I don't know how to verify the actual amount of log buffer allocated but
>> my zparms show

>>

>> * PARM TYPE SCP MIN MAX CURRENT-VALUE *

>> LOGOUTPT NUM M 40960 409600000 409600

>>

>> DSNTIPL

>> 2 OUTPUT BUFFER ===> 409600 Size in bytes (40K-400000K)

>>

>> And Mainview for DB2 shows:

>> - - - - - - - - - - - - - - - - - BUFFERS - - - - - - - - - - - - - - - -
>> - -

>> BUFFER SIZE(K) 400

>>

>> ________________________________________
>> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
>> Of Joel Goldstein - Responsive Systems
>> Sent: Friday, November 30, 2007 2:51 PM
>> To: [login to unmask email]
>> Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8

>> That is certainly what the manual states for V7 and later.
>> It also says the default now is 4000K.
>>
>> Going back several versions of DB2, the default was 400 (not K).
>> Which I always used as 400K....
>>
>> The old default of 400 should have caused instantaneous and massive log
>> performance problems, even on a small system.
>> Many small to medium systems ran quite happily with that value. Of course
>> we have to consider the amount of data being changed.
>> Inserts required a full 4096 bytes.
>>
>> SO - based on the doc, a value of 4000 without a K on the end implies we
>> should see serious logging delays, and buffer unavailable
>> during any heavy insert/update workload.
>>
>> If a system has a value of 4000 specified, substantial updates, and no
>> occurrences
>> of Log Buffer Unavailable - it's questionable if log buffer size is really
>> only 4000 bytes.
>>
>> Can anybody verify the amount of memory used for the log buffer based on
>> the specification in your zparm?
>>
>> While the manuals are usually correct, there are cases where the doc is
>> not correct and DB2 functions differently.
>> Then sometimes it's a DB2 bug...
>>
>> Regards,
>> Joel
>>
>>
>>
>> Joel Goldstein
>> Responsive Systems
>> Buffer Pool Tool for DB2, the worldwide industry standard
>> Performance software that works......
>> Predicts Group Buffer Pool performance too!
>> www.responsivesystems.com
>> tel. (732) 972-1261
>> fax.(732) 972-9416

>> **************************************************************************
>> ***
>> The information transmitted is intended only for the person or entity to
>> which it is addressed and may contain confidential and/or privileged
>> material. Any review, retransmission, dissemination or other use of, or
>> taking of any action in reliance upon, this information by persons or
>> entities other than the intended recipient is prohibited. If you
>> received this message in error, please contact the sender and delete
>> the material from any computer.
>> **************************************************************************
>> ***

>> IMPORTANT NOTICE:

>> IDUG is pleased to announce a series of upgrades to the DB2-L discussion
>> listserv that are being implemented to improve reliability and the
>> overall user experience of DB2-L. These changes are coming on November
>> 30th. Details at http://www.idug.org

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






===========
Martin Hubel
MHC Inc.
www.mhubel.com
+1 905-764-7498
+1 416-670-7498 Mobile
+44 7986 041838 UK Mobile
+1 905-764-8411 Fax

Check out www.db-hq.net Your Headquarters of How-To for DB2
=========== IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

ANAND JAYACHANDRAN

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Martin Hubel)
OUTBUFF ZPARM value in

* Test - 0000000400 (in kilobytes)
* QA and Prod - 0000000800 (in kilobytes)


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Martin Hubel
Sent: Friday, November 30, 2007 14:23
To: [login to unmask email]
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8

Thanks Brian,
As I suspected, your values are 10X bigger than my customer's. I thought
so.
Best regards,
Martin

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

James Campbell

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to ANAND JAYACHANDRAN)
From the DSNTIPL panel definition
2 OUTPUT BUFFER ===>_LOGOUTPT +Size in bytes (40K-400000K)

From the DSNTINST clist
SET &CALC = (&LOGOUTPT+1023) / 1024
IN &SUBSTR(1:56,&STR(OUTBUFF=&CALC),&B)X

So the panel is in bytes, the macro is in KB

James Campbell


On 30 Nov 2007 at 12:57, Martin Hubel wrote:

> I've spent a lot of quality time with the manuals, but I'm having trouble with being definitive regarding the V8 values for
> this parameter, and whether it's in pages or K.
> My DSNTIJUZ job says OUTBUFF=4000,
> The output on a customer's system, using the DSNWZP stored procedure is OUTBUFF 0000004000
> My questions are:
> 1) is this in pages or K? The range is 40K to 400000K
> 2) I think the default is 4000K. Has this parameter been set to the minimum, or below it according to this output?
> Many TIA,
> Martin
>
> ===========
> Martin Hubel

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Missy J. Case

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to James Campbell)
We ran a test in V7 to establish a good setting for our outbuff parm.
We run some very large conversions, and found that a very large outbuff
, say 200000 cut our conversion i.e. load elapsed times almost in half
at about 200000, you start to hit a diminishing return value for your
memory cost, so most of our prod systems are set at 200000k. Our
philosophy, if it's that cheap (relatively) then it's more than worth
the wall time we saved doing these massive projects......

Just to throw another monkey wrench into your discussion......


Missy Case
SYSDB DB2 Performance DBA
701-275-6358

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Monday, December 03, 2007 2:50 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8

From the DSNTIPL panel definition
2 OUTPUT BUFFER ===>_LOGOUTPT +Size in bytes (40K-400000K)

From the DSNTINST clist
SET &CALC = (&LOGOUTPT+1023) / 1024
IN &SUBSTR(1:56,&STR(OUTBUFF=&CALC),&B)X

So the panel is in bytes, the macro is in KB

James Campbell


On 30 Nov 2007 at 12:57, Martin Hubel wrote:

> I've spent a lot of quality time with the manuals, but I'm having
> trouble with being definitive regarding the V8 values for this
parameter, and whether it's in pages or K.
> My DSNTIJUZ job says OUTBUFF=4000,
> The output on a customer's system, using the DSNWZP stored procedure
> is OUTBUFF 0000004000 My questions are:
> 1) is this in pages or K? The range is 40K to 400000K
> 2) I think the default is 4000K. Has this parameter been set to the
minimum, or below it according to this output?
> Many TIA,
> Martin
>
> ===========
> Martin Hubel

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

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

-----------------------------------------
The information in this message may be proprietary and/or
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify First Data
immediately by replying to this message and deleting it from your
computer.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Joel Goldstein

Re: Quick question on OUTBUFF parameter Z/OS DB2 V8
(in response to Missy J. Case)
Thanks James,

I think this clears up the muck.

Regards,
Joel

Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Monday, December 03, 2007 3:50 AM
Subject: Re: [DB2-L] Quick question on OUTBUFF parameter Z/OS DB2 V8


> From the DSNTIPL panel definition
> 2 OUTPUT BUFFER ===>_LOGOUTPT +Size in bytes (40K-400000K)
>
> From the DSNTINST clist
> SET &CALC = (&LOGOUTPT+1023) / 1024
> IN &SUBSTR(1:56,&STR(OUTBUFF=&CALC),&B)X
>
> So the panel is in bytes, the macro is in KB
>
> James Campbell
>
>
> On 30 Nov 2007 at 12:57, Martin Hubel wrote:
>
>> I've spent a lot of quality time with the manuals, but I'm having trouble
>> with being definitive regarding the V8 values for
>> this parameter, and whether it's in pages or K.
>> My DSNTIJUZ job says OUTBUFF=4000,
>> The output on a customer's system, using the DSNWZP stored procedure is
>> OUTBUFF 0000004000
>> My questions are:
>> 1) is this in pages or K? The range is 40K to 400000K
>> 2) I think the default is 4000K. Has this parameter been set to the
>> minimum, or below it according to this output?
>> Many TIA,
>> Martin
>>
>> ===========
>> Martin Hubel
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L discussion
> listserv that are being implemented to improve reliability and the overall
> user experience of DB2-L. These changes are coming on November 30th.
> Details at http://www.idug.org
>
> ---------------------------------------------------------------------------------
> 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 NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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