(Deb Jenson) Not so long ago, the always-on phenomenon of Internet computing pushed performance and availability to the top of IT departments’ lists. Today, one concern tops even those: data governance. The basic organizational need to keep unauthorized eyes away from sensitive data (corporate secre

(Susan Visser) DB2 has six current certification exams that each lead to a different certification role. The most common certification is IBM Certified Database Administrator. Here are the exams that cover DB2 9 content: * Exam 730 – DB2 9 Fundamentals * Exam 731 – DB2 9 DBA for Linux, Unix, a

(Chris Eaton) Previously I posted about the basics of Backup in DB2 (part 1, part 2 and part 3). Now I’ll write about some recovery basics. I’m going to assume that you are using log archiving (otherwise you must be using offline backups and the simple restore command is all you get to get yourself

(Peggy Zagelow) Announced today: New pricing options for DB2 for z/OS running new workloads! All you data center folks who lament to us that pricing for “other” databases can’t be compared to DB2 for z/OS – rejoice!!

(Radhesh Kumar) In my experience, application or database developers will have to deal with writing SQL queries more than a DBA (specially a System DBA). However, many a times DBAs are expected to help with writing complex queries. Keeping that in mind, I have decided to post SQL tips and techniques

(Henry Cui) Part 1 and Part 2 of this three-part tutorial series showed you how to develop Web services and clients, and configure HTTP basic authentication. In this final installment, you create a self-signed certificate, key store, trust store, and Secure Sockets Layer (SSL) configuration using th

(Troy Coleman) If you’re looking for a book that presents a well-rounded overview of DB2 for LUW and you’d like to know what’s new in version 9 and 9.5, look no further. “Understanding DB2: Learning Visually with Examples” can serve as a training guide for a beginner, a DB2 certification preparation

(Cynthia Harvey) IBM has a grand dream for enterprise data management: to create a single toolset that can manage every aspect of the data life cycle. This toolset would offer built-in compliance and easy integration with other IBM tools. And it would work equally well with IBM data servers (includi

(Helmut K. C. Tessarek) Looking for a central source for tuning your WebSphere Portal Web Content Management and IBM DB2 for Linux, UNIX, and Windows environment? This article describes the different parts of the environment that are unique and require special consideration. You’ll learn how to tune

(Walker) I haven’t tried the DB2 version 9, but the version 8 offers DB2 CLP command to query or list the tablespaces statistics (particularly the used pages and free pages).