How do you know whether a table ..... 
Author Message
 How do you know whether a table .....
Hi,
  How can I know whether a table is being held[in the form of lock] by
an appliation or not?

Txs,
Ramay.

Sent via Deja.com
http://www.***.com/



Sat, 05 Jul 2003 07:11:21 GMT
 How do you know whether a table .....


Quote:
> Hi,
>   How can I know whether a table is being held[in the form of lock] by
> an appliation or not?

> Txs,
> Ramay.

> Sent via Deja.com
> http://www.deja.com/

With "db2 get snapshot for locks on <dbname>".
You might want to pipe it to a formatting script to make it more
readable and/or to grep the information you need.

Hope this helps



Sat, 05 Jul 2003 07:58:34 GMT
 How do you know whether a table .....
In AS/400 you would type

wrkobjlck or
dsprcdlck

Peter Meister
TietoEnator Sweden

Quote:

>Hi,
>  How can I know whether a table is being held[in the form of lock] by
>an appliation or not?

>Txs,
>Ramay.

>Sent via Deja.com
>http://www.deja.com/



Mon, 07 Jul 2003 16:28:36 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. help I need to know whether this can be done

2. How to know whether a table is locked ?

3. Get to know whether a certain constraint exist or not

4. How Can i know whether a transaction open or not in VB6

5. How can i know whether SQL server Support Arabic version

6. How to know whether sql Server is installed

7. Question whether this is a known problem in 7.1.2

8. How to know whether sql Server is installed via vb and ADO

9. How to know whether DB is being used ??

10. How can I know whether a form.show completely

11. What type of error should I check to know whether database is corrupted or not

12. How to know whether my imort is going on or not


 
Powered by phpBB® Forum Software