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

dbexport : -425 - Database is currently opened by

Posted By: FRANK
Date: Wednesday, 3 August 2016, at 1:26 p.m.

Guys,

Did numerous times of dbexport . in past 50 years, NO problem :-) :-)

But, now it blocked the job...

It is sure , no application , no ER, no HDR, NO nothing running there (
I even stopped scheduler ) ...

Any tip to trace the " another user"?

By the way, it is fine to do the same job on another database of the same
instance .

Thanks
Frank

[informix@maggie ~]$ dbexport noaa -ss
-425 - Database is currently opened by another user.
-107 - ISAM error: record is locked.
[informix@maggie ~]$ onstat -u
IBM Informix Dynamic Server Version 12.10.FC4W1XU -- Single-User -- Up
01:50:41 -- 11778640 Kbytes
Userthreads
address flags sessid user tty wait tout
locks nreads nwrites
4fa05028 ---P--D 1 informix - 0 0
0 1273 502
4fa058e8 ---P--F 0 informix - 0 0
0 0 328
4fa061a8 ---P--F 0 informix - 0 0
0 0 38
4fa06a68 ---P--F 0 informix - 0 0
0 0 35
4fa07328 ---P--F 0 informix - 0 0
0 0 36
4fa07be8 ---P--F 0 informix - 0 0
0 0 87
4fa084a8 ---P--F 0 informix - 0 0
0 0 11
4fa08d68 ---P--F 0 informix - 0 0
0 0 9
4fa09628 ---P--F 0 informix - 0 0
0 0 70
4fa09ee8 ---P--F 0 informix - 0 0
0 0 8
4fa0a7a8 ---P--F 0 informix - 0 0
0 0 4
4fa0b068 ---P--F 0 informix - 0 0
0 0 3
4fa0b928 ---P--F 0 informix - 0 0
0 0 3
4fa0c1e8 ---P--F 0 informix - 0 0
0 0 94
4fa0caa8 ---P--F 0 informix - 0 0
0 0 1
4fa0d368 ---P--F 0 informix - 0 0
0 0 1
4fa0dc28 ---P--F 0 informix - 0 0
0 0 1
4fa0e4e8 ---P--- 16 informix - 0 0
0 0 0
4fa0eda8 ---P--B 17 informix - 0 0
0 0 0
4fa0f668 Y--P--B 18 informix - 50b84e18 0
0 0 0
4fa0ff28 Y--P--D 19 informix - 50e39de8 0
0 9994 0
4fa107e8 ---P--D 20 informix - 0 0
0 0 0
4fa11968 ---P--D 24 informix - 0 0
0 0 0
4fa12ae8 ---P--D 25 informix - 0 0
0 3 0
4fa133a8 ---P--D 26 informix - 0 0
0 0 0
4fa14528 ---P--- 36 informix - 0 0
1 0 0
4fa156a8 Y--P--D 35 informix - 44249c30 0
0 0 0
27 active, 128 total, 61 maximum concurrent

[informix@maggie ~]$ onstat -g ses
IBM Informix Dynamic Server Version 12.10.FC4W1XU -- Single-User -- Up
01:51:48 -- 11778640 Kbytes
session #RSAM total used
dynamic
id user tty pid hostname threads memory memory
explain
280 informix - 0 - 0 16384 12440
off
264 informix - 0 - 0 16384 12440
off
15 informix - 0 - 0 16384 12440
off
13 informix - 0 - 0 16384 14032
off
12 informix - 0 - 0 16384 14032
off
11 informix - 0 - 0 16384 12440
off
10 informix - 0 - 0 16384 12440
off
8 informix - 0 - 0 16384 14032
off
7 informix - 0 - 0 16384 14032
off
6 informix - 0 - 0 16384 12440
off
5 informix - 0 - 0 16384 12440
off
4 informix - 0 - 0 16384 12440
off
3 informix - 0 - 0 16384 12440
off
2 informix - 0 - 0 16384 12440
off

