(Reddy Sripathi) This article explains an important task in WebSphere Process Server administration – restoring the deployment manager after a non-recoverable crash.

(Robert Catterall) Last week, I helped a DBA at a large financial services firm with a couple of questions related to DB2 for z/OS stored procedures and result sets (referring to the row and column information accessed via a query included in a DECLARE CURSOR statement). Both of the DBA’s questions

(Dave Beulke) As each version of DB2 comes out there are always the projects that need justification for going to the next DB2 version. The huge number of performance features in DB2 Version 9 for z/OS should make your summer of 2009 your time to get to the new release. This large number of performa

(Stefan Abraham, Simone Daum and Benjamin G. Leonhardi) Unstructured information represents the largest, most current, and fastest growing source of information that is available today. This information exists in many different sources such as call center records, repair reports, product reviews, e-

(Skip Marchesani) Many months ago, when I needed to create and execute an ad hoc query using SQL, my tool of choice was Interactive SQL, available via the System i green screen interface. I don’t recall any dramatic change taking place–I suspect it was gradual–but these days I find myself using Ru

The release of DB2 9.7 for Linux, Unix and Windows is creating quite a stir in the industry. CNET said that “IBM puts Oracle to the Sword.” ZDnet commented that “IBM’s latest DB2 woos Oracle customers.” Industry analyst Merv Adrian said, “This is a BIG deal.” Beta participants claim that “this is a

(Troy Coleman) In the early days of DB2, you had to bind all DBRMs of any program you wanted to call to the plan being executed. The problem with this is if you changed one program, that DBRM and all other DBRMs had to be bound again. When packages were introduced, the bind was moved from the plan t

(Paolo Bruni, Nisanti Mohanraj, Cristian Molaro, Yasuhiro Ohmori, Mark Rader and Rajesh Ramachandran) Distributed Relational Database Architecture (DRDA ) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of rela

(Gaurav Bhattacharjee) IBM WebSphere Portal Version 6.1 introduces new features, such as client-side aggregation, Friendly URLs, and static page aggregation. WebSphere Portal V6.1 provides new themes, which include a Web 2.0-based theme. IBM Rational Application Developer Version 7.5 provides the to

(Henrik Loeser) When you have indexes you want your dbms of choice use them as efficiently as possible – even with XQuery involved. However, SQL and XQuery can be complicated and sometimes a helping hand is needed to aid the compiler/optimizer making the right decisions. Today I am going to show you