Update statistics and distributions
Hi, When i run Update statistics medium on the database, the space in the Dbspaces is getting filled up. I want to know whether the distributions created during this are stored in the corresponding dbspaces of the tables. Bye.
Hi,
as far as I know, the data generated by update statistics is stored
in tables that belong to the system catalog, e.g. table sysdistribs.
Since the system catalog is created when you create the database,
update statistics data will go into the dbspace where the databaseresides. And this is true for all tables of this database, regardless
where the tables themselves reside.
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Data Management Solutions
forum.subscriber@iiug.org wrote on 12.01.2005 05:18:09:
> Hi,
> When i run Update statistics medium on the database, the
> space in the Dbspaces is getting filled up. I want to know
> whether the distributions created during this are stored
> in the corresponding dbspaces of the tables.
>
> Bye.
Make
sure, that your DBSPACETEMP is valid (flag T) and listed in ONCONFIG.
If not, a lot of work for building statistcs medium or high is done in
datadbs.
kalu
Martin Fuer.... wrote:
>Hi,
>
>as far as I know, the data generated by update statistics is stored
>in tables that belong to the system catalog, e.g. table sysdistribs.
>
>Since the system catalog is created when you create the database,
>update statistics data will go into the dbspace where the database>resides. And this is true for all tables of this database, regardless
>where the tables themselves reside.
>
>Regards,
>Martin
>--
>Martin Fuerderer
>IBM Informix Development Munich, Germany
>Data Management Solutions
>
>forum.subscriber@iiug.org wrote on 12.01.2005 05:18:09:
>
>
>
>>Hi,
>>When i run Update statistics medium on the database, the
>>space in the Dbspaces is getting filled up. I want to know
>>whether the distributions created during this are stored
>>in the corresponding dbspaces of the tables.
>>
>>Bye.
>>
>>
>
>
>
>
>
--0__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E
Content-type: multipart/alternative;
Boundary="1__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E"
--1__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
The distributions are stored in the system catalog table sysdistrib.
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
"PARAMESHWAR...." =
<pcdudyala@yahoo. =
com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Update statistics and distributi=ons
01/11/2005 09:18 [3991] =
PM =
=
=
=
=
=
Hi,
When i run Update statistics medium on the database, the space in the
Dbspaces is getting filled up. I want to know whether the distributions=
created during this are stored in the corresponding dbspaces of the tab=
les.
Bye.
=
--1__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>The distributions are stored in the system catalog table sysdistrib.=
<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "PARAMESHWAR..=
.." <pcdudyala@yahoo.com>">"PARAMESHWAR...." <p=
cdudyala@yahoo.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE51=
4DFC1573E8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"PARAMESHWAR...." <pcdudyala@yahoo=
.com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">01/11/2005 09:18 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE514DFC1573E8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Update statistics and distributions [3991]</font></td=
></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE514DFC1=
573E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE514DFC1573E8f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi,<br>
When i run Update statistics medium on the database, the space in the D=
bspaces is getting filled up. I want to know whether the distributions =
created during this are stored in the corresponding dbspaces of the tab=
les.<br>
<br>
<br>
Bye.<br>
<br>
</tt><br>
</body></html>=
--1__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E--
--0__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE514DFC1573E8f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=88BBE514DFC1573E8f9e8a93df938690918c88BBE514DFC1573E
Content-type: image/gif;
name="pic24934.gif"
Content-Disposition: inline; filename="pic24934.gif"
Content-ID: <20__=88BBE514DFC1573E8f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfU