Location
Winchester, Hampshire
Earlier this year, I hosted a client panel with several of our Db2 12 clients about the sucesses and migration of Db2 12, this event is now available on replay.
.…
About
What best describes your job role?
IBM Employee / Business Partner
Friends (17)
Db2portal.blogsspot
Comment Wall
You need to be a member of WorldofDb2 to add comments!
Comments are closed.
Earned points: 4600
Db2 Fan
Received:
Oct 27, 2021
Oct 27, 2021
0
Db2 Leader
Received:
Dec 3, 2021
Dec 3, 2021
0
Special
Register for the Webcast to get a head start!
Direct Link http://ibm.biz/DB2zContinuousDelivery
On the 27th September Chris Crone and I will be running a webcast with live Q&A afterwards for our worldwide customers where we will introduce and describe the DB2 for z/OS product strategy going forward for continuous delivery of new functions in…
Activity Feed
Earlier this year, I hosted a client panel with several of our Db2 12 clients about the sucesses and migration of Db2 12, this event is now available on replay. .
Comments
Dear John
Could you please explain how to duplicate romove work in DB2 11 without DISTINCT
and group by, In DB2 11 performance overview document , it is mentioned like we
have to see IXSCAN_SKIP_DUPS, IXSCAN_SKIP_SCREN and EARLY_OUT columns in
DSN_DETCOST_TABLE for further information.
Could you please explain me to eliminate the sorting for both DISTINCT and GROUP BY by using DSN_DETCOST_TABLE.
.