Hi Friends,

On Sybase IQ 12.7, I am facing issue of server stoppig -

1. I want to load data from flat files into a table with Identity defined column so I set the Identity_Insert option to that, table. Test insertion of one row was successful, but when I tried to see data from Sybase central Server was stopped and could not be resterted again(by any method) . So I created database and tables again.

2. When triying to load larger flat files (almost 3 GB) server gives 'out of virtual memory issue'. I discussed this with System people, who set the virtual memory to 3150 MB. This is also not working. I have set below options -
LOAD_MEMORY_MB =0
Main_Cache_Memory=320
Temp_Cache_Memory=480

Can anyone please help on how to restart the server? What should be done resolve vitual memory issue?

Any help please..

Regards,
Ashish