Richard,
An initial test shows that the commands return data only for active
sessions. Is this maintained historically anywhere? Also, how can I
determine which "Producer" process the various "Consumer" processes are tied
to?
Thanks
Aravind

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Monday, October 30, 2006 2:50 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Sessions in Actlog

On Oct 30, 2006, at 8:02 AM, Aravind Kurapati wrote:

> Is there any way to query the relationship between Session numbers
> in actlog
> and a TSM job? It is quite common to find multiple sessions for the
> same job

Aravind -

There's no ready way that I know of to relate the Producer and
Consumer sessions resulting from RESOURceutilization > 1.  The
Producer, being the session in charge, will show a start time (in
'select * from sessions') which is as early or earliest of any
session for that node, and will typically show a LAST_VERB of Ping,
rather than BackInsNormEnhanced or the like.  In 'SHow SESSions'
output, the Producer will show SessType=5 for a scheduled process,
with its Consumer "children" being SessType=4; and the Producer will
not transfer data, so its Backup and Archive object count will be
zero.  (But, in a manual 'dsmc', the sessions will all be
SessType=4.)  You will also see these session type numbers in the
dsmaccnt.log records.  So, to the best of my knowledge, this is all a
matter of discerning, rather than readily determining.

    Richard Sims