User Profile

Collapse

Profile Sidebar

Collapse
ikhtear
ikhtear
Last Activity: May 25 '11, 07:14 PM
Joined: Mar 6 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ikhtear
    replied to how to granr reorg privilege to any db2 user
    in DB2
    Thanks vijay for your reply. i got it. i dont like to give dbadm to other than inst user.
    See more | Go to post

      Leave a comment:

    • ikhtear
      replied to how to granr reorg privilege to any db2 user
      in DB2
      Hi vijay,

      Thanks for information

      i have give privilege as below to the group like below and restart db

      update dbm cfg using SYSMON_GROUP user_group

      and put the user on that group

      But it shows the following error
      SQL2214N The user does not have the authority to run the REORG utility on
      table "TEMP".

      Can you please help me on this regard
      ...
      See more | Go to post

        Leave a comment:

      • ikhtear
        started a topic how to granr reorg privilege to any db2 user
        in DB2

        how to granr reorg privilege to any db2 user

        I'm very new at db2 i'd like to grant reorg privilege to an user i tried with the following command
        db2 => grant reorg on database DB_NAME to USR_NAME;

        but it shows following error. can anyone help me on this

        DB21034E The command was processed as an SQL statement because it was not a
        valid Command Line Processor command. During SQL processing it returned:
        SQL0104N An unexpected token "reorg"...
        See more | Go to post
        No activity results to display
        Show More
        Working...