SAP Knowledge Base Article - Preview

3390201 - monIOQueue reports temp table activity as IOType System - SAP ASE

Symptom

  • Selecting from monIOQueue after creating and populating a temporary table to observe the rows.
  • There are no rows reported for IOType "Tempdb Data" for the temporary table.
  • The only rows reported are those for log pages (Tempdb Log) and everything else is under System.
    Example: (rows edited to show only tempdb relevant data)

    1> select * from monIOQueue
    2> go
    InstanceID IOs         IOTime      LogicalName                    IOType
    ---------- ----------- ----------- ------------------------------ ------------
            0          14           4 master                         Tempdb Log
            0        2275        3666 tempdbdev                      System


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR828550, CR#828550, 828550 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.