Db2

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2

Hello Filip,

Static SQL info, like package_schema, package_name etc. currently are not collected for package cache and individual statements pages.  It is good if you can open an RFE in IBM Aha page: https://ibm-data-and-ai.ideas.aha.io/ to track this request and have other community users to vote for the idea.

------------------------------
Jason Sizto
------------------------------

Original Message:
Sent: Wed January 27, 2021 04:51 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2

Hello Jason ,

Thx, I opened an RFE


Best regards

Filip

------------------------------
filip degryse
------------------------------

Original Message:
Sent: Wed January 27, 2021 12:42 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Hello Filip,

Static SQL info, like package_schema, package_name etc. currently are not collected for package cache and individual statements pages.  It is good if you can open an RFE in IBM Aha page: https://ibm-data-and-ai.ideas.aha.io/ to track this request and have other community users to vote for the idea.

------------------------------
Jason Sizto

Original Message:
Sent: Wed January 27, 2021 04:51 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2

Thanks Filip for submitting this idea: https://ibm-data-and-ai.ideas.aha.io/ideas/DSM-I-408

------------------------------
Jason Sizto
------------------------------

Original Message:
Sent: Thu January 28, 2021 03:24 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello Jason ,

Thx, I opened an RFE


Best regards

Filip

------------------------------
filip degryse

Original Message:
Sent: Wed January 27, 2021 12:42 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Hello Filip,

Static SQL info, like package_schema, package_name etc. currently are not collected for package cache and individual statements pages.  It is good if you can open an RFE in IBM Aha page: https://ibm-data-and-ai.ideas.aha.io/ to track this request and have other community users to vote for the idea.

------------------------------
Jason Sizto

Original Message:
Sent: Wed January 27, 2021 04:51 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2

Maybe you want to retweet this then https://twitter.com/ARSDB2/status/1355054366793863171?s=20
With more reach, chances are higher for an implementation. ;-)  https://twitter.com/ARSDB2/status/1355054366793863171?s=20https://twitter.com/ARSDB2/status/1355054366793863171?s=20

------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------

Original Message:
Sent: Thu January 28, 2021 06:12 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Thanks Filip for submitting this idea: https://ibm-data-and-ai.ideas.aha.io/ideas/DSM-I-408

------------------------------
Jason Sizto

Original Message:
Sent: Thu January 28, 2021 03:24 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello Jason ,

Thx, I opened an RFE


Best regards

Filip

------------------------------
filip degryse

Original Message:
Sent: Wed January 27, 2021 12:42 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Hello Filip,

Static SQL info, like package_schema, package_name etc. currently are not collected for package cache and individual statements pages.  It is good if you can open an RFE in IBM Aha page: https://ibm-data-and-ai.ideas.aha.io/ to track this request and have other community users to vote for the idea.

------------------------------
Jason Sizto

Original Message:
Sent: Wed January 27, 2021 04:51 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2

Thx Roland, yes, I could retweet your message but then I would have to create a twitter account  :-)

------------------------------
filip degryse
------------------------------

Original Message:
Sent: Fri January 29, 2021 02:28 AM
From: Roland Schock
Subject: where can I find package name and section number for static SQL

Maybe you want to retweet this then https://twitter.com/ARSDB2/status/1355054366793863171?s=20
With more reach, chances are higher for an implementation. ;-)  https://twitter.com/ARSDB2/status/1355054366793863171?s=20https://twitter.com/ARSDB2/status/1355054366793863171?s=20

------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen

Original Message:
Sent: Thu January 28, 2021 06:12 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Thanks Filip for submitting this idea: https://ibm-data-and-ai.ideas.aha.io/ideas/DSM-I-408

------------------------------
Jason Sizto

Original Message:
Sent: Thu January 28, 2021 03:24 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello Jason ,

Thx, I opened an RFE


Best regards

Filip

------------------------------
filip degryse

Original Message:
Sent: Wed January 27, 2021 12:42 PM
From: Jason Sizto
Subject: where can I find package name and section number for static SQL

Hello Filip,

Static SQL info, like package_schema, package_name etc. currently are not collected for package cache and individual statements pages.  It is good if you can open an RFE in IBM Aha page: https://ibm-data-and-ai.ideas.aha.io/ to track this request and have other community users to vote for the idea.

------------------------------
Jason Sizto

Original Message:
Sent: Wed January 27, 2021 04:51 AM
From: filip degryse
Subject: where can I find package name and section number for static SQL

Hello

Could somebody tell me where to find the package name and section number in package cache history ?
We run a lot of static SQL ,especially during the night (batch processing), so when I want to analyse the SQL performance of this batch processing using the package cache history , I cannot find the package name and section number of SQL statements ..

Thanks and best regards

Filip

------------------------------
filip degryse
------------------------------

#Db2