Size of Table in KB
Hi, How could i know that how much space any table takes in a physical file (size of table in terms of bytes/KB). Can i store a single table in multiple DBSpaces ? How ? And how can i know which rows are in which DBSspace. Regards
FYI it's always a good idea to post your version and platform information so responses can be specific to your system. Answers embedded below: Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 9, 2009 at 6:21 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com> wrote: > Hi, > How could i know that how much space any table takes in a physical file > (size > of table in terms of bytes/KB). See the tables sysmaster:sysptnhdr or sysmaster:sysactptnhdr (depending on version - see!) which you can locate using the table's partnum (or the fragments' partnums - see the next answer). > > > Can i store a single table in multiple DBSpaces ? How ? And how can i know > which rows are in which DBSspace. Yes. You can fragment a table across as many dbspaces as you want by adding a fragmentation expression clause to the create table statement or by altering the fragmentation (default storage is simple a single fragment for all intents and purposes). There is no good way to know in general which fragment a particular row is stored in. In general, that is. If you fragment ROUND ROBIN, then there is no way to know since the engine just alternates inserts to the fragments of a table round robin. However, if the fragmentation is BY EXPRESSION then you will know by comparing the row's values to the fragmentation expression, just as the engine does at insert and update time, which fragment contains or will contain a given row. See the CREATE TABLE and ALTER FRAGMENT statements in the Guide to SQL Syntax and Guide to SQL Reference manuals. > > > Regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b0d4982a70046e4677ff
Hi, We are using IDS 11.5 FC4 on Solaris sparc. Regards