Skip to end of metadata
Go to start of metadata

x_cons <database_name> show aio

Shows statistics of running and past backups/formatting.

I/O via asynchronous I/O Threads:
 Device                     UNIX  R/W Max     Block     Read    Write   Queue
 Name                        Tid      Blocks   Size    Count    Count Len. Max.
 /sapdb/d....knltrace          1    W      1   8192        0       56   0  ( 0)
 /sapdb/d....TA_1.dat          2    W      1   8192        0       84   0  ( 1)
 /sapdb/d....p2Backup          3    R      8   8192       77        0   0  ( 1)
 /sapdb/d....OG_1.dat          4    W      1   8192        0      783   0  ( 0)
  • Device Name : Name of the media which the thread is currently accessing.
  • Window tid/Unix tid: Thread ID
  • R/W: Operation type ( read or write )
  • Max Blocks: Maximum number of blocks/pages processed for a single I/O operation
  • Block Size: Size of a block in KB
  • Read Count : Read count
  • Write Count : Write count
  • Queue Len. : Current length of the queue
  • Queue Max. : Maximum length of the queue