Are there any examples of programs doing DDF accounting in DB2?

Thank you,
DO

Hi,

Can you please be a little bit more specific?

What do you mean by 'DDL accounting'? In DB2 LUW there is no accounting as on
the mainframe. DDL accounting sounds like you want to account for a create
table statement and I doubt that you want to do that.

On 19.01.11 9:58 , Devout Occamist wrote:

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Jan 19, 10:29*pm, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:
This isn't DB2 LUW but DB2 zOS.
DDF is the Distributed Data Facility, a built-in component of DB2 for
z/OS that provides connectivity to and from other databases over the
network; as such, it can act both as a DRDA Application Server and as
a DRDA Application Requester.
DB2 for zOS is very well instrumented and can be enabled to gather all
kinds of system data (accounting, performance, etc.).
These data are normally stored in SMF (zOS System Monitoring
Facility).
SMF-records for DB2 are well-defined (iirc they are SMF-type 100, 101
and 102), and DB2 provides a stand-alone utility-program DSN1SMFP to
transform DB2's SMF-records into nice reports.
What I would like to suggest to OP is to:
- search the DB2-docs for DSN1SMFP
- contact the sysadmins and/or others responsible for Capacity and
Performance management, as they probably already have ways to create
SMF-reports (either home-made or via 3rd party software packages like
MXG, MICS, SAS, ...)

HTH.

--
Jeroen

Sorry, my bad. I read DDL instead of DDF.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/