Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: History Function
Topic Summary: Reporting History and Cleaning Up History
Created On: 4-Aug-2006 16:32
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 4-Aug-2006 16:32
User is offline View Users Profile Print this message


robert mccauley

Posts: 22
Joined: 19-Jun-2006

I am considering implmenting the use of the History Function on our project and I was wondering if anyone knew the answers to the following questions

1) If i wanted to generate a Report based upon the information held in the History what would I query?

2) After numerous changes to a Diagram or Definition if the History Table grows to large and I want to truncate some of it, how do I go about doing it in SA?

Thanks!
Report this to a Moderator Report this to a Moderator
 6-Aug-2006 23:16
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

I've yet to get 10.4 and the history function but I would recommend the following:

To reduce the size of the database, choose the database via the Encyclopedia manager and use the Shrink function form the menu, Database :: Shrink.

Or you can shrink the database via a SQL string. This what I would do if I was flying blind (which I am )

dbcc shrinkfile(your_database_name,'truncateonly')
dbcc shrinkfile(your_database_name_only)


The first shrinkfile truncates your log files and the next one shrinks the database. Ensure you have adequate backup obviously.

To find the table to query for reports, I'd run the following SQL string:

SELECT * FROM INFORMATION_SCHEMA.TABLES

Hope this helps.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.