It was a problem related to application tuning (lacking rs.close statement in page). But inadvertently i increase the packages using command:
db2 bind @db2cli.lst blocking all grant public clipkg 30
and then my package count increase to 30 (SYSLH200 to SYSLH20F and SYSLH210 to 21F) 30 is the max for db.
later a corrected my application and revert to my previous setting of 3 packages using:
db2 bind @db2cli.lst blocking all grant public clipkg 3
But still my package count is showing 30 and all are valid.
1. What to do to drop/remove those extra 27 packages ?
2. Are those extra package may be causing any adverse effect to system/db ?
3. I understood that i will never need these packages in future then what is need to keep them in DB ?
there should be a "drop package" or similar command
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be