Re: SQL Execution Error

I am working with our admin to get it fixed, he is calling IBM.

Yes, it is disturbing my project for the CFO. Pretty important to get this
working then. ;-)

On 5/2/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

I'm with Jim all the way on this - get the latest group for DB2, because
IBM will ask you to do that first - I mean, the message is talking about the
low-level stuff like SLIC and DBOP - the latter is the database optimizer
code that is in the new SQL engine.

So find out who is in charge at your company of getting you set up to
submit problem reports to IBM and to be able to call support - there are
ways to do this on the Internet that are very nice. You are paying for the
support (I hope you are getting software support <g>) and IBM is really
superb about this stuff.

Also, you might be able to ignore it - is it stopping anything? Let it be
- if you don't need to disrupt things, you can wait. But get the group PTFs
on - they are NOT part of the CUME - and get in touch with IBM - it's their
software, right?  ;-)

Good luck!
Vern

-------------- Original message --------------
From: "Jim Franz" <franz400@xxxxxxxxxxxx>

> Go to the ptf groups and look at the DB2 group. Many SQL fixes in there.
> One of the columns in the list of ptfs shows the cume it's on, and a
1000
> means
> not on a cume.
> Beyond this, I would call support.
> jim franz
>
> ----- Original Message -----
> From: "Mike the Code Monkey"
> To: "Midrange Systems Technical Discussion"
> Sent: Tuesday, May 02, 2006 11:28 AM
> Subject: SQL Execution Error
>
>
> > Okay here is a challenge for ya. When running an SQL statement, I get
the
> > following error "SQL system error." Looking into the job log, I get
this:
> >
> > strsql
> > Function error X'1720' in machine instruction. Internal dump
identifier
> > (ID) .
> > Ownership of object DBOPTRC141 in QTEMP type *FILE changed.
> > File DBOPTRC141 created in library QTEMP.
> > Object DBOPTRC141 in QTEMP type *FILE deleted.
> > *** DBOP open FAILED. Exception from call to SLIC! ***.
> > Internal failure occurred in query processor.
> > Environment prevented creation of one or more SQL service dump spooled
> > files. Reason code 1.
> > SQL system error.
> >
> >
> > Doing a bit of digging someone thought a PTF was needed, but they
didn't
> > know what PTF. From what I know, we have the latest CUMEs installed.
Might
> > this PTF be missing?
> >
>
http://www-1.ibm.com/support/docview.wss?uid=nas3cce6ff4bdedaddc786256f19005820a
> 1
> >
> > --
> > Mike Wills
> > koldark@xxxxxxxxx
> > http://theriverbendpodcast.com
> >
> > Errors have occurred.
> > We won't tell you where or why.
> > Lazy programmers.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
Mike Wills
koldark@xxxxxxxxx
http://theriverbendpodcast.com

Code Monkey like Fritos
Code Monkey like Tab and Mountain Dew
Code Monkey very simple man
- Johnathan Coulton - Code Monkey