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
20
Jun2012
18
Jun2012
DB2 V9.7 for Linux/Unix/Windows supports automatic revalidation of objects which is controlled by the database configuration value AUTO_REVAL. If requested by database administrator, this feature for example revalidates a views which was temporary invalid due to a DROP and re-CREATE of a base table or view. But administrators should play ... 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`; # yyyy-mm-dd-hh.mm.ss
$TS ... weiterlesen
05
Jun2012
DB2 10 for z/OS
System & Application Monitoring and Tuning
Part 1: System Monitoring and Tuning (PDF from FTP server)
Part 2: Application Monitoring and Tuning
and notes (PDF's from FTP server)
IBM Silicon Valley Lab, San Jose, CA
May, 2012
