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

Re: onmode -ky kangs again

Posted By: FRANK
Date: Friday, 27 October 2006, at 11:44 a.m.

In Response To: onmode -ky kangs again (FRANK)

Hi,

Goods news. After we saw our LOG backup process was still running, we
killed it, then IDS answered and stoped.

informix 335942 282910 0 14:48:39 - 0:00 /usr/local/bin/perl -w
/dbbackup/logbackup/EventAlarm.pl 5 6 Internal Subsystem failure: 'MT' ptmap

informix 348248 192724 0 15:29:30 - 0:00 /usr/local/bin/perl -w
/dbbackup/logbackup/EventAlarm.pl 4 1 Table failure: 'noaa:
informix.cman_clean_specs'. ptmap /tmp/af.4891c40

see follwoing online log. But what is the reason caused this?

Thanks,
Frank

4:30:12 Maximum server connections 4
14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers
not flushed.
14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad

14:35:11 Maximum server connections 4
14:48:33 Assert Failed: ptmap
14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)

Thread(161, sqlexec, b02ec938, 1)

File: rspartn.c Line: 2426
14:48:33 Results: Could not complete operation on
'noaa:"informix".cman_clean_specs'
14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
14:48:39 ptmap
15:29:30 invoke_alarm(): /bin/sh -c '/dbbackup/logbackup/EventAlarm.pl 5 6
"Internal Subsystem failure: 'MT'" "ptmap" '
15:29:30 invoke_alarm(): mt_exec failed, status 589833, errno 0
15:29:31 Fuzzy Checkpoint Completed: duration was 2359 seconds, 62 buffers
not flushed.
15:29:31 Checkpoint loguniq 195, logpos 0x2c3e8c4, timestamp: 0x2dfcec8e

15:29:31 Maximum server connections 4
15:29:32 listener-thread: err = -25587: oserr = 0: errstr = : Network
receive failed.

15:29:32 listener-thread: err = -25587: oserr = 0: errstr = : Network
receive failed.

15:30:01 Checkpoint Completed: duration was 0 seconds.
15:30:01 Checkpoint loguniq 195, logpos 0x2c40018, timestamp: 0x2dfceca1

15:30:01 Maximum server connections 4
15:30:02 IBM Informix Dynamic Server Stopped.

