netezzaaginity

How to resolve 'reserve exceeded (host) : Out of memory' issue with Netezza database?


How to resolve 'reserve exceeded (host) : Out of memory' issue with Netezza database?

I try to execute Netezza database table small query using aginity tool and i got 'reserve exceeded (host) : Out of memory' issue. How to resolve this issue?


Solution

  • I have restarted Netezza database engine using below IBM Netezza SSH terminal commands

    Stop Neteazza database engine

    nzstop
    

    Start Neteazza database engine

    nzstart
    

    Other option is: restart Linux Netezza database server.