Skip to end of metadata
Go to start of metadata

Content

Provides information about all task suspend reasons.
The output is generated by the x_cons tool and matches with "x_cons <DB name> show suspends".


Content - Description of the collected values

Example output:

===== #184590     at 2017-01-08 05:20:24
*  I  Suspend Reason             Count    Abs.Suspend Time in ms         Avg.Abs.Suspend Time in ms
*  I  ----------------------------------------------------------------------------------------------------------------------------------
*  I  TableRootExcl                  1           0.003                       0.003
*  I  TableNodeExcl                  2           0.057                       0.029
*  I  LogIOwait(234)              1349        1048.081                       0.777
*  I  Vsuspend (204)               320        2465.830                       7.706
*  I  JobWait BckRec                 2        5040.699                    2520.349
*  I  IOWait(R)(041)                 3          16.880                       5.627
*  I  InvNodeExcl                    2           0.007                       0.004
*  I  SVP-LogW (211)                 1           0.042                       0.042
*  I  InvRootExcl                    1           0.004                       0.004
*  I  JobWait UpdStt               432         180.106                       0.417

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 different suspend reasons.
Expert Session (Link to Trainings)
Content / Helpful with ... 
Session XX: SAP MaxDB XXX 

                            

  • No labels