How can I check if .db file is fragmented and how can I
defragment it to optimize performance.
Also, there are crystal reports running on the server and
crystal report software is not installed. Moreover there is
no support for Dolphin 2.9 application used so no queries
are available through which I can check if they are slowing
the performance of the server.

Also, please tell me how I can unload and recreate the
database, and which precautionary steps should I follow to
achieve this.

First, make a backup for safety's sake; this assumes the database is
already running:

MD bkup
"%ASANY7%\win32\dbbackup.exe"^
-c "ENG=ddd;DBN=ddd;UID=dba;PWD=sql" bkup

Then, unload/rename/recreate/reload the database:

"%ASANY7%\win32\dbunload.exe"^
-c "ENG=ddd;DBN=ddd;UID=DBA;PWD=SQL"^
-r reload.sql reload

PAUSE dbunload done...

"%ASANY7%\win32\dbstop.exe"^
-c "ENG=ddd;DBN=ddd;UID=dba;PWD=sql" -q -y

PAUSE Old database stopped...

ATTRIB -R ddd.db
ATTRIB -R ddd.log
RENAME ddd.db old_ddd.db
RENAME ddd.log old_ddd.log

"%ASANY7%\win32\dblog.exe" -t old_ddd.log old_ddd.db

PAUSE Old database renamed...

"%ASANY7%\win32\dbinit.exe" -p 4096 ddd.db

PAUSE dbinit done...

"%ASANY7%\win32\dbspawn.exe"^
-f "%ASANY7%\win32\dbeng7.exe" ddd.db

PAUSE New database started...

"%ASANY7%\win32\dbisqlc.exe"^
-c "ENG=ddd;DBN=ddd;UID=dba;PWD=sql" reload.sql

PAUSE dbisqlc reload done...



On 9 Oct 2009 06:13:43 -0700, Deepali wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

First, make a backup for safety's sake; this assumes the