[ My apologies for sending this to the DBI related lists; this will
be my only message on this subject. ]
In the last three years, we have developed a perl interface to the DB2
Administrative API, i.e. to the various non-SQL administrative
functions. We use this for DB2 administration, monitoring and change
management. (More details below.) We are now preparing a release of
this module on CPAN; I am looking for people who can help test this
module and work out some errors before the module first hits CPAN.
If you want to help test, you will need:
- A DB2 server instance on Linux, Unix or Windows
(any release from 7.2 through 9.5);
- The DB2 development environment (i.e. DB2 header files);
- Administrative permissions on a DB2 server;
- The ability to compile and test perl XS modules and resolve
compile/link issues.
I have only compiled and tested on Linux and Solaris, and the module
makefile will require (hopefully simple) adjustments for other platforms.
If you're interested, please contact me directly, off the DBI lists.
-----
From the module README:
This module provides access to the administrative functions of DB2 for
Linux, Unix and Windows. The administrative functions are those
functions not accessible through SQL, which normally require use of
the DB2 command line processor (the "db2" command). IBM has been
making some of these available through administrative views and the
SYSPROC.ADMIN_CMD stored procedure.
Using these functions from perl is faster and can provide more
detailed results than the command-line processor. For example, when
reading configuration parameters, the administrative API will not just
tell you which values are set to "automatic", but also which options
support the "automatic" setting. In a similar manner, when loading
data into a DPF database, the API returns detailed information for
each node and agent, allowing far more fine-grained error handling.
The DB2 administrative function module provides the following
functionality:
* Monitoring: get snapshot information and read event monitor files
* Bulk data transfer: export, import, load
* Configuration: get/set instance and database level configuration
parameters
* Directory: read or modify the database, node and DCS directory
* Utilities: force applications, runstats, rebind, list history, list
utilities
