cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1162
Views
0
Helpful
1
Replies

[Cisco FAQ] - Informix questions

pravora
Level 1
Level 1

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?

1 Accepted Solution

Accepted Solutions

spaderc
Cisco Employee
Cisco Employee

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 .

View solution in original post

1 Reply 1

spaderc
Cisco Employee
Cisco Employee

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 .