(Jeffrey Benner) Native DB2 LUW database snapshot utilities identify performance characteristics of the database at the moment they are run, but are not easily used to identify performance trends over days, weeks and months. There are obvious advantages to being able to compare performance trends ov

(Paul Zikopoulos) In the first twelve parts of this series, Ive introduced you to some of the many features available within the IBM Data Studio integrated development environment (IDE) thats available for use with the IBM data servers. Specifically, Ive shown you how to set up and use database conn

(Farzad Farahbod and Ajay Aggrwal) IBM now has support for the new .NET Framework 3.5 Windows Presentation Foundation (WPF), allowing you to create data-bound Extensible Application Markup Language (XAML) applications that map directly to any IBM data server relational object. The IBM Database Add-i

(JAW) I have noticed , especially in the SQL Server world a tendency to believe that the GUI is the holy grail of database management for the DBA. You can’t beat it for certain types of look-ups and quick hitters specifically if you don’t feel like Goggling for syntax.

If you are new to Db2 for LUW and would like to try out db2-luw but don’t have access to a Unix machine where you can install db2, here is one workaround. Install Linux (Ubuntu) on your laptop/desktop and then install db2-express C. While this setup will not exactly duplicate the experience of worki

(Allen Zhang) The IBM InfoSphere Master Data Management (MDM) Server allows you to provide your own security data format to integrate into MDM security framework. This article describes how to use Security Assertion Markup Language (SAML) assertions in MDM security.

(Jeffrey Benner) Active Unix DB2 databases generate and store substantial support information outside of the database itself, in flat text files and binary dumps. If as a Unix DBA you do your administration work largely via Unix shell session, you probably have files comprising SQL, data exports, sc

(Karen Devlin) Creating database connections requires users to provide specific information including the database vendor, version and URL information. Data Studio Developer 2.1 introduces a simple and efficient way to manage database connections, allowing users to easily store and retrieve connecti

(Roger Sanders) Here are the latest sample questions to help you prepare for DB2 9 DBA certification testing. Once you’ve mastered these, browse past questions here. Several recent entries contain additional clarification in the comments section; reading through the comments might add to your own un

(Bryan Smith) Howdy! In case you missed it, we just announced a new release of HPU (High Performance Unload) for DB2 for LUW… V4.1. In case you’ve never looked at our HPU products (for DB2 for z/OS and DB2 for LUW), they can be great productivity enhancers and possibly even save you some resour