Get Snapshot

[Hattusas]

To handle the locks on my system I use the snapshot for locks command. However this command writes the result on my command center window or db2 command line processor (dos prompt). Is it possible to redirect these lock lists to a file I state?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[sathyarams]

db2 get snapshot for locks on db001 > db001_locks.out

Does this help ?????

What version of db2 are you on ?

If you are on version 8, you can use the Snapshot table functions to access the snapshot using SQL


Cheers
Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[Hattusas]

I managed to solve my problem by using ><file_name> command.
But it was difficult to run and get tihe file via Java.However it worked.
Thank you Sathyaram!

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr