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 practice to use the current-release format in order to gather maximum benefit from your EXPLAIN data.
In addition, EXPLAIN tables were ... weiterlesen
Gernot
15
Jul2012
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 Future - Nick Pachnos, BMC Software
DB2 Track:
Mainview for DB2 10.1 - Peter Plevka, BMC Software
MIPS Aufrüstung vermeiden - ... weiterlesen
15. Juli 2012Gernot
20
Jun2012
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 xmpPerl.pm library, which is also available at this site.
#!/usr/local/bin/perl -w
use strict;
print "Perl Search Path INC ........: @INC\n";
####use lib qw(/usr/opt/db2_08_01/lib64);
use Getopt::Std;
use vars qw($opt_d $opt_l ... weiterlesen
20. Juni 2012Gernot
18
Jun2012
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 temporary invalid due to a DROP and re-CREATE of a base table or view. But administrators should play ... weiterlesen
18. Juni 2012Gernot
18
Jun2012
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 xmpPerl.pm function library:
$TS = `date +%Y-%m-%d-%H.%M.%S`; # yyyy-mm-dd-hh.mm.ss
$TS ... weiterlesen
18. Juni 2012Gernot
05
Jun2012
DB2 10 for z/OS
System & Application Monitoring and Tuning
Part 1: System Monitoring and Tuning (PDF from FTP server)
Part 2: Application Monitoring and Tuning
and notes (PDF's from FTP server)
IBM Silicon Valley Lab, San Jose, CA
May, 2012
5. Juni 2012Gernot
21
Mai2012
DB2 10 for z/OS: Cost Savings . . . Right Out of the Box
Dave Beulke, Roger Miller, Surekha Parekh, and Julian Stuhler
First Edition
First Printing—September 2010
© 2010 IBM Corporation. All rights reserved.
The book is segmented in three sections:
An introduction to DB2 10 by Roger Miller, highlighting the main features and functions ... weiterlesen
21. Mai 2012Gernot
16
Mai2012
Best practices: Storage optimization with deep compression (Authors: Thomas Fanghaenel and Bill Minor)
http://www.ibm.com/developerworks/data/bestpractices/deepcompression/index.html
Best practices: A practical guide to implementing row and column access control (Author: Walid Rjaibi)
http://www.ibm.com/developerworks/data/bestpractices/rcac/index.html
Best Practices: Temporal data management with DB2 (Author: Matthias Nicola)
http://www.ibm.com/developerworks/data/bestpractices/temporal/index.html
DB2 V10.1 Multi-temperature data management recommendations (Authors: Jim Seeger, Karen McCulloch, Naresh Chainani, Kiran Chinta, ... weiterlesen
16. Mai 2012Gernot
10
Mai2012
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 DATA, which checks your DB2-enforced referential integrity ends with return code RC=4 even if the DB2 utility has detected RI ... weiterlesen
10. Mai 2012Gernot
10
Mai2012
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 a procedure or programm. Usually you would split the screen, open an additional edit oder browse session to look for ... weiterlesen
10. Mai 2012Gernot
23
Apr2012
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!
23. April 2012Gernot
10
Apr2012
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.
10. April 2012Gernot
09
Apr2012
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
9. April 2012Gernot
09
Apr2012
"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 on both platforms!
Read more!
9. April 2012Gernot
07
Apr2012
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 put in (double) quotes
special characters are included, some are used to separate columns
numerical data may include commas as decimal point
data ... weiterlesen
7. April 2012Gernot
07
Apr2012
Ursachen für Programmabbruch mit -805 suchenDie 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 Analyse des Fehler unterstützen und Dir mögliche Ursachen aufzeigen.
Vorgehensweise:
Aus dem Text der DSNTIAR-Meldung die voneinander abweichenden Timestamps bzw den Timestamp des Consistency ... weiterlesen
7. April 2012Gernot
07
Apr2012
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 of granularity. The Instrumentation Facility Interface allows application programs to retrieve IFCIDs from DB2. IFCIDs have a complex record format, ... weiterlesen
7. April 2012Gernot
07
Apr2012
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 on TAPE/CASS and keep it for 30 days:
//STEP1 EXEC PGM=ADRDSSU
//SYSPRINT DD SYSOUT=*
//AUS1 DD ... weiterlesen
7. April 2012Gernot
04
Apr2012
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® 10.1 for Linux™, UNIX™, and Windows™ (LUW) reduces your overall database licensing, administration, and storage costs. DB2 10.1 for LUW ... weiterlesen
4. April 2012Gernot
29
Mrz2012
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 DeveloperWorks. It is basically a relaunch and rebranding of ' DB2 zHotline'. As previously received via the DB2 Hotline, it ... weiterlesen
29. März 2012Gernot
15
Mrz2012
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 Ideen können Sie außerhalb der offiziellen Agenda mit den Sprechern im Detail diskutieren und sich so mit den Spezialisten aus ... weiterlesen
15. März 2012Gernot
13
Mrz2012
This perl module contains all functions need by xmp perl scripts, published at www.ruban.de. You should easily adapt some constant values to your pesonal needs.
Some comments are in german. If you need assistence, don't hesitate to contact me.
#!/usr/local/bin/perl -w
################################################################################
# DBA Perl function package:
# - deploy with "use xmpPerl;"
# - execute ... weiterlesen
13. März 2012Gernot
13
Mrz2012
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 when size or age surpasses a threshold value.
Usage: xmpFileClean.pl {-d|-l|-f file|'file*'} [ [-a|-A ext]|[-r] [-c] [-s nnn] [-D nnn] ]
-d=apply ... weiterlesen
13. März 2012Gernot
12
Mrz2012
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 to reduce high watermark and already allocated space. DB2 may itself increase storage of tablespaces whenever needed. This feature is interesting especially for ... weiterlesen
12. März 2012Gernot