DB2 AIX Memory Allocation Issue

Posted on 2004-12-01
Last Modified: 2012-05-05
When attempting to create a database in AIX, I'm seeing the following error: SQL0083C A memory allocation error has occurred.  This is a base install, with default dbm config values.  There is nothing else running on the box, so I'm fairly confident I shouldn't be running out of resources.  Any tips?
Question by:Ari_Weil
    LVL 4

    Expert Comment

    What version of AIX and DB2 are you running, and which fixpacks (for both AIX and DB2) have you applied?

    Author Comment

    AIX v5.1.  DB2 code release SQL08010 level identifier 01010106 informational tokens DB2 v8.1.1.0, s021023, fixpack 0.  This is my first time trying to run DB2 on AIX...I've gotten things running on Windows, Linux and the AS/400...this is new to me.  Is there a known issue with the base version of 8.1 on AIX?
    LVL 4

    Accepted Solution

    I suggest you upgrade to at least Fixpack 5. This should fix the problem.

    Author Comment

    I will bear that in mind for AIX v5.1, meanwhile, I'm now using AIX v5.2, and DB2 8.1 works like it should.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now