HP3000-L Archives

June 2004, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: allbase question
From:
Cathlene Mc Rae <[log in to unmask]>
Reply To:
Cathlene Mc Rae <[log in to unmask]>
Date:
Thu, 10 Jun 2004 09:57:29 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (25 lines) 
I'm not sure about the question.  An allbase dbe consist of many files,
the dbcon file, datafiles,   logs.
AllbaseSql file codes
dbe        -491     = The DBECon file
FL         -493     = The DBEFile
LG         -497     = The LogFile

select name, nrows from system.table; will provide the number of rows per
table, provided an update statisitcs has been executed against the tables.

The size of the dbefiles can be determine as follows;
select fileid, dbefname, dbefsname, (dbefupages*100/dbefnpages)
      from system.dbefile order by fileid;

(dbefupages*100/dbefnpages) column in the table in step 5 shows how full
the table is (in percent).

I hope this answers your question
Best Regards
Cathlene Mc Rae
Sr HP Response Center Eng.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2