09-04-2001
i beleave i understand yourstatement. I already have the size of the Logical Volume. I am trying to find out the actual size of the db space used. that way i can reduce the lv size acordingly.
the 4096 from what i was told is the size of each page in bytes. the colume for size and free are in pages. this is where i was getting my math from to figure out how big the actual dbspace is.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How do I access Informix from unix? It's been about 2 years since I've last used unix and I've forgotten the command. (2 Replies)
Discussion started by: pbouknight
2 Replies
2. Solaris
hi ,
we are using Veritas netbackup 5 to backup all databases at our site.
i noticed lately that a specific filesystem on the netbackup servers in running critically out of space , after some investigations i found that there are images that are increasing in size everytime a backup is taken .... (6 Replies)
Discussion started by: ppass
6 Replies
3. Shell Programming and Scripting
Hi All
Please let me know if there is command to check the version of the informix database installed..?
Thanks in advance.
Suresh (4 Replies)
Discussion started by: sureshg_sampat
4 Replies
4. HP-UX
Hi all ,
How to know the size of a oracle database running in hp-ux server. (1 Reply)
Discussion started by: megh
1 Replies
5. UNIX and Linux Applications
Can anybody tell me how to look for the size of the database on the solariis servers.
I am using Solaris 5.6 and Solaris 1.1.1
Any help will be appreciated.................. (1 Reply)
Discussion started by: asalman.qazi
1 Replies
6. HP-UX
I just used the dbsize command to find the size, but i guess, it doesn't gets me what i look for. (0 Replies)
Discussion started by: dvah
0 Replies
7. UNIX for Dummies Questions & Answers
Can anyone point me toward information on setting up a Debian server ODBC connection to an Informix server? I have a Windows server set up with the Informix drivers in ODBC and I'd like to do the same thing on Debian so that my Rails apps can query the database beneath our call-logging software. ... (1 Reply)
Discussion started by: badmoon75
1 Replies
8. Shell Programming and Scripting
Hello,
I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.
This is my SQL TEXT
# -- Total size of Database Size in GB
set echo off feedback off verify off pause... (2 Replies)
Discussion started by: jnrpeardba
2 Replies
9. UNIX for Dummies Questions & Answers
Hello,
I'm not very good at scripting as my job is an DBA for a small firm, but now I'd like to implement a few cron jobs which access and report on the databases on an automatic basis.
This is my SQL TEXT
# -- Total size of Database Size in GB set echo off feedback off verify off... (4 Replies)
Discussion started by: jnrpeardba
4 Replies
10. Shell Programming and Scripting
Hi,
Below is my input file:
Long list of significant figure
1.757E-4
7.51E-3
5.634E-5
.
.
.
Desired output file:
0.0001757
0.00751
0.00005634
.
.
. (10 Replies)
Discussion started by: perl_beginner
10 Replies
LEARN ABOUT DEBIAN
makedbz
MAKEDBZ(8) InterNetNews Documentation MAKEDBZ(8)
NAME
makedbz - Rebuild dbz files
SYNOPSIS
makedbz [-io] [-f filename] [-s size]
DESCRIPTION
makedbz rebuilds dbz(3) database. The default name of the text file is pathdb/history; to specify a different name, use the -f flag.
OPTIONS
-f filename
If the -f flag is used, then the database files are named "filename.dir", "filename.index", and "filename.hash". If the -f flag is not
used, then a temporary link to the name "history.n" is made and the database files are written as "history.n.index" , "history.n.hash"
and "history.n.dir".
-i To ignore the old database, use the -i flag. Using the -o or -s flags implies the -i flag.
-o If the -o flag is used, then the link is not made and any existing history files are overwritten. If the old database exists, makedbz
will use it to determine the size of the new database.
-s size
makedbz will also ignore any old database if the -s flag is used to specify the approximate number of entries in the new database.
Accurately specifying the size is an optimization that will create a more efficient database. Size is measured in key-value pairs
(i.e. lines). (The size should be the estimated eventual size of the file, typically the size of the old file.)
For more information, see the discussion of dbzfresh and dbzsize in dbz(3).
HISTORY
Written by Katsuhiro Kondou <kondou@nec.co.jp> for InterNetNews. Converted to POD by Julien Elie.
$Id: makedbz.pod 8584 2009-08-20 21:54:07Z iulius $
SEE ALSO
dbz(3), history(5).
INN 2.5.3 2009-09-11 MAKEDBZ(8)