dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\Unwire dServer\data\clusterdb;UID=dba;PWD=sql" -ar

SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start database server

i have tried running the cmd as administrator and granted access to 'everyone' on E drive.

Thank you, Babji

asked 22 Dec '16, 20:27

Babji's gravatar image

Babji
11122
accept rate: 0%

2

It is likely that the dbunload command cannot locate the standalone database engine executable (dbeng16.exe). You can add START connection parameter to locate the engine or if SMP does not ship that engine, force it to use the network server.

START=<full_path_and_executable>

i.e.,

...;PWD=sql;START=c:\myinstall\executables\dbeng16.exe

-or-

...;PWD=sql;START=c:\myinstall\executables\dbsrv16.exe
(23 Dec '16, 08:46) Chris Keating
Replies hidden
1

In addition to Chris' comment, I would verify that the file E:\SAP\MobilePlatform3\MR30\Servers\Unwire dServer\data\clusterdb.db (note the <dot>db at the end) exists and that you have permission to the file. I also noticed that there is a space between "Unwire" and "dServer" - is that meant to be there? ... or is that just a typo? Verify that you are using the correct full pathname to the database file.

(23 Dec '16, 09:42) Mark Culp
Replies hidden

Thank you so much Chris,The thing is i have deleted the log file of domainlogdb database and want to build a new database in its place and i am using the following command which is failing i am sure its due to missing file but how do i create a new database in place of the old one without the old databases transaction log file.

dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\U dServer\data\domainlogdb;UID=DBA;PWD=sql;START=C:\Windows\System32\dbsrv16. -an domainlog.db SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start specified database: server exit code 309

(23 Dec '16, 11:44) Babji

Thank you very much Mark.

Thank you so much Chris,The thing is i have deleted the log file of domainlogdb database and want to build a new database in its place and i am using the following command which is failing i am sure its due to missing file but how do i create a new database in place of the old one without the old databases transaction log file.

dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\U dServer\data\domainlogdb;UID=DBA;PWD=sql;START=C:\Windows\System32\dbsrv16. -an domainlog.db SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start specified database: server exit code 309

(23 Dec '16, 11:44) Babji

Hi Chris,

Finally i was able to create a new database and also use the dbunload utility from cmd prompt but now my problem is i have to shrink the databases at regular intervals and with the dbunload on Windows machine its only allowing -an option which is shrink the old db and create new database files in a new location and then i have to stop the SMP/SUP services and copy these new files to actual data folder,Could you please help with a script to shrink the databases on regular intervals without the need to create and copy new files and stopping the services.

Thank you, Babji

(23 Dec '16, 17:41) Babji
1

Why are you needing to "shrink the database"? The space in the database file will get reused if you are deleting data from the database. In fact, it could be argued that you should grow your database and then defragment the dbspace(s) so you get optimal read/write performance.

(29 Dec '16, 11:30) Mark Culp
showing 2 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×41

question asked: 22 Dec '16, 20:27

question was seen: 383 times

last updated: 29 Dec '16, 11:30