-----Original Message-----
From: MAILER-[Email address protected]
[mailto:MAILER-[Email address protected]
Sent: 25 October 2004 08:23
To: Les.[Email address protected]
Subject: failure notice
Hi. This is the qmail-send program at www.websitesondatabases.com.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.
<[Email address protected]
Sorry, no mailbox here by that name. (#5.1.1)
--- Below this line is a copy of the message.
Return-Path: <Les.[Email address protected]
Received: (qmail 31716 invoked from network); 25 Oct 2004 07:23:00 -0000
Received: from mail14.messagelabs.com (212.125.75.19)
by www.websitesondatabases.com with SMTP; 25 Oct 2004 07:23:00 -0000
X-VirusChecked: Checked
X-Env-Sender: Les.[Email address protected]
X-Msg-Ref: server-8.tower-14.messagelabs.com!1098689193!20742917
X-StarScan-Version: 5.2.10; banners=camelotgroup.co.uk,-,-
X-Originating-IP: [195.190.132.135]
Received: (qmail 5114 invoked from network); 25 Oct 2004 07:26:33 -0000
Received: from mail.camelotinteractive.com (HELO
msmsp001.camelotinteractive.com) (195.190.132.135)
by server-8.tower-14.messagelabs.com with SMTP; 25 Oct 2004 07:26:33 -0000
Received: (qmail 11719 invoked from network); 25 Oct 2004 07:27:06 -0000
Received: from unknown (HELO WATNTMSWEEP01.wat.camelot) (10.130.17.141)
by msmsp001.camelotinteractive.com with SMTP; 25 Oct 2004 07:27:06 -0000
Received: from watntm04.wat.camelot (unverified) by
WATNTMSWEEP01.wat.camelot
(Content Technologies SMTPRS 4.3.10) with ESMTP id
<[Email address protected] for
<[Email address protected] Mon, 25 Oct 2004 08:25:52 +0100
Received: by watntm04.wat.camelot with Internet Mail Service (5.5.2657.72)
id
<L25PYV7J>; Mon, 25 Oct 2004 08:27:15 +0100
Message-ID: <[Email Address Removed] Les Gray <Les.[Email address protected]
To: "'[Email address protected] <[Email address protected]
Subject: Monitor DB2 database growth
Date: Mon, 25 Oct 2004 08:25:35 +0100
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C4BA63.D1813110"
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4BA63.D1813110
Content-Type: text/plain
Hi
I'm new to DB2 - Can anyone supply me with a quick SQL statement to find the
size of DB2 database. The databases use both DMS and SMS defined
tablespaces?
Also has anybody good an SQL script that shows the locks associated with an
process rather like sp_lock in Sybase/MSQL environment ?
Thanks
Les Gray
**********************************************************************
The information contained in this e-mail may be confidential. It is intended
only for the use of the named recipient. If you are not the named recipient
please delete this e-mail. If you have received this e-mail and are not the
named recipient, any disclosure, reproduction, distribution or other
dissemination or use of the information contained in this e-mail is strictly
prohibited.
E-Mail transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required please
request a hard copy version.
Registered Office:
Camelot Group plc
Tolpits Lane
Watford
WD18 9RN
Tel : 01923 425000
Registered in England & Wales
No. 2822203
**********************************************************************
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
------_=_NextPart_001_01C4BA63.D1813110
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<html=20xmlns:o=3D"urn:schemas-microsoft-com:office:office"=20xmlns:w=3D"u=
rn:schemas-microsoft-com:office:word"=20xmlns:st1=3D"urn:schemas-microsoft=
-com:office:smarttags"=20xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META=20HTTP-EQUIV=3D"Content-Type"=20CONTENT=3D"text/html;=20charset=3Dus=
-ascii">
<meta=20name=3DProgId=20content=3DWord.Document>
<meta=20name=3DGenerator=20content=3D"Microsoft=20Word=2010">
<meta=20name=3DOriginator=20content=3D"Microsoft=20Word=2010">
<link=20rel=3DFile-List=20href=3D"cid:filelist.[Email address protected]
<o:SmartTagType=20namespaceuri=3D"urn:schemas-microsoft-com:office:smartta=
gs"
=20name=3D"PersonName"/>
<!--[if=20gte=20mso=209]><xml>
=20<o:OfficeDocumentSettings>
=20=20<o:DoNotRelyOnCSS/>
=20</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if=20gte=20mso=209]><xml>
=20<w:WordDocument>
=20=20<w:SpellingState>Clean</w:SpellingState>
=20=20<w:GrammarState>Clean</w:GrammarState>
=20=20<w:DocumentKind>DocumentEmail</w:DocumentKind>
=20=20<w:EnvelopeVis/>
=20=20<w:Compatibility>
=20=20=20<w:BreakWrappedTables/>
=20=20=20<w:SnapToGridInCell/>
=20=20=20<w:WrapTextWithPunct/>
=20=20=20<w:UseAsianBreakRules/>
=20=20</w:Compatibility>
=20=20<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
=20</w:WordDocument>
</xml><![endif]--><!--[if=20!mso]>
<style>
st1\:*{behavior:url(#default#ieooui)=20}
</style>
<![endif]-->
<style>
<!--
=20/*=20Style=20Definitions=20*/
=20p.MsoNormal,=20li.MsoNormal,=20div.MsoNormal
=09{mso-style-parent:"";
=09margin:0cm;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times=20New=20Roman";
=09mso-fareast-font-family:"Times=20New=20Roman";
=09mso-ansi-language:EN-GB;}
a:link,=20span.MsoHyperlink
=09{color:blue;
=09text-decoration:underline;
=09text-underline:single;}
a:visited,=20span.MsoHyperlinkFollowed
=09{color:purple;
=09text-decoration:underline;
=09text-underline:single;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09mso-style-noshow:yes;
=09mso-ansi-font-size:10.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:Arial;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:windowtext;}
span.SpellE
=09{mso-style-name:"";
=09mso-spl-e:yes;}
span.GramE
=09{mso-style-name:"";
=09mso-gram-e:yes;}
@page=20Section1
=09{size:612.0pt=20792.0pt;
=09margin:72.0pt=2090.0pt=2072.0pt=2090.0pt;
=09mso-header-margin:35.4pt;
=09mso-footer-margin:35.4pt;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
-->
</style>
<!--[if=20gte=20mso=2010]>
<style>
=20/*=20Style=20Definitions=20*/=20
=20table.MsoNormalTable
=09{mso-style-name:"Table=20Normal";
=09mso-tstyle-rowband-size:0;
=09mso-tstyle-colband-size:0;
=09mso-style-noshow:yes;
=09mso-style-parent:"";
=09mso-padding-alt:0cm=205.4pt=200cm=205.4pt;
=09mso-para-margin:0cm;
=09mso-para-margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:10.0pt;
=09font-family:"Times=20New=20Roman";}
</style>
<![endif]-->
</head>
<body=20lang=3DEN-US=20link=3Dblue=20vlink=3Dpurple=20style=3D'tab-interva=
l:36.0pt'>
<div=20class=3DSection1>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'>Hi=20<o:p></o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'>I'm=20new=20to=20DB2=20-=20Can=20anyone=20supply=
=20me
with=20a=20quick=20SQL=20statement=20to=20find=20the=20size=20of=20DB2=20d=
atabase.=20The=20databases=20use
both=20DMS=20and=20SMS=20defined=20<span=20class=3DSpellE>tablespaces</spa=
n>?=20<o:p></o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'>Also=20has=20anybody=20good=20an=20SQL=20script=20
=
that=20shows=20the
locks=20associated=20with=20an=20process=20rather=20like=20<span=20class=3D=
SpellE>sp_lock</span>=20<span
class=3DGramE>in<span=20style=3D'mso-spacerun:yes'> =20</span>Sybase<=
/span>/MSQL=20environment
?<o:p></o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'>Thanks<o:p></o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p=20class=3DMsoNormal><font=20size=3D2=20face=3DArial><span=20lang=3DEN-G=
B=20style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p=20class=3DMsoNormal><st1:PersonName><font=20size=3D2=20face=3DArial><sp=
an=20lang=3DEN-GB
=20style=3D'font-size:10.0pt;font-family:Arial'>Les=20Gray</span></font></=
st1:PersonName><font
size=3D2=20face=3DArial><span=20lang=3DEN-GB=20style=3D'font-size:10.0pt;f=
ont-family:Arial'><o:p></o:p></span></font></p>
</div>
<FONT=20SIZE=3D3><BR>
<BR>
**********************************************************************<BR>=
The=20information=20contained=20in=20this=20e-mail=20may=20be=20confidenti=
al.=20It=20is=20intended<BR>
only=20for=20the=20use=20of=20the=20named=20recipient.=20If=20you=20are=20=
not=20the=20named=20recipient<BR>
please=20delete=20this=20e-mail.=20If=20you=20have=20received=20this=20e-m=
ail=20and=20are=20not=20the<BR>
named=20recipient,=20any=20disclosure,=20reproduction,=20distribution=20or=
=20other<BR>
dissemination=20or=20use=20of=20the=20information=20contained=20in=20this=20
=
e-mail=20is=20strictly<BR>
prohibited.<BR>
E-Mail=20transmission=20cannot=20be=20guaranteed=20to=20be=20secure=20or=20=
error=20free=20as<BR>
information=20could=20be=20intercepted,=20corrupted,=20lost,=20destroyed,=20
=
arrive=20late=20or<BR>
incomplete,=20or=20contain=20viruses.=20The=20sender=20therefore=20does=20=
not=20accept=20<BR>
liability=20for=20any=20errors=20or=20omissions=20in=20the=20contents=20of=
=20this=20message=20which=20<BR>
arise=20as=20a=20result=20of=20e-mail=20transmission.=20If=20verification=20
=
is=20required=20please<BR>
request=20a=20hard=20copy=20version.=20<BR>
Registered=20Office:<BR>
Camelot=20Group=20plc<BR>
Tolpits=20Lane<BR>
Watford<BR>
WD18=209RN<BR>
Tel=20:=2001923=20425000<BR>
Registered=20in=20England=20&=20Wales<BR>
No.=202822203<BR>
**********************************************************************<BR>=
</FONT>
<BR>
________________________________________________________________________<B=
R>
This=20e-mail=20has=20been=20scanned=20for=20all=20viruses=20by=20Star.=20=
The<BR>
service=20is=20powered=20by=20MessageLabs.=20For=20more=20information=20on=
=20a=20proactive<BR>
anti-virus=20service=20working=20around=20the=20clock,=20around=20the=20gl=
obe,=20visit:<BR>
<A=20
href=3Dhttp://www.star.net.uk>
http://www.star.net.uk</A><BR>
________________________________________________________________________<B=
R>
</body>
</html>
------_=_NextPart_001_01C4BA63.D1813110--
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
**********************************************************************
The information contained in this e-mail may be confidential. It is intended
only for the use of the named recipient. If you are not the named recipient
please delete this e-mail. If you have received this e-mail and are not the
named recipient, any disclosure, reproduction, distribution or other
dissemination or use of the information contained in this e-mail is strictly
prohibited.
E-Mail transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required please
request a hard copy version.
Registered Office:
Camelot Group plc
Tolpits Lane
Watford
WD18 9RN
Tel : 01923 425000
Registered in England & Wales
No. 2822203
**********************************************************************
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
DB2 & UDB email list listserv db2-l LazyDBA home page