Not enough memory
Posted on 2003-03-17
1) I am having db2 EE 7.2 server on Win NT4/2000.
2) When I was doing: insert into local_db_table select * from nickname (to remote server), I get the error:
SQL1022C There is not enough memory available to process the command.
3) I failed to do anything from what was suggested as user response:
a) Change the MEMMAN NO SWAP, NO MOVE option in the CONFIG.SYS file to SWAP, MOVE. I could not find CONFIG.SYS anywhere. Can you tell me where it is located or if on windows it has a different name.
b) Remove background processes - How to do this?. First of all what all are the db2 background processes and what all can we remove.
c) Decrease the values of the configuration parameters that define allocation of memory, including udf_mem_sz if UDFs are involved in the failing statement.
This is a parameter of type db manager configuration. UDFs were not involved in the failing statement.
What all parameters define allocation of memory.
d) Install more random access memory (RAM). We are on the way.
e) If a remote procedure was invoked, ensure that the remote procedure uses a local variable space that is less than or equal to 4K. Even though remote procedure was not involved, I would like to know how to accomplish this.
f) If you are using Remote Data Services, increase the Remote Data Services heap size (rsheapsz) in the server and client configuration because at least one block is used per application. This is the one that fits I think. I could not find rsheapsz in list of db and dbm cfg parameters. When can I find and set this both in client and in server.
g) On OS/2 systems, increase the value of the min_priv_mem database manager configuration parameter. This will cause the database manager to reserve more private memory space at db2start time. I found this parameter in dbm cfg parameters. Can I set this and will it take effect for my windows system.