Re: SQL Execution Error

[vhamberg@xxxxxxxxxxx]

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. 
>