title: How to check the status of long running DB2 query?
body: <p>I am running a db2 query that unions two very large tables. I started the query 10 hours ago, and it doesn't seem to finish yet. </p>
  
  <p>However, when I check the status of the process by using <code>top</code>, it shows the status is 'S'. Does this mean that my query stopped running? But I couldn't find any error message.</p>
  
  <p><a href="https://i.stack.imgur.com/95c7G.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/95c7G.jpg" alt="enter image description here"></a></p>
  
  <p>How can I check what is happening to the query?</p>