Re: Query processor fails after disk upgrade.

Steve,

Don't know if this can help, but I had a similar problem
some years ago with a 720 running V4R5: No ODBC, No CA
transfer. I don't remember the STRSQL behavior, though.

Our problem was that an operator canceled a RCLSTG
operation, and the DB cross reference tables were throw out
of sync. We had to remade them again, using a somewhat
convoluted RCLSTG procedure. IIRC RCLSTG *DBXREF wasn't
available them.

Hope this helps,

Luis Rodriguez


--- midrange-l-request@xxxxxxxxxxxx wrote:

message: 1
date: Thu, 14 Feb 2008 11:12:43 -0500
from: "Steve Moland" <steve@xxxxxxxxxxx>
subject: Query processor fails after disk upgrade.

On a 170 I replaced all the drives with larger ones.
V4R5

Everything seemed to be except for a big problem.

ODBC connection from MS SQL has gone away.

CA file upload/download doesn't work ( I don't use this
but I was trying to
access the extent of the damage)

No SQL code inside C or RPG works.

Most stuff inside STRSQL works but has lots of dumps and
messages between
steps

* If I try to run any C or RPG program that has run for
years or try to use
STRSQL , I get this message

Scalar operand contains a value that is not valid.
Internal failure occurred in query processor.
SQL system error.

* When using STRSQL, I can press F4 on the first screen
Select option 30 for SELECT
press F4 on the SELECT screen and I a list of libraries
If I select a library I see a message that 2 dumps are
being done
and the error message about is in the history
<.....>

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping