REXX to call the IBM DB2-supplied stored procedure ADMIN_INFO_SYSPARM to access DB2 DSNZPARM parameters and writes them an output dataset. This make it easy to archive DB2 subsystem parameters or compare parameter sets of different DB2 subsystems.
See example output at end of page.
/*REXX****************************************************************/
/* DIS2INST ...: Display DB2 for ... weiterlesen
23
Feb2012
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
# ------------------------------------------------------------------------------
# Parameter: inst|db ... weiterlesen
17
Feb2012
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 for z/OS Version 9.
/*REXX****************************************************************/
/* XMPACCOX ..: Retrieve recommendations to help you maintain ... weiterlesen
16
Feb2012
All system z DASD I/O systems base on the IBM DASD device type IBM 3390 Model 3 and are compatible to it. This means that all calculations a DB2 DBA or sysadm can to do are on basis of this type and model characteristics. Quite typical for this DASD model: 12 ... weiterlesen
16
Feb2012
IBM CICS Explorer: Common, intuitive, Eclipse-based environment for architects, developers, administrators, system programmers, and operators. Looking for new ways to accelerate the transfer of knowledge, skills, and best practice to the next generation of technical staff/experts? Need to maintain productivity and protect service-levels? CICS Explorer and System z lead the ... weiterlesen
10
Feb2012
Data Aging Tools are usually instrument of development or test environments to change the age of test data, to make them younger or older. In particular, data are systematically adjusted to a desired point on the timeline concerning their chronology. Those tools has an ultimate high point of interest with ... 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 - Dateiname der ... 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 or higher
# Database - DB2 UDB V5.x or higher, ... weiterlesen
09
Feb2012
Free IBM DB2 ebooks:
Database fundamentals
Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises!
Programming fundamentals
This book is an introduction to programming. It covers basic topics, including the computer structure, algorithms, ... weiterlesen
09
Feb2012
This tiny assembler program may enhance control of your jobs whenever  TWS or JES JCL syntax would be to complex. The program raises an U0001 user abend, which leads to "end of job" - definitively! So, you do not have to COND=(nn,op) or IF statements to your JCL.
D2PABND TITLE 'D2PABND - ... weiterlesen
09
Feb2012
REXX procedure to display DBRM Timestamp:
/* REXX - Display a DBRM TimeStamp in a real date time format. */
/* - format is TSO DBRMTS DSN(MEMBER) (no quotes) */
/* ... weiterlesen
09
Feb2012
This TSO/E REXX procedures reads information from Data Propagator tables, which can be used to control dependent process flow.
The procedure is quite old but still a good sample for querying Data Propagator Control Tables.
/*REXX****************************************************************/
/* APPLYIS....: DPropR Apply V5 Information and Control ... weiterlesen
09
Feb2012
z/OS JCL example for "delete a file, if exists. Doesn't matter if not.
//DELREPT EXEC PGM=IEFBR14
//SYSUT1 DD DSN=MYUSER.TEST,
// DISP=(MOD,DELETE,DELETE),SPACE=(1,0)
//SYSPRINT DD SYSOUT=*
//... next step
