07-10-2012 12:48 PM
Is there a quick way to tell if Informix is running correctly on the DNCS and how much disk space is available for Informix? What is the precise command?
Solved! Go to Solution.
07-12-2012 06:11 AM
Yes. The DNCS utilizes Informix as the Database engine and must be running correctly for the processes and GUIs to function.
•1) From an xterm window, type:
$onstat –d
Informix Dynamic Server 2000 Version 9.21.UC3 -- On-Line -- Up 40 days 19:30:20 -- 2713600 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
9610e7d0 1 0x1001 1 1 N informix rootdbs
9610eeb8 2 0x2001 2 1 N T informix tempspace1
968b4e28 3 0x1 3 1 N informix logspace
968b5018 4 0x1 4 30 N informix dataspace1
4 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
9610e918 1 1 0 512000 406308 PO- /dev/md/rdsk/d350
9614db90 2 2 0 1048575 1048334 PO- /dev/md/rdsk/d351
9614dcf8 3 3 0 1048575 22 PO- /dev/md/rdsk/d352
9614de60 4 4 0 1048575 25 PO- /dev/md/rdsk/d353
9610ea80 5 4 0 1048575 0 PO- /dev/md/rdsk/d354
9610ebe8 6 4 0 1048575 116524 PO- /dev/md/rdsk/d355
9610ed50 7 4 0 1048575 0 PO- /dev/md/rdsk/d356
9613e830 8 4 0 1048575 97858 PO- /dev/md/rdsk/d357
9613e998 9 4 0 1048575 846563 PO- /dev/md/rdsk/d358
9613eb00 10 4 0 1048575 1047964 PO- /dev/md/rdsk/d359
9613ec68 11 4 0 1048575 1048572 PO- /dev/md/rdsk/d360
9613edd0 12 4 0 1048575 1048572 PO- /dev/md/rdsk/d361
968b3018 13 4 0 1048575 1048572 PO- /dev/md/rdsk/d362
968b3180 14 4 0 1048575 1048572 PO- /dev/md/rdsk/d363
968b32e8 15 4 0 1048575 1048572 PO- /dev/md/rdsk/d364
968b3450 16 4 0 1048575 1048572 PO- /dev/md/rdsk/d365
968b35b8 17 4 0 1048575 1048572 PO- /dev/md/rdsk/d366
968b3720 18 4 0 1048575 1048572 PO- /dev/md/rdsk/d367
968b3888 19 4 0 1048575 1048572 PO- /dev/md/rdsk/d368
968b39f0 20 4 0 1048575 1048572 PO- /dev/md/rdsk/d369
968b3b58 21 4 0 1048575 1048572 PO- /dev/md/rdsk/d370
968b3cc0 22 4 0 1048575 1048572 PO- /dev/md/rdsk/d371
968b3e28 23 4 0 1048575 1048572 PO- /dev/md/rdsk/d372
968b4018 24 4 0 1048575 1048572 PO- /dev/md/rdsk/d373
968b4180 25 4 0 1048575 1048572 PO- /dev/md/rdsk/d374
968b42e8 26 4 0 1048575 1048572 PO- /dev/md/rdsk/d375
968b4450 27 4 0 1048575 1048572 PO- /dev/md/rdsk/d376
968b45b8 28 4 0 1048575 1048572 PO- /dev/md/rdsk/d377
968b4720 29 4 0 1048575 1048572 PO- /dev/md/rdsk/d378
968b4888 30 4 0 1048575 1048572 PO- /dev/md/rdsk/d379
968b49f0 31 4 0 1048575 1048572 PO- /dev/md/rdsk/d380
968b4b58 32 4 0 1048575 1048572 PO- /dev/md/rdsk/d381
968b4cc0 33 4 0 1048575 1048572 PO- /dev/md/rdsk/d382
33 active, 2047 maximum
Results:
•- The 1st line of output should state that Informix is “On-Line” and will also display the total uptime for Informix. If this value is anything other than “On-Line”, the database is not completely up. If the database is not “up”, the processes and GUIs will not function correctly.
•- The Informix database itself is split into 2 Gig “chunks”. Each of these chunks is defined as either root space, tempspace, log space or database space. Generally, the Database chunks will all be specified as chunks “dbs 4”. Unused database chunks will have the same value in both the “size” and “free” columns, while used chunks will display less “free” space. If a chunk is completely used than “free” may actually = “0” for that chunk, which is normal.
•- If you have no database chunks that are unused, you may be in jeopardy of running out of space .
07-12-2012 06:11 AM
Yes. The DNCS utilizes Informix as the Database engine and must be running correctly for the processes and GUIs to function.
•1) From an xterm window, type:
$onstat –d
Informix Dynamic Server 2000 Version 9.21.UC3 -- On-Line -- Up 40 days 19:30:20 -- 2713600 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
9610e7d0 1 0x1001 1 1 N informix rootdbs
9610eeb8 2 0x2001 2 1 N T informix tempspace1
968b4e28 3 0x1 3 1 N informix logspace
968b5018 4 0x1 4 30 N informix dataspace1
4 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
9610e918 1 1 0 512000 406308 PO- /dev/md/rdsk/d350
9614db90 2 2 0 1048575 1048334 PO- /dev/md/rdsk/d351
9614dcf8 3 3 0 1048575 22 PO- /dev/md/rdsk/d352
9614de60 4 4 0 1048575 25 PO- /dev/md/rdsk/d353
9610ea80 5 4 0 1048575 0 PO- /dev/md/rdsk/d354
9610ebe8 6 4 0 1048575 116524 PO- /dev/md/rdsk/d355
9610ed50 7 4 0 1048575 0 PO- /dev/md/rdsk/d356
9613e830 8 4 0 1048575 97858 PO- /dev/md/rdsk/d357
9613e998 9 4 0 1048575 846563 PO- /dev/md/rdsk/d358
9613eb00 10 4 0 1048575 1047964 PO- /dev/md/rdsk/d359
9613ec68 11 4 0 1048575 1048572 PO- /dev/md/rdsk/d360
9613edd0 12 4 0 1048575 1048572 PO- /dev/md/rdsk/d361
968b3018 13 4 0 1048575 1048572 PO- /dev/md/rdsk/d362
968b3180 14 4 0 1048575 1048572 PO- /dev/md/rdsk/d363
968b32e8 15 4 0 1048575 1048572 PO- /dev/md/rdsk/d364
968b3450 16 4 0 1048575 1048572 PO- /dev/md/rdsk/d365
968b35b8 17 4 0 1048575 1048572 PO- /dev/md/rdsk/d366
968b3720 18 4 0 1048575 1048572 PO- /dev/md/rdsk/d367
968b3888 19 4 0 1048575 1048572 PO- /dev/md/rdsk/d368
968b39f0 20 4 0 1048575 1048572 PO- /dev/md/rdsk/d369
968b3b58 21 4 0 1048575 1048572 PO- /dev/md/rdsk/d370
968b3cc0 22 4 0 1048575 1048572 PO- /dev/md/rdsk/d371
968b3e28 23 4 0 1048575 1048572 PO- /dev/md/rdsk/d372
968b4018 24 4 0 1048575 1048572 PO- /dev/md/rdsk/d373
968b4180 25 4 0 1048575 1048572 PO- /dev/md/rdsk/d374
968b42e8 26 4 0 1048575 1048572 PO- /dev/md/rdsk/d375
968b4450 27 4 0 1048575 1048572 PO- /dev/md/rdsk/d376
968b45b8 28 4 0 1048575 1048572 PO- /dev/md/rdsk/d377
968b4720 29 4 0 1048575 1048572 PO- /dev/md/rdsk/d378
968b4888 30 4 0 1048575 1048572 PO- /dev/md/rdsk/d379
968b49f0 31 4 0 1048575 1048572 PO- /dev/md/rdsk/d380
968b4b58 32 4 0 1048575 1048572 PO- /dev/md/rdsk/d381
968b4cc0 33 4 0 1048575 1048572 PO- /dev/md/rdsk/d382
33 active, 2047 maximum
Results:
•- The 1st line of output should state that Informix is “On-Line” and will also display the total uptime for Informix. If this value is anything other than “On-Line”, the database is not completely up. If the database is not “up”, the processes and GUIs will not function correctly.
•- The Informix database itself is split into 2 Gig “chunks”. Each of these chunks is defined as either root space, tempspace, log space or database space. Generally, the Database chunks will all be specified as chunks “dbs 4”. Unused database chunks will have the same value in both the “size” and “free” columns, while used chunks will display less “free” space. If a chunk is completely used than “free” may actually = “0” for that chunk, which is normal.
•- If you have no database chunks that are unused, you may be in jeopardy of running out of space .
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide