RE: SQL System Error

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Glen,

Just to rule out that ORDERS file is (not) truly damaged, why don't you try
some commands against it, like SAVOBJ (probably the best test), CRTDUPOBJ,
CPYF etc.
Also, try running some queries in interactive SQL (i.e. SELECT * FROM ORDERS
etc.) to see if you'll run into the same error.

If all of this works, then you would be correct to pursue the elusive PTF
path.  If you can't find the correct PTF you're best off contacting IBM and
giving them the dump file listed in the message below.

Elvis

-----Original Message-----
 When I dig in a little deeper it has the following message:

System object ORDERS    ORDERS partially damaged. Internal dump ID .
Error
  class 0, device number X'0000'.
Internal failure occurred in query processor.
File QAP0ZDMP created in library QTEMP.
Member QP0Z110085 added to file QAP0ZDMP in QTEMP.
User Trace data for job 110085/GOSQL225/QPADEV000D dumped to member
  QP0Z110085 in file QAP0ZDMP in library QTEMP.
27 records copied from member QP0Z110085.
1 User Trace buffer(s) deleted.
SQL system error.