How does DB2 find space when there is a page split.

Ramachandran Subramanian

How does DB2 find space when there is a page split.
How does DB2 find space when it decides to make a page
split. Is it any different for IX than it is for a TS?
I have heard that first it searches between + or - 16
pages and then if it cannot find a free page , it
searches between + or - 32 pages. If that is a failure
too then it goes to the end of the dataset. Is this correct?



__________________________________
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
http://celebrity.mail.yahoo.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

Roger Miller

Re: How does DB2 find space when there is a page split.
(in response to Ramachandran Subramanian)
Space search is a short question with a very long answer, and there are
differences for the version level, index, data, table space type (segmented,
partitioned and simple), fixed or varying length data, and many more
options. The information is in a licensed book, the Diagnosis Reference.
The book I would suggest that discusses the options you have and how to use
them is the Administration Guide. Look at the information on page split,
free space, reorganization, and statistics there.

Roger Miller

On Mon, 20 Dec 2004 23:27:37 -0800, Ramachandran Subramanian
<[login to unmask email]> wrote:

>How does DB2 find space when it decides to make a page
>split. Is it any different for IX than it is for a TS?
>I have heard that first it searches between + or - 16
>pages and then if it cannot find a free page , it
>searches between + or - 32 pages. If that is a failure
>too then it goes to the end of the dataset. Is this correct?
>
>

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

Steve McAuliffe

Re: How does DB2 find space when there is a page split.
(in response to Roger Miller)
If you can get hold of a copy of the presentation 'Hints and tips for
Optimising Insert Performance' by Namik Hrle presented at IDUG Prague
this year that may well provide you with some useful information

Cheers,
Steve McAuliffe
Tel: (020) 8760 6988
Internal: x 66988


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Roger Miller
Sent: 21 December 2004 19:24
To: [login to unmask email]
Subject: Re: How does DB2 find space when there is a page split.


Space search is a short question with a very long answer, and there are
differences for the version level, index, data, table space type
(segmented, partitioned and simple), fixed or varying length data, and
many more options. The information is in a licensed book, the Diagnosis
Reference. The book I would suggest that discusses the options you have
and how to use them is the Administration Guide. Look at the
information on page split, free space, reorganization, and statistics
there.

Roger Miller

On Mon, 20 Dec 2004 23:27:37 -0800, Ramachandran Subramanian
<[login to unmask email]> wrote:

>How does DB2 find space when it decides to make a page
>split. Is it any different for IX than it is for a TS?
>I have heard that first it searches between + or - 16
>pages and then if it cannot find a free page , it
>searches between + or - 32 pages. If that is a failure
>too then it goes to the end of the dataset. Is this correct?
>
>

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



Notice to recipient:
The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are authorised and regulated by the Financial Services Authority.

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

Barbara Nigh

Re: How does DB2 find space when there is a page split.
(in response to Steve McAuliffe)
I would be interested in this presentation also. Is it posted on the IDUG
website at all?

Barbara J. Nigh - CAL261
Consultant, Database Management Systems - North America
Phone: 831.754.1400 Ext. 2048
Pager: 877.406.7868
[login to unmask email]



"McAuliffe, Stephen"
<[login to unmask email] To: [login to unmask email]
OFAMERICA.COM> cc:
Sent by: DB2 Data Base Subject: Re: How does DB2 find space when there is a page split.
Discussion List
<[login to unmask email]>


12/22/2004 01:28 AM
Please respond to DB2
Database Discussion
list at IDUG






If you can get hold of a copy of the presentation 'Hints and tips for
Optimising Insert Performance' by Namik Hrle presented at IDUG Prague
this year that may well provide you with some useful information

Cheers,
Steve McAuliffe
Tel: (020) 8760 6988
Internal: x 66988


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Roger Miller
Sent: 21 December 2004 19:24
To: [login to unmask email]
Subject: Re: How does DB2 find space when there is a page split.


Space search is a short question with a very long answer, and there are
differences for the version level, index, data, table space type
(segmented, partitioned and simple), fixed or varying length data, and
many more options. The information is in a licensed book, the Diagnosis
Reference. The book I would suggest that discusses the options you have
and how to use them is the Administration Guide. Look at the
information on page split, free space, reorganization, and statistics
there.

Roger Miller

On Mon, 20 Dec 2004 23:27:37 -0800, Ramachandran Subramanian
<[login to unmask email]> wrote:

>How does DB2 find space when it decides to make a page
>split. Is it any different for IX than it is for a TS?
>I have heard that first it searches between + or - 16
>pages and then if it cannot find a free page , it
>searches between + or - 32 pages. If that is a failure
>too then it goes to the end of the dataset. Is this correct?
>
>

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



Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by
telephone. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful.

When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued
by the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are authorised and regulated by the Financial Services
Authority.

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

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





-----------------------------------------
************************************************************************
This E-mail is confidential. It may also be legally privileged. If you
are not the addressee you may not copy, forward, disclose or use any part
of it. If you have received this message in error, please delete it and
all copies from your system and notify the sender immediately by return
E-mail. Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability for any
errors or omissions.
************************************************************************

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