Re[2]: dbschema and dbaccess different.

Message is sent with MIME. Attachments are base64 encoded --TFS-with-MIME-and-DIME Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Yes, I run update statistics every night=2E Another thing to throw in= to=20 the pot is that running a select on syscolumns ordering by colno=20 brings the columns out in dbschema order, but leaving the order by off= =20 brings them out in the dbaccess order=2E A bug in dbaccess perhaps? o= r=20 maybe corrupt indexes=2E Oncheck doesn't think the indexes are bad=20 though=2E =20 Davin ______________________________ Reply Separator ____________________________= _____ Subject: RE: dbschema and dbaccess different=2E Author: ConnD@StanGen=2Epix=2Eza at Internet Date: 7/7/97 5:38 AM =20 Message-ID: <c=3DUS%a=3D_%p=3DStanGen%l=3DJHBS02-970707090111Z-30465@jhbs01=2E= Stangen=2Epix=2E From: David Conn <ConnD@StanGen=2Epix=2Eza> Subject: RE: dbschema and dbaccess different=2E =20 Hi there =20 David Harvey Wrote> } >Hi all, } } >We are running Online 7=2E12=2EUC1 on AIX V4, and I have a table (po= ssibly=20 } >several), which has different columns as far as dbschema and } >dbaccess->Table->Info->Columns is concerned=2E Querying against } >syscolumns gets the columns in the dbschema order=2E What is wrong=20= with=20 } >dbaccess? Is my only option to dbexport and dbimport all the affect= ed=20 } >databases, as most of the databases here were onloaded from this } >corrupt one? } } >I've tried onchecking everything about the table, but no problems ar= e=20 } >ever reported=2E } } >Help! =20 Just a wild shot in the dark here but=2E=2E=2Ehave you run update statistic= s=20 lately? You do realize that system catalogues are not updated automatically? =20 Type the following in DBaccess and run it : =20 UPDATE STATISTICS =20 If the catalogues are really behind, then this will run for quite some=20 time : ) =20 Good luck =20 David } } }david@west=2Eco=2Eza }Senior Software Consultant }The West Solutions Group }Friends help you move=2E=2E=2EREAL friends help you move bodies!=20 } ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --TFS-with-MIME-and-DIME Content-Type: text/rtf; name="MSGCC.RTF" Content-transfer-encoding: base64 {\\rtf1\\ansi \\deff0\\deflang1024{\\fonttbl{\\f0\\froman Tms Rmn;}{\\f1\\froman Symbol;}{\\f2\\fswiss Helv;}} {\\colortbl;\\red0\\green0\\blue127;\\red0\\green127\\blue0;\\red0\\green127\\blue127;\\red127\\green0\\blue0; \\red127\\green0\\blue127;\\red127\\green127\\blue0;\\red127\\green127\\blue127;;\\red0\\green0\\blue255; \\red0\\green255\\blue0;\\red0\\green255\\blue255;\\red255\\green0\\blue0;\\red255\\green0\\blue255; \\red255\\green255\\blue0;\\red255\\green255\\blue255;}\\paperw12240\\paperh15840\\margl1800\\margr1800\\margt1440\\margb1440 \\gutter0 \\defformat\\sectd \\pard\\plain {\\plain \\f0 \\cb7 \\cf0 \\cb7 \\cf0 \\cb1 \\cf14 Yes, I run update statistics every night. Another thing to throw into \\ \\cb7 \\cf0 \\cb1 \\cf14 the pot is that running a select on syscolumns ordering by colno \\ \\cb7 \\cf0 \\cb1 \\cf14 brings the columns out in dbschema order, but leaving the order by off \\ \\cb7 \\cf0 \\cb1 \\cf14 brings them out in the dbaccess order. A bug in dbaccess perhaps? or \\ \\cb7 \\cf0 \\cb1 \\cf14 maybe corrupt indexes. Oncheck doesn't think the indexes are bad \\ \\cb7 \\cf0 \\cb1 \\cf14 though.\\ \\cb7 \\cf0 \\ \\cb7 \\cf0 \\cb1 \\cf14 Davin\\ \\ \\ \\cb7 \\cf0 ______________________________ Reply Separator _________________________________\\ \\cb7 \\cf0 Subject: RE: dbschema and dbaccess different.\\ \\cb7 \\cf0 Author: ConnD@StanGen.pix.za at Internet\\ \\cb7 \\cf0 Date: 7/7/97 5:38 AM\\ \\ \\ \\cb7 \\cf0 \\ \\cb7 \\cf8 Message-ID: <c=US%a=_%p=StanGen%l=JHBS02-970707090111Z-30465@jhbs01.Stangen.pix.\\ \\cb7 \\cf8 From: David Conn <ConnD@StanGen.pix.za>\\ \\cb7 \\cf8 Subject: RE: dbschema and dbaccess different.\\ \\cb7 \\cf0 \\ \\cb7 \\cf0 Hi there\\ \\cb7 \\cf0 \\ \\cb7 \\cf0 \\cb7 \\cf0 David Harvey Wrote>\\ \\cb7 \\cf0 \\} >Hi all,\\ \\cb7 \\cf0 \\}\\ \\cb7 \\cf0 \\} >We are running Online 7.12.UC1 on AIX V4, and I have a table (possibly \\ \\cb7 \\cf0 \\} >several), which has different columns as far as dbschema and\\ \\cb7 \\cf0 \\} >dbaccess->Table->Info->Columns is concerned. Querying against\\ \\cb7 \\cf0 \\} >syscolumns gets the columns in the dbschema order. What is wrong with \\ \\cb7 \\cf0 \\} >dbaccess? Is my only option to dbexport and dbimport all the affected \\ \\cb7 \\cf0 \\} >databases, as most of the databases here were onloaded from this\\ \\cb7 \\cf0 \\} >corrupt one?\\ \\cb7 \\cf0 \\}\\ \\cb7 \\cf0 \\} >I've tried onchecking everything about the table, but no problems are \\ \\cb7 \\cf0 \\} >ever reported.\\ \\cb7 \\cf0 \\}\\ \\cb7 \\cf0 \\} >Help!\\ \\cb7 \\cf0 \\ \\cb7 \\cf0 Just a wild shot in the dark here but...have you run update statistics \\'0\\cb7 \\cf0 \\'0\\'0\\'0tely? You do realize tha\\cb7 \\cf0 t\\ system catalogues are not updated automatical\\cb7 \\cf0 ly?\\ \\cb7 \\cf0 \\ Type th ZSBmb2xsb3dpbmcgaW4gREJhY2Nlc3MgYW5kIHJcY2I3IFxjZjAgdW4gaXRc@@