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 -
Can anyone please help on how to restart the server? What should be done resolve vitual memory issue?