Omegamon II question

Raymond Bell

Omegamon II question

August 9, 2004 09:52 AM

Colleagues,

This is one for anyone with Omegamon II V520. I'm trying to trace
the
issuing of DSN commands, specifically -STA and -STO commands. I
see
performance class 10 (not an audit class, as I was 1/2 expecting)
captures
'bind, commands, and utilities detail'. The IFCIDs are 90 and 91
for DSN
commands, but that's by the by. What I want is a nice shiny report
that'll
tell me who issued what DSN command when.

Omegamon will show me (via the Command Stats panel) that all sorts
of
commands (25 start database commands, 6 alter bufferpool commands,
etc) have
been issued, but won't show any detail. I've tried starting an
'IFCID Trace
Facility' trace, and it works up to a point. Examining the trace
file, I
can see myself having issued a command of some sort, but I can't
'zoom' into
the results to get any more info. The GUI just shows blank detail
lines,
while the Classic says, 'O21135 APPLICATION TRACE UOW SUMMARY HAS
NOT
LOCATED SUFFICIENT TRACE DATA TO PRODUCE A DISPLAY (ATRCATVC)'.

Omegamon II seems to want to capture trace output to a VSAM LDS,
which makes
browsing the file a bit difficult, but the data seems to be in
there
somewhere. I'm going to wait 'til tomorrow when the SMF records are
cut (I
started a TRACE(PERFM) CLASS(10) DEST(SMF) trace) and see if I
can't extract
the raw data that way, but does anyone know if/how I can get
Omegamon II to
tell me what's going on?

Cheers, and TIA,

Raymond Bell
Database Administrator

This e-mail (and any attachments) may contain privileged and/or
confidential information. If you are not the intended recipient
please do not disclose, copy, distribute, disseminate or take any
action in reliance on it. If you have received this message in
error please reply and tell us and then delete it. Should you wish
to communicate with us by e-mail we cannot guarantee the security
of any data outside our own computer systems. For the protection of
Legal & General's systems and staff, incoming emails will be
automatically scanned.

Any information contained in this message may be subject to
applicable terms and conditions and must not be construed as giving
investment advice within or outside the United Kingdom.

Legal & General Group Plc is a holding company, subsidiary
undertakings of which are fully authorised as appropriate under the
Financial Services and Markets Act in respect of their investment
activities in the UK.

Rich Gugel

Raymond, we had the same issues here. What I did was to start a
trace on
IFCID 90 and 91 and write it to SMF, then on a daily basis I
produce a
report with Omegs historical Reporter, It produces a crude but
usable
report. Here is the control statements.

This is one for anyone with Omegamon II V520. I'm trying to trace
the
issuing of DSN commands, specifically -STA and -STO commands. I
see
performance class 10 (not an audit class, as I was 1/2 expecting)
captures
'bind, commands, and utilities detail'. The IFCIDs are 90 and 91
for DSN
commands, but that's by the by. What I want is a nice shiny report
that'll
tell me who issued what DSN command when.

Omegamon will show me (via the Command Stats panel) that all sorts
of
commands (25 start database commands, 6 alter bufferpool commands,
etc) have
been issued, but won't show any detail. I've tried starting an
'IFCID Trace
Facility' trace, and it works up to a point. Examining the trace
file, I
can see myself having issued a command of some sort, but I can't
'zoom' into
the results to get any more info. The GUI just shows blank detail
lines,
while the Classic says, 'O21135 APPLICATION TRACE UOW SUMMARY HAS
NOT
LOCATED SUFFICIENT TRACE DATA TO PRODUCE A DISPLAY (ATRCATVC)'.

Omegamon II seems to want to capture trace output to a VSAM LDS,
which makes
browsing the file a bit difficult, but the data seems to be in
there
somewhere. I'm going to wait 'til tomorrow when the SMF records are
cut (I
started a TRACE(PERFM) CLASS(10) DEST(SMF) trace) and see if I
can't extract
the raw data that way, but does anyone know if/how I can get
Omegamon II to
tell me what's going on?

Cheers, and TIA,

