Share 'What privileges will be needed for NNSTAT?'
1. For v91 and V95 , A temporary tablespace (WRAPPER1) will be created.
The privilege of "create user temporary tablespace" will be need
If error reported, one option is to bind the db2stats.bnd by a dbadm user again or grant SYSCTRL or SYSADM authority)
2. NNSTAT has 2 methods to update the nickname's statistics:
2.1 For catalog-based method, NNSTAT will create temp nickname to get the statist…
You can share this blog post in two ways…
Share this link:
Send it with your computer's email program: Email this