Graeson Lewis hat zwei sehr nützliche und übersichtliche DB2 Referenzkarten erstellt – er nennt sie “DB2 cheat sheets“. Auf einem Blatt ausgedruckt stehen auf der einen Seite DB2 Commands, ... weiterlesen

For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv! Themen: Neues in DB2 V10.5, Migration von Row- zu Column-Organized Tabelle, Load Problem, Redirected Restore als Methode der Migration, ... weiterlesen

New document (PDF) "DB2 administrator's Unix Commands Survival Sheets" available: All UNIX commands DB2 administrators know but hardly remember. Covers some Solaris and most of the relevant AIX commands. Also covers ... weiterlesen

Automatic table maintenance work? When? How often? For which tables? These SQL queries will help to clarify questions of this kind. [crayon-5c14bd3987011235274373/]  

IBM is announcing the end of support of selected IBM DB2 and IBM DB2 Connectâ„¢ products. Effective April 30, 2015, IBM will withdraw support for the following programs licensed under the ... weiterlesen

Problem: You want to create a database but DB2 issues the message ... SQL1005N  The database alias "<name>" already exists in either the local       database directory or system database ... weiterlesen

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 ... weiterlesen

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 ... weiterlesen

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 ... weiterlesen

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

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 ... weiterlesen

For german speaking visitors: Neuer IBM DB2 Newsletter neu eingetroffen. Themen: IOCP, LPAD und RPAD, Automatisches REORG für statische Packages, neue Eigenschaften von DB2 V10 und Best Practices u.v.m. Hier geht's zum IBM ... weiterlesen

Performance analysis and tuning guide for SAP on DB2 and AIX. The paper describes how to analyze performance indicators for SAP with DB2 on AIX, and it contains examples of ... weiterlesen

IBM confidential PPT presentation file about the new features of  IBM DB2 Version 10 for Linux/Unix/Windows and IBM InfoSphere Warehouse Version 10. Click here for downloading/browsing .ppt file!

Program number VRM Withdrawal from marketing date Program release name 5724-B55 9.5.0 05/10/12 DB2 Personal Edition V9.5.0 5724-B55 9.7.0 05/10/12 DB2 Personal Edition V9.7.0       IBM announcement -> read more.

Encrypting Data Values in DB2 Universal Database: http://www.ibm.com/developerworks/db2/library/techarticle/benfield/0108benfield.html IBM Rebook "DB2 Security and Compliance Solutions for Linux, UNIX, and Windows", Chapter 7: http://www.redbooks.ibm.com/redbooks/SG247555/7-3-1.htm DB2 V9.7 Encryption (Information Center): http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.sec.doc/doc/c0005815.html

IBM DB2 10.1 for Linux, UNIX, and Windows makes it easier for you to develop database applications, and helps you speed your database application deployment. General availability: 30. April 2012 IBM® DB2® ... weiterlesen

After installation of DB2 V9.7 for Linux/Unix/Windows users may migrate their existing DB2 databases to make use of the new features. One important feature is "AUTOMATIC STORAGE" which enables users ... weiterlesen