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
Archiv: März, 2013
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)
function ... weiterlesen
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