Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

how to enable dbspace

Posted By: CHANATIP LAONGSIRIWONG
Date: Friday, 5 May 2006, at 4:03 a.m.

How to enable dbspace? dbspace3 be disble from I/O error. Now disks were replace already.
N740-Informix > onstat -d

Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
e06d97e8 1 0x1001 1 1 N informix rootdbs_psc
e0de2748 2 0x2001 41 2 N T informix tempdbs
e0de2898 3 0x1 3 1 N informix logicaldbs
e0de29e8 4 0x1 4 9 N informix dbspace1
e0de2b38 5 0x1 6 51 N informix dbspace2
e0de2c88 6 0x5 73 62 ND informix dbspace3
e0de2dd8 7 0x1 75 1 N informix psc_tmp1
e0de3018 8 0x11 12 1 N B informix blobspace1
e0de3168 9 0x1 13 1 N informix index1
e0de32b8 10 0x1 64 1 N informix dptraining1
10 active, 2047 maximum

Note: For BLOB chunks, the number of free pages shown is out of date.

Run 'onstat -d update' for current stats.

Chunks
address chk/dbs offset size free bpages flags pathname
e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01
e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02
e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03
e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06
e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07
e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11
e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12
e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16
e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17
e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35
e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38
e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39
e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36
e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18
e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21
e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08
e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09
e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26
e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13
e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14
e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat
e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat
e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20
e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22
e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat
e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat
e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24
e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25
e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41
e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31
e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32
e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat
e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat
e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15
e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23
e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat
e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat
e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33
e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37
e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40
e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04
e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42
e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat
e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat
e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47
e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat
e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat
e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat
e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat
e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52
e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat
e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat
e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat
e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56
e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57
e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat
e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat
e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat
e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat
e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat
e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62
e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63
e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat
e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64
e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat
e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat
e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05
e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10
e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19
e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43
e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34
e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52
e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat
e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat
e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67
e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat
e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat
e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat
e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat
e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat
e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat
e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat
e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat
e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat
e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat
e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat
e0dda748 87 6 0 1024000 0 PD- /backup/INFORMIX/data14.dat
e0dda8b8 88 6 0 1024000 0 PD- /backup/INFORMIX/data15.dat
e0ddaa28 89 6 0 1024000 0 PD- /backup/INFORMIX/data16.dat
e0ddab98 90 6 0 1024000 0 PD- /backup/INFORMIX/data17.dat
e0ddad08 91 6 0 1024000 0 PD- /backup/INFORMIX/data18.dat
e0ddae78 92 6 0 1024000 0 PD- /backup/INFORMIX/data19.dat
e0ddb018 93 6 0 1024000 0 PD- /backup/INFORMIX/data20.dat
e0ddb188 94 6 0 1024000 0 PD- /backup/INFORMIX/data21.dat
e0ddb2f8 95 6 0 1024000 0 PD- /backup/INFORMIX/data22.dat
e0ddb468 96 6 0 1024000 0 PD- /backup/INFORMIX/data23.dat
e0ddb5d8 97 6 0 1024000 0 PD- /backup/INFORMIX/data24.dat
e0ddb748 98 6 0 1024000 0 PD- /backup/INFORMIX/data25.dat
e0ddb8b8 99 6 0 1024000 0 PD- /backup/INFORMIX/data26.dat
e0ddba28 100 6 0 1024000 0 PD- /backup/INFORMIX/data27.dat
e0ddbb98 101 6 0 1024000 0 PD- /backup/INFORMIX/data28.dat
e0ddbd08 102 6 0 1024000 0 PD- /backup/INFORMIX/data29.dat
e0ddbe78 103 6 0 1024000 0 PD- /backup/INFORMIX/data30.dat
e0ddc018 104 6 0 1024000 0 PD- /backup/INFORMIX/data31.dat
e0ddc188 105 6 0 1024000 0 PD- /backup/INFORMIX/data32.dat
e0ddc2f8 106 4 0 1024000 789685 PO- /home/informix/psck5701/dpchk44
e0ddc468 107 4 0 1024000 1023997 PO- /home/informix/psck5701/dpchk45
e0ddc5d8 108 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk46
e0ddc748 109 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk48
e0ddc8b8 110 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk49
e0ddca28 111 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk50
e0ddcb98 112 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk53
e0ddcd08 113 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk54
e0ddce78 114 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk55
e0ddd018 115 5 0 512000 511997 PO- /home/informix/psck5701/dpchk58
e0ddd188 116 5 0 512000 511997 PO- /home/informix/psck5701/dpchk59
e0ddd2f8 117 5 0 512000 511997 PO- /home/informix/psck5701/dpchk60
e0ddd468 118 5 0 512000 511997 PO- /home/informix/psck5701/dpchk61
e0ddd5d8 119 5 0 512000 511997 PO- /home/informix/psck5701/dpchk65
e0ddd748 120 5 0 512000 511997 PO- /home/informix/psck5701/dpchk66
e0ddd8b8 121 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk27
e0ddda28 122 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk28
e0dddb98 123 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk29
e0dddd08 124 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk30
e0ddde78 125 6 0 1024000 0 PD- /backup/INFORMIX/data58.dat
e0de2018 126 6 0 1024000 0 PD- /backup/INFORMIX/data59.dat
e0de2188 127 6 0 1024000 0 PD- /backup/INFORMIX/data60.dat
e0de22f8 128 6 0 1024000 0 PD- /backup/INFORMIX/data61.dat
e0de2468 129 6 0 1024000 0 PD- /backup/INFORMIX/data62.dat
e0de25d8 130 6 0 1024000 0 PD- /backup/INFORMIX/data63.dat
130 active, 2047 maximum

