RE: sysmaster database
This is a multipart message in MIME format
--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
#!/bin/sh
#--------------------------------------------------------------
# PROGRAMA: este scrip es utilizado para hacer un DISPLAY de=20
# 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=3D$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,=20
a.tabname Tabla,
b.ti_fextsiz ,
b.ti_nextsiz,=20
b.ti_nextns Extent,
b.ti_nptotal Total,
b.ti_npused Usadas,
b.ti_npdata Datos,
(b.ti_nptotal-b.ti_npused) Libres,=20
b.ti_nrows Filas
from systabnames a,systabinfo b
where a.partnum =3D b.ti_partnum
and a.tabname =3D '${tabla}'
EOF
A.U.S. Dar=EDo J. Yossen
Administraci=F3n de Bases de Datos
Dpto. Tecnolog=EDa - Gcia. de Sistemas
Aguas Provinciales de Santa Fe
Tel: 54 - 342 - 4504110
E-Mail: dyossen@apsf.com.ar =20
> -----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
>=20
>=20
>=20
> ok Jamie,
> I have taked a look in the sysmaster database and I have foun that =
table=20
> (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=20
> query that table (sysptnhdr). What do you think ?
>=20
> >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
> >
>=20
>=20
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
--------------InterScan_NT_MIME_Boundary--