Archives of the TeradataForum

Message Posted: Fri, 21 Jun 2002 @ 13:57:44 GMT

We use Microstrategy as our user interface to Teradata and up till now have been passing the individual's logon id to Teradata. With 300
users, the Intelligent server frequently runs our of memory because it needs to build separate caches for each user. Also, element browsing
takes a long time if long running queries are hogging resources in Teradata. Microstrategy currently has no way to pass a separate resource
partition account code for element browsing versus report running.

We are rethinking our strategy and have decided to create group logon ids for different departments and projects, so users in the same
group can share the element cache. To facilitate element browsing, we would like to prebuild the element cache each morning before the
users log on to the system.