[informix@maggie ~]$ onstat -g ath
IBM Informix Dynamic Server Version 12.10.FC4W1XU -- Single-User -- Up
01:52:11 -- 11778640 Kbytes
Threads:
tid tcb rstcb prty status
vp-class name
2 506d6028 0 1 IO Idle
3lio* lio vp 0
3 506ee368 0 1 IO Idle
4pio* pio vp 0
4 5070f368 0 1 IO Idle
5aio* aio vp 0
5 50730368 1cf9680 1 IO Idle
6msc* msc vp 0
6 50761368 0 1 IO Idle
7fifo* fifo vp 0
7 507a5a90 0 1 IO Idle
13aio* aio vp 1
8 507c6368 0 1 IO Idle
14aio* aio vp 2
9 507e7368 0 1 IO Idle
15aio* aio vp 3
10 50824608 4fa05028 3 sleeping secs: 1
11cpu main_loop()
11 5087e028 0 1 running
20soc* soctcppoll
12 5087e6b0 0 1 running
21soc* soctcppoll
13 508bb028 0 1 running
22soc* soctcppoll
14 508bb6b0 0 1 running
23soc* soctcppoll
15 508f8028 0 1 running
1cpu* sm_poll
16 50915958 0 2 sleeping forever
1cpu* soctcplst
17 50948370 0 2 sleeping forever
1cpu sm_listen
18 50981028 0 1 sleeping secs: 1
9cpu sm_discon
19 50996418 0 2 sleeping forever
9cpu* soctcplst
20 509aad00 0 2 sleeping forever
10cpu* soctcplst
21 509c47f0 4fa058e8 1 sleeping secs: 1
11cpu flush_sub(0)
22 509c4b30 4fa061a8 1 sleeping secs: 1
11cpu flush_sub(1)
23 509fe028 4fa06a68 1 sleeping secs: 1
11cpu flush_sub(2)
24 509fe368 4fa07328 1 sleeping secs: 1
9cpu flush_sub(3)
25 509fe6a8 4fa07be8 1 sleeping secs: 1
9cpu flush_sub(4)
26 509fe9e8 4fa084a8 1 sleeping secs: 1
11cpu flush_sub(5)
27 509fed28 4fa08d68 1 sleeping secs: 1
11cpu flush_sub(6)
28 50a90028 4fa09628 1 sleeping secs: 1
11cpu flush_sub(7)
29 50a90368 4fa09ee8 1 sleeping secs: 1
9cpu flush_sub(8)
30 50a906a8 4fa0a7a8 1 sleeping secs: 1
11cpu flush_sub(9)
31 50a909e8 4fa0b068 1 sleeping secs: 1
9cpu flush_sub(10)
32 50a90d28 4fa0b928 1 sleeping secs: 1
9cpu flush_sub(11)
33 50b2c028 4fa0c1e8 1 sleeping secs: 1
9cpu flush_sub(12)
34 50b2c368 4fa0caa8 1 sleeping secs: 1
11cpu flush_sub(13)
35 50b2c6a8 4fa0d368 1 sleeping secs: 1
1cpu flush_sub(14)
36 50b2c9e8 4fa0dc28 1 sleeping secs: 1
11cpu flush_sub(15)
37 50b2cd28 0 3 IO Idle
10cpu* kaio
38 50c45370 0 3 IO Idle
9cpu* kaio
39 50cf3b68 4fa0e4e8 2 sleeping secs: 1
9cpu aslogflush
40 50d9baa8 4fa0eda8 1 sleeping secs: 2
11cpu btscanner_0
41 50e39a00 4fa0f668 1 cond wait btc_sort
1cpu btscanner_1
42 50e56aa8 4fa0ff28 3 cond wait ReadAhead
10cpu readahead_0
43 50e73bf8 4fa107e8 3 sleeping secs: 1
9cpu auto_tune
59 511cc908 0 3 IO Idle
1cpu* kaio
60 511ccc48 0 3 IO Idle
12cpu* kaio
62 510ae380 4fa11968 3 sleeping secs: 1
1cpu* onmode_mon
63 5119f380 4fa12ae8 3 sleeping secs: 1
1cpu periodic
64 5113e2c8 4fa133a8 3 sleeping forever
9cpu* memory
69 51106b08 0 3 IO Idle
11cpu* kaio
74 50f7f6b8 4fa156a8 1 cond wait bp_cond
9cpu bf_priosweep()
75 51033b28 4fa14528 1 sleeping secs: 496
1cpu ds_head_sha

--94eb2c04269cccaeac05392e2171

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.