Forum Stats

  • 3,874,202 Users
  • 2,266,682 Discussions
  • 7,911,768 Comments

Discussions

How to repair Informix DB that will not stay up?

User_59DKF
User_59DKF Member Posts: 3 Blue Ribbon

I have an old Sun machine running an Informix DB on Solaris 10. This has been running for years without issues. Recently the Informix DB stopped, and now it will run. I can start it, without showing any errors, but it only stays up for about 30 seconds, and then dies again. Anyone experienced this issue, and have any steps to repair?

This is what I'm seeing. Check if DB is running (onstat) and shows down. I can then start it (oninit -v), and it starts with all "succeeded". onstat then shows it up and "On-Line". Check again after ~30 seconds, and down again:

bash-3.00# onstat

shared memory not initialized for INFORMIXSERVER 'dncsDbServer'

bash-3.00# oninit -v

Checking group membership to determine server run mode...succeeded

Reading configuration file '/export/home/informix/etc/onconfig'...succeeded

Creating /INFORMIXTMP/.infxdirs...succeeded

Checking config parameters...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 278796 kbytes...succeeded

Allocating 1677736 kbytes for buffer pool of 2K page size...succeeded

Creating infos file "/export/home/informix/etc/.infos.dncsDbServer"...succeeded

Linking conf file "/export/home/informix/etc/.conf.dncsDbServer"...succeeded

Initializing rhead structure...succeeded

Writing to infos file...succeeded

Initialization of Encryption...succeeded

Initializing ASF...succeeded

Initializing Dictionary Cache and SPL Routine Cache...succeeded

Bringing up ADM VP...succeeded

Creating VP classes...succeeded

Onlining 1 additional cpu vps...succeeded

Onlining 1 IO vps...succeeded

Forking main_loop thread...succeeded

Initializing dataskip structure...succeeded

Checking for temporary tables to drop...succeeded

Forking onmode_mon thread...succeeded

Creating periodic thread...succeeded

Starting scheduling system...succeeded

Verbose output complete: mode = 5

bash-3.00# onstat


IBM Informix Dynamic Server Version 11.50.FC6    -- On-Line (CKPT INP) -- Up 00:00:20 -- 2587648 Kbytes


Userthreads

address         flags  sessid  user    tty     wait            tout locks nreads  nwrites

184c81028       ---P--D 1       root    -       0               0   0    41      8

184c81880       ---P--F 0       root    -       0               0   0    0       77

184c820d8       ---P--F 0       root    -       0               0   0    0       4

184c82930       ---P--F 0       root    -       0               0   0    0       44

184c83188       ---P--F 0       root    -       0               0   0    0       26

184c839e0       ---P--F 0       root    -       0               0   0    0       0

184c84238       ---P--F 0       root    -       0               0   0    0       0

184c84a90       ---P--F 0       root    -       0               0   0    0       0

184c852e8       ---P--F 0       root    -       0               0   0    0       0

184c85b40       ---P--- 12      root    -       0               0   0    0       0

184c86398       ---P--B 13      root    -       0               0   0    0       0

184c86bf0       ---P--- 15      root    -       0               0   0    0       0

184c87448       ---P--D 17      root    -       0               0   0    0       0

184c87ca0       C-BP--- 16      informix -       10b7d3d38       0   2    37      1

184c884f8       ---P--D 18      root    -       0               0   0    1       0

184c895a8       --B---- 16      informix -       0               0   2    0       0

184c89e00       --B---- 16      informix -       0               0   2    0       0

184c8aeb0       ---PR-- 25      informix -       0               0   1    66      0

 18 active, 128 total, 25 maximum concurrent


Profile

dskreads  pagreads  bufreads  %cached dskwrits  pagwrits  bufwrits  %cached

172       1211      13303     98.71  137       144       5072      97.30


isamtot   open      start     read      write     rewrite   delete    commit    rollbk

5134      242       73        269       1         1         1         721       1


gp_read   gp_write  gp_rewrt  gp_del    gp_alloc  gp_free   gp_curs

2         0         0         0         0         0         1


ovlock    ovuserthread ovbuff    usercpu syscpu  numckpts  flushes

