Unix Technical Forum

lock with force

This is a discussion on lock with force within the DB2 forums, part of the Database Server Software category; --> If you are new to the environment whats the best way to find out the "id" which is placing ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:57 AM
meetalps
 
Posts: n/a
Default lock with force

If you are new to the environment whats the best way to find out the
"id" which is placing a force with lock on a table XYZ for performing
load operation.

Thanks.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 08:58 AM
The Maxx
 
Posts: n/a
Default Re: lock with force

Probably doing a db2 get snapshot for locks on db "dbname".


Regards,

Max
meetalps wrote:
> If you are new to the environment whats the best way to find out the
> "id" which is placing a force with lock on a table XYZ for performing
> load operation.
>
> Thanks.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 09:01 AM
wishkid2000 via DBMonster.com
 
Posts: n/a
Default Re: lock with force

db2pd -db dbname -locks

The Maxx wrote:
>Probably doing a db2 get snapshot for locks on db "dbname".
>
>Regards,
>
>Max
>> If you are new to the environment whats the best way to find out the
>> "id" which is placing a force with lock on a table XYZ for performing
>> load operation.
>>
>> Thanks.


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200608/1

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:33 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com