ADSM-L

Re: Error querying OPTIONS table

2003-07-18 15:30:33
Subject: Re: Error querying OPTIONS table
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 18 Jul 2003 15:29:58 -0400
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:neil.schofield AT YORKSHIREWATER.CO DOT UK]
Sent: Thursday, July 17, 2003 9:11 AM
To: ADSM-L AT VM.MARIST DOT EDU
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

<Prev in Thread] Current Thread [Next in Thread>