Re: SQL Execution Error

Go to the ptf groups and look at the DB2 group. Many SQL fixes in there.

not on a cume.
Beyond this, I would call support.
jim franz

To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
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=nas3cce6ff4bdedaddc786256f19005820a1

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