by 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_01C1615B.2E48DD90
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
We are using Informix 7.31uc7xn on Solaris 8. I would like to clarify
about the "Next extent size" for any table on the "oncheck -pt <tabname>
output. Since we are using SAP R/3 on informix, we do use SAPDBA for our
Database maintenance.
Using SAPDBA, Iam trying to reduce a table's extent size due to our
temporary disk constraints issue.. The scenario is as follows.
1) Next extent size before changing - it was 600000 KB
2) Using SAPDBA, i'm trying 2 change the table's extent size to 300000 KB.
3) SAPDBAsays "Alter table successful".Its true that the table's next extent
size changed in system catalog table "systables" for that table
which iam altering to 300000 KB.
Note: Actually SAPDBA alter the table extent size in the same way as what
we used to do from DBACCESS for the above issue.
4) But if i use "oncheck -pt <tabname>",i still get the next extent size as
600000 KB.
5) Does Oncheck display table info retrieve from some other system table
apart from "systables" ?
6) If so,how do i rectify this problem ?
Please note that reducing next extent size for other tables using SAPDBA
works fine on PRD ,and even for this table on other servers such as DEV/QAS
using SAPDBA works fine but not on PRD.
Can anybody suggest me what could have gone wrong ?
Regards
Rajesh
314-322-3428 (Mobile)
314-493-7073 (Office)
314-439-9669 (Home)
------_=_NextPart_001_01C1615B.2E48DD90
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2><SPAN class=102054215-30102001>Hi,</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001> We are using
Informix 7.31uc7xn on Solaris 8. I would like to clarify about the "Next
extent size" for any table on the "oncheck -pt <tabname> output. Since we
are using SAP R/3 on informix, we do use SAPDBA for our Database
maintenance.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>Using SAPDBA, Iam trying
to reduce a table's extent size due to our temporary disk constraints
issue.. The scenario is as follows.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>1) Next extent size before
changing - it was 600000 KB</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>2) Using SAPDBA, i'm trying 2
change the table's extent size to 300000 KB.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>3) SAPDBAsays "Alter table
successful".Its true that the table's next extent size changed in system catalog
table "systables" for that table </SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001> which iam
altering to 300000 KB.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001> Note: Actually
SAPDBA alter the table extent size in the same way as what we used to do from
DBACCESS for the above issue.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>4) But if i use "oncheck -pt
<tabname>",i still get the next extent size as 600000
KB.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>5) Does Oncheck display table
info retrieve from some other system table apart from "systables"
?</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>6) If so,how do i rectify this
problem ?</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>Please note that reducing
next extent size for other tables </SPAN><SPAN
class=102054215-30102001>us</SPAN><SPAN class=102054215-30102001>i</SPAN><SPAN
class=102054215-30102001>ng SAPDBA works fine on PRD ,and even for this table on
other servers such as DEV/QAS using SAPDBA works fine but not on
PRD.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>Can anybody suggest me what
could have gone wrong ?</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001>Regards</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=102054215-30102001></SPAN>Rajesh<BR>314-322-3428
(Mobile)<BR>314-493-7073 (Office)<BR>314-439-9669 (Home) </FONT></DIV>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C1615B.2E48DD90--