Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2006
    Posts
    97

    Unanswered: Windows 2008 DB2 9.5 Fp4

    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.
    Last edited by smith43017; 04-21-11 at 12:24.

  2. #2
    Join Date
    Sep 2006
    Posts
    97
    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

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Not sure what you're asking. The manual can be found here: DB2 and Windows security introduction

  4. #4
    Join Date
    Sep 2006
    Posts
    97
    I can't run runstats and reorgs using db2admin account becasue of privialge issues.
    Last edited by smith43017; 04-21-11 at 16:10.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by smith43017 View Post
    I can't run runstats and reorgs using db2admin account.
    That's too bad. You can find someone who can.

  6. #6
    Join Date
    Sep 2006
    Posts
    97
    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.
    Last edited by smith43017; 04-21-11 at 16:24.

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •