Take a look at the -zr switch on the server, which turns on "request level logging". Start the server with -zr all -zo reqlog.txt
and then look at reqlog.txt after some queries have been executed. It's fairly verbose but should list the SQL that's being executed.
Disclaimer: I work for Sybase in SQL Anywhere engineering.
Ok ! Let me describe how this issue was solved:
1) There was definitely a corruption issue caused by a problem with vmware tools on solaris 10. When the network interface had high transfer/load operations (sample: copy of a 2 GB DB ....), it just stoped working, in the middle of the operation. To put the interface working again, I had to disconnect and connect the network interface again (in the vmware interface !).
Basically, I had to unistall vmware tools on solaris virtual machine.
There was one catch, the highest transfer rates that could be achieved was about 300 Kb. Basically I could take hours to perform a simple ftp transfer of a 2 GB database, but there wasn´t any corruption at all.
How to prove/test that there is/inst´t any corruption. I just packed (on the source machine) the database dump into a tar file (yes, an extra 20kb), but after the download complete, on the target server, I was able to untar the file, and if the untar operation was sucessfull that proved that there wasn´t any corruption on the file that was just transfered.
2) After being sure that the dump was ok, I got a diferent error:
Apr 17 14:24:20 2012: Backup Server: 4.188.1.1: Database wfcv2: 158936 kilobytes (1%) LOADED.
Apr 17 14:24:47 2012: Backup Server: 4.188.1.1: Database wfcv2: 303212 kilobytes (2%) LOADED.
Apr 17 14:25:16 2012: Backup Server: 4.188.1.1: Database wfcv2: 447104 kilobytes (3%) LOADED.
Apr 17 14:25:39 2012: Backup Server: 4.124.2.1: Archive API error for device='compress::1::/data4/20120413_wfcv2_zdump::000': Vendor application name=Compress API, Library version=1, API routine=syb_read(), Message=syb_read: gzread() error=0, msg=Error 0
Apr 17 14:25:39 2012: Backup Server: 4.124.2.1: Archive API error for device='compress::1::/data4/20120413_wfcv2_zdump::000': Vendor application name=Compress API, Library version=1, API routine=syb_close(), Message=syb_close: gzclose() error=-3 msg=Input/output buffer is corrupt
Apr 17 14:25:39 2012: Backup Server: 6.32.2.3: compress::1::/data4/20120413_wfcv2_zdump::000: volume not valid or not requested (server: , session id: 20.)
Apr 17 14:25:39 2012: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Ok ! Sybase configuration issues !
I had to configure some parameters that were related to load operations, such as:
number of large i/o buffers -> 32
max memory
And a Solaris issue !
I also had to adjust the Operating System Shared Memory to the sybase engine ... !
And I finally was able to load the DB (size > 2.1 GB) !
;-) Cheers !
Best Answer
Your DB files are SQLAnywhere files, so first you will need to get SQLAnywhere. Sybase has some documentation on upgrading databases from earlier versions here.