RE: sysmaster database
Hola Dario,
creo que tu scrip functiona muy bien pero solamente con tablas qui no son
fragmentas. Para que tu scrip functiona para todas las tablas creo que hay
que utilisar tambien la tabla sysmaster:sysfragments.
Mira a este tabla e di me si tengo rason o no !!
gracias.
>From: "Yossen, Dario" <dyossen@apsf.com.ar>
>To: 'samir BADAOUI' <samir_badaoui@hotmail.com>, jkohm@trusted.net
>CC: informix-list@iiug.org
>Subject: RE: sysmaster database
>Date: Tue, 3 Aug 1999 17:55:40 -0300
>
>#!/bin/sh
>#--------------------------------------------------------------
># PROGRAMA: este scrip es utilizado para hacer un DISPLAY de
># la cantidad de paginas alocadas, usadas y libres para una tabla
>#--------------------------------------------------------------
># AUTOR: Yossen Dario Fecha: 27/07/1999
>#--------------------------------------------------------------
>#
>
>clear
>echo "\\n\\n"
>echo "\\tProceso que muestra informacion de un Tabla"
>echo "\\n"
>if [ $# -eq 1 ]
> then
> tabla=$1
>fi
>
>until [ ${tabla} ]
>do
> read tabla?"Ingrese el Nombre de la TABLA a Analizar: "
>done
>
>dbaccess sysmaster 2>/dev/null <<EOF
>select a.dbsname Base,
> a.tabname Tabla,
> b.ti_fextsiz ,
> b.ti_nextsiz,
> b.ti_nextns Extent,
> b.ti_nptotal Total,
> b.ti_npused Usadas,
> b.ti_npdata Datos,
> (b.ti_nptotal-b.ti_npused) Libres,
> b.ti_nrows Filas
> from systabnames a,systabinfo b
>where a.partnum = b.ti_partnum
>and a.tabname = '${tabla}'
>EOF
>
>
>A.U.S. Dar'o J. Yossen
>Administraci'n de Bases de Datos
>Dpto. Tecnolog'a - Gcia. de Sistemas
>Aguas Provinciales de Santa Fe
>Tel: 54 - 342 - 4504110
>E-Mail: dyossen@apsf.com.ar
>
>
> > -----Mensaje original-----
> > De: samir BADAOUI [SMTP:samir_badaoui@hotmail.com]
> > Enviado el: Martes 3 de Agosto de 1999 14:27
> > Para: jkohm@trusted.net
> > CC: informix-list@iiug.org
> > Asunto: RE: sysmaster database
> >
> >
> >
> > ok Jamie,
> > I have taked a look in the sysmaster database and I have foun that table
> > (systabinfo). But I have found a other thing that can help :
> > the systabinfo is a view of table sysptnhdr so I think it's mutch
>better to
> > query that table (sysptnhdr). What do you think ?
> >
> > >From: Jamie Kohm <jkohm@trusted.net>
> > >To: "'samir BADAOUI'" <samir_badaoui@hotmail.com>
> > >CC: "'informix-list@iiug.org'" <informix-list@iiug.org>
> > >Subject: RE: sysmaster database
> > >Date: Tue, 3 Aug 1999 12:51:52 -0400
> > >
> > >Samir,
> > >
> > >The table is systabinfo. I query this table often to get the available
> > >space for a table. I've never had trouble with it. You should get a
>copy
> > >of Lester Knutsen's, "Exploring the Sysmaster Database" article from
>IIUG.
> > > It has information on other sysmaster tables.
> > >
> > >Jamie Kohm
> > >Lead Unix Admin/DBA
> > >NSI
> > >
> > >-----Original Message-----
> > >From: samir BADAOUI [SMTP:samir_badaoui@hotmail.com]
> > >Sent: Tuesday, August 03, 1999 9:46 AM
> > >To: informix-list@iiug.org
> > >Subject: sysmaster database
> > >
> > >Hi friends,
> > >I want to know witch table(s) in the sysmaster database contain the
> > >following informations :
> > >- nbr. of page used by each table
> > >- nbr. of page allocated to each table
> > >I know that oncheck -pt do this, but I want to do it from sysmaster
>cause I
> > >have to find other informations too.
> > >And if there is any risque to select from this table(s) (if it's a
>pseudo
> > >table for example )
> > >Thanks !
> > >
> > >
> > >______________________________________________________
> > >Get Your Private, Free Email at http://www.hotmail.com
> > >
> >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com