(Scott Hayes) A lot of attention is being paid these days to database security and auditing. IBM has made great improvements in security and auditing with DB2 9.5 (Viper 2). Still, there remains a security vulnerability that many auditors and security administrators are not aware of, and I doubt tha

(Troy Coleman) Have you ever looked at a default parameter and wondered why the heck they picked that as the default? I know I have. I think has IBM generally chosen its default values based on how its systems are being built at the time the feature comes out. However, with DB2 9, IBM has seen a shi

(Willie Favero) For anyone dabbling with DB2 Data Studio, here’s an interesting APAR that you are going to want to apply. It’s APAR PK50369 (PTF UK31820).

(Hardeep Singh and Karen Devlin) Installing a package that requires DB2 interaction often requires detailed, step-by-step instructions. Any failure on the part of the user can cause unexpected errors and lead to frustration for the user. This article describes a utility that can be used to simplify

(Gene Cobb) Hopefully, by now you’ve had a chance to install and use the new DB2 Web Query for System i tool. Hailed as the successor to the popular Query/400 product as the strategic System i query and reporting tool, DB2 Web Query can do things that Query/400 could only dream of. One of these adva

(Paolo Bruni, Terry Berman, John Iczkovits, Basuki Soetarman, Bart Steegmans and Mike Turner) The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as

(Knut Stolze) IBM DB2 for Linux, Unix, and Windows treats all strings stored in a database as case-sensitive. Some applications can — or even must — ignore the case of letters in strings and just want to retrieve data based on some given, mixed-case input. This article gives an overview of techniq

(Chris Eaton) I’ve been asked by several people lately about the new compression capability in Oracle 11g and if DB2 has lost any competitive advantage. I hope some Oracle folks that read my blog will jump in here and correct me if I’m wrong but here is what I see.

(Scott Hayes) If your database updates its data via Inserts, Updates, Deletes, Imports, or Loads, then this blog post is for you. Write times tend to be slower than read times, and synchronous writes can be particularly painful. When tuning your databases, it is desirable to achieve a high percentag

(Radhesh Kumar) Divide and conquer- that’s the mantra used to deal with large volume of data in data warehouses. What are the features available in DB2 to divide or partition the data? DB2 provides following three features to partition your data. –Data Partitioning Feature (DPF) –Multi-Dimensi