Tag Archives: package

Whats the plan name for my routine ?

Ever tried to find the package / plan name for your stored procedure or function in DB2 LUW. Its not straight foward was I wish it was .  Here is an sql that will make your life a little easy … Continue reading

Posted in db2 | Tagged , , , , | Leave a comment

SQL805N on NULLID.SYS* package

All applications are not perfect. There might be instances where applications do not close their cursors after they are done with them. This causes DB2 dynamic packages to be held and eventually gets used up.  When all the default number … Continue reading

Posted in db2 | Tagged , , , , , , | Leave a comment