For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv! Themen: HADR Monitoring, DB2 Backup und Log-Archivierung auf zwei verschiedene TSM Server, Techtipp: DB2 federation – direkter Zugriff, Chats ... Read More
Versions to be withdrawn from service on June 27, 2014: [crayon-53d89810ddca3330221162/] See IBM Withdrawal Announcement ZP12-0021.
DB2 11 for z/OS: The SYSPROC.ADMIN_EXPLAIN_MAINT stored procedure maintains EXPLAIN tables under a specified schema. It can be used to: bring all existing EXPLAIN tables to current release format; create missing ... Read More
Sun, 25 May 2014 21:32:07 +0200 / DB2 for z/OS
The DB2 sample program DSNTIAUL is dynamic SQL processing application that is often used to unload data from DB2 tables to an externalized format.  DSNTIAUL also generates a LOAD control ... Read More
IBM freut sich, Sie zur Frühjahrstagung des deutschen GSE DB2 z/OS Guides nach Würzburg einladen zu können. Die Veranstaltung steht diesmal unter dem Motto "DB2 z/OS V11"! Während der GSE Tagung ... Read More
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, ... Read More
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 ... Read More
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 ... Read More
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed: [crayon-53d8981100bce362790212/] In this sample the SQL's have to check incoming ... Read More
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 ... Read More
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 on z/OS Using PassTicket How RACF Processes the ... Read More
Automatic table maintenance work? When? How often? For which tables? These SQL queries will help to clarify questions of this kind. [crayon-53d89811013cc971139618/]  
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 ... Read More
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. ... Read More
Do you need to convert decimal value to hexadecimal representation? Then you should try this: [crayon-53d8981101cf3159451242/]   Sample data displayed in a GUI (e.g. DbVisualizer):... Read More
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 ... Read More
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 ... Read More
List of important APAR’s for DB2 z/OS
Tue, 04 Feb 2014 22:08:51 +0100 / DB2 for z/OS
Work File Enhancement of the process for creating Work File table spaces during installation and migration. DB2 9 and 10 for z/OS... Read More
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: For more details on how to use ... Read More
Extracts finding from STROBE report to print on log and to extract on dataset which may be emailed to administrators as precautionary notifications. [crayon-53d898110277a147154603/] Example: threshols used: [crayon-53d8981102792744780368/] findings: [crayon-53d8981102796128249013/] For more information how to apply the ... Read More
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 ... Read More
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 ... Read More
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 ... Read More
Starting in z/OS V1R13, IEBCOPY is no longer APF-authorized. It does not need to be run from an authorized library, and calling ... Read More
For german speaking visitors: Ein neuer IBM DB2 Newsletter steht im Archiv! Themen: Was ist neu in DB2 10.5 for Linux/Unix/Windows, Command dbstart nach Ãœbernahme, DB2 Abfrage Optimierung durch OPTIMIZATION GUIDELINES, ... Read More
In january 2007 the IBM DB2 PTF PK34261/UK20793 introduced DSN1SMFP, a DB2-supplied application for processing DB2 trace data into reports that are useful for evaluating and auditing the DB2 environment ... Read More
The following script references "Perl module – function package used by DBA Perl scripts" The following very ... Read More
IBM published the planned general availability date for IBM DB2 11 for z/OS: October 25, 2013 For more details see IBM EMEA Announcement ZP13-0480, dated October 1, 2013:... Read More
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 ... Read More
Latest DB2 10 for z/OS redbooks have been updated: DB2 10 for z/OS Performance Topics, last updated 23 Aug 2013... Read More
Please follow the direct link to IBM’s download pages of IBM Data Studio Client 4.1 Click here. Use IBM Installation Manager to select, download, and install ... Read More
Do you want to compare DB2 Linux/Unix/Windows databases, structures, contents or configurations. Or do you want to compare table data or structures with DB2 for z/OS? Here's list of products which ... Read More
Nutzen Sie bereits das volle Wertschöpfungspotential Ihrer DB2 Systeme? Was gibt es Neues in der DB2-Entwicklung und wie können Sie davon bestmöglich profitieren?... Read More
Do you want to delete an obsolete z/OS dataset without RECALL'ing or RECOVER'ing from CA-DISK, HSM or other storage management systems? This is a very smart ans resource saving way - ... Read More
Problem: You want to create a database but DB2 issues the message ... SQL1005N  The database alias "<name>" already exists in either the local ... Read More
SQL check for unused indexes! Before dropping indexes, verify that following PTF's are installed. RA10 PSY UK76968 UP12/03/27 P F203 R910 PSY UK76969 UP12/03/27 P F203 If not installed, LASTUSED is not being updated ... Read More
With EMEA annoucement letter ZP13-0262 (april 23rd 2013) IBM has announced  "DB2 10.5 with BLU Acceleration, the multi-workload database software for the era of big data, improves performance while helping ... Read More
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 ... Read More
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 ... Read More
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 ... Read More
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 ... Read More
Do you need to execute one ore more commands at all of your DB2 instances? Then you should deploy! This script ... locates all DB2 instances using profiles.reg (DB2 ... Read More
  [crayon-53d8981107824297807883/]   [crayon-53d898110782e500528393/]  
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 ... Read More
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 ... Read More
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 ... Read More
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 ... Read More
DSNACCOX, the successor of DSNACCOR, is a IBM DB2-supplied stored procedure to provide information to maintain DB2 objects. It includes proposals for creating image copyies (COPY), reorganization (REORG) and renewal ... Read More
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 provides following functions: creates CREATE TABLESPACE statements for existing database creates REDIRECTED RESTORE statements for a database you possibly want to or need to recover at a remote site creates ... Read More
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 ... Read More
Become a supporter
Thu, 13 Dec 2012 21:02:44 +0100 / 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 ... Read More
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. Hier ... Read More
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 ... Read More
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 ... Read More
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 ... Read More provides following functions ... lists all databases (local and remote) at current DB2 instance lists all connections at the DB2 instance, or only those connected to a specified database terminates all connections, or ... Read More
DB2 10 for z/OS: The Smarter, Faster Way to Upgrade By John Campbell, Cristian Molaro, and Surekha Parekh First Edition First Printing—October 2011 © 2011 IBM. All rights reserved. The objective of ... Read More
This book is for database administrators and application developers who are considering DB2 10 for a new installation, an upgrade ... Read More
IBM's BI/ERP Solutions Center has just updated the whitepaper "Tuning SAP with DB2 on IBM AIX": Performance analysis and tuning guide for ... Read More
You need to check the version of your Java Combined Client (JCC) installed? Try this way: [crayon-53d898110d2cc184590137/] All DB2 JDBC Driver versions, see here! More information on ... Read More
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 ... Read More
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 ... Read More
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, 6th Edition By Craig S. Mullins DB2 Developer's Guide is the field's #1 go-to source ... Read More
Each new release of DB2 introduces new columns or modifies existing columns in the EXPLAIN tables. DB2 has traditionally honored EXPLAIN tables in previous release formats, but it is best ... Read More
Find below the free documents of the annual BMC DB2 and Mainview User Meeting in Munich, June 2012.   The Evolution of the Mainframe: Meeting the Business Requirements of the ... Read More
This Perl script verifies the interface to DB2 whicht consists of the general database interface, called DBI, and the DB2-specific supplement, called DBD::DB2. This script uses the ... Read More
DB2 V9.7 for Linux/Unix/Windows supports automatic revalidation of objects which is controlled by the database configuration value AUTO_REVAL. If requested by database administrator, this feature for example revalidates a views which was ... Read More
Do you want to generate a timestamp in external DB2 format YYYY-MM-DD-HH.MM.SS.ssssss? Use either following functions which is already part of the function library: [crayon-53d898110ffa4681366494/] Or try following Perl statements which ... Read More
DB2 10 for z/OS System & Application Monitoring and Tuning Part 1: System Monitoring and Tuning (PDF from FTP server) Part 2: ... Read More
DB2 10 for z/OS: Cost Savings . . . Right Out of the Box Dave Beulke, Roger Miller, Surekha Parekh, and Julian Stuhler... Read More
Best practices: Storage optimization with deep compression (Authors: Thomas Fanghaenel and Bill Minor) Best practices: A practical guide to implementing row and column access control (Author: Walid Rjaibi)... Read More
This REXX procedure checks the status for DB2 for z/OS databases, tablespaces, utilities and threads. The user passes a valid DB2 command and the procedure checks the results. Example 1: CHECK ... Read More
This TSO/E ISPF EDIT macro, called JUMP, helps to navigate between sources. An example: You are editing a job JCL and need some information, for example input parameter allowed for ... Read More
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... Read More
DB2 encryption
Mon, 09 Apr 2012 22:23:37 +0200 / DB2 for Linux/Unix/Windows
Encrypting Data Values in DB2 Universal Database: IBM Rebook "DB2 Security and Compliance Solutions for Linux, UNIX, and Windows", Chapter 7: DB2 V9.7 Encryption (Information Center):
"Breaking the DB2 Platform Barrier" Comparing the Architectural Differences Between DB2 UDB for z/OS And DB2 UDB LUW Quest Software, Inc. Published in 2009 but one of the best overviews for DB2 "newbies" and staff working ... Read More
You want to load a CSV file into a DB2 for z/OS table? Usually the problems are ... the columns do not start at fix column position strings, dates and times are not ... Read More
Ursachen für Programmabbruch mit -805 suchen Die Situation: Ein Anwendungs-Programm bricht mit -805 (Package-Fehler) oder -818 (DBRM-Fehler, bis DB2 for z/OS V9.1) ab! Die folgende Beschreibung soll Dich bei der ... Read More
DB2 Trace Commands and Facilites
Sat, 07 Apr 2012 21:13:34 +0200 / DB2 for z/OS
DB2 has extensive tracing facilities that generate trace records called IFCIDs. IFCIDs are produced by the DB2 Instrumentation Facility. These trace records describe internal events within DB2 at various levels ... Read More
An essential example of how to deploy ADRDSSU to DUMP several files and later, if required, RESTORE one or more of those archived files. This exmpale: Create a DUMP file ... Read More
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 ... Read More
To DB2 z Hotline subscribers: For various reasons the information platform has changed from a mail distribution list to a EXCHANGE webpage. Now visable as the DB2 for z/OS Exchange on ... Read More
Problem: You are wondering about following message in your db2diag.log which appears frequently in periods of 90 or 120 minutes: [crayon-53d898111460c994039354/] Reasons: The DB2 Health Monitor periodically wakes up and checks for a connection to the DB2 ... Read More
Current Fix Packs for DB2 for Linux/Unix/Windows:   DB2 Version Fix Pack  DB2 V9.8 Fix Pack 4​​... Read More
Experten zum Anfassen! Neben fachlich hochkarätigen Vorträgen bietet Ihnen diese Konferenz einen direkten Zugang zu den DB2 Experten aus den Silicon Valley und Toronto Labs der IBM. Aktuelle Fragestellungen, Probleme und ... Read More
This perl module contains all functions need by xmp perl scripts, published at You should easily adapt some constant values to your pesonal needs. Some comments are ... Read More
Perl script to administer files, especially DB2 administration files, like db2diag.log, admin log file, or any other file. It helps to archive, compress, rename or delete one or more files, optionally ... Read More
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 ... Read More
DB2 versions
Sat, 03 Mar 2012 20:35:17 +0100 / 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:... Read More
REXX to call the IBM DB2-supplied stored procedure ADMIN_INFO_SYSPARM to access DB2 DSNZPARM parameters and writes them an output dataset. This make it easy to archive DB2 subsystem parameters or ... Read More
Activate requested DB2 environment: Search for registered DB2 software version, instances, databases and execute the appropriate DB2 environment. The KSH shell script is quite useful on sites with more than one ... Read More
DSNACCOX, the successor of DSNACCOR, is a IBM DB2-supplied stored procedure to provide information to maintain DB2 objects. It includes proposals for creating image copyies (COPY), reorganization (REORG) and renewal ... Read More
All system z DASD I/O systems base on the IBM DASD device type IBM 3390 Model ... Read More
CICS and MQ Explorer
Thu, 16 Feb 2012 11:25:02 +0100 / z/OS
IBM CICS Explorer: Common, intuitive, Eclipse-based environment for architects, developers, administrators, system programmers, and operators.  Looking for new ways to accelerate the transfer of knowledge, skills, and best practice to ... Read More
Everything you need for total control of your DB2 backup process: [crayon-53d898111f123132728559/]
Data Aging Tools
Fri, 10 Feb 2012 20:51:16 +0100 / miscellaneous
Data Aging Tools are usually instrument of development or test environments to change the age of test data, to make them younger or older. In particular, data are systematically adjusted to a desired ... Read More
This KSH shell script executes DB2 SQL statements and commands. The script and starts an DB2 enviroment connects itself to the database specified as argument.  [crayon-53d8981120d13608703879/]
Perl script to create UPDATE DB|DBM CFG statements for databases and instances, prints ordered list of confuguration options. Enables users to "copy" or "save" configurations. [crayon-53d8981121bca837886568/]
Free IBM DB2 ebooks: Database fundamentals Learn the basics of relational database theory and other information models. ... Read More
This tiny assembler program may enhance control of your jobs whenever  TWS or JES JCL syntax would be to complex. The program raises an U0001 user abend, which leads to "end of ... Read More
REXX procedure to display DBRM Timestamp: [crayon-53d8981123466879186478/] (Needs amendments for DB2 V10 for z/OS!)
This TSO/E REXX procedures reads information from Data Propagator tables, which can be used to control dependent process flow. The procedure is quite old but still a good sample for querying ... Read More
z/OS JCL to delete a file
Thu, 09 Feb 2012 10:42:54 +0100 / code for z/OS
z/OS JCL example for "delete a file, if exists. Doesn't matter if not. [crayon-53d8981125ce0087965039/]
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 ... Read More
End of Support/Service dates for IBM DB2 products: not yet announced: DB2 V10 for z/OS end of marketing at 2015-07-06 DB2 10.5  for LUW, all editions DB2 10.1  for LUW, all editions DB2 9.8  for LUW, Unix, DB2 ... Read More
NLS and unicode support
Thu, 19 Jan 2012 21:57:17 +0100 / miscellaneous
  Understanding DB2 Universal Database character conversion (IBM, PDF)... Read More
Launching the installation of DB2 Connect Personal Edition opens the product selection list but only the IBM Data Server Client is in the list. The DB2 Connect Personal Edition product ... Read More
Do you search for tools and "how-to" solve access-path related problems. Here are some interesting links: Troubleshooting access-path-related performance problems Covers deployment of DB2PLI8 program (for ... Read More

For filtered articles concerning DB2 for z/OS or DB2 for Linux/Unix/Windows, please follow appropriate links!


  • Es befinden sich keine Produkte im Warenkorb.