FWIW, I have a TSM server on AIX that is still at 4.2.1.15. SELECT * FROM OPTIONS works fine.
But we don't have any library sharing enabled... -----Original Message----- From: Neil Schofield [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:11 AM To: [EMAIL PROTECTED] Subject: Error querying OPTIONS table We've just installed the ITSM Operational Reporting software recently offered as a technology preview and seem to be having a bit of a problem running it against our 4.2.1.15 servers running on Windows. I suspect that the problem is a TSM issue rather than an OR issue. The underlying problem is that a SELECT on the OPTIONS table fails on all our servers. I wondered if anybody else experiences an ANR2956E messsage when doing a 'SELECT * FROM OPTIONS' especially if your TSM server version matches ours. The message is accomapanied by the following message in the activity log: ANR9999D psopts.c(1726): ThreadId<26> Invalid option state in psOPTIONS_Fetch SHAREDLIBIDLE I've seached this site and the IBM support pages but can't find anything similar. Regards Neil Schofield Yorkshire Water Services Ltd. tsm: TSM1>select * from options OPTION_NAME OPTION_VALUE ------------------ ------------------ CommTimeOut 36000 IdleTimeOut 600 BufPoolSize 786432 LogPoolSize 2048 ... ... ... AffinityMask 0x0000 AssistVCRRecovery Yes AdRegister No AdUnRegister No AdSetDC AdComment ANR2956E Unable to access SQL base table 'OPTIONS'. | ..............V...... select * from options ANS8001I Return code 26. tsm: TSM1>q actlog begint=13:32 Date/Time Message -------------------- ---------------------------------------------------------- 17-07-2003 13:32:23 ANR2017I Administrator SCHOFIELDN issued command: select * from options 17-07-2003 13:32:23 ANR9999D psopts.c(1726): ThreadId<26> Invalid option state in psOPTIONS_Fetch SHAREDLIBIDLE 17-07-2003 13:32:23 ANR2956E Unable to access SQL base table 'OPTIONS'. 17-07-2003 13:32:24 ANR2017I Administrator SCHOFIELDN issued command: ROLLBACK 17-07-2003 13:32:30 ANR2017I Administrator SCHOFIELDN issued command: QUERY ACTLOG begint=13:32 tsm: TSM1> Visit our web site to find out about our award winning Cool Schools community campaign at http://www.yorkshirewater.com/yorkshirewater/schools.html The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House Halifax Road Bradford BD6 2SZ Registered in England and Wales No 2366682
