[DB2-L] z/OS v7.1: Scrollable vs. Non-scrollable

Ruediger Kurtz

[DB2-L] z/OS v7.1: Scrollable vs. Non-scrollable
Dave,

thanks for the reply, and yes, I would like some specifics, if it isn't too much bother for you.

Best regards

Ruediger Kurtz

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Mike Turner
Gesendet: Freitag, 16. Dezember 2005 13:03
An: [login to unmask email]
Betreff: Re: [DB2-L] z/OS v7.1: Scrollable vs. Non-scrollable

Date: Fri, 16 Dec 2005 07:36:27 -0600
Reply-To: DB2 Database Discussion list at IDUG <[log in to unmask]>
Sender: DB2 Data Base Discussion List <[log in to unmask]>
From: Dave Churn <[log in to unmask]>
Subject: Re: z/OS v7.1: Scrollable vs. Non-scrollable
In-Reply-To: <[log in to unmask]>
Content-Type: multipart/alternative;

Ruediger,

I ran some initial tests on our test machine initial test on scrollable
cursors back when version 7 was new. My best result had them running twice
as long so we quickly lost interest in trying to use them.

Besides performance, our other con was the internal storage space used.
Static scrollable cursors used some pool space that we wished to use
differently.

If you would like some further details, please contact me and I'll dig up
some specifics.

Dave Churn
DST Systems, Inc.
Vice-President, Heart of America DB2 Users Group

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