Unable to initiliaze informix instance

Hi, Sorry I am sending the mail again because I found that the attachment reached to you will not be in proper format. I have installed informix 7.31 on MP-RAS 3.02 (NCR S 1600 machine, with 2GB RAM) . But I am not initialize my informix instance using "oninit -i" command if i use raw device. I tried using cooked file instead of raw and it worked fine. Following are the Kernel parameters changed:- STRTHRESH 0 SEMMAP 522 SEMMNI 2048 SEMMNS 2048 SEMMNU 2048 SEMMSL 250 SEMUME 64 SHMMAX 209715200 SHMSEG 64 SDATLIM 0X7fffffff HDATLIM 0X7fffffff SVMMLIM 0X7fffffff HVMMLIM 0X7fffffff Following are the permission and links created for accessing the raw device. $ cd /dev $ ls -l online*lrwxrwxrwx 1 root other 20 May 15 15:00 online_root -> /dev/rdsk/c110t0d0se $ ls -l rdsk/c11* cr-------- 1 root root 35,589824 May 10 13:27 rdsk/c110t0d0s0 cr-------- 2 root root 35,589825 May 10 13:27 rdsk/c110t0d0s1 cr-------- 2 root root 35,589826 May 17 12:13 rdsk/c110t0d0s2 cr-------- 1 root root 35,589827 May 12 15:10 rdsk/c110t0d0s3 cr-------- 1 root root 35,589828 May 12 15:10 rdsk/c110t0d0s4 cr-------- 1 root root 35,589830 May 10 13:27 rdsk/c110t0d0s6 cr-------- 1 root root 35,589831 May 10 13:27 rdsk/c110t0d0s7 cr-------- 1 root sys 35,589832 May 15 16:24 rdsk/c110t0d0s8 cr-------- 1 root sys 35,589833 May 12 16:06 rdsk/c110t0d0s9 cr-------- 1 root root 35,589834 May 10 13:27 rdsk/c110t0d0sacrw-rw-rw- 1 informix informix 35,589838 May 17 13:00 rdsk/c110t0d0se crw-rw---- 1 informix informix 35,589839 May 15 13:47 rdsk/c110t0d0sf Following are the onconfig, online.log and output_of_oninit -i -v files. **********************************************************ONCONFIG************** ************************************************** #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/online_root#ROOTPATH /backup/online_root # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 20000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 1000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 6 # Number of logical log files LOGSIZE 500 # Logical log size (Kbytes) # Diagnostics MSGPATH /informix/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /dev/null # Tape device path #TAPEDEV /dev/tapedev # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/null # Log tape device path#LTAPEDEV /dev/tapedev # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a DynamicServer instance DBSERVERNAME ONLINE1 # Name of default database server DBSERVERALIASES # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 2000 # Maximum number of locks BUFFERS 200 # Maximum number of shared buffers NUMAIOVPS 1 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 6 # Maximum number of logical log files CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 8000 # initial virtual shared memory segmentsize SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - Dynamic Server no longer supports this configuration parameter. # To determine the page size used by Dynamic Server on your platform # see the last line of output from the command, 'onstat -b'. # Recovery Variables # OFF_RECVRY_THREADS: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline workerthreads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables # DRAUTO: 0 manual, 1 retain type, 2 reverse type DRAUTO 0 # DR automatic switchover DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec)DRLOSTFOUND /informix/etc/dr.lostfound # DR lost+found file path # CDR Variables CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes) CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional) CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)CDR_LOGDELTA 30 # % of log space allowed in queue memory CDR_NUMCONNECT 16 # Expected connections per server CDR_NIFRETRY 300 # Connection retry (seconds) CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max) # Backup/Restore variables BAR_ACT_LOG /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp please BAR_DEBUG_LOG /usr/informix/bar_dbug.log # ON-Bar Debug Log - not in /tmp please BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 # Informix Storage Manager variables ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to # update $INFORMIXDIR/bin/onbar. Change to # ism_catalog -

Karl, I got following error while writing into online_root. It means that the device is having some problem. UX:dd: ERROR: Write: No such device or address 1+0 records in 0+0 records out Regards, Shailesh M Karl Ostner <KOSTNER@de.ibm.c To: "Shailesh.Mo...." <Shailesh.More@ril.com> om> cc: Subject: Re: Unable to initiliaze informix instance [2969] 05/17/2004 05:55 Importance: Normal Sender's OU: Reliance |------------------| PM | [ ] Confidential | |------------------| Shailesh, as user informix, can you write to /dev/online_root via dd command ? E.g. dd if=/dev/zero of=/dev/online_root bs=2k count=20000 regards, Karl -- Karl Ostner IBM Informix Development Munich Data Management Solutions e-mail: kostner@de.ibm.com

