Re: Reported IP inconsistency

TSM does not store the number of processors.  To find this info, you have to go 
to each client machine and use its OS commands for finding number of processors.

David Ehresman

>>> David.Moore AT LA DOT GOV 10/8/2004 11:26:57 AM >>>
Hello List -

I've got zero scripting experience for TSM.  But, we are trying to determine 
the number of processors that are on each of the nodes that we are backing up.  
That info is not available in the WEBGUI drop-downs and I don't know the tables 
and layouts in the database.  Is this information there?  Does anyone have a 
SQL statement to retrieve it using the TSM server?

Thanks in advance.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Daniel Sparrman
Sent: Friday, October 08, 2004 10:04 AM
To: ADSM-L AT VM.MARIST DOT EDU 
Subject: Re: Reported IP inconsistency


Hi Kevin

The URL is a static value, set by the TSM administrator. TSM doesnt change 
this value in the case that the IP-adress of the client changes. Only the 
tcpadress changes on a client change.

You can change the URL value by selecting "Updating node", and then "URL".

The tcpadress value will change as soon as you restart the TSM scheduler 
service. It will then update the entry with the new value.

Best Regards

Daniel Sparrman
-----------------------------------
Daniel Sparrman
Chef Utveckling & Drift
Exist i Stockholm AB
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51



Kevin Kinder <Admin AT WVADMIN DOT GOV> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-10-08 16:56
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU 
cc

Subject
Reported IP inconsistency






I am running the following simple query.  Environment is TSM 5.1.7.0 MVS.

select -
  nodes.node_name as "Node Name",-
  nodes.tcp_address as "IP Address",-
  concat(concat(concat(concat(varchar(nodes.client_version),'.'), -
  concat(varchar(nodes.client_release),'.')), -
  concat(varchar(nodes.client_level),'.')), -
  concat(varchar(nodes.client_sublevel),'')) as "Client Ver", -
  nodes.url as "URL",-
from nodes -
order by nodes.node_name

The nodes.url field returns the values that have been manually entered for 
that node. (These are the correct IP addresses.)  However, in some 
instances, the value returned from nodes.tcp_address are different.  For 
example:

Node Name        IP Address       Client Ver   URL 
 
BRIMSERVER2   10.200.80.38   5.2.0.0      http://10.200.19.133:1581 
FINSERVER2      10.200.13.4     5.2.0.0      http:10.200.71.100:1581

I believe this problem shows up whenever the client node has had its IP 
address changed.  The IP address is the original address of the server. It 
has since been given a new IP address, but for some reason this field 
doesn't change or get updated.  It does not appear to affect the backup 
process, but I'd like to get this corrected.  I can't see how to edit this 
field - any ideas?  Thanks in advance!



-----
Kevin Kinder
304-558-5914  x1988