?
Solved

Compact Database?

Posted on 2004-08-11
3
Medium Priority
?
656 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 375 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
Hey fellow admins! This time, I have a little fairy tale for you. As many tales do, it starts boring and then gets pretty gory. I hope you like it. TL;DR: It is about an important security matter, you should read it if you run or administer Windows …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 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