Schlagwort: Db2 12

2019-03 EXPLAIN data review

Db2 EXPLAIN example: a quick history of EXPLAIN and a new standard Db2 EXPLAIN Query to bring out the best and most underused columns.

Getagged mit: ,

2019-02 Global Temporary Confusion

Learn, through examples, why CGTT (CREATEd Global Temporary Tables) are possibly better than DGTT (DECLAREd Global Temporary Tables) and how to use them to speed up performance.

Getagged mit: , ,

2018-08 SOUNDEX and other „cool“ features – Part six All new for Db2 12

Part six of my – everlasting – walk through of new Aggregate and Scalar functions. Following with :  HASH & WRAP Previous „SOUNDEX“ Newsletters Part 5:  2018-07:  SOUNDEX and other „cool“ features – Part five All new for Db2 12 Part

Getagged mit: , , ,

2018-07 – SOUNDEX and other „cool“ features – Part five All new for Db2 12

Part five of my – everlasting – walk through of new Aggregate and Scalar functions. This time I will start with the new AGGREGATE functions introduced in Db2 12. LISTAGG This is mainly of interest due to the fact that

Getagged mit: , ,

Baltimore Washington Db2 Users Group – Juni 2018

Treffen Sie uns auf der Baltimore – Washington DB2 Users Group, Juni 2018, MD, Vereinigte Staaten – BWDB2UG – und nehmen Sie an unserer on Db2 12 Continuous Delivery Präsentation teil: „Db2 12 – 12 months agile production experience with more focus on the Data and less on the base“

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.
In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on „Data“—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Getagged mit: , , , ,

Heart of America Db2 Users Group – Juni 2018

Treffen Sie uns auf der Heart of America Db2 Users Group – Juni 2018 in Overland Park, KS – HOADb2UG – und nehmen Sie an unserer Präsentation über Continuous Delivery teil: „Db2 12 – 12 months agile production experience with more focus on the Data and less on the base“.
On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.
In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on „Data“—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Getagged mit: , , , ,

Atlanta DB2 Users Group Juni 2018

Treffen Sie uns auf der Atlanta Db2 Users Group – ADUG – und nehmen Sie an unserer Präsentation über Db2 12 Continuous Delivery teil: „Db2 12 – 12 months agile production experience with more focus on the Data and less on the base“

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.
In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on „Data“—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Getagged mit: , , , ,

Midwest Database Users Group – Juni 2018

Treffen Sie uns auf der Midwest Database Users Group – Juni 2018, Chicago, IL, USA – MWDUG – und nehmen Sie an unserer Präsentation über Db2 12 Continuous Delivery teil : „Total environment simulation – Workload Replay in an agile world“

Db2 Cloning proved to be just the right way to setup a testing, or development environment instantly. Some Db2 shops are refreshing multi-terabyte sized Db2 systems nearly on a daily basis, by exploiting cloning procedures and instant copy hardware features. While associated database objects and their data can be copied in a fully automated and resource friendly way, it turns out to be quite challenging and complex to cover representative SQL workload. Scaling workloads is an easier task, but parallel execution and especially exceptional queries, only executed on months, quarters, or years end can be cumbersome to be included adequately. If we want to avoid compromising quality of testing, our testing tasks become more complex to build and to maintain. Do we have the time for tasks like this? Does it fit DevOps, Agile and Continuous Delivery? Join this presentation and learn how you can upgrade!

Getagged mit: , , , ,

Northeast Ohio Database Users Group – Juni 2018

Treffen Sie uns auf der Northeast Ohio Database Users Group 2018, Juni, OH, USA – NEODBUG – und nehmen Sie an unserer Präsentation über Continuous Delivery teil: „Db2 12 – 12 months agile production experience with more focus on the Data and less on the base“.

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.
In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on „Data“—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

Getagged mit: , , , ,

Wisconsin Db2 Users Group – Juni 2018

Treffen Sie uns auf der Wisconsin Db2 Users Group – Juni 2018, USA – WDUG – und nehmen Sie an unserer Präsentation über Db2 12 Continuous Delivery teil: „Total environment simulation – Workload Replay in an agile world“

Db2 Cloning proved to be just the right way to setup a testing, or development environment instantly. Some Db2 shops are refreshing multi-terabyte sized Db2 systems nearly on a daily basis, by exploiting cloning procedures and instant copy hardware features. While associated database objects and their data can be copied in a fully automated and resource friendly way, it turns out to be quite challenging and complex to cover representative SQL workload. Scaling workloads is an easier task, but parallel execution and especially exceptional queries, only executed on months, quarters, or years end can be cumbersome to be included adequately. If we want to avoid compromising quality of testing, our testing tasks become more complex to build and to maintain. Do we have the time for tasks like this? Does it fit DevOps, Agile and Continuous Delivery? Join this presentation and learn how you can upgrade!

Getagged mit: , , , ,