Sponsored Content
Top Forums UNIX for Advanced & Expert Users how to figure out the size in MB for an informix database Post 6252 by patvdv on Saturday 1st of September 2001 12:57:49 AM
Old 09-01-2001
No bet

Optimus,

I am not sure myself but I would not bet on 4096 as 'block size' for the chunks. Are you not using LVM where you could e.g. use lvdisplay (HP-UX) to determine the size of a logical volume? From there you could possibly make a link to the chunk sizes etc.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

accessing the informix database

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

database image size

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

unix command to find the version of Informix database

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

know the size of database

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

Database Size

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

how to identify the size of a informix db(in kb/mb)?

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

Debian - Connect To Informix Database

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

Help with Database size script

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

Help with Database size script

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

Help with change significant figure to normal figure command

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
LVDISPLAY(8)						      System Manager's Manual						      LVDISPLAY(8)

NAME
lvdisplay - display attributes of a logical volume SYNOPSIS
lvdisplay [-a|--all] [-c|--colon] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--maps] [--nosuffix] [-P|--partial] [--units hHbB- sSkKmMgGtTpPeE] [-v|--verbose] [--version] [LogicalVolumePath [LogicalVolumePath...]] lvdisplay --columns | -C [--aligned] [-a|--all] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--noheadings] [--nosuffix] [-o|--options [+]Field[,Field]] [-O|--sort [+|-]Key1[,[+|-]Key2[,...]]] [-P|--partial] [--segments] [--separator Separator] [--unbuffered] [--units hHbBsSkKmMgGtTpPeE] [-v|--verbose] [--version] [LogicalVolumePath [LogicalVolumePath...]] DESCRIPTION
lvdisplay allows you to see the attributes of a logical volume like size, read/write status, snapshot information etc. lvs (8) is an alternative that provides the same information in the style of ps (1). lvs is recommended over lvdisplay. OPTIONS
See lvm for common options and lvs for options given with --columns. --all Include information in the output about internal Logical Volumes that are components of normally-accessible Logical Volumes, such as mirrors, but which are not independently accessible (e.g. not mountable). For example, after creating a mirror using 'lvcreate -m1 --mirrorlog disk', this option will reveal three internal Logical Volumes, with suffixes mimage_0, mimage_1, and mlog. -c, --colon Generate colon separated output for easier parsing in scripts or programs. N.B. lvs (8) provides considerably more control over the output. The values are: * logical volume name * volume group name * logical volume access * logical volume status * internal logical volume number * open count of logical volume * logical volume size in sectors * current logical extents associated to logical volume * allocated logical extents of logical volume * allocation policy of logical volume * read ahead sectors of logical volume * major device number of logical volume * minor device number of logical volume -m, --maps Display the mapping of logical extents to physical volumes and physical extents. To map physical extents to logical extents use pvs --segments -o+lv_name,seg_start_pe,segtype. --columns | -C Display output in columns, the equivalent of lvs. Options listed are the same as options given in lvs (8). Examples "lvdisplay -v /dev/vg00/lvol2" shows attributes of that logical volume. If snapshot logical volumes have been created for this original logical volume, this command shows a list of all snapshot logical volumes and their status (active or inactive) as well. "lvdisplay /dev/vg00/snapshot" shows the attributes of this snapshot logical volume and also which original logical volume it is associated with. SEE ALSO
lvm(8), lvcreate(8), lvscan(8), pvs(8) Sistina Software UK LVM TOOLS 2.02.95(2) (2012-03-06) LVDISPLAY(8)
All times are GMT -4. The time now is 04:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy