(Susan Visser) How would you like to compress data, store it in a cloud, and analyze your data as though you are traveling through time? Do all this, plus experience lower costs and faster performance. Sound good? Read this book to understand the power of DB2 10 and get started immediately!

(Scott Hayes) 100% of our studio audience learned something! Steve talked about monitor table functions and admin views, strange numbers in the monitors, literals versus parameter markers in dynamic SQL, the Statement Concentrator (STMT_CONC) – when to use it and when not to use it, improving perfor

(Gaurav Shukla) As part of the continuous enhancements happening with respect to Oracle compatibility in DB2, the number of Oracle Pro*C features supported in DB2 has been on the rise since it began with DB2 Linux, UNIX, and Windows (LUW) 9.7 fixpack 5. With the list of features growing in DB2 10.1,

(Cindy Russell) This popular webcast helps prepare you for the all new DB2 10 for Linux, UNIX and Windows Fundamentals Exam 610.

(Willie Favero) Today’s blog post is going to start out with a discussion on what should be specified for two DSNZPARM keywords that will affect your utility processing. Regardless of what you specify, even if you just take the defaults, their values will alter your utility behavior.

(hollyann) At the end of August we released a new fixpack for InfoSphere Optim Performance Manager (OPM) 5.1.1.1. In addition to defect rollup, there were a few functional enhancements as well:

(Sandeep Sethia and Vaibhav Kulkarni) Performance issues can be difficult to diagnose and fix. Often issues crop up when least expected. Usually, they gradually develop and sometimes can cause outage of the application using the database. It is important from the DBA’s point of view to be aware of a

(Philip) It looked like today was not going to be useful, with the agenda for the day looking at the differences between Oracle and DB2 and trying to get you to convert, and security, with a test at the end that was really for business partners so looked like I could take a nap, but actually each pa

(Sam Lennon) Common table expressions (CTEs) allow you to break down complex SQL logic into smaller pieces. This makes development and testing easier, and when you come back to the code next year you’ll understand it more quickly. That can’t be bad, and a CTE is not hard to use. In this article, I’l

(Babita Sonavane and Javier Sagrera) To improve the performance of a relational database application, it is normal to use stored procedures, which are nothing but user-defined functions containing a series of SQL statements stored in database. In this article, we are going to demonstrate how to acce