Thursday, March 15, 2012

File-Aid : How to see the various attributes of a load module


Select option 3.1 from the file-aid main menu

 File-AID 9.3.0 -------------  Primary Option Menu  ----------------------------
 OPTION ===> 3.1                                                               
                                                                                
   0  PARAMETERS  - Specify ISPF and File-AID parameters     USERID   - TSUXXXX
   1  BROWSE      - Display file contents                    PF KEYS  - 24     
   2  EDIT        - Create or change file contents           TERMINAL - 3278   
   3  UTILITIES   - File-AID/SPF extended utilities          TIME     - 11:02  
   5  PRINT       - Print file contents                      JULIAN   - 12.075 
   6  SELECTION   - Create or change selection criteria      DATE     - 12/03/15
   7  XREF        - Create or change record layout cross reference             
   8  VIEW        - View interpreted record layout                             
   9  REFORMAT    - Convert file from one format to another                    
  10  COMPARE     - Compare file contents                                      
   C  CHANGES     - Display summary of File-AID changes                        
   T  TUTORIAL    - Display information about File-AID                         
   X  EXIT        - Terminate File-AID and return to ISPF                      
                                                                               
      Use END to terminate File-AID                                             
                                                                               
      Online Technical Support available at:  frontline.compuware.com
          
                                                                                
      Copyright (c) 1982 - 2004, by Compuware Corporation. All rights reserved.
      Unpublished rights reserved under the Copyright Laws of the United States .
      Type LEGAL on the command line for Copyright/Trade Secret Notice.         


Select option "A" in the below screen


 File-AID -------------------  Library Utility  -------------------------------
 OPTION ===> A                                                                 
                                                                                
    A - Map CSECTs in address order            B - Browse member               
    N - Map CSECTs in name order               D - Delete member               
    I - Display directory entry of member      R - Rename member               
    BLANK - Display member list                                                
                                                                               
   Dataset name   ===> 'TS331.UATXTX.TSTSYS.LOADONL                            
                                                                               
   Member name    ===> XCL1992  (Blank or pattern for member list)             
                                                                                
   New name       ===>                                                         
                                                                               
   Volume serial  ===>          (If not cataloged)                             
                                                                               
   Disposition    ===> SHR      (SHR or OLD)                                   
                                                                                
   Process Option ===> O        (O = Online, B = Batch)                        
                                                                               

The below screen shows the various attributes of the load module.

There is one line for every CSECT defined in the Load Module.  The data on the
line falls under the column headings as follows:                             
                                                                             
    SYMBOL .... the name of the CSECT.                                       
    TYPE ...... 'SD' to indicate a section definition.   
                'LD' to indicate a label definiton.                       
    ADDR ...... the hex-offset from the beginning of the load module.        
    LENGTH .... the hexadecimal length of the csect.                         
    TNAME1 .... the first translator name for this csect                     
                ('translator' usually means compiler).                       
    TDATE1 .... the date of the first translation.                            
    TNAME2 .... the second translator name for this csect.                   
    TDATE2 .... the date of the second translation.                          
    A/R MODE .. addressing and residency modes of the csect.                 


 File-AID ADDRESS List of TS331.UATXTX.TSTSYS.LOADONL(XCL1992 Row 1 to 19 of 37
 COMMAND ===>                                                  SCROLL ===> CSR 
 XCL1992 was linked on 2009.307   by BINDER version 01.10                      
  - Symbol - Type  ADDR   Length  Tname 1    Tdate 1  Tname 2    Tdate 2 A/Rmode
 -----------  -- -------- ------ ---------- -------- ---------- -------- -------
    CL1992    SD 00000000  1C322 COBOL Z/OS 2009.307                     MIN/ANY
                 IDENT   2009.307 0.séÇØ..Ëõ.  .1XæØ  .ì.n< ..é.  .. H;..0     
    CEESG005  SD 0001C328     18 HLASM      2008.079 PL/X-390   2008.079 MIN/ANY
                 IDENT   2008.079 RSI80792818                                  
    DSNCLI    SD 0001C340     6C HLASM      2007.156                      31/ANY
     DSNHLI   LD 0001C340                                                      
     DSNWLI   LD 0001C370                                                       
    DFHEAI    SD 0001C3B0     26 HLASM      2008.108                     MIN/ANY
                 IDENT   2008.170 UK35298                                      
     DFHEI1   LD 0001C3B8                                                       
    DSNAA     SD 0001C3D8    100 HLASM      2006.200 PL/X-390   2006.200  31/ANY
                 IDENT   2007.026 UK16433                                      
     DS#AA    LD 0001C4BC                                                       
     DSNAA@   LD 0001C4D4                                                      
    DSNHADDR  SD 0001C4D8     58 HLASM      2006.090                      31/ANY
                 IDENT   2006.097 RSI60902549                                  
     DS#HADDR LD 0001C4E2                                                      
    DSNHMVHW  SD 0001C530     1C HLASM      2006.090                      31/ANY
                 IDENT   2006.097 RSI60902549                                  

Friday, March 9, 2012

File-Aid for DB2 - How to solve Table Not Found error

Some times you may receive “Table not found” error in file-aid for Db2 as shown below.


 File-AID for DB2 ----------------- Browse Options ------------ Table not found
 COMMAND ===>                                                  SCROLL ===> CSR 
                                                                 SSID ===> DB0T
 Specify DB2 Table (* or pattern for list)                                     
   Location ID ===>                        Optional:                           
   Creator     ===> MYTESTDB                  Database    ===>                 
   Table Name  ===> *                         Tablespace  ===>                 
                                                                               
 Specify Selection Criteria Information:                                       
   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)
   Criteria Display Format  ===> T   (T-Template, S-SQL)                       
   Criteria Dataset Name    ===>                                                
   Member                   ===> S1       (Blank or Pattern for list)          
                                                                               
 Specify Browse Options:                                                        
   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen
                                            2 - Row, One row per screen)       
   Use Uncommitted Read   ===> YES         (Yes or No)                          
   Maximum Rows To Select ===> 2000        (* for all rows)                    
   Relationship File      ===>                                                 
                                                                               
                                                                                
