Sponsored Content
Top Forums UNIX for Advanced & Expert Users how to figure out the size in MB for an informix database Post 6572 by mbb on Friday 7th of September 2001 08:00:01 AM
Old 09-07-2001
Optimus,

Your method is mostly correct, but I am not sure about your math!

acutal_size = free * 4096 = bytes

/ 1024 = Kbytes
/ 1024 = Mbytes
/ 1024 = GBytes.

Thats makes the total size of a chunk at 0.9gb

Free:

692mb
944mb
621mb
194mb

Do these numbers seem familiar? Plug them into a spread sheet for more accurate results.

Plus, be very careful when changing the disk allocations of logical volumes underneath Informix' nose. If you screw up, Informix won't like it and a level 0 archive/restore might not cut it either. Do a dbexport to disk or tape. It may take a while, and the restoration, with dbimport, may be a bit trickier with large tables. The benefit would be that the format (dbschema + unload files) is simple and does not rely on the underlying instance configuration on being exactly the same.

MBB.



 

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
extendfs_vxfs(1M)														 extendfs_vxfs(1M)

NAME
extendfs_vxfs: extendfs - extend VxFS file system size SYNOPSIS
size] special DESCRIPTION
If the VxFS file system image created on special does not use all of the available space, increases the capacity of a VxFS file system by updating the file system structure to include the extra space. special specifies the device special file of either a logical volume or a disk partition. If special refers to a mounted file system, you must unmount special before running (see mount(1M)). The Version 5 disk layout supports file systems up to 32 terabytes. The size to which a Version 5 disk layout file system can be increased depends on the file system block size: o 1024 bytes 4,294,967,039 sectors (4 TB) o 2048 bytes 8,589,934,078 sectors (8 TB) o 4096 bytes 17,179,868,156 sectors (16 TB) o 8192 bytes 34,359,736,312 sectors (32 TB) The Version 6 disk layout supports file systems up to 256 terabytes. The size to which a Version 6 disk layout file system can be increased depends on the file system block size: o 1024 bytes 34,359,736,312 sectors (32 TB) o 2048 bytes 68,719,472,624 sectors (64 TB) o 4096 bytes 137,438,945,248 sectors (128 TB) o 8192 bytes 274,877,890,496 sectors (256 TB) The maximum file system size supported is 2 terabytes. For a file system's size to be increased to 32 terabytes or greater, the file sys- tem must be on a 64-bit kernel operating system and must reside on a VERITAS Volume Manager volume. If the file system resides on a volume set, will fail. Use the fsvoladm(1M) command to extend a multi-volume file system. When the file system size is grown with the extendfs command, the intent log size is not automatically increased. Options recognizes the following options: Specify the VxFS file system type. Query special to determine the size. The file system is not extended. Specify the number of blocks to add to the file system. If size is omitted, the maximum possible size is used. Specify verbose mode, which displays the resulting size of file system along with output of the newly sized file system. Without there is no output. Operands recognizes the following operand: special The device special file of either a logical volume or a disk partition. If special refers to a mounted file system, you must unmount special before running (see mount(1M)). EXAMPLES
This example shows how to increase the capacity of a file system created on a logical volume. SEE ALSO
extendfs(1M), lvextend(1M), mkfs(1M), mount(1M), umount(1M), fs_vxfs(4). extendfs_vxfs(1M)
All times are GMT -4. The time now is 01:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy