unable to use dbunload from command prompt

[Former Member]

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

[chris_keating]

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

[MarkCulp]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[MarkCulp]

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.