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.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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 Open source databases
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.