I cut some part from online.log.

20:16:22 Maximum server connections 104
20:19:50 Logical Log 299852 Complete.
20:22:14 Assert Failed: I/O error, Primary Chunk '/backup/INFORMIX/data63.dat' -- Offline
20:22:14 Informix Dynamic Server Version 9.30.HC3
20:22:14 Who: Thread(19, flush_sub(0), dfbd6624, 1)

File: rsbuff.c Line: 4086
20:22:14 Results: Chunk is now unusable
20:22:14 Action: Repair and restore from mirror or archive
20:22:14 stack trace for pid 20455 written to /tmp/af.3fba075
20:22:14 See Also: /tmp/af.3fba075
20:22:15 I/O error, Primary Chunk '/backup/INFORMIX/data63.dat' -- Offline
20:23:18 Assert Failed: Chunk 130 is being taken OFFLINE.
20:23:18 Informix Dynamic Server Version 9.30.HC3
20:23:18 Who: Thread(19, flush_sub(0), dfbd6624, 1)

File: rsmirror.c Line: 1847
20:23:18 Results: Dynamic Server will block at next checkpoint
20:23:18 Action: Shutdown (onmode -k) or override (onmode -O)
20:23:18 stack trace for pid 20455 written to /tmp/af.3fba075
20:23:18 See Also: /tmp/af.3fba075
20:23:18 Chunk 130 is being taken OFFLINE.
20:23:34 I/O write chunk 130, pagenum 584917, pagecnt 1 --> errno = 2
20:23:34 Checkpoint blocked by down space, waiting for override or shutdown

Thu May 4 19:04:05 2006

19:04:05 Event alarms enabled. ALARMPROG = '/home/informix/logs/log_full.sh'
19:04:06 Booting Language <c> from module <>
19:04:06 Loading Module <CNULL>
19:04:06 Booting Language <builtin> from module <>
19:04:06 Loading Module <BUILTINNULL>
19:04:12 Dynamically allocated new virtual shared memory segment (size 8000KB)
19:04:12 Informix Dynamic Server Version 9.30.HC3 Software Serial Number AAD#A361521
19:04:14 Informix Dynamic Server Initialized -- Shared Memory Initialized.

19:04:14 Physical Recovery Started at Page(1:757).
19:04:15 Physical Recovery Complete: 601 Pages Examined 599 Pages Restored.

19:04:15 Logical Recovery Started.
19:04:15 10 recovery worker threads will be started.
19:09:16 I/O read chunk 130, pagenum 584916, pagecnt 1 --> errno = 5
19:09:16 Rollforward of log record failed. iserrno = 126
19:09:16 Log Record: log = 299852, pos = 0x154445c, type = OLDRSAM:HINSERT(40), trans = 20
19:09:17 Ignoring the ONDBSPACEDOWN option during logical recovery. Dynamic Server
will NOT BLOCK at the next checkpoint
19:10:19 Assert Failed: Chunk 73 is being taken OFFLINE.
19:10:19 Informix Dynamic Server Version 9.30.HC3
19:10:19 Who: Session(11, informix@pscrp740, 0, -571108388)

Thread(29, xchg_1.3, ddf2b29c, 1)

File: rsmirror.c Line: 1854
19:10:19 Results: DBspace dbspace3 is disabled.
19:10:19 Action: Restore DBspace dbspace3
19:10:19 stack trace for pid 3551 written to /tmp/af.405e0db
19:10:19 See Also: /tmp/af.405e0db
19:10:19 Chunk 73 is being taken OFFLINE.
19:10:19 Rollforward of log record failed. iserrno = 126

I try to do some command. But got error.
> onspaces -s dbspace3 -p /backup/INFORMIX/data1.dat -o 0 -O
Warning: Bringing chunk back online.
Do you really want to continue? (y/n)y
Verifying physical disk space, please wait ...
Cannot change chunk status.
ISAM error: illegal argument to ISAM function.

Please help me. Thank you.

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.