Judy,
There is also a AIX script on the User Group Website that uses
column attributes to calculate row length for determining the amount of Disk
Space that tables are using:
http://people.mn.mediaone.net/scottrmcleod/diskspce.txt
Hope it helps!
----------------------------------
> From: [EMAIL PROTECTED]
> Subject: How to determine size of database in UDB?
> Date: Mon, 2 Jul 2001 10:19:55 -0500
> MIME-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Disposition: inline
>
>
>
> 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
>
>
>
>
> --------------- MESSAGE db2eug.v002.n110.2 ---------------
>
> From: "Sinha, Abhijit" <[EMAIL PROTECTED]>
> Subject: RE: DB2EUG: How to determine size of database in UDB?
> Date: Mon, 2 Jul 2001 12:17:01 -0400
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> 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
>
>
> --------------- MESSAGE db2eug.v002.n110.3 ---------------
>
> From: "Sinha, Abhijit" <[EMAIL PROTECTED]>
> Subject: RE: DB2EUG: How to determine size of database in UDB?
> Date: Mon, 2 Jul 2001 12:17:01 -0400
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> 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
>
>
> --------------- MESSAGE db2eug.v002.n110.4 ---------------
>
> From: [EMAIL PROTECTED]
> Subject: RE: DB2EUG: How to determine size of database in UDB?
> Date: Mon, 2 Jul 2001 11:58:46 -0500
> MIME-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Disposition: inline
>
>
>
> 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
>
>
>
>
>
>
> --------------- MESSAGE db2eug.v002.n110.5 ---------------
>
> From: "Pav Kumar-Chatterjee" <[EMAIL PROTECTED]>
> Subject: Re: DB2EUG: How to determine size of database in UDB?
> Date: Mon, 02 Jul 2001 19:48:34 -0000
> MIME-Version: 1.0
> Content-Type: text/plain; format=flowed
>
> Hi Judy
>
> If you have the control center working on NT monitoring your AIX system,
> then if you click on the tablespace folder (under the database name)and
> scroll right in the right hand panel, then you can see whether your
> tablespaces are SMS or DMS and how much space they have allocated/are
> using.
> This might be a little on the "manual" side, but it depends on how many
> tablespaces you have and how often you have to report.
>
> HTH
>
> Pav
>
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: DB2EUG: How to determine size of database in UDB?
> >Date: Mon, 2 Jul 2001 10:19:55 -0500
> >
> >
> >
> >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
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
> --------------- MESSAGE db2eug.v002.n110.6 ---------------
>
> From: "Pav Kumar-Chatterjee" <[EMAIL PROTECTED]>
> Subject: Re: DB2EUG: How to determine size of database in UDB?
> Date: Mon, 02 Jul 2001 19:48:34 -0000
> MIME-Version: 1.0
> Content-Type: text/plain; format=flowed
>
> Hi Judy
>
> If you have the control center working on NT monitoring your AIX system,
> then if you click on the tablespace folder (under the database name)and
> scroll right in the right hand panel, then you can see whether your
> tablespaces are SMS or DMS and how much space they have allocated/are
> using.
> This might be a little on the "manual" side, but it depends on how many
> tablespaces you have and how often you have to report.
>
> HTH
>
> Pav
>
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: DB2EUG: How to determine size of database in UDB?
> >Date: Mon, 2 Jul 2001 10:19:55 -0500
> >
> >
> >
> >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
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
> --------------- MESSAGE db2eug.v002.n110.7 ---------------
>
> From: "Sinha, Amit" <[EMAIL PROTECTED]>
> Subject: SQL0995C - Sort memory cannot be allocated to process the stateme
> nt
> Date: Mon, 2 Jul 2001 18:28:14 -0500
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
>
> > Hi All,
> >
> > Recently, in one of our UDB 6.1 on AIX we are having sporadic prolems
> with
> > one of the queries in the application failing with SQL0995C Sort memory
> > cannot be allocated to process the statement.
> >
> > The explanation says Insufficient virtual memoy is available to the
> > database agent for sort processing.
> > User response : Terminate the application on receipt of this message.
> > Decrease the size of the sort heap parameter(sortheap) in the
> > corresponding database configuration file.
> >
> >
> > Was confused how would decreasing the sort memory would solve the
> problem
> > ? The UDB version 2 message reference manual says to increase the sort
> > heap parameter. So I am confused about which is right Version 5 and 6
> > message manual or version 2 manual.
> >
> > Thanks.
> >
> > Amit Sinha
>
>
> --------------- MESSAGE db2eug.v002.n110.8 ---------------
>
> From: "Vilas, Ajith (USPC.PCT.Hopewell)" <[EMAIL PROTECTED]>
> Subject: RE: DB2EUG: SQL0995C - Sort memory cannot be allocated to
> process the stateme nt
> Date: Tue, 3 Jul 2001 08:56:49 -0400
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset=iso-8859-1
> Content-Transfer-Encoding: 7bit
>
> Amit,
> If the sort heap cannot be allocated, your system don't have enough memory
> to start this agent (private heap). Algorithm will try for smaller sizes,
> if the sortheap size parameter size cannot be
> allocated and will finally get out throwing the message you got. So,
> reducing the sort heap will force all agents to allocate lesser sort heaps
> and you'll have room for more agents.
> Regards,
> Ajith
>
>
> -----Original Message-----
> From: Sinha, Amit [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 02, 2001 7:28 PM
> To: [EMAIL PROTECTED]
> Subject: DB2EUG: SQL0995C - Sort memory cannot be allocated to process
> the stateme nt
>
>
>
> > Hi All,
> >
> > Recently, in one of our UDB 6.1 on AIX we are having sporadic prolems
> with
> > one of the queries in the application failing with SQL0995C Sort memory
> > cannot be allocated to process the statement.
> >
> > The explanation says Insufficient virtual memoy is available to the
> > database agent for sort processing.
> > User response : Terminate the application on receipt of this message.
> > Decrease the size of the sort heap parameter(sortheap) in the
> > corresponding database configuration file.
> >
> >
> > Was confused how would decreasing the sort memory would solve the
> problem
> > ? The UDB version 2 message reference manual says to increase the sort
> > heap parameter. So I am confused about which is right Version 5 and 6
> > message manual or version 2 manual.
> >
> > Thanks.
> >
> > Amit Sinha
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
>
>
> --------------- MESSAGE db2eug.v002.n110.9 ---------------
>
> From: Daniel Scheibli <[EMAIL PROTECTED]>
> Subject: Re: DB2EUG: Open Source Project: Lib for processing the Snapshot
> output buffer
> Date: Tue, 3 Jul 2001 16:56:09 +0200 (MEST)
> MIME-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: 8bit
>
> Dear Paul,
>
> DbtuFpsLib is a framework for easy processing of the output buffer (the
> output buffer is the result of a db2GetSnapshot() call).
>
> If you take an snapshot with db2GetSnapshot() you have to do a lot of
> coding (since V5) to process the resulting informations. With DbtuFpsLib
> you call DbtuFps_BuildUp() which walks through the output buffer and
> builds up the FPS buffer. This buffer is much more formated and much
> easier to process -> this results in a minimum of coding for you. You
> can also use DbtuFpsLib to format the data for printing (also reduces
> the lines of code in your coding).
>
> About other UNIX? I think there is no real problem, I included an Makefile
> for solaris and an other guy tested it under AIX. You only have to change
> the linker parameters, compiler and DB2 path to suite your enviroment -
> thats it!
>
>
>
> Yours
> Daniel
>
>
> > -----Urspr�ngliche Nachricht-----
> > ...
> > What exactly is the point of DbtuFpsLib as compared to db2GetSnapshot.
> >
> > Now, my lack of UNIX knowledge will really stand out. You have this
> > on a Linux page, with a refrence to the GNU license. Would the library
> > work with AIX, HP-UX or other UNIX? Would it need any significant
> > modifications to work on the other UNIX'? If it needs any
> modifications,
> > what might they be?
> >
> > Daniel Scheibli wrote:
> >
> > > Dear list colleagues,
> > >
> > > today I would like to announce DbtuFpsLib an library
> > (including an sample
> > > implementation -> alternative LIST APPLICATIONS) which
> > helps you to process the
> > > output buffer of snapshots taken with UDB.
> > >
> > > The current status is, that the lib works, but not all
> > snapshot groups are
> > > implemented yet. I wanted to provide this lib as soon as possible.
> > >
> > > Download:
> > http://sites.inka.de/scheibli/private/daniel/html/s05c400m.htm
> > >
> > > Yours
> > > Daniel
> > >
> > > PS: I'am looking for a lot of feedback!
>
>
> --
> Daniel Scheibli
> Karlsruhe, Germany
>
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
> GMX Tipp:
>
> Machen Sie Ihr Hobby zu Geld bei unserem Partner 1&1!
> http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
>
>
>
> --------------- END db2eug.v002.n110 ---------------
>
>
> =====
> You are subscribed to the DB2EUG digest. To receive messages
> separately, send email to [EMAIL PROTECTED]
> containing the line: subsingle <your-email-address>
> To unsubscribe, send: unsubscribe <your-email-address>
*****************************************************************
DISCLAIMER: The information contained in this e-mail may be confidential
and is intended solely for the use of the named addressee. Access, copying
or re-use of the e-mail or any information contained therein by any other
person is not authorized. If you are not the intended recipient please
notify us immediately by returning the e-mail to the originator.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
