Re: getting full volume info

Posted in 2008

Summary

Raja wanted to measure a database's size and ran a query summing pe_size from systabnames/sysptnext, getting 19,425,058 — asking whether that figure was bytes. Respondents explained the value is in pages, not bytes, and that the page size depends on the platform (commonly 2K on Linux, 4K on AIX). Since Raja was on AIX, the size is 19,425,058 * 4096 bytes (not * 4). Raja accepted this answer, so the thread is resolved.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: SQL Development & Query Writing

raja — Tue, 18 Nov 2008 01:51:03 -0800 (PST) — source: Usenet: comp.databases.informix

Hi, I have to find how big is the database ( size of the database ). I have the following query and its output : select dbsname,sum( pe_size ) total_pages from systabnames, sysptnext where partnum = pe_partnum group by 1 order by 2 desc No dbsname total_pages 1 db1 19425058 Does this mean that the size of the database is 19425058 bytes ? Thanks in Advance. With Regards, Raja.

↪ replying to raja

Plugge, Joe R. — Tue, 18 Nov 2008 07:34:36 -0600 — source: Usenet: comp.databases.informix

What is the page size of the OS that you are operating on? Typically Linux is 2K and AIX is 4K page size and then you do the math from there to calculate size allocated. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of raja Sent: Tuesday, November 18, 2008 3:51 AM To: informix-list@iiug.org Subject: Re: getting full volume info Hi, I have to find how big is the database ( size of the database ). I have the following query and its output : select dbsname,sum( pe_size ) total_pages from systabnames, sysptnext where partnum = pe_partnum group by 1 order by 2 desc No dbsname total_pages 1 db1 19425058 Does this mean that the size of the database is 19425058 bytes ? Thanks in Advance. With Regards, Raja. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Plugge, Joe R.

raja — Tue, 18 Nov 2008 06:07:05 -0800 (PST) — source: Usenet: comp.databases.informix

yes, its AIX, so its 4k. So is the database size to be calculated as : 19425058 * 4 bytes ? Please help on this With Regards, Raja.

↪ replying to raja

Obnoxio The Clown — Tue, 18 Nov 2008 14:14:02 +0000 — source: Usenet: comp.databases.informix

raja wrote: > yes, its AIX, so its 4k. > > So is the database size to be calculated as : 19425058 * 4 bytes ? 19425058 * 4096 bytes -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com

↪ replying to raja

Link, David A — Tue, 18 Nov 2008 08:15:30 -0600 — source: Usenet: comp.databases.informix

No. It would be 19425058 * 4096 bytes. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of raja Sent: Tuesday, November 18, 2008 8:07 AM To: informix-list@iiug.org Subject: Re: getting full volume info yes, its AIX, so its 4k. So is the database size to be calculated as : 19425058 * 4 bytes ? Please help on this With Regards, Raja. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Link, David A

raja — Tue, 18 Nov 2008 07:17:52 -0800 (PST) — source: Usenet: comp.databases.informix

Thanks to all. With Regards, Raja.