SQL Anywhere database replication

Author

dbunload

Nick

2006-03-06, 7:23 am

I have one ASA Database. It's a 4.1GB
I want to rebuild this DB
But I always saw "***** SQL error: Communication error"
Can you tell me??
How to rebuild this DB??
Thanks for your help

Reg Domaratzki \(iAnywhere Solutions\)

2006-03-06, 7:17 pm

Can you tell us how you are trying to rebuild the database?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Nick> wrote in message news:440bda61.41b7.1681692777@sybase.com...
> I have one ASA Database. It's a 4.1GB
> I want to rebuild this DB
> But I always saw "***** SQL error: Communication error"
> Can you tell me??
> How to rebuild this DB??
> Thanks for your help

Nick

2006-03-07, 3:23 am

I use rebuild this program.

rebuild test new

But Always display "***** SQL error: Communication error"

Thanks for your help

> Can you tell us how you are trying to rebuild the
> database?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs : http://downloads.sybase.com/swd/base.do
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> <Nick> wrote in message
>
>

Christopher Harn

2006-03-10, 8:23 pm

ASA Database Administration Guide
Database Administration Utilities
The Rebuild utility
Rebuilding a database using the rebuild batch or command file

@echo off
rem ********************
********************
********************
*******
rem Copyright 1992-2004 iAnywhere Solutions, Inc. All rights reserved.
rem ********************
********************
********************
*******
if %1. == . goto usage
if %2. == . goto usage
if not exist %2.db goto ok1
echo Database %2 exists.
echo You must "dberase" it first.
goto done
:ok1
if not exist unload\*.* goto ok2
echo Directory UNLOAD exists, but is needed for rebuilding.
echo You must remove it first.
goto done
:ok2
set pwd=%3
if %pwd%. == . set pwd=SQL
dbunload -c " uid=DBA;pwd=%pwd%;db
f=%1" -an %2 unload
set pwd=
goto done
:usage
echo Usage: rebuild {olddb} {newdb} [{dba-password}]
echo Unloads "{olddb}.db", then creates "{newdb}.db".
echo Do not specify ".db" in the database names.
goto done
:done

The rebuild batch file expects the database to be stopped, it is really just
an example for you to build on.

If you were me or if I was you... I would look directly towards the
dbunload command.

If you are using replicaiton spend serious attention to the rebuilding a
database involved in replication section of the help.

<Nick> wrote in message news:440d04ac.4fc2.1681692777@sybase.com...[color=darkred]
>I use rebuild this program.
>
> rebuild test new
>
> But Always display "***** SQL error: Communication error"
>
> Thanks for your help
>
>
>

Sponsored Links