Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
katherinec — — source: Informix-list mailing list archive (1991-1998)
We are in the middle of a huge migration (IDS to XPS) & are taking this
opportunity to reevaluate space needs for all 160 of our databases. I
am looking for a way to create a report to give our Data Acquistion
people a starting point for tracking the information we need to know to
estimate database size & growth. Here is where I am right now:
select tabname, rowsize, nrows from systables
where systables.tabid >= 100
Then they can pull the unload file into excel and simply add the
expected per month growth for the number of rows and we will at least
have SOME idea for space needs.
The only thing we are missing is the per row index size. I know
dbschema and dbexport gets this info from SOMEwhere, but I would hate
to have to go through all those dbschemas for all those databases
manually.
Anybody know how I could get this info using a query???????
--
Free audio & video emails, greeting cards and forums
Talkway - http://www.talkway.com - Talk more ways (sm)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.