Problem solve Get help with specific problems with your technologies, process and projects.

Error dumping database

I installed Sybase 12.5.1 on AIX 5.2. When I try to dump a database of about 12 GB, in the middle of the job I get the following error: Fork: not enough memory. Afterwards, the server is not accessible, and it needs a reboot. Do you have any suggestions? Swap area is 5 GB, memory 10 GB.

I have not seen this problem. However, AIX like most other Unix-based systems, will try to buffer the entire file. In addition, AIX, like the other Unix-based systems, should have swap space equal to or slightly greater than the amount of physical memory (RAM) on the box. This is a must! Otherwise it could cause problems when the box needs to go to the paging area.

My suggestions: Increase the swap area to the IBM-recommended size of at least the size of physical memory. Better configure the swap area 1.5 times the amount of physical memory.

If you do what I recommend, you would have a swap space size of 15 GB for a 10 GB of RAM.

Also, how many stripes are you using for the database dump? How many devices does the database have? For a 12 GB database, I would recommend at a minimum 8 stripes for a standard JFS. For JFS with large file enabled or for JFS2, you should probably go for between 4 and 8 stripes for best performance.

Having said that, based upon the information provided, I suggest you increase the swap space to 15 GB and the number of database dump stripes to 8.

This was last published in November 2004

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.