This article sheds a little light on the inner workings of dynamic workload balancing of distributed connections, and how this can benefit the performance, scalability and availability of your DB2 for z/OS solutions.
When the term high availability is brought up, most DBAs reflexively think of technical solutions to help keep a system or database available for users – However, there is so much more to availability than simply ensuring that a database is available for a user to connect to.
Check out this article by Billy Sundarrajan that will introduce you to the IBM DB2 Analytics Accelerator Studio. This graphical user interface (GUI) is used for the administration of IBM DB2 Analytics Accelerator for z/OS. It is available as a plug-in for Data Studio v3.2 or v4.1.
Once you have written a stored procedure or two you'll very soon want to debug it. There's nothing like stepping through the code line-by-line to try to find out what is going wrong. Thankfully IBM Data Studio provides a very good debugger for SQL stored procedures.
In this entry we will look at the use of IBM Data Studio in the development life cycle SQL Procedure Language (SQL PL) stored procedures on both DB2 for z/OS as well as DB2 LUW. A “cheat sheet” for some of the more common SQL PL commands is found on the last page of this article.