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.

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.