Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

When upgrading a large DB (100GB) from v9 to v10 64-bit on a 64bit windows box (with 64GB RAM) we are trying to minimise the unload time (currently 5.5 hours - the reload is only 1.5 hours) and therefore downtime, on the 24x7 system. The databases and unload files are on different (fast) disk systems.

Given how impressively fast the reload is, the unload seems on the slow side. So far we have been using the unload wizard in Sybase Central. This in turn starts the database with the unload engine (dbunlspt.exe) which is presumably some sort of cut down v9 engine. There doesn't seem to be anywhere to set server start-up options (eg cache, priority etc) in this process - so presumably defaults are used. This will all be a 32-bit process.

My questions:

  1. Does cache size matter when unloading?
  2. If it does, can we persuade the unload engine to use more?
  3. Would we be better using the 64-bit version of the dbunload.exe command line utility - and again if cache matters, can we persuade it to use more than the default?

asked 28 Apr '11, 12:23

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

I would expect, that cache size will be unimportant, if you use -u to not order the data during unload.

permanent link

answered 29 Apr '11, 09:44

Martin's gravatar image

accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 28 Apr '11, 12:23

question was seen: 3,346 times

last updated: 29 Apr '11, 09:44