RE: XPS 8.1

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

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.

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. >

yes, it has dbaccess plane to catch - more later. j. On Thu, Jul 10, 2008 at 2:01 PM, LARRY SORENSEN wrote: > 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 <mailto:ids@iiug.org> <mailto:ids@iiug.org> > From: jack.parker4@verizon.net <mailto:jack.parker4@verizon.net> <mailto: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. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

OK. I noticed that there is no "oncheck". That is one of the commands that I need to know how to replace. Also, any other commands that I may want to use to check things. I look forward to hearing from you. Larry> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XPS 8.1 [12638]> Date: Thu, 10 Jul 2008 15:00:12 -0400> > yes, it has dbaccess > > plane to catch - more later. > > j. > > On Thu, Jul 10, 2008 at 2:01 PM, LARRY SORENSEN wrote: > > > 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 <mailto:ids@iiug.org> <mailto:ids@iiug.org> > > From: jack.parker4@verizon.net <mailto:jack.parker4@verizon.net> > <mailto: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. > > > > ****************************************************************************** * > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Larry, The onutil command replaces oncheck, onspaces, etc., at least in XPS 8.51. Try running "onutil help". That will show you the options that are available with onutil. Then you can run "onutil help check index", for example, to see specific syntax. Pam Ekstrand Database Administrator email: ekstrand@us.ibm.com Home Office: 727-729-8210 Cell: 727-365-3781 "LARRY SORENSEN" <lsorensen25@msn.com> Sent by: ids-bounces@iiug.org 07/10/2008 03:04 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: XPS 8.1 [12639] OK. I noticed that there is no "oncheck". That is one of the commands that I need to know how to replace. Also, any other commands that I may want to use to check things. I look forward to hearing from you. Larry> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XPS 8.1 [12638]> Date: Thu, 10 Jul 2008 15:00:12 -0400> > yes, it has dbaccess > > plane to catch - more later. > > j. > > On Thu, Jul 10, 2008 at 2:01 PM, LARRY SORENSEN wrote: > > > 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 <mailto:ids@iiug.org> <mailto:ids@iiug.org> > > From: jack.parker4@verizon.net <mailto:jack.parker4@verizon.net> > <mailto: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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thank you. When I run onutil help, I get "Error opening file help" When I run 'onutil help check index' I get "usage: onutil [-e] [-i] [-o] [filename] Larry> To: ids@iiug.org> From: ekstrand@us.ibm.com> Subject: RE: XPS 8.1 [12641]> Date: Thu, 10 Jul 2008 15:25:04 -0400> > Larry, > > The onutil command replaces oncheck, onspaces, etc., at least in XPS > 8.51. Try running "onutil help". That will show you the options that are > available with onutil. Then you can run "onutil help check index", for > example, to see specific syntax. > > Pam Ekstrand > Database Administrator > email: ekstrand@us.ibm.com > Home Office: 727-729-8210 > Cell: 727-365-3781 > > "LARRY SORENSEN" <lsorensen25@msn.com> > Sent by: ids-bounces@iiug.org > 07/10/2008 03:04 PM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > RE: XPS 8.1 [12639] > > OK. I noticed that there is no "oncheck". That is one of the commands that > I > need to know how to replace. Also, any other commands that I may want to > use > to check things. I look forward to hearing from you. > > Larry> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XPS > 8.1 > [12638]> Date: Thu, 10 Jul 2008 15:00:12 -0400> > yes, it has dbaccess > > > > plane to catch - more later. > > j. > > On Thu, Jul 10, 2008 at 2:01 PM, > LARRY > SORENSEN wrote: > > > 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 <mailto:ids@iiug.org> <mailto:ids@iiug.org> > > From: > jack.parker4@verizon.net <mailto:jack.parker4@verizon.net> > > <mailto: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. > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hmm, well, I don't know if onutil works the same on your version, but here is the syntax output from running oncheck help check index: CHECK INDEX [WITH DATA] <index_target> [LOCK] [<display_option>] Where <index_target> is one of the following: <database>#[<owner>.]<index> IN DATABASE <database> IN TABLE <database>:[<owner>.]<table> IN TABLESPACE <partnum> And where <partnum> can be either a table or index partition number. LOCK forces a share lock on the table. <display_option> is DISPLAY | SAVE [IN "filename"] Examples: CHECK INDEX sysmaster#idxname DISPLAY CHECK INDEX IN DATABASE sysmaster SAVE IN "/tmp/check.out" CHECK INDEX IN TABLE sysmaster:systables Note: "WITH DATA" option not supported with "IN TABLESPACE" clause Pam Ekstrand Database Administrator email: ekstrand@us.ibm.com Home Office: 727-729-8210 Cell: 727-365-3781 "LARRY SORENSEN" <lsorensen25@msn.com> Sent by: ids-bounces@iiug.org 07/10/2008 03:48 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: XPS 8.1 [12646] Thank you. When I run onutil help, I get "Error opening file help" When I run 'onutil help check index' I get "usage: onutil [-e] [-i] [-o] [filename] Larry> To: ids@iiug.org> From: ekstrand@us.ibm.com> Subject: RE: XPS 8.1 [12641]> Date: Thu, 10 Jul 2008 15:25:04 -0400> > Larry, > > The onutil command replaces oncheck, onspaces, etc., at least in XPS > 8.51. Try running "onutil help". That will show you the options that are > available with onutil. Then you can run "onutil help check index", for > example, to see specific syntax. > > Pam Ekstrand > Database Administrator > email: ekstrand@us.ibm.com > Home Office: 727-729-8210 > Cell: 727-365-3781 > > "LARRY SORENSEN" <lsorensen25@msn.com> > Sent by: ids-bounces@iiug.org > 07/10/2008 03:04 PM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > RE: XPS 8.1 [12639] > > OK. I noticed that there is no "oncheck". That is one of the commands that > I > need to know how to replace. Also, any other commands that I may want to > use > to check things. I look forward to hearing from you. > > Larry> To: ids@iiug.org> From: jack.parker4@verizon.net> Subject: RE: XPS > 8.1 > [12638]> Date: Thu, 10 Jul 2008 15:00:12 -0400> > yes, it has dbaccess > > > > plane to catch - more later. > > j. > > On Thu, Jul 10, 2008 at 2:01 PM, > LARRY > SORENSEN wrote: > > > 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 <mailto:ids@iiug.org> <mailto:ids@iiug.org> > > From: > jack.parker4@verizon.net <mailto:jack.parker4@verizon.net> > > <mailto: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. > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.