(Dave Beulke) In addition to the introduction of ROLES with DB2 10 there are also a number of other security improvements that are also introduced with the new release. The first ones that are going to be a big hit with everyone are the encryption and masking of data.

(Willie Favero) Continuing on with my discussion the very cool security enhancement being delivered by DB2 10 for z/OS. This stuff alone is enough to entice you into upgrading to DB2 10.

(Gaurav Dhudashiya, Nilesh R Awasthey and Sanjay Singh) In this article, we will explore how the default data modes, default filter dialogs and default templates can be applied globally for all IBM Cognos Query Studio users.

(Troy Coleman) With the regulatory requirements that have been enacted in recent years, companies must spend more time and money ensuring that customer data is kept private.

(Kent Milligan) As the numbers of applications systems and interfaces continues to grow, many IBM i developers face the challenge of getting their DB2 for i data into the right format to meet the requirements of these new interfaces. The format types range can from XML to comma-separated values (CSV

(Tom Miller and Hongdi Zhang) The Unified Debugger in DB2 product and the Optim Development Studio product provide a great toolset for anyone creating SQL native or external stored procedures as well as Java stored procedures. This article provides important background information about the Unified

(Henrik Loeser) This week I was asked how to build a full text index on PDF documents in DB2. Because my hard drive is full of them, I created a new DB2 database and set up DB2 Text Search with so-called rich text document filters.

(Willie Favero) Everyone likes to talk about DB2 performance. And if it’s not performance, it’s SQL and Application stuff. There are even long conversations about installation, migrations, backup and recovery, and disaster recovery. However, you just don’t hear all that much about security. Yes, it’

(Shan Chen and Tao Wang) REOPT is a bind option for IBM DB2 for Linux, UNIX, and Windows that influences the optimizer to re-optimize so that it can consider values passed to the application at runtime. In this article, learn how to use REOPT to improve query performance in different types of applic

(Laura) Over the last few weeks we have been bringing you reports on our DB2 Vs Oracle Database complexity study. The next database administration task is Backup and Recovery, and we found DB2 was a breeze compared to Oracle Database.