Error querying OPTIONS table
2003-07-17 09:14:51
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Error querying OPTIONS table,
Neil Schofield <=
|
|
|