Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
IBM File Manager for z/OS® User’s Guide and Reference for Db2 Data Version 14.1.21
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with FM/Db2
  • FM/Db2 reference
  • Messages
  • Support resources
  • Notices
  1. Home
  2. FM/Db2 reference
  3. FM/Db2 panels and fields
  4. EXPLAIN Interpretation panel
  • FM/Db2 reference
    • Db2® data types
    • FM/Db2 panels and fields
      • Scrollable fields on FM/Db2 panels
      • Action bar pull-down menu
      • Additional LISTDEF Statements panel
      • Additional TEMPLATE Statements panel
      • Advanced SELECT Prototyping panel
      • Alter Database panel
      • Alter External Scalar Function panel
      • Alter Index panel
      • Alter Stored Procedure panel
      • Alter Table panel
      • Alter Table - ADD CHECK Constraint panel
      • Alter Table - ADD Column panel
      • Alter Table - ADD FOREIGN KEY Constraint panel
      • Alter Table - ADD PRIMARY KEY panel
      • Alter Table - AUDIT panel
      • Alter Table - DATA CAPTURE panel
      • Alter Table - DROP CHECK Constraint panel
      • Alter Table - DROP FOREIGN KEY Constraint panel
      • Alter Table - DROP PRIMARY KEY panel
      • Alter Table - RESTRICT ON DROP panel
      • Alter Table - VALIDPROC panel
      • Alter Table Space panel
      • Application Packages panel
      • Application Plans panel
      • Basic SELECT Prototyping panel
      • Bind Application Plan panel
      • Bind Package panel
      • Children of Table panel
      • Collections panel
      • Column Attributes panel (alphanumeric)
      • Column Attributes panel (DATE)
      • Column Attributes panel (numeric)
      • Column Attributes panel (TIME)
      • Column Attributes panel (TIMESTAMP)
      • Column Distribution panel
      • Column Part Statistics panel
      • Column Selection/Edit panel
      • Columns panel
      • Columns in Index panel
      • Columns in Table panel
      • Comment panels
      • Compiler Language Selection panel
      • Constraint Columns for panel
      • Copy Options panel
      • Copy Utility ("From") panel
      • COPY Utility (Index Spaces) panel
      • COPY Utility (Index Spaces) with LISTDEF panel
      • Copy Utility ("To") panel
      • COPY Utility (Table Spaces) panel
      • COPY Utility (Table Spaces) with LISTDEF panel
      • Create Alias panel
      • Create Auxiliary Table panel
      • Create Database panel
      • Create Distinct Type panel
      • Create Function: Option List (1/2) panel
      • Create Function: Option List (2/2) panel
      • Create Function panel
      • Create Function: Parameter Types panel
      • Create Function: Parameters panel
      • Create Function: Returned Data Type panel
      • Create Index panel
      • Create Index: Allocation panel
      • Create Index: Column Selection panel
      • Create Index: Options panel
      • Create Index: Partitions panel
      • Create Index: Partition Values panel
      • Create Index: Type panel
      • Create Procedure panel
      • Create Procedure: Option List (1/2) panel
      • Create Procedure: Option List (2/2) panel
      • Create Procedure: Parameter Types panel
      • Create Procedure: Parameters panel
      • Create Synonym panel
      • Create Table panel
      • Create Table Space panel
      • Create Table Space: Allocation panel
      • Create Table Space: Data Sharing Options panel
      • Create Table Space: Data Storage Options panel
      • Create Table Space: Define Partitions panel
      • Create Table Space: Locking Options panel
      • Create Table Space: Type panel
      • Create Table: Column Check Constraints panel
      • Create Table: Column Referential Constraints panel
      • Create Table: Columns panel
      • Create Table: Generate Values panel
      • Create Table: Model Load panel
      • Create Table: Nulls and Default Values panel
      • Create Table: Options panel
      • Create Table: Procedure Exits panel
      • Create Table: Table Check Constraints panel
      • Create Table: Table Referential Constraint panel
      • Create Table: Table Referential Constraints panel
      • Create Table: Unique Constraints panel
      • Create Trigger panel
      • Create Trigger: Details panel
      • Create Trigger: Search Condition panel
      • Create Trigger: SQL statement panel
      • Create View panel
      • Create View Source Statements panel
      • Data Create Utility panel
      • Database Request Modules panel
      • Database Structure panel
      • Databases panel
      • Db2® Browse panel
      • Db2® Edit panel
      • Db2® Location Selection panel
      • Db2® Object Functions panel
      • Db2® Save Error Action panel
      • Db2® Subsystem Selection panel
      • Db2® Template Description panel
      • Db2® Utilities panel
      • Db2® View panel
      • Db2I Primary Option Menu panel
      • Details panels
      • Display Row panel
      • Distinct Types panel
      • Drop panels
      • Drop Confirmation panel
      • Edit/Execute SQL (Data Set) panel
      • Editor Options (1 of 8) panel
      • Editor Options (2 of 8) panel
      • Editor Options (3 of 8) panel
      • Editor Options (4 of 8) panel
      • Editor Options (5 of 8) panel
      • Editor Options (6 of 8) panel
      • Editor Options (7 of 8) panel
      • Editor Options (8 of 8) panel
      • Enter and Execute Db2® Commands panel
      • Enter, Execute and Explain SQL Statements panel
      • EXPLAIN Interpretation panel
      • Explain Utilities panel
      • Export Options (1 of 3) panel
      • Export Options (2 of 3) panel
      • Export Options (3 of 3) panel
      • Export Utility ("From") panel
      • Export Utility ("To") panel
      • Field Selection/Edit panel
      • FM/Db2 Release News panel
      • Foreign Keys for Table panel
      • Free Application Plan panel
      • Free Package panel
      • From Column Mapping panel
      • Functions panel
      • Generate SQL From Db2® Catalog panel
      • Grant privileges panels
      • Import Options panel
      • Import Utility ("From") panel
      • Import Utility ("To") panel
      • Index Parts panel
      • Indexes panel
      • Indexes and Columns for panel
      • ISPF Primary Option panel
      • ISPF Settings panel
      • Label Column panel
      • Label Table panel
      • LISTCAT Output Display panel
      • LISTDEF Options panel
      • LOAD from panel
      • LOAD Utility panel
      • LOAD Utility panel using Db2® templates
      • LOAD Utility - Using Templates panel
      • LOAD Utility Options panel
      • Manage Db2® Privileges panel
      • Object List Line Commands panel
      • Object List Options (1 of 2) panel
      • Object List Options (2 of 2) panel
      • Object List Utility panel
      • OPTIONS Options panel
      • Package Dependencies panel
      • Package List panel
      • Parents of Table panel
      • Partitioned Table Statistics panel
      • Plan Dependencies panel
      • Plan Enabled/Disabled Connections panel
      • Plan Table Rows panel
      • Primary Key for Table panel
      • Primary Option Menu panel
      • Print Audit Trail panel
      • Print Utility Options panel
      • Print Utility panel
      • Privilege details panels
      • Privileges panels
      • Rebind Application Plan panel
      • Rebind Package panel
      • REBUILD (Indexes for Table Spaces) panel
      • REBUILD (Indexes for Table Spaces) with LISTDEF panel
      • REBUILD Utility (Indexes) panel
      • REBUILD (Indexes) with LISTDEF panel
      • Record Type Selection panel
      • RECOVER Utility (Index Spaces) panel
      • RECOVER Utility (Index Spaces) with LISTDEF panel
      • RECOVER Utility (Table Spaces) panel
      • RECOVER Utility (Table Spaces) with LISTDEF panel
      • Recovery Information panel
      • Related tables panel
      • Remote Db2® Location Selection panel
      • REORG Utility (Indexes) panel
      • REORG Utility (Indexes) with LISTDEF panel
      • REORG Utility (Table Spaces) panel
      • REORG Utility (Table Spaces) with LISTDEF panel
      • Revoke privileges panels
      • Routine Parameters panel
      • Row Selection Criteria panel
      • RUNSTATS Utility (Indexes) panel
      • RUNSTATS Utility (Indexes) with LISTDEF panel
      • RUNSTATS Utility (Table Spaces) panel
      • RUNSTATS Utility (Table Spaces) with LISTDEF panel
      • Schemas panel
      • Scramble Exit Specification panel
      • Select Statement Browse panel
      • Select Statement Edit panel
      • Sequences panel
      • Set Batch Job Card Information panel
      • Set COBOL Processing Options panel
      • Set HLASM Processing Options panel
      • Set Optimizer Hint panel
      • Set Output Data Set Allocation Options panel
      • Set PL/I Processing Options panel
      • Set Print Processing Options panel
      • Set Processing Options panel
      • Set System Processing Options panel
      • Set Temporary Data Set Allocation Options panel
      • Set Trace options panel
      • Set Utility Options panel
      • Sort Fields panel
      • SQL Prototyping, Execution and Analysis panel
      • Statement Table Rows panel
      • Storage Group(s) panel
      • Storage Group Usage Privileges panel
      • Stored Procedures panel
      • Synonym Dependencies panel
      • Synonyms panel
      • Systems Options (1 of 4) panel
      • Systems Options (2 of 4) panel
      • Systems Options (3 of 4) panel
      • Systems Options (4 of 4) panel
      • Table Browse panel
      • Table Check Constraint Dependencies panel
      • Table Check Constraint Details panel
      • Table Check Constraints panel
      • Table Edit panel
      • Table Edit (related) panel
      • Table Selection panel
      • Table Space Parts panel
      • Table Spaces panel
      • Table View panel
      • Table/View/Alias Selection panel
      • Tables, Views and Aliases panel
      • TEMPLATE Options (1 of 2) panel
      • TEMPLATE Options (2 of 2) panel
      • Template Mapping panel
      • Template Save panel
      • Triggers panel
      • UNLOAD Options panel
      • UNLOAD Utility (Table Spaces) panel
      • UNLOAD Utility (Table Spaces) with LISTDEF panel
      • UNLOAD Utility (Tables) "From" panel
      • UNLOAD Utility (Tables) "To" panel
      • UNLOAD Utility (Tables) with LISTDEF panel
      • Utility Functions panel
      • Value List Edit panel
      • Volumes panel
    • FM/Db2 commands
    • FM/Db2 functions

EXPLAIN Interpretation panel

FM/Db2 displays the EXPLAIN Interpretation panel if you use the I line command against an item listed on:
  • The Plan Table Rows panel, or
  • The Statement Table Rows panel

Rate this topic


  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences