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

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

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

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

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

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

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 DB2 instance. #!/bin/ksh ################################################################################ # xmpSetInstance.sh - set DB2 environment # ------------------------------------------------------------------------------ # Parameter: inst|db ... weiterlesen

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.  #!/bin/ksh ################################################################################ # xmpDB2Util - Frame for DB2 utilities which connect to database # ------------------------------------------------------------------------------ # Parameter: DML - Dateiname der ... weiterlesen