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

IIUG on Facebook IIUG on Twitter

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

IDS Forum

Re: Help with disk space

Posted By: Víctor Fabián Miramontes
Date: Saturday, 12 May 2007, at 1:58 p.m.

In Response To: Re: Help with disk space (Esteban Casuscelli)

Mr Casuscelli,

¿ Cómo anda ? o mejor dicho ¿ Dónde ? jajaja

Yo acá estoy, me pasé al lado oscuro. Estoy en IBM.
Pero yo solo no, el gordito Outeiro también se pasó.

Pero estamos en el Global Delivery en la parte de Unix.

Bueno, me alegro de escuchar de vos y aprovecho para
mandarte un abrazo grande.

Saludos,
Víctor

----- Mensaje original ----
De: Esteban Casuscelli <estebanc00@yahoo.com.ar>
Para: ids@iiug.org
Enviado: viernes 11 de mayo de 2007, 18:36:29
Asunto: Re: Help with disk space [9133]

OK,

para liberar espacio fisico con informix la unica forma es borrar el chunk or
el dbspace. Sino el espacio va a seguir tomado por informix.

Asi que podes borrar chunks of dbspaces. Fijate que los chunks o dbspaces
tienen que estar vacios para poder borrarlos. Pero la cosa es nunca los vas a
ver completamente vacios porque ciertas estructuras internas consumen un poco
de espacio en cada chunk.

Si el chunk o dbspace tiene tablas primero vas a tener que mover o borrar esas
tablas.

Avisame si se entiendo lo que digo o no.

esteban.-

----- Mensaje original ----
De: rguevara <rguevara@mcanet.com.ar>
Para: ids@iiug.org
Enviado: viernes 11 de mayo de 2007, 20:02:24
Asunto: Re: Help with disk space [9132]

Te mando el onstat -d

IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 23 days 04:02:54
-- 3382272 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
2ae890e80 1 0x40001 1 1 N B informix rootdbs
2afb2c510 2 0x40001 2 1 N B informix physdbs
2afb2c6a0 3 0x40001 3 1 N B informix logdbs
2afb2c830 4 0x40001 4 1 N B informix generaldbs
2afb2c9c0 5 0x40001 5 2 N B informix admingraldbs
2afb2cb50 6 0x40001 6 4 N B informix forumdbs
2afb2cce0 7 0x40001 7 1 N B informix estadisdbs
2afb2ce70 8 0x40001 8 3 N B informix admindbs
2afb2d030 9 0x40001 9 1 N B informix idxestadisdbs
2afb2d1c0 10 0x40001 10 2 N B informix idxforumdbs
2afb2d350 11 0x40001 11 2 N B informix idxadmindbs
2afb2d4e0 12 0x40001 12 2 N B informix salariumdbs
2afb2d670 13 0x42001 14 1 N TB informix tempdbs01
2afb2d800 14 0x42001 15 1 N TB informix tempdbs02
2afb2d990 15 0x42001 16 1 N TB informix tempdbs03
2afb2db20 16 0x42001 17 1 N TB informix tempdbs04
16 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
2ae891030 1 1 0 500000 497304 PO-B /dev/chunks/rootchk.00
2ae891a70 2 2 0 500000 243947 PO-B /dev/chunks/physchk.00
2ae891c10 3 3 0 1000000 499947 PO-B /dev/chunks/logchk.00
2ae891db0 4 4 0 2000000 448067 PO-B /dev/chunks/generalchk.00
2afb28030 5 5 0 2000000 19 PO-B /dev/chunks/admingralchk.00
2afb281d0 6 6 0 8000000 29 PO-B /dev/chunks/forumchk.00
2afb28370 7 7 0 8000000 2611371 PO-B /dev/chunks/estadischk.00
2afb28510 8 8 0 12000000 8 PO-B /dev/chunks/adminchk.00
2afb286b0 9 9 0 6000000 2324073 PO-B /dev/chunks/idxestadischk.00
2afb28850 10 10 0 6000000 38 PO-B /dev/chunks/idxforumchk.00
2afb289f0 11 11 0 8000000 3 PO-B /dev/chunks/idxadminchk.00
2afb28b90 12 12 0 8000000 6786319 PO-B /dev/chunks/salariumchk.00
2afb28d30 13 8 0 8000000 0 PO-B /dev/chunks/adminchk.01
2afb29030 14 13 0 1000000 992397 PO-B /datos/chunks/tempchk01.00
2afb291d0 15 14 0 1000000 992397 PO-B /datos/chunks/tempchk02.00
2afb29370 16 15 0 1000000 992397 PO-B /datos/chunks/tempchk03.00
2afb29510 17 16 0 1000000 992397 PO-B /datos/chunks/tempchk04.00
2afb296b0 18 6 0 8000000 0 PO-B /datos/chunks/forumchk.01
2afb29850 19 10 0 8000000 342215 PO-B /datos/chunks/idxforumchk.01
2afb299f0 20 6 0 8000000 0 PO-B /datos/chunks/forumchk.02
2afb29b90 21 5 0 2000000 708176 PO-B /datos/chunks/admingralchk.01
2afb29d30 22 8 0 8000000 821272 PO-B /datos/chunks/adminchk.02
2afb2c030 23 11 0 8000000 5314503 PO-B /datos/chunks/idxadminchk.01
2afb2c1d0 24 12 0 8000000 4671688 PO-B /datos/chunks/salariumchk.01
2afb2c370 25 6 0 2500000 0 PO-B /datos/chunks/forumchk.03
25 active, 32766 maximum

