Monday, 6 April 2015

SQL10003C There are not enough system resources to process the request. The request cannot be processed.

If you see this: -

SQL10003C  There are not enough system resources to process the request.  The request cannot be processed.

when trying to run commands against DB2 e.g. db2level, db2start, db2licm etc. then make one simple check :-)


ping `hostname`

PING ( 56(84) bytes of data.
64 bytes from ( icmp_seq=1 ttl=64 time=0.020 ms
64 bytes from ( icmp_seq=2 ttl=64 time=0.099 ms
--- ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1493ms
rtt min/avg/max/mdev = 0.020/0.059/0.099/0.040 ms

cat /home/db2inst1/sqllib/db2nodes.cfg 

0 0

It's important that db2nodes.cfg matches the hostname of the server, and that the hostname is resolvable.

I hit this issue having changed my OS hostname AFTER I created my DB2 instance :-)

No comments:

Ubuntu and Docker - Handling the GUI

Long story very short, I've been building some Docker images from an existing parent image. As part of my build, I wanted to ensure th...