Hi Otto, we have got the same problem over here, and the only difference in the nodes I got info from and those I can't find is the level of the TSM clients. I know this was a problem in some client versions and should be solved in versien 5.1 and up.
Gr. Oscar Kolsteren Netherlands -----Original Message----- From: Otto Schakenbos [mailto:[EMAIL PROTECTED] Sent: dinsdag 12 augustus 2003 12:01 To: [EMAIL PROTECTED] Subject: update sql query I played around a bit more and found out when issuing a "select * from summary" i still don't get my nodes. (see org story below) So i'm pretty sure now it is not a sql problem but a db problem. But in the actlog i don't find any errors after a node has finished its backup. Anybody able to give a pointer in the right direction. thnx ORG: we have a tsm server 5.1.5.4 on aix 4.3. Every day we run a sql query with the following statement select ENTITY as Node_Name, ACTIVITY, BYTES as Bytes_Transferred, START_TIME, END_TIME, IDLE as Idle_in_Sec, MEDIAW as meddia_wait_in_sec, PROCESSES, AFFECTED as Files_backup, FAILED, EXAMINED as All from summary where start_time>timestamp(current date -1 day, '12:20:00' )and bytes>0 Resulting in an overview of the transferred bytes per day per node. (clients, db backup, migrations, stgp backup) This has been running since about 6 months without any problem but since last sunday a weird thing is happening. The result from the query now only shows migrations, db backup and storagepool backup. The client nodes itself have gone from the result. Since the script didn't change, the clients nodes are still backing up as normally. I suspect that a value the clients generate after finishing a backup is not written to the db anymore. Then when the sql scripts runs it doesn't get the clients in the result because this valua is not there. things i have tried so far: Checked if the clients are backing up properly, they are. ( in the act log then it is), all other things run fine as well, like space recl, stgp backup etc etc. We also run a script that only looks how long a client has been backing up, is also still working correct and listing the client nodes as ussual. Checked if someone changed something on the day it started, nothing has changed on the tsm side of things. When i run the sql statement over a longer period also covering a day or 2 before things went funny the clients show up in this period until things went funny (till 11pm that day), so the sql statement appears to be ok. Taking away the bytes>0 , no luck. (accept i could see the tapemounts now as well.) I'm a bit low on idea's now so if someone has any hints where to look for it would be great. mvg -- Otto Schakenbos PC-Support TEL: +49-7151/502 8468 FAX: +49-7151/502 8489 MOBILE: +49-172/7102715 E-MAIL: [EMAIL PROTECTED] TFX IT-Service AG Fronackerstrasse 33-35 71332 Waiblingen GERMANY ----------------------------------------------------------------- ATTENTION: The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it. Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them. -----------------------------------------------------------------
