this is my first posting here and I am looking forward to join your community!
I am using IDS 9.40 on Win2003. Are ther any scripts, working with this Version on this OS, that determin the size of a single Database?
I hope, this Question is not too simple for you and bothering you, but I am in Trouble and I need your help.
It is quite easy to get the database size of normal datatypes. Especially large objects (blobs) and smart blobs are rather difficult to specify per database. To get the info you need just use the following sql:
select sum(size) as nr_of_pages
where dbsname = '<dbname>'
This is just one of the methods. You can also use the systabnames and sysptnhdr tables in the sysmaster database to get the info. This will even give you a more detailed look because woth this you can get all allocated pages (like in previous query), but also all used and data pages.