Hi when we execure a storred procedure we get the error
*** SCRIPT START: Connection: 10.80.10.36-TMSADMIN-OBDEV9II (tpeomdev) Oct-15-2003 12:49:20 ***
CALL X_PKG.Y('RATING' ,10531 ,NULL ,'''ANAND''' ,NULL , NULL ,NULL , NULL,
'US' , NULL , NULL , NULL , NULL ,NULL , NULL, 'US' ,NULL , CURRENT TIMESTAMP , NULL , NULL ,
NULL , NULL , NULL, 'Exact Lanes', 'rl.lane_id' , 'ASC' , 0 , 1 , 10 , ?, ? , '');
SQL0083C A memory allocation error has occurred.
*** SCRIPT END : Connection: 10.80.10.36-TMSADMIN-OBDEV9II (tpeomdev) Oct-15-2003 12:49:20 ***
The error analysis says
SQL0083C A memory allocation error has occurred.
Explanation:
During processing, there was not enough memory to continue
processing.
User Response:
Possible solutions include:
o Ensure that your system has sufficient real and virtual
memory.
o Remove background processes.
If you continue to receive this message after attempting the
suggested solutions, contact IBM Customer Support.
No i understand that this is an environment variable set up issue
and
on checking that from my comand center, i am not able to see the variables like
1 keepfenced
2 Febnced_pool
i done know weather they relate to the error above. where are the variables .
Note these values i hav taken from the performance manual of the admin guide for DB2 .
we are running Db2 on AIX and control center is at the local workstation
wjat is the ideal configuration set up.