Usage Analysis of a File

joesat · Post by **joesat** » Mon Feb 09, 2009 12:37 am

I would like to know if there are any ways to find out the list of DS jobs where a sequential file is used... something like a Usage Analysis report, but for a file rather than a routine, etc.

Thanks!

chulett · Post by **chulett** » Mon Feb 09, 2009 8:14 am

Usage Analysis works for files as well if you've stored metadata from the file and linked the metadata to the job by importing it. Or search for "CSeqInput" for a way to query the repository for this. You'll need "CSeqOutput" as well but the search will turn that up.

joesat · Post by **joesat** » Tue Feb 10, 2009 1:19 am

Thanks Craig!

I was able to get the reply from viewtopic.php?t=124079&highlight=CSeqInput

Since I am a newbie to DS Administrator, I would like to know how one captures the output to a file.

Craig, if you can just give me the keywords to search DSXchange I would gladly search for that.. Thanks again!

joesat · Post by **joesat** » Tue Feb 10, 2009 3:40 am

another query.. is there any way to execute these SQL statements from a command prompt rather than logging into DS Administrator?

kiran259 · Post by **kiran259** » Tue Feb 10, 2009 4:11 am

joesat wrote:another query.. is there any way to execute these SQL statements from a command prompt rather than logging into DS Administrator?

You have to run them from DS Admin.

throbinson · Post by **throbinson** » Tue Feb 10, 2009 6:23 am

Kiran259 is mistaken. You can run the SQL from the command line. Do a search for dssh or uv.

chulett · Post by **chulett** » Tue Feb 10, 2009 6:32 am

To capture output, search for "COMO ON" and you'll find "COMO OFF" as well. Output will be written to the "&COMO&" directory in the attached project.