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 letter. While every effort is made to provide accurate information, ... weiterlesen
Gernot
30
Mrz2013
Do you need to execute one ore more commands at all of your DB2 instances? Then you should deploy xmpDB2all.sh!
This script ...
locates all DB2 instances using profiles.reg (DB2 9.1) or global.reg (9.7 or later)
executes commands passed as arguments
#!/bin/ksh
################################################################################
# xmpDB2All.sh - DB2 Command an allen DB2 Instanzen eines Systems ausführen
# ------------------------------------------------------------------------------
# ... weiterlesen
30. März 2013Gernot
30
Mrz2013
######################################################################
# DB2CJTrace-Start.sh
######################################################################
clear
echo "Start DB2 CLI+JDBC Trace ..........."
echo "- enter path to trace file: (e.g. /db2inst1/db2/db2diag/$DB2INSTANCE)"
read tfp
datestr=`date +%Y-%m-%d-%H.%M.%S`
CLIFile=$tfp/CLI-Trace-$datestr.txt
JDBCFile=$tfp/JDBC-Trace-$datestr.txt
echo "* CLI Trace File : $CLIFile"
echo "* JDBC Trace File: $JDBCFile"
#
db2 UPDATE CLI CFG FOR SECTION COMMON USING TracePathName NULL
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceFileName $CLIFile
db2 UPDATE CLI CFG FOR ... weiterlesen
30. März 2013Gernot
11
Mrz2013
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 separately in a file called the Activation key.
The Activation key ... weiterlesen
11. März 2013Gernot
11
Mrz2013
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 customers can use this new DB2 capability to ... weiterlesen
11. März 2013Gernot
11
Mrz2013
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 database manager and the database parameterization as well as for ... weiterlesen
11. März 2013Gernot
11
Mrz2013
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 bit Install - ibm_ds320_lin_im64.zip (1500 MB)
IBM Data Studio client Windows Install - ibm_ds320_win.zip (1500 MB)
11. März 2013Gernot
11
Mrz2013
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 of statistics (RUNSTATS).
This version covers DB2 10 for z/OS.
For more information about DSNACCOX click here.
/*REXX****************************************************************/
/* XMPACCOX ..: Retrieve ... weiterlesen
11. März 2013Gernot
07
Feb2013
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
7. Februar 2013Gernot
07
Feb2013
xmpTBSCStmt.pl 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 ALTER TABLESPACE statements to reduce tablespace size and/or to lower the high water mark. Action depends on type of tablespace: Automatic storage, ... weiterlesen
7. Februar 2013Gernot
25
Dez2012
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 IBM DB2 Newsletter Archiv!
25. Dezember 2012Gernot
13
Dez2012
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 supporter of db2top.
Follow the link to IBM survey:Â https://www.ibm.com/survey/oid/wsb.dll/s/ag4b4
13. Dezember 2012Gernot
03
Dez2012
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 geht’s zum IBM DB2 Newsletter Archiv!
3. Dezember 2012Gernot
18
Nov2012
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, and if requested by the user, loads it into storage by issuing the DB2 command -SET SYSPARM command with the LOAD option. ... weiterlesen
18. November 2012Gernot
04
Okt2012
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 and performance improvements for certain online transaction processing (OLTP), heavy ... weiterlesen
4. Oktober 2012Gernot
04
Okt2012
-- V8:
SELECT GETVARIABLE('SYSIBM.DATA_SHARING_GROUP_NAME'),
GETVARIABLE('SYSIBM.PACKAGE_NAME'),
GETVARIABLE('SYSIBM.PACKAGE_SCHEMA'),
GETVARIABLE('SYSIBM.PACKAGE_VERSION'),
GETVARIABLE('SYSIBM.PLAN_NAME'),
GETVARIABLE('SYSIBM.SECLABEL'),
... weiterlesen
4. Oktober 2012Gernot
01
Okt2012
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 Archiv!
1. Oktober 2012Gernot
29
Sep2012
xmpTerm.pl 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 only those connected to a specified database, or a specific thread id
Options supported:
-l: (deflt. option) display all threads
-d {dbname|*}: display ... weiterlesen
29. September 2012Gernot
19
Sep2012
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 this book is to help customers plan their migration strategy effectively and efficiently by providing the right information, facts, and guidance. The knowledge you’ll ... weiterlesen
19. September 2012Gernot
19
Sep2012
This book is for database administrators and application developers who are considering DB2 10 for a new installation, an upgrade from a previous version of DB2, or a migration from a vendor product. It explains key features and illustrates concepts with real-world examples to provide a clear idea of how ... weiterlesen
19. September 2012Gernot
12
Sep2012
IBM's BI/ERP Solutions Center has just updated the whitepaper "Tuning SAP with DB2 on IBM AIX":
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 typical problems and processes used ... weiterlesen
12. September 2012Gernot
15
Aug2012
You need to check the version of your Java Combined Client (JCC) installed? Try this way:
// The following command will retrieve the JCC driver version if executed from the command line:
java com.ibm.db2.jcc.DB2Jcc -version
//Or for drivers that are not yet installed:
java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version
//Content of db2jcc ... weiterlesen
15. August 2012Gernot
09
Aug2012
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 (Optimization Service Center) does not support DB2 ... weiterlesen
9. August 2012Gernot
30
Jul2012
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 typical problems and processes used to analyze them.
Tuning SAP® with DB2® on AIX®
by Mark Gordon, version 1.3, revised June ... weiterlesen
30. Juli 2012Gernot
15
Jul2012
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 for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has ... weiterlesen
15. Juli 2012Gernot