RE: SQL System Error -- MIDRANGE-L

Have you worked with IBM's Partner in Education program? You might be
able to find a Business Partner who would do the install for free.
Darn...I was just in Madison a couple of weeks ago for the Linkin Park
concert...I could have dropped by, did the install, and bill the whole
trip as a business expense. :)

On Tue, 17 Feb 2004 11:14:24 -0600, "Orsburn, Glen O" <orsburn@xxxxxxxx>
said:
> Everyone -- I've been off to class.  We have V5R2 for over 6 months --
> trouble is money or having someone to install.  Administratively we
> don't have anyone over looking this machine.  I might attempt the
> reclaim storage & updating PTF level.
> 
> Glen
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of pnelson@xxxxxxxxxx
> Sent: Tuesday, February 17, 2004 9:35 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL System Error
> 
> 
> You should be at least at Cumulative PTF level TL03175. Do you still
> have 
> an agreement in place with IBM? You need to order PTF's, both cumulative
> 
> and group HIPER's.
> 
> IIRC, WRKPTFGRP came along with V5R2. 
> 
> 
> Paul Nelson
> Arbor Solutions, Inc.
> 708-670-6978  Cell
> pnelson@xxxxxxxxxx
> 
> 
> 
> 
> 
> "Orsburn, Glen O" <orsburn@xxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 02/17/2004 09:05 AM
> Please respond to Midrange Systems Technical Discussion
> 
>  
>         To:     "Midrange Systems Technical Discussion"
> <midrange-l@xxxxxxxxxxxx>
>         cc: 
>         Subject:        RE: SQL System Error
> 
> 
> OS Release is: V5R1M0 L00
> 
> First PTF is: TL01163  Permanently applied
> 
> The command WRKPTFGRP doesn't work.
> 
> Glen
> 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Tuesday, February 17, 2004 8:58 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: SQL System Error
> 
> 
> The disconcerting message is MCH1668.
> 
> Going to http://www-912.ibm.com/n_dir/nas4apar.nsf/$$Search?openform
> and searching for MSGMCH1668 gets a lot of hits.  Searching for
> MSGSQL0901 
> also gets a lot of hits.  But nothing in combo.
> 
> DSPPTF
> At the top, what is your OS release?
> What is the first ptf, example TL03364?
> 
> WRKPTFGRP
> What do you have there?
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> "Orsburn, Glen O" <orsburn@xxxxxxxx> 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 02/17/2004 09:35 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx> cc
> 
> Fax to
> 
> Subject
> SQL System Error
> 
> 
> 
> 
> 
> 
> Any suggests or help on this one would be appreciated:
> 
> When we run subquery interactively in SQL this is the error: (if I
> should run each Select statement by it self no error occurs)
> 
>  <<Picture (Metafile)>> SELECT customer_num, customer_name 
>   FROM premiere/customer 
> WHERE customer_num in (select customer_num from premiere/orders where
>                                  order_date = '10/20/2003')
> 
> I'm getting the following error when we run a interactive SQL statement
> above:
> 
> Message ID . . . . . . :   SQL0901       Severity . . . . . . . :   50
> Message type . . . . . :   Diagnostic
> 
> Message . . . . :   SQL system error.
> Cause . . . . . :   An SQL system error has occurred.  The current SQL
>   statement cannot be completed successfully.  The error will not
> prevent
>   other SQL statements from being processed. Previous messages may
> indicate
>   that there is a problem with the SQL statement and SQL did not
> correctly
>   diagnose the error. The previous message identifier was CPF4204.
> Internal
>   error type 3109 has occurred. If precompiling, processing will not
> continue
>   beyond this statement.
> 
> 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.
> 
> 
> Glen 
> FVTC Instructor
> 
> 
> "Give a man a fish and he'll eat for a day. Teach a man to fish and
> he'll eat for a lifetime.".
> 
> 
> _______________________________________________
> 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.
> 
> 
> 
> _______________________________________________
> 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.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - Consolidate POP email and Hotmail in one place