IDS Forum

RE: XPS 8.1

Posted By: LARRY SORENSEN
Date: Thursday, 10 July 2008, at 2:01 p.m.

In Response To: RE: XPS 8.1 (jack.parker4@verizon.net)

There is just a single node. I was hoping for some commands, etc. that I could run on the XPS server to possibly determine the problem. Also, does XPS come with dbaccess that I could use to drop and rebuild some indexes? How do I check the indexes?

thanks> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XPS 8.1 [12635]> Date: Thu, 10 Jul 2008 13:15:30 -0400> > These are totally different beasties. do you have a single node XPS > instance? Or are you running multiple co-servers? > > xctl onstat - > > will give you the status of each co-server, if you have more than one, > then your upgrade path is not so simple. > > I would also figure out why things have gotten slow rather than shoot > the workhorse, maybe it just has a pebble in it's shoe. > > j. > > On Thu, Jul 10, 2008 at 1:00 PM, LARRY SORENSEN wrote: > > > To All: > > I have just inherited an Informix XPS 8.1 instance. I believe that the > plan > was to eventually migrate away from it, so no upgrades were ever done > and it > is no longer supported. It has been running along fine up until about a > week > ago. All of a sudden, data uploads, queries and reports are taking a lot > longer than they used to. I have not yet checked, but I was told that > UPDATE > STATISTICS and possibly index rebuilds have been done on a regular > basis. > > Having not worked with XPS before, how does it differ from IDS and what > are > the diagnostic steps that I should go through to find the possible > problems? > Are they the exact same commands as IDS or different? > > Larry > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Messages In This Thread

• RE: XPS 8.1
  LARRY SORENSEN -- Thursday, 10 July 2008, at 1:00 p.m.
  • RE: XPS 8.1
    jack.parker4@verizon.net -- Thursday, 10 July 2008, at 1:15 p.m.
    • RE: XPS 8.1
      LARRY SORENSEN -- Thursday, 10 July 2008, at 2:01 p.m.
      • RE: XPS 8.1
        jack.parker4@verizon.net -- Thursday, 10 July 2008, at 3:00 p.m.
        • RE: XPS 8.1
          LARRY SORENSEN -- Thursday, 10 July 2008, at 3:04 p.m.
          • RE: XPS 8.1
            Pamela Ekstrand -- Thursday, 10 July 2008, at 3:25 p.m.
            • RE: XPS 8.1
              LARRY SORENSEN -- Thursday, 10 July 2008, at 3:48 p.m.
              • RE: XPS 8.1
                Pamela Ekstrand -- Thursday, 10 July 2008, at 4:08 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.