Re: how to keep an eye on extents
Neil Truby said: > "sumGirl" <emebohw@netscape.net> wrote in message > news:a5e13cff.0407071258.38eb00e3@posting.google.com... >> Hey all. Anyone have a good query that will list by table the number >> of extents that table is using and the number of extents left to it >> before error? > > I use this. We've adapted it from an original written by Lester Knutsen. > > --Script: tabextent.sql > > select n.dbsname[1,20], > n.tabname[1,20], > count(*) num_of_extents, > sum( pe_size) total_size > from sysmaster:systabnames n, sysmaster:sysptnext p, systables t > where n.partnum = p.pe_partnum > and n.partnum = t.partnum > and t.tabtype = "T" > group by 1,2 > order by 3 desc , 4 desc; > > The algorithim for the maximum number is somewhat arcane I'm afraid. What's an "algorithim"? Do you perchance mean "algorithm"? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:ccj17d$uh2$1@news.xmission.com... > > > Neil Truby said: > > "sumGirl" <emebohw@netscape.net> wrote in message > > The algorithim for the maximum number is somewhat arcane I'm afraid. > > What's an "algorithim"? Do you perchance mean "algorithm"? What are you, Captain Pednatic's cockpuppet, or whatever the phrase is?
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:2l4s3gF87348U1@uni-berlin.de... > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:ccj17d$uh2$1@news.xmission.com... > > > > > > Neil Truby said: > > > "sumGirl" <emebohw@netscape.net> wrote in message > > > The algorithim for the maximum number is somewhat arcane I'm afraid. > > > > What's an "algorithim"? Do you perchance mean "algorithm"? > > What are you, Captain Pednatic's cockpuppet, or whatever the phrase is? Pedantic.
Thanks all. I'm from Alabama and so wouldnt have noticed you spelled it wrong anyway!