Just an FYI  - in a couple of situations including one I came across last
week, a select * from events resulted in an "ANR0102E admsql.c error 1
inserting in table EVENTS.SQL" message that caused the admin session to hang
on this and any subsequent select (whatever) from events. The admin session
will eventually time out. Many reporting environments (including ITM - TSM
Reporting in 6.1) rely on select (something) from events and will hang if
this problem is encountered. It appears that the error is caused by a TSM
administrator having removed nodes. We ended up setting eventretention to 0
days and re-registering the nodes, and then removing them again, then
rebooting the server and had our problem cleared so that we were able to
select (something) from events and had our reporting operational again. I do
not know if this is a real work-around of this problem or if we were just
lucky and TSM 6.1.2.0 healed itself. You might want to be careful about
removing nodes, especially those that were recently active.



Joerg Pohlmann

250-245-9863