View - Identify View Databases Associated with a Running SARSTC Task.

Products

• View

Issue/Introduction

Is there a job or way to list all of the active View databases that are running SARSTC tasks, residing on a system?

Resolution

View currently does not have a utility to list the databases with a running SARSTC task, in an LPAR. 

For a particular View SARSTC task, on the EXEC statement, there is the PARM='view_hlq' field, which identifies the high-level qualifier of the database being used. 

A recommendation is to speak with the Storage or Performance staff to find those View databases (view_hlq.SARDBASE.I00nnnnn) that show regular I/O activity, as that activity would be related to a running SARSTC task.