What is contained in the Subsystem Analyzer FMT_WIO column?

book

Article ID: 50567

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Introduction: 

This article describes what is contained in the Subsystem Analyzer FMT_WIO column.

Question: 

What is contained in the Subsystem Analyzer FMT_WIO column?

Environment:  

z/OS 1.11 and above.

Answer: 

This column contains a count of the DB2 pre-formatting I/O's of new pages in a table space during execution time.

A common reason would be Inserts which cause new extents to be built and new pages to be formatted by DB2. 

Additional Information:

If the PREFORMAT option is used in a LOAD or REORG utility, depending upon the size of the object, this could generate a substantial amount of "Format Write I/O's".

Environment

Release:
Component: PSA