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 >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Daniel Sparrman Sent: Friday, October 08, 2004 10:04 AM To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-10-08 16:56 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] 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
