Start
This is not just a blog for experts, but for anyone looking for the latest information on DB2. You will find tons of interesting articles and “how to” examples. The blog provides a vast number of useful links which lead directly to sources hidden deep in the world wide web.
A short compilation for the first time visitors – this waits to be discovered:
- links, news, facts of DB2 for z/OS, DB2 for Linux/Unix/Windows, DB2 for iSeries
- samples and code snippets (e.g. SQL, Perl, Shell, JCL, Rexx, Assembler …)
- directory of interesting courses and important events
- DB2 usage and special topics
- directory of free tools for z/OS and Linux/Unix/Windows
- german DB2 newsletter archive
- RSS feeds (in and out)
- moderated forum
Following the dynamic navigation bar at the right, or the TOC page, will bring you directly to the item of interest.
Regards
Gernot
PS: Do you want to become a contributor? Don’t hesitate to contact me!
Latest posts for DB2 for z/OS, Linux, Unix, Windows and much more ...
IDUG DB2 Tech Conference in Barcelona, Spain October 13-18, 2013 (last modified 2013-04-26 by Gernot, category DB2 for iSeries, DB2 for Linux/Unix/Windows, DB2 for z/OS)
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...
15th DB2 Symposium 28-30 May 2013, Netherlands (last modified 2013-04-26 by Gernot, category DB2 for z/OS)
The DB2 symposium fills the gap between classic conferences and workshops. In classic conferences many topics are covered, but each speaker has only a limited time for each topic. Interaction between speakers and attendees is normally restricted. In ...
Neuer DB2 Newsletter (german) (last modified 2013-04-04 by Gernot, category DB2 for Linux/Unix/Windows)
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...
Product Lifecycle for DB2 and IMS Tools (last modified 2013-03-30 by Gernot, category DB2 for z/OS, z/OS)
IBM provides "The IBM DB2 and IMS Tools Product Lifecycle matrix" to display the marketing and support services available over the life of z/OS-based products. You can click the dates that are listed to go directly to the product announcement lette...
General availability (GA) for IBM DB2 products (last modified 2013-03-30 by Gernot, category DB2 for Linux/Unix/Windows, DB2 for z/OS)
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, category DB2 for Linux/Unix/Windows)
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, category DB2 for Linux/Unix/Windows)
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, category DB2 for Linux/Unix/Windows)
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, category DB2 for Linux/Unix/Windows)
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, category DB2 for Linux/Unix/Windows, DB2 for z/OS)
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, category DB2 for Linux/Unix/Windows)
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, category DB2 for Linux/Unix/Windows)
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...
Neuer DB2 Newsletter (german) (last modified 2012-12-03 by Gernot, category DB2 for Linux/Unix/Windows)
For german speaking visitors: Neuer IBM DB2 Newsletter neu eingetroffen.
Themen: Ändern Null-Wertigkeit, DB2 System ODBC Datasources auf X64, DB2 Tabellen Status, ITDS und LDAP_MAXCARD, Schulungen / Tagungen / Informationsveranstaltung u.v.m....
New ADMIN_UPDATE_SYSPARM stored procedure (last modified 2012-11-18 by Gernot, category DB2 for z/OS)
The SYSPROC.ADMIN_UPDATE_SYSPARM stored procedure changes the value of one or more DB2 subsystem parameters located in one of these macros: DSN6SPRM, DSN6ARVP, DSN6LOGP, DSN6SYSP, DSN6FAC, and DSN6GRP. It builds a subsystem paramters load module,...
No harmony between DB2 10 and Data Studio 3.1.1 (last modified 2012-10-17 by Gernot, category DB2 for Linux/Unix/Windows, DB2 for z/OS)
Customers who want to make use of extended EXPLAIN need to adapt and execute a DB2 10 sample job from SDSNSAMP library. IBM delivers a job called DSNTESC to create a set of 20 EXPLAIN tables required.
Because Visual Explain is deprecated and OSC (...
End of service (EOS) date for DB2 products (last modified 2012-10-08 by Gernot, category DB2 for Linux/Unix/Windows, DB2 for z/OS)
End of Service dates for IBM DB2 products:
30.06.2008: DB2 for OS/390 V7
30.09.2009: DB2 LUW V8.x EoS
30.04.2012: DB2 LUW V9.1 EoS
30.04.2012: DB2 for z/OS V8
30.04.2013: DB2 LUW V9.5 EoS
27.06.2014: DB2 for z/OS V9
30.09.2014: DB2 LU...
DB2 versions (last modified 2012-10-08 by Gernot, category DB2 for z/OS)
List of most important changes every DB2 for z/OS, DB2 for OS/390 or DB2 for MVS version brought with.
(Partially in german language only.)
Important links:
IBM Support DB2 for z/OS
IBM Software support lifecycles for DB2 for z/OS 10.1....
IBM DB2 11 for z/OS Early Support Program starts march 2013 (last modified 2012-10-07 by Gernot, category DB2 for z/OS)
IBM® intends to make DB2 11 for z/OS ( DB2 11) available to a select group of clients in a closed Early Support Program (ESP) on March 8, 2013.
Selected features that deliver these valuable benefits to your business include:
CPU reductions an...
SQL to retrieve DB2 subsystem information - update for DB2 10 z/OS (last modified 2012-10-04 by Gernot, category miscellaneous)
[crayon-519f92cbb0790/]
Neuer DB2 Newsletter (german) (last modified 2012-10-01 by Gernot, category DB2 for Linux/Unix/Windows)
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 DB2 Newsletter Arch...
For a complete list of all pages and posts, see TOC – table of content.