Expanded chunk capacity mode: always

Y ademas te mando el resultado del script que circula por todos lados para
mostrar mas claro los dbspaces:

[informix@server informix]$ ./espacio.sh
Dbspace Ck Size(Kb) Libre(Kb) Usado(Kb) Usado[%]
============= === ========== ========== ========== ========
rootdbs 1 2000000 1989216 10784 0.54%
physdbs 1 2000000 975788 1024212 51.21%
logdbs 1 4000000 1999788 2000212 50.01%
generaldbs 1 8000000 1792268 6207732 77.60%
admingraldbs 2 16000000 2832780 13167220 82.30%
forumdbs 4 106000000 116 105999884 100.00%
estadisdbs 1 32000000 10445484 21554516 67.36%
admindbs 3 112000000 3285120 108714880 97.07%
idxestadisdbs 1 24000000 9296292 14703708 61.27%
idxforumdbs 2 56000000 1369012 54630988 97.56%
idxadmindbs 2 64000000 21258024 42741976 66.78%
salariumdbs 2 64000000 45832028 18167972 28.39%
tempdbs01 1 4000000 3969588 30412 0.76%
tempdbs02 1 4000000 3969588 30412 0.76%
tempdbs03 1 4000000 3969556 30444 0.76%
tempdbs04 1 4000000 3969588 30412 0.76%
------------- --- ---------- ---------- ---------- --------
Totales (16): 25 506000000 116954236 389045764 76.89%

Roberto C. Guevara
--
Desarrollo de Sistemas
http://www.mcanet.com.ar

---------- Original Message -----------
From: Esteban Casuscelli <estebanc00@yahoo.com.ar>
To: rguevara@mcanet.com.ar
Sent: Thu, 10 May 2007 14:38:13 -0700 (PDT)
Subject: Re: Help with disk space [9123]

> Roberto,
>
> no se entiende bien lo que estas tratando de decir pero si es lo que estoy
pensando mandame un onstat -d y con eso respondo tu pregunta
>
> esteban.-
>
> ----- Mensaje original ----
> De: rguevara <rguevara@mcanet.com.ar>
> Para: ids@iiug.org
> Enviado: jueves 10 de mayo de 2007, 22:15:42
> Asunto: Help with disk space [9123]
>
> Hello, this it is my first post. We have a IDs9.4 running in aRedhat
> Enterprise, a disc of 116 Gb, memory 8 Gb.
> The problem is thatthe space that I have left is of 115 Mb, we we purified
> data, butchunks is not drained logically bony estan empty, but they
> continueoccupying space in the disc.
> There is some command to release thespace occupied by chunks empty?
>
> Greetings, and thank you very much
>
> Roberto C. Guevara
> --
> Desarrollo de Sistemas
> http://www.mcanet.com.ar
>
>

*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> __________________________________________________
> Preguntá. Respondé. Descubrí.
> Todo lo que querías saber, y lo que ni imaginabas,
> está en Yahoo! Respuestas (Beta).
> ¡Probalo ya!
> http://www.yahoo.com.ar/respuestas
------- End of Original Message -------

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas

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.