On 10/27/06, FRANK <yunyaoqu@gmail.com> wrote:
>
>
> HI,All
>
> Our IDS hangs again for some reason. Basically, it can answer onstat
> commands, but NOT onmode, i.e., onmode -c, onmode -ky,..
>
> The following is some info, hope can give some tips,
>
> Thanks,
> Frank
>
> informix@dora $ onstat -m
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:53:39 -- 1976112 Kbytes
> Blocked:CKPT
>
> Message Log File: /dbbackup/online_log/online_int2.log
> 14:25:11 Maximum server connections 4
> 14:30:12 Fuzzy Checkpoint Completed: duration was 0 seconds, 33 buffers
> not flushed.
> 14:30:12 Checkpoint loguniq 195, logpos 0x2c13250, timestamp: 0x2dfce9ca
>
> 14:30:12 Maximum server connections 4
> 14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers
> not flushed.
> 14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad
>
> 14:35:11 Maximum server connections 4
> 14:48:33 Assert Failed: ptmap
> 14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
> 14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)
>
> Thread(161, sqlexec, b02ec938, 1)
>
> File: rspartn.c Line: 2426
> 14:48:33 Results: Could not complete operation on
> 'noaa:"informix".cman_clean_specs'
> 14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
> 14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
> 14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
> 14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
> 14:48:39 ptmap
>
> informix@dora $ onstat -u
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:57:01 -- 1976112 Kbytes
> Blocked:CKPT
>
> Userthreads
> address flags sessid user tty wait tout locks nreads
> nwrites
> b02e5018 ---P--D 1 informix - 0 0 0 129 620
> b02e5524 ---P--F 0 informix - 0 0 0 0
> 332094
> b02e5a30 ---P--F 0 informix - 0 0 0 0
> 54060
> b02e5f3c ---P--F 0 informix - 0 0 0 0
> 40075
> b02e6448 ---P--F 0 informix - 0 0 0 0
> 28388
> b02e6954 ---P--F 0 informix - 0 0 0 0
> 27867
> b02e6e60 ---P--F 0 informix - 0 0 0 0
> 15648
> b02e736c ---P--F 0 informix - 0 0 0 0
> 27848
> b02e7878 ---P--F 0 informix - 0 0 0 0
> 19935
> b02e7d84 ---P--F 0 informix - 0 0 0 0
> 34797
> b02e8290 ---P--F 0 informix - 0 0 0 0
> 32678
> b02e879c ---P--F 0 informix - 0 0 0 0
> 17602
> b02e8ca8 ---P--F 0 informix - 0 0 0 0
> 38163
> b02e91b4 ---P--F 0 informix - 0 0 0 0
> 36215
> b02e96c0 ---P--F 0 informix - 0 0 0 0
> 27917
> b02e9bcc ---P--F 0 informix - 0 0 0 0
> 29085
> b02ea0d8 ---P--F 0 informix - 0 0 0 0
> 32569
> b02ea5e4 ---P--- 12 informix - 0 0 0 0
> 170316
> b02eaaf0 ---P--B 13 informix - 0 0 0 66478 176
> b02eb508 Y--P--D 19 informix - 40089b44 0 0 0 0
> b02eba14 ---P--D 16 informix - 0 0 0 0 0
> b02ec938 ---PX-- 98 saatmgr 0 0 0 2 6464
> 35114
> 22 active, 128 total, 0 maximum concurrent
>
> informix@dora $ onstat -g ses
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:59:38 -- 1976112 Kbytes
> Blocked:CKPT
>
> session #RSAM total used
> dynamic
> id user tty pid hostname threads memory memory
> explain
> 104 informix - 0 - 0 12288 8168
> off
> 99 informix - 0 - 0 12288 8168
> off
> 98 saatmgr 0 401514 gustav-d 1 122880 96440
> off
> 11 informix - 0 - 0 12288 8168
> off
> 10 informix - 0 - 0 12288 9392
> off
> 9 informix - 0 - 0 12288 8168
> off
> 6 informix - 0 - 0 12288 9392
> off
> 5 informix - 0 - 0 12288 9392
> off
> 4 informix - 0 - 0 12288 8744
> off
> 3 informix - 0 - 0 12288 8168
> off
> 2 informix - 0 - 0 12288 8168
> off
>
> informix@dora $ onstat -g seg
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:57:38 -- 1976112 Kbytes
> Blocked:CKPT
>
> Segment Summary:
> id key addr size ovhd class blkused blkfree
> 5 1382041603 30000000 540672 672 M 132 0
> 1048577 1382041601 40000000 1708425216 269028 R* 417091 5
> 4 1382041602 b0000000 314572800 10248 V 9937 66863
> Total: - - 2023538688 - - 427160 66868
>
> (* segment locked in memory)
>
> informix@dora $ onstat -g stm
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:58:02 -- 1976112 Kbytes
> Blocked:CKPT
>
> session 98 ---------------------------------------------------------------
> sdblock heapsz statement ('*' = Open cursor)
> b15ba018 7280 SELECT * FROM cman_clean_specs
> b15ba14c 5120 select * from cman_clean_specs
> b15ba280 6352 *INSERT INTO cman_clean_specs values(?,?,?)
>
> informix@dora $ onstat -g ath
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:58:19 -- 1976112 Kbytes
> Blocked:CKPT
>
> Threads:
> tid tcb rstcb prty status vp-class name
> 2 b083ceb8 0 2 sleeping forever 9lio lio vp 0
> 3 b086e968 0 2 sleeping forever 10pio pio vp 0
> 4 b088c968 0 2 sleeping forever 11aio aio vp 0
> 5 b08aa968 0 2 sleeping forever 12msc msc vp 0
> 6 b08e0968 0 2 sleeping forever 13aio aio vp 1
> 7 b08feb70 b02e5018 2 sleeping secs: 1 7cpu
> main_loop()
> 8 b088ccc0 0 2 running 14soc
> soctcppoll
> 9 b08aaab0 0 2 running 15soc
> soctcppoll
> 10 b08aac50 0 2 sleeping forever 1cpu sm_poll
> 11 b0846ec8 0 3 ready 1cpu
> soctcplst
> 12 b097e380 0 3 sleeping forever 1cpu
> sm_listen
> 13 b0997d00 0 2 sleeping secs: 1 5cpu
> sm_discon
> 14 b09a85d0 0 3 sleeping forever 4cpu
> soctcplst
> 15 b09a8a10 b02e5524 2 sleeping secs: 1 8cpu
> flush_sub(0)
> 16 b09a8b98 b02e5a30 2 sleeping secs: 1 8cpu
> flush_sub(1)
> 17 b09a8d20 b02e5f3c 2 sleeping secs: 1 8cpu
> flush_sub(2)
> 18 b09a8ea8 b02e6448 2 sleeping secs: 1 5cpu
> flush_sub(3)
> 19 b09f6058 b02e6954 2 sleeping secs: 1 8cpu
> flush_sub(4)
> 20 b09f61e0 b02e6e60 2 sleeping secs: 1 5cpu
> flush_sub(5)
> 21 b09f6368 b02e736c 2 sleeping secs: 1 8cpu
> flush_sub(6)
> 22 b09f64f0 b02e7878 2 sleeping secs: 1 8cpu
> flush_sub(7)
> 23 b09f6678 b02e7d84 2 sleeping secs: 1 8cpu
> flush_sub(8)
> 24 b09f6800 b02e8290 2 sleeping secs: 1 8cpu
> flush_sub(9)
> 25 b09f6988 b02e879c 2 sleeping secs: 1 8cpu
> flush_sub(10)
> 26 b09f6b10 b02e8ca8 2 sleeping secs: 1 5cpu
> flush_sub(11)
> 27 b09f6c98 b02e91b4 2 sleeping secs: 1 5cpu
> flush_sub(12)
> 28 b09f6e20 b02e96c0 2 sleeping secs: 1 5cpu
> flush_sub(13)
> 29 b0ade018 b02e9bcc 2 sleeping secs: 1 5cpu
> flush_sub(14)
> 30 b0ade1a0 b02ea0d8 2 sleeping secs: 1 8cpu
> flush_sub(15)
> 31 b0ade3f8 0 4 sleeping forever 1cpu kaio
> 32 b0c57dd8 b02ea5e4 3 sleeping secs: 1 8cpu
> aslogflush
> 33 b0cf23e0 b02eaaf0 2 sleeping secs: 126 6cpu
> btscanner_0
> 35 b0cf2bc0 0 4 sleeping forever 4cpu kaio
> 50 b136a1a0 0 4 sleeping forever 5cpu kaio
> 51 b136a328 b02eba14 4 ready 1cpu
> onmode_mon
> 54 b136a4b0 b02eb508 2 cond wait bp_cond 5cpu
> bf_priosweep()
> 57 b136a638 0 4 sleeping forever 7cpu kaio
> 58 b136a018 0 2 sleeping forever 16lio lio vp 1
> 59 b0d15968 0 2 sleeping forever 17pio pio vp 1
> 64 b1314338 0 4 sleeping forever 8cpu kaio
> 70 b0e76780 0 4 sleeping forever 6cpu kaio
> 161 b0fc3748 b02ec938 2 running 1cpu sqlexec
>
> informix@dora $ onstat -g glo
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:58:34 -- 1976112 Kbytes
> Blocked:CKPT
>
> MT global info:
> sessions threads vps lngspins
> 1 42 17 0
>
> sched calls thread switches yield 0 yield n yield forever
> total: 206901591 21471422 189064709 1978340 4551099
> per sec: 13 13 0 10 0
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 6 514.23 101.22 615.45
> aio 2 0.29 0.74 1.03
> lio 2 0.28 0.70 0.98
> pio 2 0.30 0.76 1.06
> adm 1 1.41 1.94 3.35
> soc 2 2.95 8.67 11.62
> msc 1 0.04 0.03 0.07
> jvp 1 0.26 0.42 0.68
> total 17 519.76 114.48 634.24
>
> Individual virtual processors:
> vp pid class usercpu syscpu total
> 1 282910 cpu 173.08 32.94 206.02
> 2 192724 adm 1.41 1.94 3.35
> 3 287008 jvp 0.26 0.42 0.68
> 4 200896 cpu 204.66 34.39 239.05
> 5 291106 cpu 50.90 10.52 61.42
> 6 155868 cpu 29.76 10.51 40.27
> 7 295204 cpu 26.34 6.97 33.31
> 8 303142 cpu 29.49 5.89 35.38
> 9 299304 lio 0.14 0.35 0.49
> 10 307242 pio 0.15 0.37 0.52
> 11 311340 aio 0.15 0.39 0.54
> 12 315438 msc 0.04 0.03 0.07
> 13 319536 aio 0.14 0.35 0.49
> 14 323634 soc 1.68 5.29 6.97
> 15 303412 soc 1.27 3.38 4.65
> 16 340034 lio 0.14 0.35 0.49
> 17 344130 pio 0.15 0.39 0.54
>
> tot 519.76 114.48 634.24
>
> informix@dora $ onstat -version
> Program Name: onstat
> Build Version: 10.00.UC5
> Build Number: N202
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Thu May 18 00:09:08 CDT 2006
> GLS Version: glslib-4.00.UC8
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

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.