Logical Page List (LPL) Error While Inserting Into an Index

[login to unmask email]

Logical Page List (LPL) Error While Inserting Into an Index
Fellow Listers,

We have an application that is "cratering" an index while trying to
INSERT a duplicate row. DB2 returns the customary -803
abend. Instead of the usuall Rollback we get an error message "DSNB250E - A
Page Range was added to the Logical Page List"
and the Index is then put into LPL status. When another application tries
to access the table it gets a -904 (resource unavailble) so we
either Recover the index or Start the Database/Tablespace to remove the LPL
status.

We are running DB2 V5 at PUT9810. I would appreciate any suggestions or
experiences from you Listers that might help us out.


Thanx-A-Bunch
Don Alden
DB2 DBA



Sanjeev (CTS) S

Re: Logical Page List (LPL) Error While Inserting Into an Index
(in response to Don.Alden@I-STRUCTURE.COM)
Hi Don,
I am not sure if insert only put in your pageset in LPL but there could be
a possiblility that someone had run the LOAD with Enforce No and after the
tablespace was put into check pending status the start with access force was
issues and at the 1st insert tablespace might have gone into LPL.As you said
"instead of rollback" , rollback is not issued when -803 is issued.Did u
find this message in the MSTR address space ?
Hope this helps

Regards
Sanjeev

> -----Original Message-----
> From: Don Alden [SMTP:[login to unmask email]
> Sent: Saturday, December 02, 2000 2:33 AM
> To: [login to unmask email]
> Subject: Logical Page List (LPL) Error While Inserting Into an Index
>
> Fellow Listers,
>
> We have an application that is "cratering" an index while trying to
> INSERT a duplicate row. DB2 returns the customary -803
> abend. Instead of the usuall Rollback we get an error message "DSNB250E -
> A
> Page Range was added to the Logical Page List"
> and the Index is then put into LPL status. When another application tries
> to access the table it gets a -904 (resource unavailble) so we
> either Recover the index or Start the Database/Tablespace to remove the
> LPL
> status.
>
> We are running DB2 V5 at PUT9810. I would appreciate any suggestions or
> experiences from you Listers that might help us out.
>
>
> Thanx-A-Bunch
> Don Alden
> DB2 DBA
>
>
>
>
>
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com



Chris Munson

Logical Page List (LPL) Error While Inserting Into an Index
(in response to Sanjeev (CTS) S)
Don, An LPL entry occurs as a result of some sort of 'logical' error
condition and not as a result of some erroneous action on behalf of a user.
The reasons vary but in the DSNB250E message you will see a CSECT name.
This gives a general idea and can sometimes pinpoint the reason for the
LPL. You can use this information to search for any known problems or
APARs.

FYI, we are working on a change to DB2 that will 1) pinpoint the exact
cause of each LPL addition and 2) automatically recovery the LPL page (if
we can) instead of the user having to issue a STA DB command.

Chris Munson
DB2 Development, IBM Silicon Valley Laboratory

Date: Fri, 1 Dec 2000 14:02:50 -0700
From: Don Alden <[login to unmask email]>
Subject: Logical Page List (LPL) Error While Inserting Into an Index

Fellow Listers,

We have an application that is "cratering" an index while trying to
INSERT a duplicate row. DB2 returns the customary -803
abend. Instead of the usuall Rollback we get an error message "DSNB250E -
A
Page Range was added to the Logical Page List"
and the Index is then put into LPL status. When another application tries
to access the table it gets a -904 (resource unavailble) so we
either Recover the index or Start the Database/Tablespace to remove the
LPL
status.

We are running DB2 V5 at PUT9810. I would appreciate any suggestions or
experiences from you Listers that might help us out.


Thanx-A-Bunch
Don Alden
DB2 DBA



Luke (ECS) McGee

LPL
(in response to Chris Munson)
Does anyone know where the Logical Page List (LPL) is stored in DB2 Land? Thanks.



Toine Michielse

Re: LPL
(in response to Luke (ECS) McGee)
Hello Luke,

LPL information is stored in the DBET.

Regards,

Toine Michielse



"McGee, Luke (ECS)" <[login to unmask email]>@RYCI.COM> on 12/14/2000
04:14:14 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

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


To: [login to unmask email]
cc:
Subject: LPL



Does anyone know where the Logical Page List (LPL) is stored in DB2 Land?
Thanks.