in fact, it"s about physical dbspace
on config file, it s rootdbs that is mentionned, with more then 6 Gb, but rootdbs is only 1gb sized.
PHYSDBS rootdbs
PHYSFILE 6400000
PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp
PHYSBUFF 512
oncheck -pe physdbs
oncheck -pe physdbs
DBspace Usage Report: physdbs Owner: informix Created: 08/21/2001
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
2 /dev/chklink/rchkphys 4 262100 53 262047
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
physdbs:'informix'.TBLSpace 3 50
FREE 53 262047
Total Used: 53
Total Free: 262047
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
91 /dev/chklink/rchkphys_1 4 10485735 10223619 262116
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
PHYSICAL LOG 3 10223616
FREE 10223619 262116
Total Used: 10223619
Total Free: 262116
------------------------------
John Smith
------------------------------
Original Message:
Sent: Mon September 28, 2020 11:26 AM
From: John Smith
Subject: Dbspace contents
Thanks a lot; i already dit it but on a space that appears to be not empty, but when i ran oncheck -pe on that dbspace, no objects are listed
that"s what i wanted a sql statement
but yes, oncheck -pe works for other dbspaces, and there are objects in it
thanks a lot
------------------------------
John Smith
Original Message:
Sent: Mon September 28, 2020 09:52 AM
From: Scott Pickett
Subject: Dbspace contents
John,
oncheck -pe will give you all extents (disk storage allocations of objects), in other words, the entire contents of a dbspace, for all dbspaces. If you have a lot of objects .... this listing will be huge. You can redirect to a filename oncheck -pe > oncheckpe.out for example.
oncheck -pe dbspace_name will give you all extents (disk storage allocations of objects), in other words, the entire contents of a dbspace, for the named dbspace only. Redirect works here as well.
Scott Pickett
IBM Informix WW Technical Sales
IBM Informix WW Cloud Technical Sales
IBM Informix WW Cloud Technical Sales ICIAE
IBM Informix WW Informix Warehouse Accelerator Sales
Boston, Massachusetts USA
spickett@us.ibm.com617-899-7549
33 Years Informix User
The current Informix Roadshow presentations are here:
The current internal ZACS Informix Page can be found here:
Original Message:
Sent: 9/28/2020 6:48:00 AM
From: John Smith
Subject: Dbspace contents
Hi to All,
how to list what a dbspace contain ?
thanks :)
------------------------------
John Smith
------------------------------
#Informix