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

Question

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?

It the error triggered by any statement or a particular one? — Lars G Olsen, Jul 12 '20 at 16:32

score 1 · Accepted Answer · answered Jul 12 '20 at 14:26

1

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.

answered Jul 12 '20 at 14:26

Jeyavel

2,974
10
38
48

Cool - I’m a bit slow at times :) – Lars G Olsen Jul 18 '20 at 12:06

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

1 Answers1