5 Replies Latest reply on Dec 2, 2019 1:04 PM by cpriddy

How can I view all the named queries on a server?

s.hoyer Nov 27, 2019 9:41 AM

Hopefully this is a simple question.

I need to view all the named queries on a server. Back some time ago I passed some tuning advice to a third party. It seems they took it, and the query I had originally named was modified and is now at the top of my wait list again, but slightly different. I'd like to name it the same thing, but can't find the old query to rename first.

Thanks!

Steve

Re: How can I view all the named queries on a server?

tony.fountain@wtainc.com Nov 27, 2019 10:32 AM (in response to s.hoyer)

That's a drawback in DPA, you cannot name multiple queries the same. I just use a pattern of starting with "name-01, name-02, name-03" etc.
Like (0)

Actions
- Re: How can I view all the named queries on a server?
  
  s.hoyer Nov 27, 2019 10:38 AM (in response to tony.fountain@wtainc.com)
  
  Ideally, I'd like to remove the name from the one and then name this one correctly. The query as it was is no longer used, and it's been enough days that it no longer shows in my list of bad queries. Is there any place to view all the named queries?
  
  Like (0)
  
  Actions
  - Re: How can I view all the named queries on a server?
    
    cpriddy Dec 1, 2019 1:28 PM (in response to s.hoyer)
    
    Try querying the hash, name, and descr columns from the CON_SQL_NAME table in the repository.
    
    Like (1)
    
    Actions
    - Re: How can I view all the named queries on a server?
      
      s.hoyer Dec 2, 2019 8:39 AM (in response to cpriddy)
      
      It'd still be nice to have it in the interface somewhere, but this works. Thanks!
      
      Steve
      
      Like (0)
      
      Actions
      - Re: How can I view all the named queries on a server?
        
        cpriddy Dec 2, 2019 1:04 PM (in response to s.hoyer)
        
        Agree that an out of the box option to report and manage custom names would be useful. There are a few other query naming related Thwack feature requests as well that would be useful to tackle together.
        
        Like (0)
        
        Actions

Go to original post