Re: strange sql system error 901 has cropped up

["SANTOSH PRASAD" <santoshp@xxxxxxxxxxxxxxxxx>]

There was no change in query option file QAQQINI and we have just one copy
of this in QSYS. Nothing is there in QUSRSYS.
There was no PTF application during IPL. I gather that power supply, SMPS
was changed before the IPL.

Following my extreme hue and cry , IBM again IPLed the system yesterday and
since then , that error has gone.
We checked all the logs during the last two IPLs, nothing was abnormal.
I havent known OS/400 behaving like Windows NT
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Santosh.
e- mail at :  santoshp@xxxxxxxxxxxxxxxxx
FPC-IS, ITS, Tata Steel.
Jamshedpur, India.

message: 3
date: Wed, 26 Mar 2003 05:53:29 -0800 (PST)
from: Marco Facchinetti <facchinetti@xxxxxxxxx>
subject: Re: strange sql system error 901 has cropped up

Did you apply PTF during IPL?

--- SANTOSH PRASAD <santoshp@xxxxxxxxxxxxxxxxx> wrote:
>
>
> I have  a curious case.
> We have V4R5 running ok for the past 2 years. All the
> programs were also
> running ok since then.
> 4 days back, an IPL and a complete backup was taken (
> thats a regular
> affair on a monthly basis). Everything was normal during
> the backup and IPL
> procedure.
>
> But few of the SQL statements in a few programs now has
> started failing now
> and then with SQLCODE 901.


__________________________________________________





********************************DISCLAIMER***********************************

Information contained and transmitted by this e-mail is confidential and
proprietary to Tata Steel Ltd. and is intended for use only by the
addressee. If you are not the intended recipient , you are notified that
any dissemination or copying of this e-mail is strictly prohibited and you
are requested to delete this e-mail immediately and notify the originator.
Tata Steel does not enter into any binding agreement with any party by
e-mail. Any views expressed by an individual do not necessarily reflect the
view of Tata Steel. Tata Steel is not responsible for the consequences of
any actions taken on the basis of information provided.
While this e-mail has been checked for all known viruses the addressee
should also scan for viruses.
To know more about Tata Steel please visit www.tatasteel.com
********************************************************************************