tablesize BLOBs
where in sysmaster database can i find the size of a
table that contains BLOBs in blobspaces ?
I would like to find out how many parts have to be unloaded using HPL.
oncheck -pT shows only the normal datatypes,
oncheck -pB did not come back within 15 min....
--
Mit freundlichen Grüßen
Gerd Kaluzinski
\\\\\\\\|//
(o o)
--------------------------------------------------ooO-(_)-Ooo---
Gerd Kaluzinski mailto:gerd.kaluzinski@bytec.de
Manager Consulting mailto:support@bytec.de
Informix Certified Senior System Engineer
http://www.bytec.de
BYTEC GmbH Telefon: 07541-585-1019
Hermann-Metzger-Str. 7 Fax : 07541-585-2019
88045 Friedrichshafen Ooo.
-------------------------------------------------.ooO----( )---
( ) (_/
\\\\_)
Here's a little script I like to use to check out how much space is
allocated to a table. It requires that you know the partition number,
which you can get from systables or sysmaster:systabnames.
#!/usr/bin/ksh
if [ $# -ne 1 ]; then
echo "usage: dbptnpages <partition number>"
else
dbaccess sysmaster 2>/dev/null <<EOF
set isolation to dirty read;
select count(*)total,
-- instead of joining with sysmaster:flags_textcase tp_type
-- normal
when 0 then "free"
when 4 then "with room for another row"
when 8 then "with index or bitmap data"
when 12 then "full"
-- blob
when 2 then "(blob) free"
when 6 then "(blob) semi-full"
when 10 then "(blob) full"
when 14 then "(blob) very full"
-- unknown
else "unknown"
end pages
from systabpagtypes
where tp_partnum = $1
group by 2
order by 2;
EOF
fi
"Gerd
Kaluzi...." To: ids@iiug.org
<gerd.kaluzinski cc:
@bytec.de> Subject: tablesize BLOBs [1046]
Sent by:
forum.subscriber
@iiug.org
04/30/2003 11:27
AM
where in sysmaster database can i find the size of a table that contains
BLOBs in blobspaces ?
I would like to find out how many parts have to be unloaded using HPL.
oncheck -pT shows only the normal datatypes,
oncheck -pB did not come back within 15 min....
--
Mit freundlichen Grüßen
Gerd Kaluzinski
\\\\\\\\|//
(o o)
--------------------------------------------------ooO-(_)-Ooo---
Gerd Kaluzinski mailto:gerd.kaluzinski@bytec.de
Manager Consulting mailto:support@bytec.de
Informix Certified Senior System Engineer
http://www.bytec.de
BYTEC GmbH Telefon: 07541-585-1019
Hermann-Metzger-Str. 7 Fax : 07541-585-2019
88045 Friedrichshafen Ooo.
-------------------------------------------------.ooO----( )---
( ) (_/
\\\\_)