Re: Query processor fails after disk upgrade.

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

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