The name /dev/online_root is a dummy copied from the onconfig.std file. You need to set it to point to the device or file that you are going to use to store your instance's most critical information. Your error says 'no such device or address' - go fix. Usually, you decide on your disk layout ahead of time. Usually, you want to use raw devices rather than cooked. And you definitely want to use symbolic links to the actual devices. I'd recommend some system for this - along the lines of: /ix-dev/servername/rootdbs.c0 -- rootdbs primary chunk 0 for 'servername'. /ix-dev/servername/rootdbs.m0 -- rootdbs mirror chunk 0 You'd have to create that /ix-dev directory (I personally use /usr/informix/dev for the job, and filenames such as servername.rootdbs.c0 rather than an extra sub-directory, but my setup is not standard - and /usr/informix is not a working INFORMIXDIR). This scheme divorces your device names from the server version and allows you to upgrade over time -- that's an advantage, believe me! -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 05/17/2004 06:01:14 AM: > > > > > > Karl, > > I got following error while writing into online_root. It means that the > device is having some problem. > > UX:dd: ERROR: Write: No such device or address > 1+0 records in > 0+0 records out > > Regards, > Shailesh M > > > > > Karl Ostner > <KOSTNER@de.ibm.c To: "Shailesh. > Mo...." <Shailesh.More@ril.com> > om> cc: > Subject: Re: Unable > to initiliaze informix instance [2969] > 05/17/2004 05:55 Importance: Normal > Sender's OU: Reliance |------------------| > PM > | [ ] Confidential | > > |------------------| > > > > > > > > > > Shailesh, > > as user informix, can you write to /dev/online_root via dd command ? > E.g. dd if=/dev/zero of=/dev/online_root bs=2k count=20000 > > regards, > > Karl > -- > Karl Ostner > IBM Informix Development Munich > Data Management Solutions > e-mail: kostner@de.ibm.com > > > > >

Shailesh, Please, change permissions of Your root chunk to 660: chmod 660 /dev/rdsk/c110t0d0se The same rule should apply to all raw devices designated to Informix ------------------------------------------ Alexey Sonkin > From: Shailesh.Mo.... [mailto:Shailesh.More@ril.com] > > Hi, > > Sorry I am sending the mail again because I found that the attachment > reached to you will not be in proper format. > > I have installed informix 7.31 on MP-RAS 3.02 (NCR S 1600 machine, with > 2GB RAM) . But I am not initialize my informix instance using "oninit -i" > command if i use raw device. I tried using cooked file instead of raw and > it worked fine. > > $ ls -l online*> lrwxrwxrwx 1 root other 20 May 15 15:00 online_root -> > /dev/rdsk/c110t0d0se > > $ ls -l rdsk/c11*> crw-rw-rw- 1 informix informix 35,589838 May 17 13:00 rdsk/c110t0d0se > crw-rw---- 1 informix informix 35,589839 May 15 13:47 rdsk/c110t0d0sf >

I have found the problem. It was with the slice, which my system admin has configured it for informix chunks were not properly configured. thanks for ur help, advice and suggestions. Regards, Shailesh M Jonathan Leffler <jleffler@us.ibm. To: "Shailesh.Mo...." <Shailesh.More@ril.com>, ids@iiug.org com> cc: Subject: Re: Unable to initiliaze informix instance [2970] 05/17/2004 10:59 Importance: Normal Sender's OU: Reliance |------------------| PM | [ ] Confidential | |------------------| The name /dev/online_root is a dummy copied from the onconfig.std file. You need to set it to point to the device or file that you are going to use to store your instance's most critical information. Your error says 'no such device or address' - go fix. Usually, you decide on your disk layout ahead of time. Usually, you want to use raw devices rather than cooked. And you definitely want to use symbolic links to the actual devices. I'd recommend some system for this - along the lines of: /ix-dev/servername/rootdbs.c0 -- rootdbs primary chunk 0 for 'servername'. /ix-dev/servername/rootdbs.m0 -- rootdbs mirror chunk 0 You'd have to create that /ix-dev directory (I personally use /usr/informix/dev for the job, and filenames such as servername.rootdbs.c0 rather than an extra sub-directory, but my setup is not standard - and /usr/informix is not a working INFORMIXDIR). This scheme divorces your device names from the server version and allows you to upgrade over time -- that's an advantage, believe me! -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 05/17/2004 06:01:14 AM: > > > > > > Karl, > > I got following error while writing into online_root. It means that the > device is having some problem. > > UX:dd: ERROR: Write: No such device or address > 1+0 records in > 0+0 records out > > Regards, > Shailesh M > > > > > Karl Ostner > <KOSTNER@de.ibm.c To: "Shailesh. > Mo...." <Shailesh.More@ril.com> > om> cc: > Subject: Re: Unable > to initiliaze informix instance [2969] > 05/17/2004 05:55 Importance: Normal > Sender's OU: Reliance |------------------| > PM > | [ ] Confidential | > > |------------------| > > > > > > > > > > Shailesh, > > as user informix, can you write to /dev/online_root via dd command ? > E.g. dd if=/dev/zero of=/dev/online_root bs=2k count=20000 > > regards, > > Karl > -- > Karl Ostner > IBM Informix Development Munich > Data Management Solutions > e-mail: kostner@de.ibm.com > > > > >