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: DB space usage

Posted By: Art Kagel
Date: Tuesday, 29 September 2009, at 11:06 p.m.

In Response To: DB space usage (DEEPAK JOSHI)

Advise you about what?

Here's a query that will give you totals by dbspace:

select name as dbspace, sum(chksize) * 2 as size_kb, sum(nfree) * 2 as
free_kb
from sysmaster:sysdbspaces sd, sysmaster:syschunks sc
where sd.dbsnum = sc.dbsnum
group by 1
order by 1, 3 ASC;

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

On Tue, Sep 29, 2009 at 4:37 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:

> Can anybody look at the output and let me know and advice me.
>
> INFORMIX-OnLine Version 7.13.UC6 -- On-Line -- Up 1 days 18:13:14 -- 953176
> Kbytes
>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 800300e8 1 1 1 1 N informix rootdbs
> 8005dfa8 2 1 2 1 N informix logsdbs
> 80361018 3 1 3 2 N informix standarddbs
> 80361080 4 1 4 2 N informix bestlockdbs
> 803610e8 5 1 5 18 N informix sabledbs_0
> 80361150 6 1 6 13 N informix sabledbs_1
> 803611b8 7 1 7 12 N informix sabledbs_2
> 80361220 8 1 8 10 N informix sabledbs_3
> 80361288 9 2001 9 2 N T informix sabledbs_temp0
> 803612f0 10 1 10 12 N informix sabledbs_4
> 80361358 11 1 61 2 N informix sabledbs_5
> 803613c0 12 1 63 3 N informix sabledbs_6
> 12 active, 2047 maximum
>
> Chunks
> address chk/dbs offset size free bpages flags pathname
> 80030150 1 1 488 122070 115659 PO- /informix/rootdb
> 80030228 2 2 488 244141 1088 PO- /dev/vg01/rlogsdb
> 80030300 3 3 488 24414 6 PO- /dev/vg03/rstandb
> 800303d8 4 4 488 24414 7684 PO- /dev/vg03/rbestdb
> 800304b0 5 5 488 488281 78 PO- /dev/vg02/rsabledb0
> 80030588 6 6 488 729574 19 PO- /dev/vg02/rsabledb1
> 80030660 7 7 488 488281 5 PO- /dev/vg03/rsabledb2
> 80030738 8 8 488 729574 200 PO- /dev/vg02/rsabledb3
> 80030810 9 9 488 122070 117649 PO- /dev/vg01/rtempdb0
> 800308e8 10 10 488 729574 0 PO- /dev/vg02/rsabledb4
> 800309c0 11 7 488769 244140 3 PO- /dev/vg03/rsabledb2
> 80030a98 12 3 24902 24414 0 PO- /dev/vg03/rstandb
> 80030b70 13 4 24902 24414 24411 PO- /dev/vg03/rbestdb
> 80030c48 14 5 488769 244140 4 PO- /dev/vg02/rsabledb0
> 80030d20 15 5 732909 97656 4 PO- /dev/vg02/rsabledb0
> 80030df8 16 6 730062 97656 0 PO- /dev/vg02/rsabledb1
> 80030ed0 17 7 732909 97656 0 PO- /dev/vg03/rsabledb2
> 80030fa8 18 8 730062 97656 18 PO- /dev/vg02/rsabledb3
> 80031080 19 10 730062 97656 0 PO- /dev/vg02/rsabledb4
> 80031158 20 5 830565 122070 0 PO- /dev/vg02/rsabledb0
> 80031230 21 6 830565 61035 0 PO- /dev/vg02/rsabledb1
> 80031308 22 6 891600 61035 0 PO- /dev/vg02/rsabledb1
> 800313e0 23 10 827718 97656 0 PO- /dev/vg02/rsabledb4
> 800314b8 24 8 827718 97656 32 PO- /dev/vg02/rsabledb3
> 80031590 25 7 830565 122070 0 PO- /dev/vg03/rsabledb2
> 80031668 26 6 488 122070 0 PO- /dev/vg03/rsabledb5
> 80031740 27 10 122558 122070 0 PO- /dev/vg03/rsabledb5
> 80031818 28 8 244628 122070 0 PO- /dev/vg03/rsabledb5
> 800318f0 29 8 366698 122070 25 PO- /dev/vg03/rsabledb5
> 800319c8 30 5 488768 122070 2 PO- /dev/vg03/rsabledb5
> 80031aa0 31 7 610838 122070 0 PO- /dev/vg03/rsabledb5
> 80031b78 32 10 732908 122070 0 PO- /dev/vg03/rsabledb5
> 80031c50 33 6 854978 24414 0 PO- /dev/vg03/rsabledb5
> 80031d28 34 6 488 120117 0 PO- /dev/vg02/rsabledb6
> 80031e00 35 7 488 122070 0 PO- /dev/vg05/rlvol6
> 80031ed8 36 10 122558 122070 0 PO- /dev/vg05/rlvol6
> 80053a28 37 5 488 122070 0 PO- /dev/vg05/rlvol7
> 80053b00 38 5 244628 122070 0 PO- /dev/vg05/rlvol6
> 80053bd8 39 6 366698 122070 0 PO- /dev/vg05/rlvol6
> 80053cb0 40 8 488768 122070 0 PO- /dev/vg05/rlvol6
> 80053d88 41 5 122558 122070 0 PO- /dev/vg05/rlvol7
> 80053e60 42 10 244628 122070 0 PO- /dev/vg05/rlvol7
> 80053f38 43 7 366698 122070 3 PO- /dev/vg05/rlvol7
> 8005d228 44 5 488 122070 0 PO- /dev/vg05/rlvol8
> 8005d300 45 6 122558 122070 0 PO- /dev/vg05/rlvol8
> 8005d3d8 46 8 244628 122070 0 PO- /dev/vg05/rlvol8
> 8005d4b0 47 10 366698 122070 0 PO- /dev/vg05/rlvol8
> 8005d588 48 7 488768 122070 0 PO- /dev/vg05/rlvol8
> 8005d660 49 5 610838 122070 0 PO- /dev/vg05/rlvol8
> 8005d738 50 6 732908 122070 0 PO- /dev/vg05/rlvol8
> 8005d810 51 10 488768 122070 0 PO- /dev/vg05/rlvol7
> 8005d8e8 52 5 610838 122070 2 PO- /dev/vg05/rlvol7
> 8005d9c0 53 8 732908 122070 0 PO- /dev/vg05/rlvol7
> 8005da98 54 7 854978 122070 0 PO- /dev/vg05/rlvol7
> 8005db70 55 5 610838 122070 0 PO- /dev/vg05/rlvol6
> 8005dc48 56 8 732908 122070 0 PO- /dev/vg05/rlvol6
> 8005dd20 57 10 854978 122070 0 PO- /dev/vg05/rlvol6
> 8005ddf8 58 5 488 122070 0 PO- /dev/vg05/rlvol1
> 8005ded0 59 7 122558 122070 0 PO- /dev/vg05/rlvol1
> 80360010 60 10 244628 122070 0 PO- /dev/vg05/rlvol1
> 803600e8 61 11 488 976560 3 PO- /dev/vg06/rlvol1
> 803601c0 62 11 488 976560 140066 PO- /dev/vg06/rlvol2
> 80360298 63 12 488 976560 3 PO- /dev/vg06/rlvol3
> 80360370 64 12 488 976560 228 PO- /dev/vg06/rlvol4
> 80360448 65 5 854978 121092 0 PO- /dev/vg05/rlvol8
> 80360520 66 6 366698 122070 0 PO- /dev/vg05/rlvol1
> 803605f8 67 5 488768 122070 0 PO- /dev/vg05/rlvol1
> 803606d0 68 7 610838 122070 0 PO- /dev/vg05/rlvol1
> 803607a8 69 5 0 1024000 0 PO- /dev/vg06/rlvol5
> 80360880 70 5 0 1024000 0 PO- /dev/vg06/rlvol6
> 80360958 71 5 0 1024000 739817 PO- /dev/vg06/rlvol7
> 80360a30 72 10 0 1024000 297299 PO- /dev/vg06/rlvol8
> 80360b08 73 6 0 512000 0 PO- /dev/vg05/rsabledb7
> 80360be0 74 6 512001 511999 40366 PO- /dev/vg05/rsabledb7
> 80360cb8 75 9 244 128500 128497 PO- /dev/vg01/rtempdb1
> 80360d90 76 7 0 1024000 641452 PO- /dev/vg05/rsabledb8
> 80360e68 77 12 0 500000 146541 PO- /dev/vg05/rsabledb9
> 80360f40 78 8 500001 524000 273873 PO- /dev/vg05/rsabledb9
> 78 active, 2047 maximum
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0023545bf5485502510474c2d2ab

Messages In This Thread

  • DB space usage
    DEEPAK JOSHI -- Tuesday, 29 September 2009, at 4:37 p.m.
    • RE: DB space usage
      Stuart McCann -- Tuesday, 29 September 2009, at 9:55 p.m.
    • Re: DB space usage
      Art Kagel -- Tuesday, 29 September 2009, at 11:06 p.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.