Oninit cdi / Archive
Talk to an expert →

oninit -i problem

Posted in 2006

Topics: Storage & Space Management, Stored Procedures & SPL, Server Administration, Logging & Checkpoints

mchivaviro@okzim.co.zw — — source: Usenet: comp.databases.informix

online log out put Sat May 20 17:01:32 2006 17:01:32 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 17:01:37 DR: DRAUTO is 0 (Off) 17:01:38 Informix Dynamic Server Version 7.31.UC5 Software SerialNumber AAC #J876311 17:01:38 Informix Dynamic Server Initialized -- Shared MemoryInitialized. 17:01:38 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP. 17:01:38 Physical Recovery Started. 17:01:38 Physical Recovery Complete: 0 Pages Restored. 17:01:38 Logical Recovery Started. 17:01:40 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 17:01:41 Dataskip is now OFF for all dbspaces 17:01:41 On-Line Mode 17:01:41 Building 'sysmaster' database ... 17:01:41 Checkpoint Completed: duration was 0 seconds. 17:08:28 Informix Dynamic Server Stopped. 17:08:56 Segment locked: addr=0xc47d4000, size=463470592 oninit -v outputWriting to infos file ... succeeded Checking config parameters...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 52512 kbytes...succeeded Creating buffer pool 400002 kbytes...succeeded Initializing rhead structure...succeeded Initializing ASF ...succeeded Initializing Dictionary Cache and Stored Procedure Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded nlining 3 additional cpu vps...succeeded Onlining 8 IO vps...succeeded Forking main_loop thread...succeeded Initialzing DR structures...succeeded Forking 1 'ipcshm' listener threads...succeeded Forking 1 'soctcp' listener threads...succeeded Starting tracing...succeeded Initializing 127 flushers...succeeded Initializing log/checkpoint information...succeeded Opening primary chunks...succeeded Opening mirror chunks...succeeded Initializing dbspaces...succeeded Validating chunks...succeeded Initialize Async Log Flusher...succeeded Forking btree cleaner...succeeded Initializing DBSPACETEMP list $ Checking database partition index...succeeded Checking location of physical log...succeeded Initializing dataskip structure...succeeded Checking for temporary tables to drop Forking onmode_mon thread...succeeded Verbose output complete: mode = 5

↪ replying to mchivaviro@okzim.co.zw
Neil Truby — — source: Usenet: comp.databases.informix

<mchivaviro@okzim.co.zw> wrote in message news:1148138748.289735.287040@j33g2000cwa.googlegroups.com... > online log out put Have you got a question?

↪ replying to Neil Truby
mchivaviro@okzim.co.zw — — source: Usenet: comp.databases.informix

Can not make informix go online. I have put out from online.log and oninit -v where its stopping.I am installing IDS 7.31 UC5 on HP11.11

↪ replying to mchivaviro@okzim.co.zw
TBP — — source: Usenet: comp.databases.informix

mchivaviro@okzim.co.zw wrote: > online log out put > Sat May 20 17:01:32 2006 > > 17:01:32 Event alarms enabled. ALARMPROG = > '/u/informix/etc/log_full.sh' > 17:01:37 DR: DRAUTO is 0 (Off) > 17:01:38 Informix Dynamic Server Version 7.31.UC5 Software Serial> Number AAC > #J876311 > 17:01:38 Informix Dynamic Server Initialized -- Shared Memory> Initialized. > 17:01:38 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP. > 17:01:38 Physical Recovery Started. > 17:01:38 Physical Recovery Complete: 0 Pages Restored. > 17:01:38 Logical Recovery Started. > 17:01:40 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 17:01:41 Dataskip is now OFF for all dbspaces > 17:01:41 On-Line Mode > 17:01:41 Building 'sysmaster' database ... > 17:01:41 Checkpoint Completed: duration was 0 seconds. > 17:08:28 Informix Dynamic Server Stopped. > 17:08:56 Segment locked: addr=0xc47d4000, size=463470592> > oninit -v output> Writing to infos file ... succeeded > Checking config parameters...succeeded > Allocating and attaching to shared memory...succeeded > Creating resident pool 52512 kbytes...succeeded > Creating buffer pool 400002 kbytes...succeeded > Initializing rhead structure...succeeded > Initializing ASF ...succeeded > Initializing Dictionary Cache and Stored Procedure Cache...succeeded > Bringing up ADM VP...succeeded > Creating VP classes...succeeded > nlining 3 additional cpu vps...succeeded > Onlining 8 IO vps...succeeded > Forking main_loop thread...succeeded > Initialzing DR structures...succeeded > Forking 1 'ipcshm' listener threads...succeeded > Forking 1 'soctcp' listener threads...succeeded > Starting tracing...succeeded > Initializing 127 flushers...succeeded > Initializing log/checkpoint information...succeeded > Opening primary chunks...succeeded > Opening mirror chunks...succeeded > Initializing dbspaces...succeeded > Validating chunks...succeeded > Initialize Async Log Flusher...succeeded > Forking btree cleaner...succeeded > Initializing DBSPACETEMP list > $ Checking database partition index...succeeded > Checking location of physical log...succeeded > Initializing dataskip structure...succeeded > Checking for temporary tables to drop > Forking onmode_mon thread...succeeded > Verbose output complete: mode = 5 > This is great, a bit like a puzzle really ... oninit -i is different to oninit -v - subject says oninit -i, yet output suggests oninit -v. However, it looks like "building sysmaster" has failed to complete : > 17:01:41 Building 'sysmaster' database ... > 17:01:41 Checkpoint Completed: duration was 0 seconds. > 17:08:28 Informix Dynamic Server Stopped. Now, another clue is : > 17:01:38 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP. Perhaps an oninit -i (-y?) was run mistakenly? Still, a bit more info may help.

Glossary