Question Re: ASA 12 dbunload command line problem in Technology Q&A

ASA 12 dbunload command line problem

Former Member — Wed, 28 Sep 2011 16:03:04 GMT

I am converting all our databases from ASA 9.0.2.3508 to ASA 12.0.1.3152.

Running the unload wizard in Sybase Central work fine and generates the following command line.

dbunload  -v -c "UID=dba;PWD=*******;DBF=C:\\databases\\asa12\\emr.db" -ac 
"UID=dba;PWD=***;DBF=C:\\databases\\asa12\\emr12_rebuild.db" -xx

Using the wizard, the process runs to completion with no errors.

When I attempt to run this manually, I get this error

***** SQL error: Unable to start specified database:
C:\\databases\\asa12\\emr12_rebuild.db was created by a different version of the software

I am prefixing the dbunload command with the correct path for ASA 12. I even tried running the command from the ASA12bin32 directory thinking that there may be some kind of pathing issue, but with no success and getting the same error.

The emr12_rebuild.db was created using the DBinit from ASA 12. We are manually creating the database ahead of time so that we can pre-allocate the space for the database and make the load faster (the datebases are all over 100 GB or larger) and not have the resulting db file be fragmented.

We would prefer to be able to this with a single batch file and not have to manually run the wizard as doing so exposes our passwords and we do not wish to do that.

Thanks

Alex

Re: ASA 12 dbunload command line problem

VolkerBarth — Wed, 28 Sep 2011 16:44:46 GMT

What does happen when the old and new databases are not located in the same directory?

BTW: Is there a specific reason to use -xx, i.e. an external unload. This will usually be slower than an internal one...

Just two more remarks: Build 12.0.1.3152 is the GA version. As you seem to plan the migration, I would highly recommend to use a newer 12.0.1 EBF. That may or may not have fixes to your issues.

What does happen when you start the new database from a command line, say by something like

"%SQLANY12%\\bin32\\dbeng12" -n MyEngine -o C:\\MyLog.txt C:\\databases\\asa12\\emr12_rebuild.db

Does that work, and can the database be startet? - Just to assure the command line start does work at all...

Re: ASA 12 dbunload command line problem

Former Member — Wed, 28 Sep 2011 20:07:20 GMT

different directories resutls in same error. The -xx was added by the wizard the database can be started.

Re: ASA 12 dbunload command line problem

Former Member — Wed, 28 Sep 2011 20:23:00 GMT

I will also experiment with just the -an option (and -ii) to see what effect that has.

Re: ASA 12 dbunload command line problem

VolkerBarth — Thu, 29 Sep 2011 03:28:13 GMT

I guess the following quote from the DBUNLOAD utility doc does apply here - relöated to the -ac option:

If the original database was created using version 9 or earlier of SQL Anywhere and the new database is not already running, you must provide a database server name in the -ac option. For example:

dbunload -c "UID=DBA;PWD=sql;DBF=c:mydata.db" -ac "UID=DBA;PWD=sql;DBF=c:mynewdata.db;Server=newserver"

I suspect that without giving a server name, DBUNLOAD tries to load the new database on the engine it has started for the old database (which is the particular "Database Unload Support Engine" - dbunlspt.exe - a v9 database engine). And that will obviously fail for a new v10+ database.

Re: ASA 12 dbunload command line problem

Former Member — Thu, 29 Sep 2011 13:13:27 GMT

That works.

Thank you very much!

Re: ASA 12 dbunload command line problem

VolkerBarth — Thu, 29 Sep 2011 13:34:43 GMT

Feel free to accept this answer...

Cf. this FAQ how to do so:)