Raymond Bell
Database Administrator

This e-mail (and any attachments) may contain privileged and/or
confidential
information. If you are not the intended recipient please do not
disclose,
copy, distribute, disseminate or take any action in reliance on it.
If you
have received this message in error please reply and tell us and
then delete
it. Should you wish to communicate with us by e-mail we cannot
guarantee the
security of any data outside our own computer systems. For the
protection of
Legal & General's systems and staff, incoming emails will be
automatically
scanned.

Any information contained in this message may be subject to
applicable terms
and conditions and must not be construed as giving investment
advice within
or outside the United Kingdom.

Legal & General Group Plc is a holding company, subsidiary
undertakings of
which are fully authorised as appropriate under the Financial
Services and
Markets Act in respect of their investment activities in the
UK.

Raymond Bell

You're a genius. Omegamon was really yanking my chain on this. It
would
gather the info, but then play dumb on reporting on it. I could
_see_ the
raw data in the VSAM trace dataset Omegamon wrote but the $odding
thing
wouldn't report on it. Aaargh! Come back DB2PM, all is forgiven.
Anyway,
I waited for the SMF records to be dumped overnight, extracted the
day's
records and ran the O2 report you suggested. Worked just like a
bought one
(i.e. fine, in case you're not familiar with that expression). The
report's
a bit fugly but at least it's readable and the info is there. So
I'm off to
get the perfm class(10) trace started automagically via Zparms.

Thanks again,

Raymond Bell
Database Administrator
PS. Martin, can you guess what BP still has our DGTT database? It's
on the
list of things to do...

Raymond, we had the same issues here. What I did was to start a
trace on
IFCID 90 and 91 and write it to SMF, then on a daily basis I
produce a
report with Omegs historical Reporter, It produces a crude but
usable
report. Here is the control statements.

This is one for anyone with Omegamon II V520. I'm trying to trace
the
issuing of DSN commands, specifically -STA and -STO commands. I
see
performance class 10 (not an audit class, as I was 1/2 expecting)
captures
'bind, commands, and utilities detail'. The IFCIDs are 90 and 91
for DSN
commands, but that's by the by. What I want is a nice shiny report
that'll
tell me who issued what DSN command when.

Omegamon will show me (via the Command Stats panel) that all sorts
of
commands (25 start database commands, 6 alter bufferpool commands,
etc) have
been issued, but won't show any detail. I've tried starting an
'IFCID Trace
Facility' trace, and it works up to a point. Examining the trace
file, I
can see myself having issued a command of some sort, but I can't
'zoom' into
the results to get any more info. The GUI just shows blank detail
lines,
while the Classic says, 'O21135 APPLICATION TRACE UOW SUMMARY HAS
NOT
LOCATED SUFFICIENT TRACE DATA TO PRODUCE A DISPLAY (ATRCATVC)'.

Omegamon II seems to want to capture trace output to a VSAM LDS,
which makes
browsing the file a bit difficult, but the data seems to be in
there
somewhere. I'm going to wait 'til tomorrow when the SMF records are
cut (I
started a TRACE(PERFM) CLASS(10) DEST(SMF) trace) and see if I
can't extract
the raw data that way, but does anyone know if/how I can get
Omegamon II to
tell me what's going on?

Cheers, and TIA,

Raymond Bell
Database Administrator

This e-mail (and any attachments) may contain privileged and/or
confidential
information. If you are not the intended recipient please do not
disclose,
copy, distribute, disseminate or take any action in reliance on it.
If you
have received this message in error please reply and tell us and
then delete
it. Should you wish to communicate with us by e-mail we cannot
guarantee the
security of any data outside our own computer systems. For the
protection of
Legal & General's systems and staff, incoming emails will be
automatically
scanned.

Any information contained in this message may be subject to
applicable terms
and conditions and must not be construed as giving investment
advice within
or outside the United Kingdom.

Legal & General Group Plc is a holding company, subsidiary
undertakings of
which are fully authorised as appropriate under the Financial
Services and
Markets Act in respect of their investment activities in the
UK.