Installed DB2 9.5 FP4 ( comes along with application will work only on windows environment). While in the installtion proce we created db2 instance ( instance name itself as db2 (default)).

On the same with different id they installed was and with same id They have to create database and objects.

When I logged in as DB2admin ( default id) I can't run runstats , reorgs.

Why is that? Db2admin is instance owner he owns all the databases and its objects right?

Is there any read up on this?

I am new to DB2 Windows environment.


corrected typo.

I just got this info


C:\>db2 get authorizations

Administrative Authorizations for Current User

Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = NO
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO

Indirect SYSADM authority = YES
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = YES
Indirect BINDADD authority = YES
Indirect CONNECT authority = YES
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = YES
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO

Not sure what you're asking. The manual can be found here: DB2 and Windows security introduction

I can't run runstats and reorgs using db2admin account becasue of privialge issues.

That's too bad. You can find someone who can.

db2 -x -r "runstats.sql" "select rtrim(concat('RUNSTATS ON TABLE ',concat(rtrim(tabSchema),concat('.',concat(rtrim( tabname),' WITH DISTRIBUTION AND DETAILED INDEXES ALL;'))))) from syscat.tables where tabSchema='XXXX' and type='T'"

db2 -tvf runstats.sql


I am getting privilage issues when we running the runstats. Not like I don't how to run. Come on, any way thanks for your help.

Sorry, my crystal ball is malfunctioning, I can't see clearly from here what you're doing and what kind of issues you're getting. Would you like to post your entire session output, starting with the CONNECT command, or should I keep guessing?