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.
asked 28 Apr '11, 12:23
I would expect, that cache size will be unimportant, if you use -u to not order the data during unload.
answered 29 Apr '11, 09:44