performance / tuning tips. to the point.                
 
About Us | Site Map | Privacy
Disclaimer | Feedback
About RSS Feed | Useful Links
Search Partner Links
Original Blog
Add to My Yahoo!
Google Reader or Homepage
del.icio.us performancewiki.com Latest Items


© 2005-2009 PerformanceWiki.com
All Rights Reserved.


Performance Related DB2 Error Codes and Resolutions



[IBM][CLI Driver] SQL1224N

You may see your application running on DB2 v8.1 on AIX may "hang", and your app is reporting
myapp:ERROR   2004-05-26 21:36:13.214000 context:?:? [Servlet.Engine.Transports : 2] - 
[IBM][CLI Driver] SQL1224N  A database agent could not be started to service a request, or 
was terminated as a result of a database system shutdown or a force command.  SQLSTATE=55032
 - ?(?:?)

The problem: shared memeory between DB2 and other apps on the same OS is not enough; 
basically, DB2 runs out of memeory for DB2 agents proceses.  To fix, try:
to FIX:
 Set the EXTSHM environment variable by entering the following commands: 

$ EXTSHM=ON 
$ export EXTSHM 
$ db2set DB2ENVLIST=EXTSHM

Ensure: that the EXTSHM environment variable is set each time you start DB2. 
Do this by editing /home/db2inst1/sqllib/profile.env and add or modify the line: 

DB2ENVLIST='EXTSHM' 

Also add the following to /home/db2inst1/sqllib/userprofile: 

export EXTSHM=ON 

Add EXT_SHM to userpofile of DB2.