Skip to end of metadata
Go to start of metadata

x_cons <database_name> show iopending

Shows running I/O jobs in the system

I/O jobs processed by job workers

 O Flg Device                           BlkPosit.  BlkCount   BlkCompl.
       Owner           Worker           QueueID               State
 F A   /sapdb/data/wrk/C0F/knltrace              0        881        881
       T1              IOWorker_002_1            1            RetSucc
 S A   /sapdb/C0F/sapdata1/DISKD0004       1279962          8          8
       T77             IOWorker_082_1            5            RetSucc
 r     /sapdb/C0F/sapdata1/DISKD0007        285581          1          1
       T122            IOWorker_004_1           83            RetSucc
 S A   _                                        -1          8          8
       T74             IOWorker_008_1          113            RetSucc
 S A   /sapdb/C0F/sapdata1/DISKD0004       1279729          8          8
       T83             IOWorker_082_1            5            RetSucc
 S A   _                                        -1          8          8
       T74             IOWorker_049_1          113            RetSucc
 r     /sapdb/C0F/sapdata1/DISKD0009        322984          1          1
       T72             SelfIO                    0            RetSucc
 S A   /sapdb/C0F/sapdata1/DISKD0004       1279994          5          5
       T76             IOWorker_082_1            5            RetSucc
 w +   /sapdb/C0F/saplog1/DISKL001          235132          1          1
       T2              SelfIO                    0            RetSucc
 r     /sapdb/C0F/sapdata1/DISKD0008        321032          1          1
       T122            IOWorker_059_1           93            RetSucc
:
 r     /sapdb/C0F/saplog1/DISKL001               1          1          1
       T116            IOWorker_074_1           13            RetSucc
 :
 S A   /sapdb/C0F/sapdata1/DISKD0004       1279655          1          1
       T81             IOWorker_082_1            5            RetSucc
 w +   /sapdb/C0F/saplog1/DISKL001          235132          1          1
       T2              SelfIO                    0            RetSucc
 :
 r     /sapdb/C0F/sapdata1/DISKD0006        336084          1          1
       T72             SelfIO                    0            RetSucc
 Displayed 114 jobs; allocated 128 descriptions, 73 pooled job workers

  • O: operation ('F'=format, 'w'=write, 'r'=read, 'W'=multi-write, 'R'=multi-read, 'S'=stream operation on backup medium, 'o'=open volume, 'c'=close volume, 'O'=open stream, 'C'=close stream, 'I'=initialize tape)
  • Flg: Flag ('A'=asynchronous I/O, 'C'=I/O on cport, '+'=high priority I/O, '-'= low priority I/O, No flag = medium priority I/O)
  • Device: Path to device
  • Owner: Owner task of the I/O
  • Worker: Either I/O worker name working on the operation or self I/O if the task does the I/O by itself inline.
  • BlkPosit.: Starting block position on volume, where the I/O occurs.
  • QueueID: Queue ID of I/O subsystem (each volume has several queues)
  • BlkCount: Requested count of blocks in the I/O, usually starting from BlkPosit, except for multi-I/O, where they can be scattered.
  • BlkCompl.: The number of already completed blocks, here we can see formatting progress for instance.
  • State: Stuste of the I/O operation. Additionally, there are two status RetSucc

I/O job status

  • Pending: pending
  • InProgress: in progress
  • Success: success
  • Failed: failed
  • RetSucc: retired successfully. Per I/O context, some history of retired operations (by default 8), so we can see what each task has done in the past time. (see parameter RetiredIOJobCount)
  • RetFail: retired failed
  • Cancelled: cancelled
  • No labels