www.ruban.de – DB2 experts web site

Essential information of current versions of DB2 for Linux/Unix/Windows

• DB2 10.1
  • Announcement IBM DB2 10.1 and IBM DB2 Connect 10.1 for Linux, UNIX and Windows
  • Products and packages
  • DB2 10.1 functions and editions and DB2 Connect 10.1 functions and editions
  • What’s new in DB2 10 for Linux, UNIX, and Windows
  • A matter of time: Temporal data management in DB2 10
  • DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows: DB2 10 gives applications developed on Oracle a bear hug with PL/SQL support, and more
• DB2 9.8 - pureScale Feature for Enterprise Server Edition
  • Announcement
• DB2 9.7
  • Announcement
  • Products and packages
  • Features and functions on product base, e.g. which product include the compression feature
  • Which distributed edition of DB2 9.7 is right for you?
  • Compare the distributed DB2 9.7 database servers
  • Licensing distributed DB2 9.7 servers in a high availability (HA) environment
• All versions
  • Best practices for DB2 for Linux, UNIX, and Windows
  • System Requirements
  • Fix Packs by version
  • DB2 and IBM’s Processor Value Unit pricing
  • Which edition of DB2 Connect is right for you?

Documents [site property]

Latest posts for DB2 for Linux/Unix/Windows

IDUG DB2 Tech Conference in Barcelona, Spain October 13-18, 2013 (last modified 2013-04-26 by Gernot)
IDUG DB2 Tech Conference in Barcelona, Spain 2013 Barcelona, Spain October 13-18, 2013 Call For Presentations: You can submit your abstracts by clicking here. IDUG DB2 Tech Conference in Berlin Wrap Up Article: The Conference was a great su...

Neuer DB2 Newsletter (german) (last modified 2013-04-04 by Gernot)
For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv! Themen: Die GSE DB2 LUW Working Group Tagung in Heidelberg, DB2 Troubleshooting – db2stop hangs, Monitoring archivierter Log Files, automatisierte Datenbank-Reorganisat...

General availability (GA) for IBM DB2 products (last modified 2013-03-30 by Gernot)
General Availability (GA) of IBM DB2 software products: (link to annoucement if available): 26.03.2004: DB2 for z/OS V8 16.03.2007: DB2 for z/OS V9.1 22.10.2010: DB2 for z/OS V10.1 31.10.2007: DB2 for LUW V9.5 19.06.2009: DB2 for LUW V9....

Neuer DB2 Newsletter (german) (last modified 2013-03-11 by Gernot)
For german speaking visitors: Neuer IBM DB2 Newsletter neu eingetroffen. Themen: Transponieren, Tabellen-Liste und Anzahl der Datensätze, DB2 Connect-Zeiten unter Windows, Erstellen eines EXPLAIN, Chats mit dem Labor  u.v.m. Hier geht’s zum...

Download your IBM DB2 license from Passport Advantage (last modified 2013-03-11 by Gernot)
Each DB2 database product has its own license key. If you purchased a DB2 V10.1, V9.8, V9.7, V9.5 product then you can obtain license key from Passport Advantage. Starting with DB2 Version 9.1, the license file for DB2 products is shipped separate...

Changing SYSCATSPACE Page Size Using DB2 "RESTORE … TRANSPORT" by SAP (last modified 2013-03-11 by Gernot)
Changing SYSCATSPACE Page Size Using DB2 "RESTORE … TRANSPORT" May 11th, 2011, PDF 557 KB As of DB2 Version 9.7 Fix Pack 3, DB2 allows you to move from one DB2 database to another database schema with the new RESTORE ... TRANSPORT option. SAP...

SAP's IBM DB2 for LUW Parameter Check Tool (last modified 2013-03-11 by Gernot)
IBM DB2 for LUW Parameter Check Tool May 11th 2011, PDF 819KB SAP products have been released for several versions of the IBM DB2 for Linux, UNIX, and Windows database. For each of these DB2 versions, SAP makes special recommendations for the d...

Free IBM Data Studio Client 3.2 download (last modified 2013-03-11 by Gernot)
Please follow the direct link to IBM's download pages of IBM Data Studio Client 3.2 Click here. No Installation Manager needed! IBM Data Studio client Linux 32 bit Install - ibm_ds320_lin_im32.zip (1500 MB) IBM Data Studio client Linux 64 b...

DB2 9.5 for LUW and some tools withdrawn from marketing (last modified 2013-02-07 by Gernot)
Software withdrawal: DB2 and Infosphere Warehouse 9.5 including coordinated Federation Server IBM Europe, Middle East, and Africa Withdrawal Announcement ZP12-0567 November 13, 2012 Withdrawl from marketing date: 2013-02-13

Become a <db2top> supporter (last modified 2012-12-13 by Gernot)
IBM obviously plans to remove the db2top utility from upcoming versions of DB2 for Linux/Unix/Windows. If you are a db2top user, like the utility and would appreciate using it in the future, then take part of an IBM survey and thus become a supp...

Don’t miss …

• IBM featured Documents for DB2 for Linux, UNIX and Windows
• SAP: New DB2 Parameter Check Tool for the DBA Cockpit
• Authorization errors due to changes to the SYSADM authority scope (DB2 V9.7)
• DB2 Basics:  Fun with Dates and Times
• DB2 Sample UDFs for Migration
• DB2 10-Minutes-Solutions (DevX)
• DB2 Stored Procedures and UDF’s (Quest)
• Connect to DB2 for Linux/Unix/Windows Server and DB2 for z/OS Server: The famous “Connectivity cheat sheet for Application Developers”, part 4 and part 5. These are 2 articles in a series discussing connectivity scenarios involving DB2 for Linux, UNIX and Windows, DB2 UDB for iSeries and DB2 UDB for z/OS. The focus of this article is on workstation application development connectivity for ADO and ADO.NET applications accessing DB2 using C++, Visual Basic, C#, and Visual Basic .NET languages.