Quick Select

Brett Sinclair

Quick Select
Is anyone using a MIPS-saving program called Quick Select?

Thanks, Brett Sinclair


The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

________________________________


Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.

Joel Goldstein

Quick Select
(in response to Brett Sinclair)
Is that a vendor program?

How does/would it save mips?



I’ve heard of a quickselect algorithm ….







Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 2:45 PM
To: [login to unmask email]
Subject: [DB2-L] - Quick Select



Is anyone using a MIPS-saving program called Quick Select?



Thanks, Brett Sinclair





The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



_____

Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.



-----End Original Message-----

Brett Sinclair

Quick Select
(in response to Joel Goldstein)
This is a vendor program







The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 7:25 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select

Is that a vendor program?
How does/would it save mips?

I’ve heard of a quickselect algorithm ….



Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard
Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.comhttp://www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
[login to unmask email]<mailto:[login to unmask email]>

From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 2:45 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Quick Select

Is anyone using a MIPS-saving program called Quick Select?

Thanks, Brett Sinclair


The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

-----End Original Message-----

-----End Original Message-----


Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.

Joel Goldstein

Quick Select
(in response to Brett Sinclair)
What vendor?

Nothing comes up on Google searches…



Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 5:47 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



This is a vendor program















The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 7:25 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



Is that a vendor program?

How does/would it save mips?



I’ve heard of a quickselect algorithm ….







Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 2:45 PM
To: [login to unmask email]
Subject: [DB2-L] - Quick Select



Is anyone using a MIPS-saving program called Quick Select?



Thanks, Brett Sinclair





The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



-----End Original Message-----



-----End Original Message-----

Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.



-----End Original Message-----

Brett Sinclair

Quick Select
(in response to Joel Goldstein)
Vendor name is Log-On Software—European company







The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 9:37 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select

What vendor?
Nothing comes up on Google searches…

Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard
Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.comhttp://www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
[login to unmask email]<mailto:[login to unmask email]>

From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 5:47 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Quick Select

This is a vendor program







The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 7:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Quick Select

Is that a vendor program?
How does/would it save mips?

I’ve heard of a quickselect algorithm ….



Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard
Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.comhttp://www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416
[login to unmask email]<mailto:[login to unmask email]>

From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 2:45 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Quick Select

Is anyone using a MIPS-saving program called Quick Select?

Thanks, Brett Sinclair


The most important thing is to keep the most important thing the most important thing

Brett Sinclair
AXA Technology Services
Telephone: 1-908-204-0144

-----End Original Message-----

-----End Original Message-----

Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.

-----End Original Message-----

-----End Original Message-----


Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.

Joel Goldstein

Quick Select
(in response to Brett Sinclair)
I know Log-On, did not know about this product.



Thanks for the information.



Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 7:23 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



Vendor name is Log-On Software—European company















The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 9:37 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



What vendor?

Nothing comes up on Google searches…



Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 5:47 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



This is a vendor program















The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



From: Joel Goldstein - Responsive Systems [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 7:25 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Quick Select



Is that a vendor program?

How does/would it save mips?



I’ve heard of a quickselect algorithm ….







Joel Goldstein
Responsive Systems
Buffer Pool Tool(R) for DB2, the worldwide industry standard

Predicts the IO rate/Sec for tuning changes
Performance software that works......
Predicts Group Buffer Pool performance too!
http://www.responsivesystems.com www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

[login to unmask email]



From: SINCLAIR Brett [mailto:[login to unmask email]
Sent: Saturday, September 10, 2016 2:45 PM
To: [login to unmask email]
Subject: [DB2-L] - Quick Select



Is anyone using a MIPS-saving program called Quick Select?



Thanks, Brett Sinclair





The most important thing is to keep the most important thing the most important thing



Brett Sinclair

AXA Technology Services

Telephone: 1-908-204-0144



-----End Original Message-----



-----End Original Message-----

Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.



-----End Original Message-----



-----End Original Message-----

Ce message est confidentiel; Son contenu ne represente en aucun cas
un engagement de la part de AXA Technology Services (AXA Tech) sous
reserve de tout accord conclu par ecrit entre vous et AXA Technology
Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
partielle, doit etre autorisee prealablement. Si vous n'etes pas
destinataire de ce message, merci d'en avertir immediatement l'expe-
diteur.

This message is confidential; its contents do not constitute a
commitment by AXA Technology Services (AXA Tech) except where provi-
ded for in a written agreement between you and AXA Technology
Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
tion, either whole or partial, is prohibited. If you are not the
intended recipient of the message, please notify the sender imme-
diately.



-----End Original Message-----

Isaac Yassin

Quick Select
(in response to Brett Sinclair)
Some of my customers use it and have good results. In short - uses result
cache for repetitive SQL that avoids DB2 BP search.
Please email me privately for more information.
Isaac (dot) Yassin (at) gmail

Isaac Yassin
Sent from my Galaxy Note 5

בתאריך 11 בספט׳ 2016 00:55,‏ "SINCLAIR Brett" <[login to unmask email]> כתב:

> Is anyone using a MIPS-saving program called Quick Select?
>
>
>
> Thanks, Brett Sinclair
>
>
>
>
>
> *The most important thing is to keep the most important thing the most
> important thing *
>
>
>
> *Brett Sinclair*
>
> *AXA Technology Services*
>
> *Telephone: 1-908-204-0144 <1-908-204-0144>*
>
>
> ------------------------------
>
> Ce message est confidentiel; Son contenu ne represente en aucun cas
> un engagement de la part de AXA Technology Services (AXA Tech) sous
> reserve de tout accord conclu par ecrit entre vous et AXA Technology
> Services (AXA Tech).Toute publication, utilisation ou diffusion,meme
> partielle, doit etre autorisee prealablement. Si vous n'etes pas
> destinataire de ce message, merci d'en avertir immediatement l'expe-
> diteur.
>
> This message is confidential; its contents do not constitute a
> commitment by AXA Technology Services (AXA Tech) except where provi-
> ded for in a written agreement between you and AXA Technology
> Services (AXA Tech). Any unauthorised disclosure, use or dissemina-
> tion, either whole or partial, is prohibited. If you are not the
> intended recipient of the message, please notify the sender imme-
> diately.
>
> -----End Original Message-----
>

Derek Flux

RE: Quick Select
(in response to Isaac Yassin)

We are doing a Proof of Concept with QuickSelect. We have installed on the system test environment and ran the IVP to show that the same SQL executed a certain number of times by a static SQL bound package will be moved to the QuickSelect fast cache. There are VALIDPROCs added by the product to the tables on which you want to capture the identical SQL's being executed. The VALIDPROCs keep track of changes in the members of a Data Sharing group.

 

Now the issue is to get permission to install the POC version of the tool in production which will just do a SURVEY report to report on how much the CPU savings should be.  We do not have enough activity in development and QA to see how much the tool may help us. 

 

Note: The tool currently does not capture dynamic SQL. It may be a feature added in the future. That is where we experience a lot of performance issues - mainly from the Data Warehouse analytic queries, so I would like to see that supported.