Code, samples, snippets …
oldIFS=$IFS
liste="A B C"
IFS=" "
set -A arr $liste
IFS=$oldIFS
echo ${arr[2]} C
arr[3]="D"
echo ${arr[*]} A B C D
Ergänzungen sind willkommen!
25
Jul2018
07
Feb2018
Gewissenhafte DBA's benennen allle ihre Primary Key und Check Constraints explizit. Damit kann man prima über Entwicklungs-, Test- und Produktions-Umgebungen hinweg, sofern erforderlich, einen Constraint überarbeiten, sprich löschen und geändert ieder aufbauen.
Aber was tun, wenn man keinen Constraint-Namen vergeben hat, ... weiterlesen
20
Mrz2017
Gesucht war eine Möglichkeit, als Berichtszeitraum immer nur von Montag bis Freitag der Vorwoche oder der ablaufenden Woche zu selektieren. Ab Freitag (-nacht), Samstag und Sonntag sollte immer die aktuelle Woche selektiert werden, sonst die Vorwoche.
Beispiel: Am Ender einer Woche ... weiterlesen
28
Sep2015
Graeme Birchall, der Autor der legendären DB2 Cookbooks, hat sich in den Ruhestand begeben und seine Web Site aufgegeben. Graeme hat sich ausdrücklich die kostenfreie Bereitstellung seines Cookbooks gewünscht. Bevor die Dateien in den Weiten des Webs verloren gehen, ... weiterlesen
25
Sep2015
In diesem Beispiel wird von einem Unix/AIX das DB2LOOK Utility über Secondary AuthID an ein DB2 for z/OS Subsystem gebunden.
#!/bin/ksh
################################################################################
# 21.05.2013/GR - Adapted from BindDB2ConnectSecondary to bind DB2LOOK to DB2 z/OS
# 16.09.2015/GR - db2look.bnd, db2lkfun.bnd, db2lksp.bnd not needed for ... weiterlesen
18
Sep2014
Erste Veröffentlichung am 14.12.2012.
19
Aug2014
--------------------------------------------------------------------------------
-- SQL-Table-Index-Metrics.sql - Table/Index metrics since DB2 start/connection
-- DB2 9.7 FP 5 and later
--------------------------------------------------------------------------------
-- Number of INSERT/UPDATE/DELETE/SELECT and Tablescans,
-- overflows and page reorgs since first DB Connection
SELECT *
FROM TABLE(MON_GET_TABLE('','',-2)) AS T
;
-- Number of INDEX_SCANS, INDEX_ONLY_SCANS, KEY_UPDATES.
-- PSEUDO_DELETES, ... weiterlesen
27
Mrz2014
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 this costs you a separate license fee. For a distinct ... weiterlesen
18
Mrz2014
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed:
-- any userid between L0... and F9..., but letters are illegal
SELECT USERID,HEX(USERID)
FROM MY.TABLE_OF_AUTHIDS
WHERE USERID ... weiterlesen
10
Okt2013
The following script references "Perl module xmpPerl.pm – function package used by DBA Perl scripts"
The following very simple script is just a small frame for sending mail via network from command level or as a service for other scripts.
#!/usr/local/bin/perl -w
################################################################################
# ... weiterlesen
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 - ... weiterlesen
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 ... weiterlesen
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 ... weiterlesen
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 ... weiterlesen
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 ... weiterlesen
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 ... weiterlesen
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`; ... weiterlesen
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 ... weiterlesen
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 ... weiterlesen
19
Feb2012
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
# ------------------------------------------------------------------------------
# ... weiterlesen
09
Feb2012
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 ... weiterlesen
09
Feb2012
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.
#!/usr/local/bin/perl -w
################################################################################
# xmpDB2Cfg.pl - DB2 Configuration Parameter Tool
# OS System - AIX 4.3.x or Sun/Solaris 2.6 ... weiterlesen
