Hi Charles,
I am sure this is a really stupid question. I have gone and gotten the script
you mentioned in your earlier email, but I can't seem to quite figure out what
is needed to make it work. I have changed a few things in the script that I
know needed to be changed to work in our environment here, but I don't
understand what is needed in the section of the script I am including below:
#------------------------------------------------------------------------------#
#-- Loop through each itteration of a local database name. --#
#------------------------------------------------------------------------------#
ALL_DB_ERRORS=false
. get.instance.names
for DB2INST in $DB2ILIST
do
. /db2_6000/$DB2INST/sqllib/db2profile >/dev/null 2>&1
echo "\nStarting Instance $DB2INST, Path $DB2IPATH"
.attach.to.instance
. get.database.names
ERRORS=false
for DBNAME in $LOCDBNAMES
do
RPTFILE="$DB2IPATH/spacereports/`echo $DBNAME | tr [':upper:']
[':lower:']` \
What are/where are the get.instance.names, attach.to.instance,
get.database.names routines, or are these just like comments where someone more
script
savvy knows to substitute other commands?! Can you point me in the right
direction?!
Many thanks,
Judy
Stoker Charles W <[EMAIL PROTECTED]> on 07/03/2001 11:45:16 AM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: (bcc: Judy Kibler/Nashville)
Subject: DB2EUG: RE: Digest db2eug.v002.n110
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
