How do I correct this error: Failed : Dynamic sections check : Dynamic sections in DB2 databases set to 200. It should be at least set to 1000?

Enyinnaya
Enyinnaya used Ask the Experts™
on
Hello All,

I have this error running a particular application and I get this error:

Failed : Dynamic sections check : Dynamic sections in DB2 databases set to 200. It should be at least set to 1000

How do I correct this error? What bind/rebind parameter do I need to Dynamic sections to any valuse desired?

Enyinnaya
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
momi_sabag,

But my Package cache size (4KB)    is set to  (PCKCACHESZ) = AUTOMATIC(3207)

What does automatic(3207) mean and should this be increased? It seem to me more than what the application is complaining about so I am wondering is PCKCACHE_SZ really the issue here?

Thanks
AFAIK, it is a client side property ...

Depends on the application .. Examples below ..
 

to set jdbc dynamicsections properties,

http://docs.oracle.com/cd/E13222_01/wls/docs81/admin_ref/utils11.html

for odbc
http://www.sybase.com/detail?id=1033611

Check your application documentation for details
automatic means db2 sets it automatically
3207 means it is set right now to 3207 but that is subjected to change automatically

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial