Tag Archives: db2

Free IBM InfoSphere Warehouse 9.7 Redbook

by JpK on Jun 26, 2010 in db2, infosphere warehouse, publications

Just released: InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence

Here’s the abstract:

In this IBM® Redbooks® publication we describe and demonstrate Version 9.7 of IBM InfoSphere™ Warehouse. InfoSphere Warehouse is a comprehensive platform with all the functionality required for developing robust infrastructure for business intelligence solutions. It enables companies to access and analyze operational and historical information, whether structured or unstructured, to gain business insight for improved decision making. InfoSphere Warehouse solutions simplify the processes of developing and maintaining a data warehousing infrastructure and can significantly enhance the time to value for business analytics.

The InfoSphere Warehouse platform provides a fully integrated environment built around IBM DB2® 9.7 server technology on Linux®, UNIX® and Microsoft® Windows® platforms, as well as System z®. Common user interfaces support application development, data modeling and mapping, SQL transformation, online application processing (OLAP) and data mining functionality from virtually all types of information.

Composed of a component-based architecture, it extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, inLine analytics and intra-warehouse data movement and transformation, on a common platform.

Thanks to the authors: Chuck Ballard, Nicole Harris, Andrew Lawrence, Meridee Lowry, Andy Perkins, and Sundari Voruganti.

Read full story • Comments { 1 }

“Macintosh: Insanely Great”

by JpK on Jan 25, 2009 in db2, mac

MacRumours.com pointed out that January 24, 2009 marked the 25th anniversary of the introduction of the Apple Macintosh.

Below is a YouTube video of a younger (and healthier) Steve Job’s demonstrating the Mac.

(more…)

Read full story • Comments { 0 }

25 years of DB2

by JpK on Jun 15, 2008 in db2

June 7th marked the 25th anniversary of the launch of IBM’s DB2 database on the MVS operating system.

(more…)

Read full story • Comments { 2 }

Best practices for DB2 for Linux, UNIX, and Windows

by JpK on May 26, 2008 in db2

We have just released 11 best practice papers for DB2 9.  The papers are available at no charge.  You can download them from IBM developerWorks.

These Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM’s development and consulting teams, and have been extensively tested.

Each Best Practice paper is designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM’s technical direction for DB2.

Currently there are papers covering the following topics:

  1. Database storage
  2. Physical database design
  3. Data life cycle management
  4. Minimizing planned outages
  5. IBM data server security
  6. Deploying IBM DB2 products
  7. Writing and tuning queries for optimal performance
  8. Tuning and monitoring database system performance
  9. Managing XML data
  10. Improving data server utilization and management through virtualization
  11. Frequently asked questions from problem management reports

Expect more papers on other topics in the near future.

Read full story • Comments { 2 }

DB2 Monitoring Console

by JpK on Jan 07, 2008 in db2

A few weeks ago, the DB2 Monitoring Console was released.  The monitoring console is “a light weight, web based console for DB2 for Linux, UNIX and Windows.  It is also a set of building blocks for rapidly developing your own console or PHP Web-based application.”

It has been released under the Apache License and is hosted at SourceForge.  To learn more, visit: http://sourceforge.net/projects/db2mc

Read full story • Comments { 0 }

DB2 9.5 now available

by JpK on Nov 11, 2007 in db2

DB2 Viper 2 is out of beta and now available as DB2 9.5 for Linux, UNIX, and Windows.  The What’s New guide provides a complete list of all the new features. If you’d rather take a test drive, download DB2 9.5 now.

PS.  If you’re looking for a version of DB2 for Linux, UNIX, and Windows that is free to develop, deploy, and distribute, check out DB2 Express-C.

Read full story • Comments { 0 }