>
> We are running AR System version 3.2 on a HP-UX machine with an Oracle
> 7.3.4 database. We upgraded to 7.3.4 this past July, and since then, have
> been experiencing poor performance when querying. In order to try and fix
> this, the Oracle DBA's placed indexes on certain fields, external to
> Remedy. After the changes to the database were made; very, very, strange
> things began happening to our client tool. For example, when someone
> tries to populate fields in a schema from a query, it takes a long period
> of time for the data to be downloaded and sometimes pieces of data are
> missing. Also, were are having a problem where data from one field will
> be automatically copied to another. For no apparent reason, the data
> stored in say, the 'Last Name' field will be copied to the 'Short
> Description' Field.
>
> !! Why?? This is incredibly frustrating, and it is having a seriously
> negative impact on our call center's ability to handle their calls.
>
> This is happening on all clients (they are also 3.2). No changes to
> workflow have been made. Has this happened to anyone else??
> If so, what did you do to resolve the problem?
> Any advice would be most appreciated!!
>
> Thanks!!
>
> Jim Thayer
> Associate Programmer
> IS Support Center
> (508) 253-3501 x33501
>
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Where are running HPUX 10.2 with Informix 7.31. While it is true that DBA's go into convultions at just looking at the many VARCHAR's and other totally inefficent datatypes that make up our database, we have found the best way to handle performance is to let Remedy Create EVERYTHING. The only thing that Remedy doesn't really do for us is configure our extent sizes correctly, so we create our own forms by importing them through the user form, then the DBA, drops our tables and readds them exactly as he found them with the exception of resizing them to run faster in the database and still have plenty of space to grow. My advice, for what it's worth, create the indexes yourself through Remedy and if any tweeking needs to be done, let the DBA come back and play with it after it has been created by Remedy. Who knows what Regular Logical indexes will do to this crazy database created by Remedy.

Bill Shine

-----Original Message-----
From: Liles, Julie [SMTP:julie.liles@STAPLES.COM]
Sent: Friday, October 01, 1999 3:04 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: FW: Desperate Remedy Administrator needs help!!

> Here's my problem,
>
> We are running AR System version 3.2 on a HP-UX machine with an Oracle
> 7.3.4 database. We upgraded to 7.3.4 this past July, and since then, have
> been experiencing poor performance when querying. In order to try and fix
> this, the Oracle DBA's placed indexes on certain fields, external to
> Remedy. After the changes to the database were made; very, very, strange
> things began happening to our client tool. For example, when someone
> tries to populate fields in a schema from a query, it takes a long period
> of time for the data to be downloaded and sometimes pieces of data are
> missing. Also, were are having a problem where data from one field will
> be automatically copied to another. For no apparent reason, the data
> stored in say, the 'Last Name' field will be copied to the 'Short
> Description' Field.
>
> !! Why?? This is incredibly frustrating, and it is having a seriously
> negative impact on our call center's ability to handle their calls.
>
> This is happening on all clients (they are also 3.2). No changes to
> workflow have been made. Has this happened to anyone else??
> If so, what did you do to resolve the problem?
> Any advice would be most appreciated!!
>
> Thanks!!
>
> Jim Thayer
> Associate Programmer
> IS Support Center
> (508) 253-3501 x33501
>
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist