Sponsored Content
Top Forums UNIX for Advanced & Expert Users how to figure out the size in MB for an informix database Post 6213 by Optimus_P on Friday 31st of August 2001 10:22:26 AM
Old 08-31-2001
how to figure out the size in MB for an informix database

This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct.

Code:
Chunks
address  chk/dbs offset   size     free     bpages   flags pathname
5003e1f8 1   1   0        250000   177177            PO-   /database/link_cw_p01_rootdbs
5003e494 2   2   256      250000   241891            PO-   /database/link_cw_p01_dbs1
5003e570 3   3   256      250000   159038            PO-   /database/link_cw_p01_dbs2
5003e64c 4   4   256      250000   49869             PO-   /database/link_cw_p01_ithdbs
 4 active, 2047 maximum

hostname: onstat -b

Informix Dynamic Server Version 7.30.UC5   -- On-Line -- Up 17 days 21:01:13 -- 429568 Kbytes

Buffers
address  userthread flgs pagenum  memaddr  nslots pgflgs xflgs owner    waitlist
 92 modified, 0 resident, 90000 total, 131072 hash buckets, 4096 buffer size

actual_size=((size-free)*4096)/1024

link_cw_p01_rootdbs=292mb
link_cw_p01_dbs1=325
link_cw_p01_ithdbs=801
link_cw_p01_cw_dbs2=364
 

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
IONCONFIG(5)						      ICI configuration files						      IONCONFIG(5)

NAME
ionconfig - ION node configuration parameters file DESCRIPTION
ION node configuration parameters are passed to ionadmin in a file of parameter name/value pairs: parameter_name parameter_value Any line of the file that begins with a '#' character is considered a comment and is ignored. ionadmin supplies default values for any parameters for which no value is provided in the node configuration parameters file. The applicable parameters are as follows: sdrName This is the character string by which this ION node's SDR database will be identified. (Note that the SDR database infrastructure enables multiple databases to be constructed on a single host computer.) The default value is "ion". configFlags This is the bitwise "OR" of the flag values that characterize the SDR database to use for this ION node. The default value is 1. The SDR configuration flags are documented in detail in sdr(3). To recap: 1. The SDR is implemented in a region of shared memory. [Possibly with write-through to a file, for fault tolerance.] 2. The SDR is implemented as a file. [Possibly cached in a region of shared memory, for faster data retrieval.] 3. Transactions in the SDR are written ahead to a log, making them reversible. 4. SDR heap updates are not allowed to cross object boundaries. heapKey This is the shared-memory key by which the pre-allocated block of shared dynamic memory to be used as heap space for this SDR can be located, if applicable. The default value is -1, i.e., not specified and not applicable. pathName This is the fully qualified path name of the directory in which are located (a) the file to be used as heap space for this SDR (which will be created, if it doesn't already exist), in the event that the SDR is to be implemented in a file, and (b) the file to be used to log the database updates of each SDR transaction, in the event that transactions in this SDR are to be reversible. The default value is /usr/ion. heapWords This is the number of words (of 32 bits each on a 32-bit machine, 64 bits each on a 64-bit machine) of nominally non-volatile storage to use for ION's SDR database. If the SDR is to be implemented in shared memory and no heapKey is specified, a block of shared memory of this size will be allocated (e.g., by malloc()) at the time the node is created. If the SDR is to be implemented in a file and no file named ion.sdr exists in the directory identified by pathName, then a file of this name and size will be created in this directory and initialized to all binary zeroes. The default value is 250000 words (1 million bytes on a 32-bit computer). wmKey This is the shared-memory key by which this ION node's working memory will be identified. The default value is 65537. wmAddress This is the address of the block of dynamic memory -- volatile storage, which is not expected to persist across a system reboot -- to use for this ION node's working memory. If zero, the working memory block will be allocated from system memory (e.g., by malloc()) at the time the local ION node is created. The default value is zero. wmSize This is the size of the block of dynamic memory that will be used for this ION node's working memory. If wmAddress is zero, a block of system memory of this size will be allocated (e.g., by malloc()) at the time the node is created. The default value is 5000000 (5 million bytes). EXAMPLE
configFlags 1 heapWords 2500000 heapKey -1 pathName 'usr/ion' wmSize 5000000 wmAddress 0 SEE ALSO
ionadmin(1) perl v5.14.2 2012-06-11 IONCONFIG(5)
All times are GMT -4. The time now is 05:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy