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
lvreduce
LVREDUCE(8) System Manager's Manual LVREDUCE(8)
NAME
lvreduce - reduce the size of a logical volume
SYNOPSIS
lvreduce [-A|--autobackup {y|n}] [-d|--debug] [-h|--help] [-t|--test] [-v|--verbose] [--version] [-f|--force] [--noudevsync] {-l|--extents
[-]LogicalExtentsNumber[%{VG|LV|FREE|ORIGIN}] | [-L|--size [-]LogicalVolumeSize[bBsSkKmMgGtTpPeE]} [-n|--nofsck] [-r|--resizefs] Logi-
calVolume{Name|Path}
DESCRIPTION
lvreduce allows you to reduce the size of a logical volume. Be careful when reducing a logical volume's size, because data in the reduced
part is lost!!!
You should therefore ensure that any filesystem on the volume is resized before running lvreduce so that the extents that are to be removed
are not in use.
Shrinking snapshot logical volumes (see lvcreate(8) for information to create snapshots) is supported as well. But to change the number of
copies in a mirrored logical volume use lvconvert(8).
Sizes will be rounded if necessary - for example, the volume size must be an exact number of extents and the size of a striped segment must
be a multiple of the number of stripes.
OPTIONS
See lvm(8) for common options.
-f, --force
Force size reduction without prompting even when it may cause data loss.
--noudevsync
Disable udev synchronisation. The process will not wait for notification from udev. It will continue irrespective of any possible
udev processing in the background. You should only use this if udev is not running or has rules that ignore the devices LVM2 cre-
ates.
-l, --extents [-]LogicalExtentsNumber[%{VG|LV|FREE|ORIGIN}]
Reduce or set the logical volume size in units of logical extents. With the - sign the value will be subtracted from the logical
volume's actual size and without it the value will be taken as an absolute size. The number can also be expressed as a percentage
of the total space in the Volume Group with the suffix %VG, relative to the existing size of the Logical Volume with the suffix %LV,
as a percentage of the remaining free space in the Volume Group with the suffix %FREE, or (for a snapshot) as a percentage of the
total space in the Origin Logical Volume with the suffix %ORIGIN. The resulting value for the substraction is rounded downward, for
the absolute size it is rounded upward.
-L, --size [-]LogicalVolumeSize[bBsSkKmMgGtTpPeE]
Reduce or set the logical volume size in units of megabytes. A size suffix of k for kilobyte, m for megabyte, g for gigabytes, t
for terabytes, p for petabytes or e for exabytes is optional. With the - sign the value will be subtracted from the logical vol-
ume's actual size and without it it will be taken as an absolute size.
-n, --nofsck
Do not perform fsck before resizing filesystem when filesystem requires it. You may need to use --force to proceed with this option.
-r, --resizefs
Resize underlying filesystem together with the logical volume using fsadm(8).
EXAMPLES
Reduce the size of logical volume lvol1 in volume group vg00 by 3 logical extents:
lvreduce -l -3 vg00/lvol1
SEE ALSO
fsadm(8), lvchange(8), lvconvert(8), lvcreate(8), lvextend(8), lvm(8), lvresize(8), vgreduce(8)
Sistina Software UK LVM TOOLS 2.02.95(2) (2012-03-06) LVREDUCE(8)