Skip to end of metadata
Go to start of metadata

Content

 List/information about user tasks that executed at least one SQL statement during the last analyses (question)


Content - Description of the collected values

Example output:

===== #182970     at 2017-01-08 00:50:04
* I  Task    Cmds  tot cl exec  tot exec   tot CPU   tot I/O  tot susp  tot wait   disp   region  physical read    susp    wait    application
* I    id    exec  time (s)     time (s)   time (s)  time (s) time (s)  time (s)   count  count   count    pages   count   count     pid  node
* I  ------------------------------------------------------------------------------------------------------------------------------------------
* I  T___30   2793     0.57      0.48      0.51      0.00     -0.01      0.00      2883    26917      0       0      90       0     1236 SHL014
* I  T___40    489     1.27      1.25      1.25      0.00      0.00      0.00       615     4039      0       0       8       0     4932 SHL014
* I  T___61     50     0.01      0.01      0.01      0.00      0.00      0.00        59      359      0       0       9       0     4452 SHL014
* I  T___42    104     2.39      2.36      2.36      0.00      0.00      0.00       267     1175      0       0       1       0     5800 SHL014
[...]

 

Examples of Analyses

  • <Links to BCP tickets>
  • <Links to new pages or WORD documents describing an analysis>

 

More Information

SAP Note
Helpful with ...
936058 - FAQ: SAP MaxDB Runtime Environment Find information about task types and states and different suspend reasons.
Expert Session (Link to Trainings)
Content / Helpful with ... 
Session XX: SAP MaxDB XXX 

                            

  • No labels