Hallo,
ich habe mit folgenden fehlermeldung zu kämpfen:

C:\>db2 select * from table(snapshot_table('Sample',-1)) as snap

SNAPSHOT_TIMESTAMP ROWS_WRITTEN ROWS_READ
OVERFLOW_AC
-------------------------- -------------------- --------------------
-----------
SQL0443N Routine "*OT_TABLE" (specific name "") has returned an error
SQLSTATE with diagnostic text "SQL1092 Reason code or token:
ADMINISTRATOR
". SQLSTATE=38553



wäre über hilfe sehr dankbar...

gruss khoco

db2 ? SQL1092

will give you the explanation. The user ADMINISTRATOR has no rights to
issue snapshots.

the user should have one of the following:

* sysadm
* sysctrl
* sysmaint
* sysmon

Read more about SYSMON_GROUP database manager parameter.

-- Artur Wronski

How can i give the administrator the rights to issue snapshots?
How can i give him the rights in the following groups:
* sysadm
* sysctrl
* sysmaint
* sysmon
?
thx

<khosravi (AT) gmx (DOT) de> wrote

First define the group name you want in the operating system. Then you
define the group name in the dbm config (instance). Try this:
db2 get dbm cfg
and you will see where the group names are defined for the various
authorization levels you have indicated above..

Then add the user id to the group at the operating system level. You may
need to restart the instance (db2stop and db2start) for it to take effect
(but I am not sure).

but today it works with a domain user but not with the local admin!!!
I have a Domain user (TEST) as DBA and Local Admin on the server and i
have the local admin(administrator).
I have no rights with the local admin to issue snapshots but with the
domain user and i have no group define...

?????
Thank in advance!

By default Windows administrators have all the authorities (SYSADM).
You don't have to define the groups and update the instance parameters
if you accept the default.

BUT:

If you started DB2 using Domain user, domain administrators are "the
DB2 administrators".

-- Artur Wronski