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

RES: Problem with ONBAR: unusually slow on IDS ...

Posted By: Celso Cabral Coimbra
Date: Thursday, 24 February 2011, at 7:09 a.m.

In Response To: Re: Problem with ONBAR: unusually slow on IDS .... (Khaled Bentebal)

Khaled,

I met this bug in Nov 2010. In my environment, this query used to take more than 24 hours to start transfer data to tape. I upgraded to 11.50.FC8 and solved the problem.

https://www-304.ibm.com/support/docview.wss?uid=swg1IC67929

Celso Cabral Coimbra
Administrador de Banco de Dados
ClearTech Ltda
"Trust at the heart of Communications"
Tel. (11) 3576-4509

-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Khaled Bentebal
Enviada em: quarta-feira, 23 de fevereiro de 2011 22:51
Para: ids@iiug.org
Assunto: Re: Problem with ONBAR: unusually slow on IDS .... [22894]

Thanks Fernando,

What about APAR IC67929 ? This has been also mentionned by support as a
possibility.

A PMR has been opened.

Khaled Bentebal

Email: khaled.bentebal@consult-ix.fr

Le 24/02/11 00:13, Fernando Nunes a écrit :
> Hello,
>
> It looks like APAR IC71702
>
> https://www-304.ibm.com/support/entdocview.wss?uid=swg1IC71702
>
> It's fixed in 11.50.FC8W2
> You may want to open a PMR for further details.
>
> Check that the "slow" instance has much more partitions (either table,
> indexes or fragments) than the other(s).
>
> Regards.
>
> On Wed, Feb 23, 2011 at 10:52 PM, Khaled Bentebal<
> khaled.bentebal@consult-ix.fr> wrote:
>
>> Hi,
>>
>> A client of ours is runnning IDS 11.50.FC5 on AIX and is facing a
>> problem with a backup running ONBAR.
>>
>> It runs fine on several instances on different machines, but is very
>> slow on one instance. All of the instances are setup the same way along
>> the same model and the same ONCONFIG.
>>
>> ONBAR runs a particular query before performing the backup:
>> *select ( sum ( npused ) ) from sysdbspaces as D , sysptnhdr as P where
>> D.dbsnum = TRUNC ( P.partnum/1048576 ) and name = ? *
>>
>> This query goes on for ever (*few hours*). We tried to run a query on
>> sysptnhdr by itself and sysdbspaces also by itself. It seems that the query
>> on
>> sysptnhdr is very very slow. The same query runs very fast (instantanious)
>> on
>> the other instances.
>> We tried to rebuild the sysmaster databse, but nothing came out it.
>>
>> Here is more info on this session: any ideas ?
>> -------------------------------------------------------------------------
>> tid tcb rstcb prty status vp-class name
>> 2 7000000b162d9f0 0 1 IO Idle 10lio* lio vp 0
>> 3 7000000b166a288 0 1 IO Idle 11pio* pio vp 0
>> 4 7000000b1692288 0 1 IO Idle 12aio* aio vp 0
>> 5 7000000b16ba288 0 1 IO Idle 13msc* msc vp 0
>> 6 7000000b16f2528 7000000b0adc028 3 sleeping secs: 1 1cpu main_loop()
>> 7 7000000b1638a50 0 1 running 14soc* soctcppoll
>> 8 7000000b15236c0 0 2 sleeping forever 1cpu* soctcplst
>> 9 7000000b1692830 0 2 sleeping forever 3cpu* soctcplst
>> 10 7000000b16ba4e8 7000000b0adc858 1 sleeping secs: 1 1cpu flush_sub(0)
>> 11 7000000b16ba7c0 7000000b0add088 1 sleeping secs: 1 1cpu flush_sub(1)
>> 12 7000000b16baa98 7000000b0add8b8 1 sleeping secs: 1 1cpu flush_sub(2)
>> 13 7000000b16bad70 7000000b0ade0e8 1 sleeping secs: 1 1cpu flush_sub(3)
>> 14 7000000b1617300 0 3 running 3cpu* kaio
>> 31 7000000b196a808 0 3 IO Idle 1cpu* kaio
>> 37 7000000b1a7a388 7000000b0ade918 2 sleeping secs: 1 1cpu aslogflush
>> 38 7000000b1a7a660 7000000b0adf148 1 sleeping secs: 125 1cpu btscanner_0
>> 60 7000000b211c928 7000000b0ae09d8 3 sleeping secs: 1 1cpu* onmode_mon
>> 61 7000000b211cb88 7000000b0ae01a8 3 sleeping secs: 1 1cpu periodic
>> 62 7000000b257e028 0 3 IO Idle 4cpu* kaio
>> 67 7000000b23ec418 7000000b0ae1a38 1 sleeping secs: 10 1cpu dbScheduler
>> 69 7000000b2337028 7000000b0ae1208 1 sleeping forever 3cpu dbWorker1
>> 70 7000000b2373568 7000000b0ae2268 1 sleeping forever 1cpu dbWorker2
>> 73 7000000b21c5148 0 3 IO Idle 6cpu* kaio
>> 76 7000000b21c55e8 0 3 IO Idle 7cpu* kaio
>> 77 7000000b21c5ad8 7000000b0adf978 1 cond wait bp_cond 1cpu bf_priosweep()
>> 78 7000000b22131e8 0 3 IO Idle 5cpu* kaio
>> 87 7000000b5fd5550 0 3 IO Idle 9cpu* kaio
>> 93 7000000b5fd5bc8 0 3 IO Idle 8cpu* kaio
>> * 129 7000000b241a930 7000000b0ae3af8 1 IO Wait 3cpu ontape*
>>
>> IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 02:45:14 --
>> 3142096 Kbytes
>>
>> Stack for thread: 129 ontape
>> base: 0x07000000b603d000
>>
>> len: 135168
>>
>> pc: 0x00000001000429b0
>>
>> tos: 0x07000000b605a3b0
>> state: sleeping
>>
>> vp: 3
>>
>> 0x00000001000429b0 (oninit)yield_processor_mvp
>> 0x000000010004d400 (oninit)mt_yield
>> 0x00000001000d1798 (oninit)mt_aio_wait
>> 0x00000001000d1cb0 (oninit)mt_aio_start
>> 0x00000001001e8268 (oninit)chunkio_int
>> 0x00000001001e5ea8 (oninit)chunkio
>> 0x00000001001ea52c (oninit)physio
>> 0x00000001001ef024 (oninit)buffget
>> 0x00000001001978c0 (oninit)pthdrgetx
>> 0x000000010019cf80 (oninit)ptalloc
>> 0x0000000100348664 (oninit)nxtpartp
>> 0x0000000100345898 (oninit)prptnhdr
>> 0x000000010033e064 (oninit)pstread
>> 0x0000000100327288 (oninit)pst_rsread
>> 0x00000001003306e8 (oninit)rsread
>> 0x00000001004500fc (oninit)fmread
>> 0x00000001007e811c (oninit)readseq
>> 0x00000001007e883c (oninit)gettupl
>> 0x00000001007ebc78 (oninit)scan_next
>> 0x000000010089d57c (oninit)hjoin_open
>> 0x0000000100bf41d0 (oninit)group_open
>> 0x0000000100551718 (oninit)prepselect
>> 0x0000000100458130 (oninit)excommand
>> 0x000000010041c464 (oninit)sq_exselect
>> 0x00000001002187a0 (oninit)sqmain
>> 0x0000000100578b50 (oninit)listen_verify
>> 0x0000000100577294 (oninit)spawn_thread
>> 0x0000000100d0f93c (oninit)startup
>>
>> tid name rstcb flags curstk status
>> 129 ontape 7000000b0ae3af8 Y--PR-M 12720 cond wait pt_448a8d -
>>
>> Memory pools count 2
>> name class addr totalsize freesize #allocfrag #freefrag
>> 92 V 7000000b2307040 229376 19480 293 27
>> 92*O0 V 7000000b5fe9040 4096 808 1 1
>>
>> name free used name free used
>> overhead 0 6576 mtmisc 0 144
>> scb 0 144 opentable 0 7752
>> filetable 0 1936 ru 0 600
>> log 0 16536 temprec 0 2208
>> keys 0 208 ralloc 0 128072
>> gentcb 0 1584 ostcb 0 3400
>> sort 0 104 sqscb 0 21696
>> sql 0 72 hashfiletab 0 552
>> osenv 0 3376 buft_buffer 0 4216
>> sqtcb 0 10760 fragman 0 776
>> shmblklist 0 704 udr 0 1768
>>
>> sqscb info
>> scb sqscb optofc pdqpriority sqlstats optcompind directives
>> 7000000b24e9110 7000000b274c028 0 0 0 0 1
>>
>> Sess SQL Current Iso Lock SQL ISAM F.E.
>> Id Stmt type Database Lvl Mode ERR ERR Vers Explain
>> 92 SELECT sysmaster RR Wait 300 0 0 9.24 Off
>>
>> Current SQL statement :
>>
>> select ( sum ( npused ) ) from sysdbspaces as D , sysptnhdr as P where D
>>
>> .. dbsnum = TRUNC ( P . partnum/ 1048576 ) and name = ?
>>
>> Host variables :
>>
>> address type flags value
>>
>> -----------------------------------------
>>
>> 0x07000000b5a2d268 CHAR 0x000 db11_13trnr
>>
>> Last parsed SQL statement :
>>
>> select ( sum ( npused ) ) from sysdbspaces as D , sysptnhdr as P where D
>>
>> .. dbsnum = TRUNC ( P . partnum/ 1048576 ) and name = ?
>>
>> mpm13trnr_prodappl(ifx/ifx) /tmp> more sqexplain.out
>>
>> QUERY: (OPTIMIZATION TIMESTAMP: 02-22-2011 13:58:12)
>> ------
>> select ( sum ( npused ) ) from sysdbspaces as D , sysptnhdr as P where
>> D.dbsnum = TRUNC ( P.partnum/1048576 ) and name = "de07_13trnr"
>>
>> Estimated Cost: 30
>> Estimated # of Rows Returned: 1
>>
>> 1) ifx.d: INDEX PATH
>>
>> Filters: ifx.d.name = 'de07_13trnr'
>>
>> (1) Index Name: informix.sysdbstab_dbsnum
>>
>> Index Keys: dbsnum
>>
>> Lower Index Filter: ifx.d.dbsnum> 0
>>
>> 2) ifx.p: SEQUENTIAL SCAN
>>
>> DYNAMIC HASH JOIN
>>
>> Dynamic Hash Filters: ifx.d.dbsnum = trunc(ifx.p.partnum / 1048576 )
>>
>> UDRs in query:
>> --------------
>>
>> UDR id : 386
>>
>> UDR name: bitval
>>
>> UDR id : 386
>>
>> UDR name: bitval
>>
>> UDR id : 386
>>
>> UDR name: bitval
>>
>> UDR id : 386
>>
>> UDR name: bitval
>>
>> *Khaled Bentebal
>>
>> Email: khaled.bentebal@consult-ix.fr*
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>

*******************************************************************************
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.