Tutorial: Displaying detailed information about an object

 ADB21PI1  --------- DD1A Interpretation of an Object in SYSPLAN --------- 11:46
 Command ===>                                                                   
                                                                                
 Details for application plan : DSNTIAD                                         
                                                                    More:     + 
 Authorization ID of owner  . . . : DB2ADM                                      
 Authorization ID of creator  . . : ISTJE                                       
 Creator type . . . . . . . . . . : Auth ID                                     
 Qualifier for unqualified SQL  . : DSCGDB2                                     
 Date of latest BIND of plan  . . : 040524   (yymmdd)                           
 Time of latest BIND of plan  . . : 02411994 (hhmmssth)                         
 Time when the plan was bound . . : 2004-05-24-02.41.19.948290                  
 Version under which plan bound . : P - DB2 V11                                 
 SQL rules specified at BIND  . . : D - DB2                                     
 Cache size for auth IDs in bytes : 1024                                        
 Operative status of plan . . . . : Plan is valid and operative                 
 Resource and authorization check : At plan allocation time                     
 Plan base section size (bytes) . : 2632     (in EDM pool during execution)     
 Average DML section size (bytes) : 0        (loaded when needed during exec)   
 Plan bound with EXPLAIN option . : NO                                          
 Plan bound with DEFER(PREPARE) . : No - DEFER(PREPARE) not specified           
 Number of PACKAGE list entries . : 0                                           
 Number of enabled/disabled sys . : 0                                           
 Current server . . . . . . . . . :                                             
 Disconnect option used . . . . . : E - explicit. Release locations at commit   
 Data concurrency . . . . . . . . : C - required for ambiguous cursors          
   Effect on blocking . . . . . . : Inhibit blocking for ambiguous cursors      
 DEGREE of I/O parallelism  . . . : 1 - parallel I/O inhibited                  
 Group member that performed BIND :                                             
 Dynamic SQL rules  . . . . . . . : Not specified - use the rules for the plan  
 Re-optimize SQL at execution time: No - access path determined at BIND time    
 Keep prepared dynamic SQL stmts  : No - are destroyed at COMMIT                
 Protocol for 3 part names  . . . : D                                           
 Function resolved at . . . . . . : 2004-05-24-02.41.19.894713                  
 Optimizer hint identifier  . . . :                                             
 Encode CCSID . . . . . . . . . . : 277                                         
 Write group buffer pool pages  . : Normal write                                
 Catalog table uncoding scheme  . : Unicode                                     
 SQL path for resolving UDT,UDF,SP:                                             
                                                                                
 ROUNDING option used on last bind: Created prior to V9                   
 Concurrent access  . . . . . . . : Not specified - inherit from DB2 ZPARM
 Date that the plan was last used : 05/04/2026    
    
 Resource allocation information :                                              
 Resources acquired . . . . . . . : When first used                             
 Resources released . . . . . . . : At COMMIT                                   
 Isolation level  . . . . . . . . : Cursor stability