Interesting Aha Idea to vote for (Db2 for z/OS)

Roy Boxwell

Interesting Aha Idea to vote for (Db2 for z/OS)
Hi All!



I think we all know the pain of changing a DBD during dynamic SQL workload.
In the past this was not soooo important as dynamic SQL was “special” but
nowadays it is the de facto standard and so simply DROPing a dead table that
happens to be in the same database as your central, most used, table is a
real pain point. I have seen a very nice idea:



https://ibm-data-and-ai.ideas.aha.io/ideas/DB24ZOS-I-1076



That raises the desire to somehow change the way the DBD is locked and
updated in cases like a DROP of a table. I can see this as an extension of
Phase In Rebind. Why not slide the DBD change out gradually?



Whaddya all think???



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Vagedesstrasse 19
40479 Dusseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur
Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



Attachments

  • smime.p7s (5.1k)

Roland Schock

AW: Interesting Aha Idea to vote for (Db2 for z/OS)
(in response to Roy Boxwell)
Hi Roy,

the most important is to register at aha.io and vote for such an idea. If Db2 development sees, that many people are interested in such an idea, then they will put it into consideration for development.
So from time to time I browse through the ideas an vote for all, which make sense for me and would be a nice extension for Db2.

This time I voted for your RFE even if it is for z/OS and I'm only on LUW.

Mit freundlichen Grüßen/Kind regards
Roland Schock
[ibm-champion-rgb-130px]

Von: Boxwell, Roy <[login to unmask email]>
Gesendet: Donnerstag, 13. Februar 2020 08:20
An: [login to unmask email]
Betreff: [Marketing Mail] [DB2-L] - Interesting Aha Idea to vote for (Db2 for z/OS)

Hi All!

I think we all know the pain of changing a DBD during dynamic SQL workload. In the past this was not soooo important as dynamic SQL was "special" but nowadays it is the de facto standard and so simply DROPing a dead table that happens to be in the same database as your central, most used, table is a real pain point. I have seen a very nice idea:

https://ibm-data-and-ai.ideas.aha.io/ideas/DB24ZOS-I-1076

That raises the desire to somehow change the way the DBD is locked and updated in cases like a DROP of a table. I can see this as an extension of Phase In Rebind. Why not slide the DBD change out gradually?

Whaddya all think???

Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Vagedesstrasse 19
40479 Dusseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
Web http://www.seg.de http://www.seg.de
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

[login to unmask email]
Telefon+Mobil +49 89 32468-130

________________________________
ARS Computer und Consulting GmbH, www.ars.de http://www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software Engineering, Technologieberatung, IBM Software, IBM Lizenzmanagement Services

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Joachim Gucker, Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://web.ars.de/datenschutz/
Attachments

  • image001.jpg (3.8k)