Tag: DB2

Miscellaneous

Db2 12 for z/OS SQL Enhancements: Result Set Pagination

In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and “Db2,” versus “DB2,” is officially the new form of the product name), I will describe useful functionality pertaining to result set pagination (my first post in this series covered piece-wise DELETE). “Result set pagination” refers …

Miscellaneous

How to create a Date Series in DB2 (DBA DB2)

Question: How can I create a Date Series  in DB2 LUW. e.g. 01-01-2017 to 30-01-2017 . ? Answer:  There are a number of different ways to create a date series in DB2 LUW.One way is the example used below, which lists the dates from 1st January 2017 – 30 January 2017. : db2 “with tempdateseries (date) …

Miscellaneous

Five Data Management Predictions for 2018

By Dave Beulke, on January 10th, 2018 Happy New Year! I hope everyone has their 2018 filled with good health, happiness and prosperity. Once again I am offering you my data management predictions for 2018. Thank you all for great support in 2017 and countless emails regarding my conference, user group presentations and blogs last …

Miscellaneous

Using Real Memory to Enhance Performance in Db2

As many enterprise applications mature, the increases in customers, functions, features and transaction rates require scaling up. Several alternatives for maintaining acceptable performance include installing or upgrading hardware resources such as CPU speeds, disk volume and computer memory. Of these, adding memory can sometimes be the cheapest and most convenient. In this article we review …

Miscellaneous

Supporting Operational Systems in a Big Data World

Today’s IT developers use a combination of rapid design and cloud technologies to ensure that new applications can be implemented quickly. Speedy production implementation is essential for two reasons: competitive advantage, and minimizing costs. Some markets such as retail sales and medical support are highly competitive, and the first to bring a new application to …