Judith, it will you the actual number of pages used, wether they have data in them or not. If you do a select on syscat.tables for tabname, FPAGES, NPAGES you'll get FPAGES=number of total pages used by the system to store the table. NPAGES=number of pages in the table that hold at least one row. (i.e.: it is conceivable that between reorgs, you delete all rows of page. This page is part of FPAGES but not NPAGES). Soeven if the page is not full it will tell you the actual physical space the table requires on the drive. HTH, Pierre. [EMAIL PROTECTED] a �crit : > Thanks for the reply Abhijit! I wonder, though. Won't that give me somewhat of > a skewed view of actual usage? That will show the number of pages with data on > them, but the whole page might not be full, right? > > "Sinha, Abhijit" <[EMAIL PROTECTED]> on 07/02/2001 11:17:01 AM > > Please respond to [EMAIL PROTECTED] > > > > To: [EMAIL PROTECTED] > > cc: (bcc: Judy Kibler/Nashville) > > > > Subject: RE: DB2EUG: How to determine size of database in > UDB? > > > Hi, > > >From the DB2 CLP, use the following command: > list tablespaces show detail. > You will get a list of the used pages. Just add them up. > > Abhijit > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 02, 2001 11:20 AM > To: [EMAIL PROTECTED] > Subject: DB2EUG: How to determine size of database in UDB? > > Hello all, > > I was wondering if someone could help an old mainframe DB2 DBA! We recently > migrated our DB2/390 v5.1 database to DB2 UDB for AIX v6.1. I have to > provide a > monthly report to management to show the actual size of the database. I > used to > calculate it as the sum of (reclength * card) for all tables in the database > (from SYSIBM.SYSTABLES). I just noticed that reclength is not included in > the > SYSCAT.TABLES table. Can someone point me in the right direction to show me > how > to report the actual size of the database in our new environment? > > Thanks, in advance, for your help! > > Judy > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
