Sonntag, 20 of April of 2014

Start

DB2 forum

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

Neuer DB2 Newsletter 2014/01 (german) (last modified 2014-04-02 by Gernot, category DB2 for Linux/Unix/Windows)
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, Von V9.7 nach 10.5, Migration nach ...

New "DB2 administrator's Unix Commands Survival Sheets" available (last modified 2014-03-27 by Gernot, category DB2 for Linux/Unix/Windows)
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 some SAP R3 commands for SAP ba...

Loading DB2 z/OS data into DB2 LUW in internal format (last modified 2014-03-27 by Gernot, category code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows, DB2 for z/OS, z/OS)
Loading data of DB2 z/OS internal format into a DB2 Linux/Unix/Windows database became very easy. Either you use DB2 Connect to connect from any DB2 Linux/Unix/Windows to DB2 for z/OS. But this costs you a separate license fee. For a distinct cla...

SQL playing with user id's (last modified 2014-03-18 by Gernot, category code for Linux/Unix/Windows, code for z/OS, DB2 for Linux/Unix/Windows, DB2 for z/OS)
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed: [crayon-5353c946cf60c025177859/] In this sample the SQL's have to check incoming userid's for having .. ...

db2jcc_license_cisuz.jar JCC JDBC (last modified 2014-03-16 by Gernot, category DB2 for Linux/Unix/Windows, DB2 for z/OS)
Accessing DB2 for z/OS or DB2 for iSeries from client on DB2 for Linux/Unix/Windows? Do you  experience troubles accessing then remote server database? Missing a license file? How to install and custimize? DB2 JDBC driver is not licensed for con...

New document "Extended DB2 DRDA Security" available (last modified 2014-03-13 by Gernot, category DB2 for z/OS)
Extended DB2 DRDA Security: Managing TCP/IP-based connection requests Prepare requestors for access requests using extended security IPNAMES LOCATION USERNAMES Setting DB2 for z/OS DRDA AR to use encrypted passwords Using ICSF...

SQL to determine automatic table maintenance Events (last modified 2014-03-13 by Gernot, category DB2 for Linux/Unix/Windows)
Automatic table maintenance work? When? How often? For which tables? These SQL queries will help to clarify questions of this kind. [crayon-5353c946cfe96045814415/]  

Job Scheduling on Windows - White Paper (last modified 2014-03-01 by Gernot, category DB2 for iSeries, DB2 for Linux/Unix/Windows, DB2 for z/OS, miscellaneous, z/OS)
The purpose of the white paper is to compare mainframe-based and distributed-based job schedulers and to assess the readiness of Microsoft Windows-based job scheduling technology to manage workloads at the enterprise level. The paper can also help IT...

15th DB2 Symposium 28-30 May 2013, Netherlands (last modified 2014-03-01 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 ...

SQL functions to convert DEC to HEX value (last modified 2014-02-14 by Gernot, category code for z/OS, DB2 for z/OS)
Do you need to convert decimal value to hexadecimal representation? Then you should try this: [crayon-5353c946d06cf226318884/]   Sample data displayed in a GUI (e.g. DbVisualizer):   The result is of type VARBINARY. You c...

IBM DB2 Autonomics - A Practical Guide to DB2 Autonomic Features in SAP Environments (last modified 2014-02-13 by Gernot, category DB2 for Linux/Unix/Windows)
This excellent guide describes how  autonomic features can help to make database administration as easy and low-cost as possible. The basis for the descriptions and recommendations in this paper is database version DB2 9.7. If there are comma...

List of important APAR's for DB2 z/OS (last modified 2014-02-13 by Gernot, category DB2 for z/OS)
Work File http://www-01.ibm.com/support/docview.wss?uid=swg1PM17336 Enhancement of the process for creating Work File table spaces during installation and migration. DB2 9 and 10 for z/OS http://www-01.ibm.com/support/docview.wss?uid=isg1II1458...

CA Performance Handbook for DB2 for z/OS (last modified 2014-02-06 by Gernot, category DB2 for z/OS)
The "CA Performance Handbook for DB2 for z/OS" handbook helps DB2 performance tuners to complete the following tasks: Design databases for high performance. Understand how DB2 processes SQL and transactions, and tune those processes for perfo...

New document: DB2 11 for z/OS new way of archiving data (last modified 2014-02-06 by Gernot, category DB2 for z/OS)
New document published: DB2 11 for z/OS new way of archiving data DB2 11 for z/OS new way of archiving data: With DB2 11 for z/OS user can create archive tables to manage historical data for existing tables that is not often referenced. Read more a...

DSN1SMFP now supports also DB2 10 for z/OS (last modified 2014-02-04 by Gernot, category DB2 for z/OS)
DB2 10 for z/OS customers who want a basic  tool for evaluating DB2 audit records: PI05578: Enhance DSN1SMFP to support DB2 10 for z/OS: http://www-01.ibm.com/support/docview.wss?uid=swg1PI05578 For more details on how to use DSN1SMFP, see ...

General availability (GA) for IBM DB2 products (last modified 2013-12-10 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....

End of service (EOS) date for DB2 products (last modified 2013-12-10 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...

Automated STROBE measurement reports and alerts (last modified 2013-12-05 by Gernot, category miscellaneous, z/OS)
Project Title: Automated STROBE batch measurement reports and alerts Subject: Instead of ad-hoc or permanent monitoring, an individual solution based on Compuware's STROBE will periodically monitor distinct address spaces at distinct time and du...

How to determine PUT level of BMC products (last modified 2013-11-28 by Gernot, category miscellaneous, z/OS)
Do you want to determine the maintenance level of you BMC software products? BMC Software updates all mainframe deliverables at regular intervals. The Program Update Tape (PUT) system makes available the latest service and maintenance for BMC Soft...

Avoiding Database REORG Operations in SAP Systems on DB2 for Linux, UNIX, and Windows Version 10.1 (last modified 2013-11-21 by Gernot, category DB2 for Linux/Unix/Windows)
An excellent SAP document describes how to avoid database REORG operations in SAP Systems operating with DB2 10.1 LUW Techniacal environment: SAP NetWeaver 7.0 and higher on DB2 for Linux, UNIX, and Windows (DB2 for LUW) version 10.1 or higher...


For a complete list of all pages and posts, see TOC – table of content.