ADSM-L

Re: General *SM database/ IP address question

2015-10-04 17:25:43
Subject: Re: General *SM database/ IP address question
From: Andy Raibeck [mailto:Andrew_Raibeck AT TIVOLI DOT COM]
To: ADSM-L AT VM.MARIST DOT EDU
Hi Christo,

Thank you for pointing this out. I stand corrected.   :-)

Please note, though, that the information is not kept permanently, and =
will
expire after the number of days specified by the Activity Summary =
Retention
Period (via SET SUMMARYRETENTION). So it may not be complete.

Best regards,

Andy

Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: andrew.raibeck AT tivoli DOT com
"The only dumb question is the one that goes unasked."


Christo Heu=EBr <christoh AT ABSA.CO DOT ZA>@VM.MARIST.EDU> on 12/19/2000 =
02:31:40

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: General *SM database/ IP address question



Hi Andy, David,

This info is kept in the summary table on Tsm3.7 servers. Here is an
example
of of a select * from summary query: (Note the address field).

START_TIME: 2000-11-20 19:05:55.000000
     END_TIME: 2000-11-20 19:35:38.000000
     ACTIVITY: BACKUP
       NUMBER: 274
       ENTITY: LEGALJHB
     COMMMETH: Tcp/Ip
      ADDRESS: 10.0.8.34:2177
SCHEDULE_NAME:
     EXAMINED: 2977
     AFFECTED: 2977
       FAILED: 0
        BYTES: 638352864
         IDLE: 99
       MEDIAW: 0
    PROCESSES: 1
   SUCCESSFUL: YES

Cheers
Christo

> Actually this info isn't in the NODES table, either. The TSM server
stores
> the IP addresses for nodes using the PROMPTED scheduling mode only, =
so
the
> server knows which address to prompt when it is time to run scheduled
> events. However, the table in which this data resides has not been
> externalized, so it can not be accessed by any QUERY or SELECT =
statement.
>
> Regards,
>
> Andy
>
> Andy Raibeck
> IBM/Tivoli
> Tivoli Storage Manager Client Development
> e-mail: andrew.raibeck AT tivoli DOT com
> "The only dumb question is the one that goes unasked."
>
>
>
> I am sory to correct you, but there is a field in the nodes table =
that
> stores the hex IP address of the client.
>
> Keith Davey
>
>
> On Mon, 18 Dec 2000, Williams, Tim wrote:
>
> >         I don't think that it really 'stores' that information, per =
se.
> >         IT, is however logged in the activity log....
> >         q actlog.....search=3D....etc....  (help q actlog)
> >         hope this helps...
> >
> >
> >
> >
> >         David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
> >         12/18/2000 02:24 PM
> >         Please respond to "ADSM: Dist Stor Manager"
> > <ADSM-L AT VM.MARIST DOT EDU>@SMTP@Exchange
> >         To:     ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
> >         cc:
> >
> >         Subject:        General *SM database/ IP address question
> >
> >         When you register a node name and the node first contacts =
the
*SM
> > Server, the server stores the IP address of the client.  Where is =
this
IP
> > address stored on the server?
> >
> >
> >         David B. Longo
> >         Systems Administrator
> >         Health First, Inc. I/T
> >         3300 Fiske Blvd.
> >         Rockledge, FL 32955-4305
> >         PH      321.434.5536
> >         Pager  321.634.8230
> >         Fax:    321.434.5525
> >         david.longo AT health-first DOT org
> >