To solve the error, type the work ‘EXPAND’ on the COMMAND LINE, put the cursor on the Table Name field, and press Enter.
                                                                                

 File-AID for DB2 ----------------- Browse Options ------------ Table not found
 COMMAND ===> expand                                           SCROLL ===> CSR 
                                                                 SSID ===> DB0T
 Specify DB2 Table (* or pattern for list)                                     
   Location ID ===>                        Optional:                           
   Creator     ===> MYTESTDB                  Database    ===>                 
   Table Name  ===> *                         Tablespace  ===>                 
                                                                               
 Specify Selection Criteria Information:                                       
   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)
   Criteria Display Format  ===> T   (T-Template, S-SQL)                       
   Criteria Dataset Name    ===>                                               
   Member                   ===> S1       (Blank or Pattern for list)          
                                                                               
 Specify Browse Options:                                                       
   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen
                                            2 - Row, One row per screen)       
   Use Uncommitted Read   ===> YES         (Yes or No)                         
   Maximum Rows To Select ===> 2000        (* for all rows)                    
   Relationship File      ===>                                                 
                                                                               
                                                                                
                                                                               
                                                                               
A new panel is shown. Note that you now see the characters that were in the Table Name Field that you couldn’t see before. Clear out the extra characters and continue. This should solve the issue.


 Essssssssssssssssssssssssssssssss RETAINTN+0 sssssssssssssssssssssssssssssssssN
 e                                                          Line   1 of      2 e
 e Command ===>                                             Scroll ===> PAGE   e
 e                                                                             e
 e *                                           XXXXX                           e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 e                                                                             e
 DsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssM


Second work-around is, type the work ‘ZCLRSFLD’ on the COMMAND LINE, put the cursor on the Table Name field, and press Enter.


 File-AID for DB2 ----------------- Browse Options ------------ Table not found
 COMMAND ===> ZCLRSFLD                                         SCROLL ===> CSR 
                                                                 SSID ===> DB0T
 Specify DB2 Table (* or pattern for list)                                     
   Location ID ===>                        Optional:                           
   Creator     ===> MYTESTDB                  Database    ===>                 
   Table Name  ===> *                         Tablespace  ===>                 
                                                                                
 Specify Selection Criteria Information:                                       
   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)
   Criteria Display Format  ===> T   (T-Template, S-SQL)                        
   Criteria Dataset Name    ===>                                               
   Member                   ===> S1       (Blank or Pattern for list)          
                                                                               
 Specify Browse Options:                                                       
   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen
                                            2 - Row, One row per screen)       
   Use Uncommitted Read   ===> YES         (Yes or No)                         
   Maximum Rows To Select ===> 2000        (* for all rows)                    
   Relationship File      ===>