• Subject: Re:CPU at 100%
  • From: Eric Sundell PMI <ESundell@xxxxxxxxxxxxx>
  • Date: Tue, 25 Jan 2000 11:57:00 -0800

Subject:    CPU at 100%
Author: "Jim Langston" [SMTP:jlangston@conexfreight.com]
Date:       01/25/1900 4:05 PM

9406-500 V3R7M0

Yesterday around 2:30 our system did something unexpected.
Our system stopped responding to requests, and looking at the
CPU indicator, it was at 100%  Within about 25 minutes I got
one response on my session, then it "locked up" again.  I could
not get anywhere to find out what was going on, I couldn't even
log onto the console, as it normally logs onto QINTER unless 
we ENDSBS *ALL *IMMED then it switches to QCTL.

____________________Reply Separator____________________

We had our F70 do this twice, the first time a RPG program went nusts and
started to produce a report in QSPL, it bombed before it finished so it left
huge member in QSPL but no output, the second time a new guy ran a query off
of our bigest files and dumped it to a new file. Both of these had no real
warnings in DSPLOG and I found them with a little program that I wrote to
the largest objects on the system, here it is if you need it:

CHGJOB     LOG(4 00 *SECLVL) LOGCLPGM(*YES)               
             DETAIL(*FULL) OUTPUT(*OUTFILE) +             
RUNQRY     QRY(MYLIB/QRYOBJSIZE)                           
           QRYFILE((MYLIB/OBJSIZE))                       +

        And The Query:

        Selected files

  ID     File           Library       Member        Record Format

  T01    OBJSIZE        MYLIB         *FIRST        QLIDOBJD

Select record tests

  AND/OR   Field             Test     Value (Field, Numbers, or
           ODOBSZ            GE       1000000

Ordering of selected fields

  Field           Sort      Ascending/  Break  Field

  Name            Priority  Descending  Level  Text

  ODLBNM          10        A           1      Library

  ODOBNM          40        A                  Object

  ODOBTP          20        A                  Object type

  ODOBAT                                       Object attribute

  ODOBSZ          30        D                  Object size

  ODOBTX                                       Text description

Report column formatting and summary functions

  Summary functions:  1-Total, 2-Average, 3-Minimum, 4-Maximum, 5-Count

  Field           Summary    Column                                Dec  Null

  Name            Functions  Spacing  Column Headings         Len  Pos  Cap

  ODLBNM                     4        LIBRARY                  10


  ODOBNM                     4        OBJECT                   10


  ODOBTP                     4        Object                    8


  ODOBAT                     4         OBJECT                  10


  ODOBSZ          1          4        OBJECT                   10    0


  ODOBTX                     4                                 50


You can format it with what you want, works good for cleanup too,hope it
good luck

"It's a little known fact that the Dark Ages were caused by unresolved Y1K
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].