Code

Code, samples, snippets …

Playground game.

07

Feb2018
Constraint umbenennen – mit Hilfe einer SQL Stored Procedure
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows
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
7. Februar 2018Gernot

14

Sep2017
Mit awk Output aus “db2 list applications” aufbereiten
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows
Hi folks, db2pd -alldbs -apinfo liefert ja wirklich schon allerhand nützliche Informationen, die sich aber leider nur schlecht automatisiert weiterverarbeiten lassen. Klar, es gibt zahlreiche Table Functions, Stored Procs und anderes Gedöns, das aber leider einen Connect an die Datenbank(en) erforderlich macht. ... weiterlesen
14. September 2017Gernot
help-hint

20

Mrz2017
SQL Selektion: Immer nur montags bis freitags
von Gernot / code for Linux/Unix/Windows, code for z/OS
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
20. März 2017Gernot
sushi-789820_640

28

Sep2015
Graeme Birchall’s DB2 Cookbook Archiv
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows
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
28. September 2015Gernot
DB2 z/OS DDF

25

Sep2015
BIND db2look Utility an ein DB2 z/OS Subsystem (Unix)
von Gernot / code for Linux/Unix/Windows, code for z/OS, DB2 for Linux/Unix/Windows, DB2 for z/OS, z/OS
In diesem Beispiel wird von einem Unix/AIX das DB2LOOK Utility über Secondary AuthID an ein DB2 for z/OS Subsystem gebunden. [crayon-5b2cbbb6dab1e807019472/] Bei einem BIND an DB2 for z/OS sind die anderen .bnd-Files unerheblich - sie werden nur für DB2 Unix oder DB2 ... weiterlesen
25. September 2015Gernot

18

Sep2014
Perl Script xmpBkp.pl – DB2 Backup, Restore, List Backup and Backup Script Creation
von Gernot / code for Linux/Unix/Windows
Erste Veröffentlichung am 14.12.2012.
18. September 2014Gernot

19

Aug2014
SQL-Table-Index-Metrics.sql
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows
-------------------------------------------------------------------------------- -- 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
19. August 2014Gernot

27

Mrz2014
Loading DB2 z/OS data into DB2 LUW in internal format
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows, DB2 for z/OS, z/OS
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
27. März 2014Gernot

18

Mrz2014
SQL playing with user id’s
von Gernot / code for Linux/Unix/Windows, code for z/OS, DB2 for Linux/Unix/Windows, DB2 for z/OS
Does your application has to check cerrtain authorzation id's for certain access rights needed? Following SQL shows some ways how to proceed: [crayon-5b2cbbb6dee3c603497628/] In this sample the SQL's have to check incoming userid's for having .. L0nnnnnn or F0nnnnnn where n=0-9 except first letter should ... weiterlesen
18. März 2014Gernot

10

Okt2013
Shell xmpMail.pl to send mails via sendmail
von Gernot / code for Linux/Unix/Windows, miscellaneous
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. [crayon-5b2cbbb6df674504976061/] For more ... weiterlesen
10. Oktober 2013Gernot

30

Mrz2013
Shell script xmpDB2All.sh to execute commands at all DB2 instances
von Gernot / code for Linux/Unix/Windows
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 [crayon-5b2cbbb6e0071224779784/] (Some comments are ... weiterlesen
30. März 2013Gernot

30

Mrz2013
Starting and stopping an CLI and JDBC trace in a shell environment
von Gernot / code for Linux/Unix/Windows
  [crayon-5b2cbbb6e0a00644514222/]   [crayon-5b2cbbb6e0a08231504469/]  
30. März 2013Gernot

07

Feb2013
Perl Script xmpTBSCStmt.pl to generate useful tablespace statements
von Gernot / code for Linux/Unix/Windows
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
7. Februar 2013Gernot
Perl development

29

Sep2012
Perl Script xmpTerm.pl to list or terminate DB2 connections
von Gernot / code for Linux/Unix/Windows
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
29. September 2012Gernot

15

Aug2012
How to retrieve JCC version
von Gernot / code for Linux/Unix/Windows, DB2 for Linux/Unix/Windows, miscellaneous
You need to check the version of your Java Combined Client (JCC) installed? Try this way: [crayon-5b2cbbb6e4357132213325/] All DB2 JDBC Driver versions, see here! More information on DB2, Java, JDBC and JCC.
15. August 2012Gernot

20

Jun2012
Perl Script xmpPerlDB2Test.pl to verify DBI and DBD::DB2 installation
von Gernot / code for Linux/Unix/Windows
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. [crayon-5b2cbbb6e4b99009094629/]
20. Juni 2012Gernot

18

Jun2012
Perl statements to generate (DB2) timestamp
von Gernot / code for Linux/Unix/Windows
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: [crayon-5b2cbbb6e53e6796222064/] Or try following Perl statements which are compatible to POSIX and are portable to other platforms: [crayon-5b2cbbb6e53ed333469469/]
18. Juni 2012Gernot

13

Mrz2012
Perl module xmpPerl.pm – function package used by DBA Perl scripts
von Gernot / code for Linux/Unix/Windows
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. [crayon-5b2cbbb6e5fb1104424614/]
13. März 2012Gernot

13

Mrz2012
Perl Script xmpFileClean.pl to archive, remove, compress files
von Gernot / code for Linux/Unix/Windows
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. [crayon-5b2cbbb6e6dd1268032851/] -d=apply on db2diag.log ... weiterlesen
13. März 2012Gernot

19

Feb2012
Shell Script xmpSetInstance.sh – set DB2 environment
von Gernot / code for Linux/Unix/Windows
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. [crayon-5b2cbbb6e796f641034821/]
19. Februar 2012Gernot

09

Feb2012
Shell Script xmpDB2Util – Frame for DB2 utilities which connect to database
von Gernot / code for Linux/Unix/Windows
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.  [crayon-5b2cbbb6e85b9092427357/]
9. Februar 2012Gernot

09

Feb2012
Perl script xmpDB2Cfg.pl – DB2 Configuration Parameter Tool
von Gernot / code for Linux/Unix/Windows
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. [crayon-5b2cbbb6e9377125788117/]
9. Februar 2012Gernot