RE: Systables Data...

Posted in 1999

Rick Rabe — Mon, 12 Jul 1999 16:23:07 -0500 — source: Informix-list mailing list archive (1991-1998)

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_01BECCAC.A2307720 Content-Type: text/plain Have you run update statistics since the upgrade? > ---------- > From: Michael Brizendine[SMTP:michaelb@pegsinc.com] > Sent: Monday, July 12, 1999 2:28 PM > To: informix-list@iiug.org > Cc: Rob Gajdica; William Marquis; Dave Pittman > Subject: Systables Data... > > Hi All, > > I've got another question for you all. I'm moving from INFORMIX-OnLine > Version 7.24.UC5 to Informix Dynamic Server Version 7.31.UC2A. I'm on a > Sun E4000 with Solaris 2.6. > > I normally use the systables for a given database to aid some of the > applications I've built for DB maintenance. I have hit a road block > today because the number of rows, column, for a given table is always 0 > for the new version. I haven't seen this value ever be out of sync with > the isql, table, status menu before... Did this data get moved to a > different table, or could i have hit a new bug?? Thanks a lot in > advanced, > > Michael Brizendine > Pegasus System Inc. > Strategy DBA > 214-523-0143 > michaelb@pegsinc.com > ------_=_NextPart_001_01BECCAC.A2307720 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Systables Data...</TITLE> </HEAD> <BODY> Have you run update = statistics since the upgrade? <UL> ---------- From:   = Michael = Brizendine[SMTP:michaelb@pegsinc.com] Sent:   = Monday, July 12, 1999 2:28 = PM To: =     informix-list@iiug.org Cc: =     Rob Gajdica; = William Marquis; Dave Pittman Subject: =        Systables Data... Hi All, I've got another question for you = all.  I'm moving from INFORMIX-OnLine Version 7.24.UC5 to Informix Dynamic = Server Version 7.31.UC2A.  I'm on a Sun E4000 with Solaris 2.6.  = I normally use the systables for a = given database to aid some of the applications I've built for DB = maintenance.  I have hit a road block today because the number of rows, = column, for a given table is always 0 for the new version.  I haven't = seen this value ever be out of sync with the isql, table, status menu = before... Did this data get moved to a different table, or could i have hit = a new bug??  Thanks a lot in advanced, Michael Brizendine Pegasus System Inc. Strategy DBA 214-523-0143 michaelb@pegsinc.com </UL> </BODY> </HTML> ------_=_NextPart_001_01BECCAC.A2307720--