Let’s start this discussion candidly – I am a big fan of the FETCH FIRST n ROWS ONLY clause coded in a SQL statement. That assertion will require some clarification, since there are some valid use cases, and others that make little sense. Regardless, I will try not to over-complicate the discussion.
In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
At the IDUG North American conference in May, 2016, George Wang gave a presentation showcasing how Apache Spark can be used in conjunction with high volume OLTP database technologies like DB2 for z/OS.
IBM® Data Server Manager is an integrated database management tools platform. In this article, learn how to use the Query Tuning functionality that is included with the Base edition of DSM at no additional charge to tune the queries running in your DB2® for z/OS® environment.