|
Does anybody know of any tools to monitor performance, defragment, etc. a Sybase SQL Anywhere database?
Thanks.
Started by Zerofiz on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
If you're looking....
Look in the docs for the dbunload is an issue, my experience with dbunload is that the rebuilt database files will also be fragmented to some and .log files.
To defragment a SQL Anywhere database, you need to rebuild it .
|
|
On Wed, 20 May 2009 11:51:00 -0700 (PDT), beam <martinbeauchesne@gmail.com
I'm migrating from 5.5 to 11.0 and I have french caracters in my
tables. ê, Ê, à, À, ç, Ç, é, É,....
With 5.5 we used the code page 437.
To do the migration I had to create...
Started by beam on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Wed, 20 May 2009 12:37:41 -0700 (PDT), beam <martinbeauchesne@gmail.com
I noticed that when I use UNLOAD files that the LOAD statement uses
ENCODING 'cp437'
I did a test in ISQL 11 and took the LOAD statement and change the
ENCODING tp cp125... .
|
|
Hi, I'm trying to upgrade a Sybase SqlAnywhere 9 DB to
Version 11 using the command line tool dbunload (parameter
-c and -an). The tool starts "working" but when it is trying
to load data into the new DB it terminates with the
following error:
SQLCODE...
Started by Lars Stokes on
, 10 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
What else do I have to do?
Ciao
Lars have been passed to
... .
The tool starts "working" but when it is trying
to load provided the db connect data to
dbunload using the -c parameter.
Line tool dbunload (parameter
-c and -an).
|
Ask your Facebook Friends
|
On 30 Sep 2009 02:59:13 -0700, Justin Willey <gjw@nospam.iqx.co.uk
Unless I am missing something obvious (it wouldn't be the first time!),
but there is no easy way to unload all the database objects that are
owned by a particular user.
I envisage...
Started by Justin Willey on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
That might work....
Have you tried running dbunload connected as that user?
Sybase Central itself likes to have DBA priviledges but
maybe dbunload will not.
There is no specific switch to filter that way (at least not w\dbunload).
|
|
On 18 May 2009 01:13:09 -0700, "Volker Barth" <No_VBarth@Spam_GLOBAL-FINANZ.de
Hi all,
this is a follow-up from the thread "Reloading tables with autoincrement
columns" on the general NG.
I would like either of the following:
a) A documentation...
Started by Volker Barth on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
This page
displays the SQL or command.
Or
dbunload) now include a new page at the end of the wizard.
|
|
On 9 Nov 2009 15:05:25 -0800, "Doug Stone" <doug.stone@res-q.com
We have a customer where it looks like their database and all their backups
are corrupt.
I am seeing a "checksum failure on page 11661" error when unloading the
database.
Is there...
Started by Doug Stone on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Then try a second time with the reversed
order (ASC replaced by DESC or vice ... .
Until it stops with the error.
Pods" <r.pods@gmx.net
Doug,
you might want to try the UNLOAD SELECT statement with an ORDER BY .. .
On 10 Nov 2009 04:52:34 -0800, "R.
|
|
On 26 Feb 2009 00:12:44 -0800, "Markus KARG" <karg@quipsy.de
The Windows Shell (aka Desktop) allow to deal with files in several ways,
like double clicking on them and showing context menus when clicking on them
with the right mouse button. It...
Started by Markus KARG on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Simultaneously may
be a burden for a standard tool from iAnywhere - I wouldn't be glad for a
bunch of "open.
|
|
I have a series of db files that I need to convert to any standard
flat file format (csv, xls). By looking at the file in notepad I've
deduced that this is indeed a Watcom database file--I think a Watcom
4.0 database file, but I'm not entirely certain...
Started by gzuz00@gmail.com on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
dbunload -c "UID=dba....
Type:
mkdir C:\unload
dbunload -c
"UID=<useridC:\unload
(Beware word-wrap!)
e.g.
(Version 11 can't prompt (Start -2.
Unload the database to a set of CSV files using
the version 11 "dbunload" command.
|
|
When we unload our Database in dat-Files with ASA 9 or ASA
11 (Dataformat: cp850), we can't reload the exported data &
structur in a new ASA 11 UTF-8 DB. Create a new ASA 11
Database is not the Problem. Only run the Reload.sql - File
with the cp850 Encoding...
Started by Thomas Hoffmann on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
(v9 dbunload will not know how to prepare
for a V11 upgrade and can introduce behaviours
that are addressed in the V11 dbunload)
To make dbisql later with dbunload....
First off you should only use V11 of DBUnload
for this.
|
|
On 23 Jun 2009 05:31:09 -0700, "Robert Paresi" <FirstInitialLastName@innquest.com
Hello,
This is a bug (?) which I've now been able to narrow down and reproduce. It
caused me a considerable amount of hours. I really would need this resolved ...
Started by Robert Paresi on
, 8 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Have a checkbox on the DBUNLOAD in V11 could not be unloaded using
a version 10....
The ability for that tool to be able to apply those
transactions would require a full engine
Hi,
Yes :-)
That's my pretty please for an enhancement.
|