0         0           0         2.12    2.67    0         1


bufwaits  lokwaits  lockreqs  deadlks   dltouts   ckpwaits  compress  seqscans

3         0         593       0         0         1         1408      1


ixda-RA   idx-RA    da-RA     RA-pgsused lchwaits

3         0         0         3         457

bash-3.00# onstat

shared memory not initialized for INFORMIXSERVER 'dncsDbServer'

Answers

  • User_59DKF
    User_59DKF Member Posts: 3 Blue Ribbon

    Tried "oninit -vi" and this is output, and what's in the online.log:

    bash-3.00# oninit -vi

    This action will initialize IBM Informix Dynamic Server;

    any existing IBM Informix Dynamic Server databases will NOT be accessible -

    Do you wish to continue (y/n)? y

    Checking group membership to determine server run mode...succeeded

    Reading configuration file '/export/home/informix/etc/onconfig'...succeeded

    Creating /INFORMIXTMP/.infxdirs...succeeded

    Checking config parameters...succeeded

    Allocating and attaching to shared memory...succeeded

    Creating resident pool 278796 kbytes...succeeded

    Allocating 1677736 kbytes for buffer pool of 2K page size...succeeded

    Creating infos file "/export/home/informix/etc/.infos.dncsDbServer"...succeeded

    Linking conf file "/export/home/informix/etc/.conf.dncsDbServer"...succeeded

    Initializing rhead structure...succeeded

    Writing to infos file...succeeded

    Initialization of Encryption...succeeded

    Initializing ASF...succeeded

    Initializing Dictionary Cache and SPL Routine Cache...succeeded

    Bringing up ADM VP...succeeded

    Creating VP classes...succeeded

    Onlining 1 additional cpu vps...succeeded

    Onlining 1 IO vps...succeeded

    Forking main_loop thread...succeeded


    WARNING: server initialization failed, or possibly timed out (if -w was used).

    Check the message log, online.log, for errors.



    From

    12:21:09 IBM Informix Dynamic Server Started.

    12:21:09 Requested shared memory segment size rounded from 1980416KB to 1998848KB

    12:21:09 Shared memory segment will use large pages with intimate shared memory (ISM) if available

    12:21:11 Segment locked: addr=10a000000, size=2046820352

    12:21:11 Requested shared memory segment size rounded from 587202KB to 587776KB


    Thu May 20 12:21:13 2021


    05/20/21 12:21:13 Event alarms enabled. ALARMPROG = '/export/home/informix/etc/no_log.sh'

    05/20/21 12:21:13 Booting Language <c> from module <>

    05/20/21 12:21:13 Loading Module <CNULL>

    05/20/21 12:21:13 Booting Language <builtin> from module <>

    05/20/21 12:21:13 Loading Module <BUILTINNULL>

    05/20/21 12:21:13 SQLTRACE: SQL History Tracing set to 60000 SQL statements.

    05/20/21 12:21:18 DR: DRAUTO is 0 (Off)

    05/20/21 12:21:18 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)

    05/20/21 12:21:18 Fast poll /dev/poll enabled.

    05/20/21 12:21:19 Requested shared memory segment size rounded from 560KB to 1024KB

    05/20/21 12:21:21 IBM Informix Dynamic Server Version 11.50.FC6    Software Serial Number AAA#B000000

    05/20/21 12:21:21 oninit: Not enough room in ROOT DBspace.

           Requested 7292388K, ONCONFIG value 'ROOTSIZE' 3145728K.


    05/20/21 12:21:21 IBM Informix Dynamic Server Stopped.


    12:21:22 mt_shm_remove: WARNING: may not have removed all/correct segments

  • Nik
    Nik Blocked Member Posts: 2,879 Bronze Crown

    Hi.

    You should ask experts of Informix, not Solaris.


    According logs You have problem with space of ROOT DPspace:

    05/20/21 12:21:21 oninit: Not enough room in ROOT DBspace.

           Requested 7292388K, ONCONFIG value 'ROOTSIZE' 3145728K.


    According this: https://www.ibm.com/support/pages/oninit-not-enough-room-root-dbspace

    You should Increase the value of ROOTSIZE in onconfig file.


    Regards,

    Nik