469,928 Members | 1,691 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,928 developers. It's quick & easy.

SNAPSHOT_LOCK Errors

SR
Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------
-----------
SQL0443N Routine "SYSPROC.SNAPSHOT_LOCK" (specific name
"SNAPSHOT_LOCK") has
returned an error SQLSTATE with diagnostic text "". SQLSTATE=38553
However, when I ran the same as a instance owner, it runs fine:

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------

0 record(s) selected.
Any insights greately appreciated.

Thanks
Sarvesh

Jun 27 '06 #1
6 3562
Ian
SR wrote:
Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name


As documented, users need to either be members of the SYSADM group
or the SYSMON group to use the snapshot facility (whether it's
coming from the CLI or the SNAPSHOT tables).

Jun 27 '06 #2
The NON-SYSADM id should be atleast in SYSMON_GROUP in DBM cfg.
To run snapshot functions.

Shashi Mannepalli
SR wrote:
Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------
-----------
SQL0443N Routine "SYSPROC.SNAPSHOT_LOCK" (specific name
"SNAPSHOT_LOCK") has
returned an error SQLSTATE with diagnostic text "". SQLSTATE=38553
However, when I ran the same as a instance owner, it runs fine:

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------

0 record(s) selected.
Any insights greately appreciated.

Thanks
Sarvesh


Jun 27 '06 #3
SR

Ian wrote:
SR wrote:
Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name


As documented, users need to either be members of the SYSADM group
or the SYSMON group to use the snapshot facility (whether it's
coming from the CLI or the SNAPSHOT tables).


Thanks Ian! One more question for you (forgive me for my ignorance as I
am new to DB2), how do I grant SYSMON privilege to this user? Should I
create a seperate OS group? Can I do this using Control Center?

Regards
Sarvesh

Jun 27 '06 #4
Ian
SR wrote:

Thanks Ian! One more question for you (forgive me for my ignorance as I
am new to DB2), how do I grant SYSMON privilege to this user? Should I
create a seperate OS group? Can I do this using Control Center?


You have to:

1) create a new OS group
2) assign users to it,
3) update the database manager config file to set SYSMON_GROUP
4) Recycle the instance

Jun 28 '06 #5
SR

Ian wrote:
SR wrote:

Thanks Ian! One more question for you (forgive me for my ignorance as I
am new to DB2), how do I grant SYSMON privilege to this user? Should I
create a seperate OS group? Can I do this using Control Center?


You have to:

1) create a new OS group
2) assign users to it,
3) update the database manager config file to set SYSMON_GROUP
4) Recycle the instance


Thank you very much!!

Regards
Sarvesh

Jun 28 '06 #6
SR
Thanks Shashi!

Regards
Sarvesh
Shashi Mannepalli wrote:
The NON-SYSADM id should be atleast in SYSMON_GROUP in DBM cfg.
To run snapshot functions.

Shashi Mannepalli
SR wrote:
Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------
-----------
SQL0443N Routine "SYSPROC.SNAPSHOT_LOCK" (specific name
"SNAPSHOT_LOCK") has
returned an error SQLSTATE with diagnostic text "". SQLSTATE=38553
However, when I ran the same as a instance owner, it runs fine:

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------

0 record(s) selected.
Any insights greately appreciated.

Thanks
Sarvesh


Jun 28 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by mikey_boy | last post: by
2 posts views Thread by Trev | last post: by
10 posts views Thread by Douglas Buchanan | last post: by
24 posts views Thread by pat | last post: by
8 posts views Thread by ImOk | last post: by
2 posts views Thread by =?Utf-8?B?UmFuZHlz?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.