Solved

Compact Database?

Posted on 2004-08-11
3
643 Views
Last Modified: 2008-02-26
I have used foxpro before and we used the "zap" command to compact the databases.  Is there a similar command in sybase or is it even necessary for a sql database?
0
Comment
Question by:vcab
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Jan_Franek
ID: 11771995
What Sybase database server do you have - ASE (Adaptive Server Enterprise) or ASA (Adaptive Server Anywhere) ?
0
 

Author Comment

by:vcab
ID: 11772178
Adaptive Server Anywhere 7.0.2.15
0
 
LVL 14

Accepted Solution

by:
Jan_Franek earned 125 total points
ID: 11772360
Well it is not necessary to compact ASA database. However, sometimes it's good to create new clean database and then there are same useful utilities like rebuild or dbunload. For detailed info you can check http://sybooks.sybase.com/onlinebooks/group-aw/awg0700e/dbrfen7/@Generic__BookView;lang=cs
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Multi-threading long-running processes can have a significant increase in overall performance and drastically decrease over time it takes for a process to complete. Unfortunately, not all applications support native multi-threading, some by design a…
Postmortem reporting allow us to examine mistakes in a way that focuses on the situational aspects of a failure’s mechanism and the decision-making process of individuals proximate to the failure. Read our guide on how to handle IT post-mortem repor…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question