Migrating Db2 objects


Just as changing Db2 objects is a three-stage process, migrating Db2 objects from one environment to another within the same Db2 subsystem in ALTER or 

BMC AMI Change Manager for Db2

 is also a three-stage process.

The three stages are specification, analysis, and execution.

  1. Specification

    Identify the objects to be migrated and specify changes to the data structures.

  2. Analysis

    Analyze the specified migration changes for accuracy and completeness. The result of the analysis stage is a worklist that contains the SQL and the information that is necessary to generate the data structure in the target Db2 system.

  3. Execution

    Execute the worklist that is generated during the analysis stage.

Important

The changes that you specify in the specification stage and analyze in the analysis stage are actually made to the objects in the execution stage.

The following example illustrates these three stages by showing how to use the Task List feature of Change Manager to quickly and easily migrate objects from one environment to another environment within the same Db2 subsystem.

Important

Remember that Change Manager can also migrate only the changes that you make to a data structure on one Db2 subsystem to other Db2 subsystems.

Before you begin a set of tasks to achieve a particular goal, you should allocate your JCL data sets for analysis and execution, ensure that you are using the correct Db2 subsystem, and define your job card with the correct account information.

GUID-47E5A770-A760-442A-9F5A-06872981813D-low.png

For more information, view the Quick Course CHANGE MANAGER for DB2 - Migrating in Same Subsystem.

To migrate objects

  1. Start the Task List feature.The Task List feature of Change Manager enables you to achieve various goals by taking you step-by-step through a series of tasks.
    1. On the BMC AMI Change Manager for Db2 Main Menu, select Task List and press Enter.The Task List Menu is displayed.

      ALUFTASK ------------------------- Task List Menu -----------------------------
      Command ===>                                                                   
                                                                                    
                                                                                    
                                                                                    
      Select a task.  Then press Enter.                                              
            2 1. Create, alter, or drop Db2 objects                                  
              2. Migrate Db2 objects using Specification                             
              3. Migrate Db2 objects using scope rules from a Migrate Profile        
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
      Commands:  HELP END                                                            
    2. On the Task List Menu, select Migrate Db2 objects using Specification and press Enter.The Migrate Db2 Objects Using Specification panel is displayed:

      ALUFPALT -------------------- Migrate Db2 Objects Using Specification ---------
      Command   ===>                                                                 
                                                                                    
      Specify a Migrate WORKID.                                                      
      If the WORKID does not exist, the Create WORKID panel will be displayed.       
      To see a list of WORKIDs, type a wildcard pattern.  (For example BM*.*)        
                                                                                    
      Migrate WORKID:  RDACRJ.RD10405D                                               
                                                                                    
      Optionally specify a Migrate Profile.                                          
      If the profile does not exist, the Create Profile panel will be displayed.     
      To see a list of profiles, type a wildcard pattern. For example BM*.*)         
                                                                                    
      Migrate Profile:                                                               
                                                                                    
      Type S to select processing options.  Then press Enter to continue.            
      _ Create or edit a Migrate Profile                                             
      _ Create or edit a WORKID                                                      
      _ Specify changes to Db2 objects                                               
      _ Analyze the changes to create a worklist                                     
      _ Execute the worklist to process the changes                                  
                                                                                                                                              
  2. On the Migrate Db2 Objects Using Specification panel, specify a migrate-type work ID.A work ID enables you to identify, control, and track a unit of work. The migrate-type work ID is used to specify data structure definitions to be migrated from one Db2 subsystem to another, or to duplicate structures within the same subsystem.
    1. On the Migrate Db2 Objects Using Specification panel, type the name of a migrate-type work ID, and type S to select all of the processing options except Create or edit a Migrate Profile. Then, press Enter.The Create WORKID panel is displayed.

      ALUFWRKC -------------------------- Create WORKID ----------- WORKID NOT FOUND
      Command ===>                                                                   
                                                                                    
      WORKID . . . . . . : RDACRJ.RD10405D                                           
                                                                                    
      Type . . . . . . . . 2 1. Alter                                                
                             2. Migrate                                              
                             3. Receive                                              
                                                                                    
                                                                                    
      Comment  . . . . . .                                                           
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
      Select additional panels to display for Migrate type WORKID.  Then press Enter.
      _ WORKID Migrate Options                                                       
      _ WORKID Change Rules                                                          
                                                                                    
                                                                                    
      Commands:  HELP END CANCEL          
    2. On the Create WORKID panel, select Migrate for the Type. Type S to select the WORKID Change Rules. Then, press Enter.The Change Rules panel is displayed.

      Change rules enable you to specify global changes to the name, owner, creator, or other attributes of the objects. The new attributes that you specify apply to all objects in the migration that possess the attributes.

    3. On the Change Rules panel, type E in the Act field to select Edit. Press Enter.The Edit Change Rules panel is displayed.

      ALUF3RLE ---------------------- Edit Change Rules -----------------------------
      Command ===>                                                                   
                                                                                    
      Option . . . 1    1. Change   2. Include   3. Exclude  4. Force                
                                                                                    
      Object . . .      1. Stogroup        8.  Unique Cnst   15. Stored Procs        
                        2. Database        9.  View          16. Sequences           
                        3. Tablespace      10. Trigger       17. Functions           
                        4. Table           11. Alias         18. Row Permissions     
                        5. Check Cnst      12. Synonym       19. Column Masks        
                        6. Foreign Key     13. Plan          20. All                 
                        7. Index           14. Package                               
                                                                                    
      Attribute. .                        _  Display Attribute List                  
                                                                                    
      Current Attribute Value. .                                                     
      New Attribute Value. . . .                                                     
                                                                                    
      Specify optional object name(s).                                               
       Part1                                                  (SG, DB, owner, schema)
       Part2                                                  (TS, name)             
       Part3                                                  (SP, version)          
                                                                                    
      Commands:  HELP END CANCEL PF4=ZOOM                                            
    4. On the Edit Change Rules panel, select Change as the Option for the attribute, select All as the Object, and type S to select Display Attribute List. Press Enter.By selecting All objects, you can specify one change rule that changes an attribute for all of the tables, indexes, views, and so on. You can change an attribute that applies to all of the migrated objects that have that attribute.

      The Edit Rules Attribute Selection panel is displayed.

      ALUF3RL2 --------------- Edit Rules Attribute Selection -----------------------
      Command ===>                                                                   
                                                                                    
      Option . . . . . .  Change                                                     
      Object . . . . . .  All                                                        
      Attribute Name . .                                                             
                                                                                    
      Select from attribute list below.                                              
                                                                                    
      Attribute Number. .                                                            
                                                                                    
                 1. Activate     17. Debug_Mode    *. Log          49. SPType       
                 2. Append       18. Define       34. Maxparts     50. Stog_VCAT    
                 3. Asutime      19. Devtype      35. Name          *. Stogroup     
                 4. Audit        20. Dssize       36. Owner        52. Tablespace   
                 5. BuffpoolIX   21. DssizeRPN    37. Pctfree      53. Trackmod     
                 6. BuffpoolTS   22. Editproc     38. Pctfreeupd   54. Validproc    
                 7. CCSID        23. Erase        39. Piecesize    55. VCAT         
                 8. Close        24. Fieldproc    40. PKOwner      56. VCAT_Stog    
                 9. Collection   25. Freepage     41. Priqty       57. Version      
                10. Colname      26. Grantee      42. Qualifier    58. Volatile     
                11. Compress     27. Grantor      43. Resident     59. Volorder     
                12. Createdby     *. Inline       44. Restrict     60. Volume       
                13. Creator      29. Keylabel      *. Schema       61. WLM_Env      
                14. Database     30. Location     46. Secqty                        
                15. DataCapture  31. Lockmax      47. Segsize                       
                16. Dbrmlib      32. Locksize     48. SPAlter                       
                                                                                    
                                                                                    
                                                                                    
      Commands:  HELP END CANCEL PF4=ZOOM                                            
    5. On the Edit Rules Attribute Selection panel, select the number for the Name attribute. Press Enter and then press END.The Edit Change Rules panel is displayed.

      ALUF3RLE ---------------------- Edit Change Rules -----------------------------
      Command ===>                                                                   
                                                                                    
      Option . . . 1    1. Change   2. Include   3. Exclude  4. Force                
                                                                                    
      Object . . . 20   1. Stogroup        8.  Unique Cnst   15. Stored Procs        
                       2. Database        9.  View          16. Sequences           
                       3. Tablespace      10. Trigger       17. Functions           
                       4. Table           11. Alias         18. Row Permissions     
                       5. Check Cnst      12. Synonym       19. Column Masks        
                       6. Foreign Key     13. Plan          20. All                 
                       7. Index           14. Package                               
                                                                                    
      Attribute. . NAME                   _  Display Attribute List                  
                                                                                    
      Current Attribute Value. .                                                     
      New Attribute Value. . . .                                                     
                                                                                    
      Specify optional object name(s).                                               
      Part1                                                  (SG, DB, owner, schema)
      Part2                                                  (TS, name)             
      Part3                                                  (SP, version)          
                                                                                    
      Commands:  HELP END CANCEL PF4=ZOOM                                            
    6. On the Edit Change Rules panel, type the Current Attribute Value and the New Attribute Value for the database name. Press END.

      The change rules are displayed in the Change Rules panel.

      ALUFRULL ------------------   Change Rules ------------------------------------
      Command ===>                                                  SCROLL ===> PAGE
                                                                                    
      WORKID . . . . : RDACRJ.RD10405D                                               
                                                                                    
      Type action next to existing rule or overtype existing values.                 
                                                                   Rules 1 to 1 of 1
      E=Edit I=Insert D=Delete L=Like C=Create                         More:       >
      Act Opt Obj Attribute  Current Attribute Value     New Attribute Value         
      ************************************** TOP ************************************
          C   **  NAME       R1128C04                    R1128C30                    
      ************************************* BOTTOM **********************************
    7. On the Change Rules panel, type L in the Act field for the name rule. The L enables you to create a new rule like the existing rule. Press Enter.
    8. On the second line, type OWNER over NAME in the Attribute field, type * for the Current Attribute Value (if you do not know the current owner), and type your TSO logon ID (or other desired value) for the New Attribute Value. Press Enter.The Change Rules panel is displayed.

      ALUFRULL ------------------   Change Rules ------------------------------------
      Command ===>                                                  SCROLL ===> PAGE
                                                                                    
      WORKID . . . . : RDACRJ.RD10405D                                               
                                                                                    
      Type action next to existing rule or overtype existing values.                 
                                                                   Rules 1 to 2 of 2
      E=Edit I=Insert D=Delete L=Like C=Create                         More:       >
      Act Opt Obj Attribute  Current Attribute Value     New Attribute Value         
      ************************************** TOP ************************************
          C   **  NAME       R1128C04                    R1128C30                    
          C   **  OWNER      *                           RDACRJ4
          C   TR  SCHEMA     *                           RDACRJ4                      
      ************************************* BOTTOM **********************************
    9. Add additional rules as needed, such as changing the trigger schema.
    10. Press END.The Edit WORKID Migration Options panel is displayed.
    11. Press END to return to the Object Specification panel.


  3. Identify the objects and dependent objects that you want to migrate.
    1. On the Object Specification panel, type the name of a Database. Press Enter.The Mixed List panel is displayed with the dependent objects of the database.

      ALUSMXL RATE --------------------------- Mixed List ---------------------------
      Command ===>                                                    Scroll. . CSR  
                                                                                    
      WORKID  . . . . : RDACRJ.RD10405D                             Commands: CANCEL
                                                                                    
      Type action next to object and press Enter.                                    
         E=Edit  L=Like  D=Drop  U=Undo  M=Migrate  MO=Migrate options               
                                                          Objects 149 to 170 of 227  
                                                                       More:   - +   
      Act     Object-Type    Objects                                           
      ************************************ TOP **************************************      
              DB . . . . . . R1128C04                                                
                TSR2 . . . .   R1128C04   T128PBR2                                   
                  TBBT . . .     R1128C04   T@T128PBR2                               
                    CK . . .       R1128C04   T@T128PBR2           CK@T128PBR2       
                    FK . . .       R1128C04   T@T128PBR2           FK@T128PBR2       
                    IXVD . .       R1128C04   I_DOCIDT@T128PBR2                      
                    IX . . .       R1128C04   I@T128PBR21                            
                    IXP. . .       R1128C04   I@T128PBR22                            
                      UCP. .         R1128C04   T@T128PBR2           PK@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR23                            
                      UCU. .         R1128C04   T@T128PBR2           UC@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR24                            
                    IXS. . .       R1128C04   I@T128PBR25                            
                    IXS. . .       R1128C04   I@T128PBR26                            
                    TRB. . .       R1128C04   TR@T128PBR2                            
                    VW . . .       R1128C04   V1@T128PBR2                            
                    VW . . .       R1128C04   V2@T128PBR2                            
                    VW . . .       R1128C04   V3@T128PBR2                            
                    VW . . .       R1128C04   V4@T128PBR2                            
                    VW . . .       R1128C04   V5@T128PBR2                            
    2. On the Mixed List panel, type M in the Act field next to the database that you want to migrate. Press Enter.
    3. Type MO in the Act field next to the database that you selected. Press Enter.The Migrate Options Overrides panel is displayed.

      ALUSMO GRATE -------------------- Migrate Options Overrides -------------------
      Command ===>                                                                   
                                                                   Commands: CANCEL
      WORKID  . . . . : RDACRJ.RD10405D                                              
      Database  . . . : R1128C04                                                     
                                                                                    
      Specify dependencies that should also be migrated.                             
      (Y=include them;  N=omit them)                                                 
                                                                                    
      _  Migrate Data                                                               
      _  Migrate Tablespaces                                                        
      _  Migrate Tables                                                             
      _  Migrate Unique Constraints                                                 
      _  Migrate Check Constraints                                                  
      _  Migrate Foreign Keys                                                       
      _  Migrate Indexes                                                            
      _  Migrate Views                                                              
      _  Migrate Authorizations                                                     
      _  Migrate Synonyms                                                           
      _  Migrate Aliases                                                            
      _  Migrate Trigger                                                            
      _  Migrate Auxiliary Objects                                                  
      _  Migrate Row Permissions                                                    
      _  Migrate Column Masks                                                       
                                                                                    
      Commands: HELP END CANCEL                                                      
    4. On the Migrate Options Overrides panel, type Y to select the dependent objects that you want to migrate. Press Enter, and then press END.In this example, data was selected. No dependent objects were selected.

      The Mixed List panel is displayed, as shown below. An '*M' is displayed next to the database that you selected to migrate.

      ALUSMXL RATE --------------------------- Mixed List ---------------------------
      Command ===>                                                    Scroll. . CSR  
                                                                                    
      WORKID  . . . . : RDACRJ.RD10405D                             Commands: CANCEL
                                                                                    
      Type action next to object and press Enter.                                    
         E=Edit  L=Like  D=Drop  U=Undo  M=Migrate  MO=Migrate options               
                                                          Objects 149 to 170 of 227  
                                                                       More:   - +   
      Act     Object-Type    Objects                                           
      ************************************ TOP **************************************      
          *M  DB . . . . . . R1128C04                                                
                TSR2 . . . .   R1128C04   T128PBR2                                   
                  TBBT . . .     R1128C04   T@T128PBR2                               
                    CK . . .       R1128C04   T@T128PBR2           CK@T128PBR2       
                    FK . . .       R1128C04   T@T128PBR2           FK@T128PBR2       
                    IXVD . .       R1128C04   I_DOCIDT@T128PBR2                      
                    IX . . .       R1128C04   I@T128PBR21                            
                    IXP. . .       R1128C04   I@T128PBR22                            
                      UCP. .         R1128C04   T@T128PBR2           PK@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR23                            
                      UCU. .         R1128C04   T@T128PBR2           UC@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR24                            
                    IXS. . .       R1128C04   I@T128PBR25                            
                    IXS. . .       R1128C04   I@T128PBR26                            
                    TRB. . .       R1128C04   TR@T128PBR2                            
                    VW . . .       R1128C04   V1@T128PBR2                            
                    VW . . .       R1128C04   V2@T128PBR2                            
                    VW . . .       R1128C04   V3@T128PBR2                            
                    VW . . .       R1128C04   V4@T128PBR2                            
                    VW . . .       R1128C04   V5@T128PBR2                            
    5. On the Mixed List panel, type M in the Act field next to the table space that you want to migrate. Press Enter.
    6. Type MO in the Act field next to the table space that you selected. Press Enter.The Migrate Options Overrides panel is displayed.
    7. On the Migrate Options Overrides panel, type Y to select the dependent objects that you want to migrate. Press Enter, and then press END.In this example, data and all of the dependent objects were selected.

      The Mixed List panel is displayed, as shown below. An '*M' is displayed next to the table space that you selected to migrate.

      ALUSMXL RATE --------------------------- Mixed List ---------------------------
      Command ===>                                                    Scroll. . CSR  
                                                                                    
      WORKID  . . . . : RDACRJ.RD10405D                             Commands: CANCEL
                                                                                    
      Type action next to object and press Enter.                                    
         E=Edit  L=Like  D=Drop  U=Undo  M=Migrate  MO=Migrate options               
                                                          Objects 149 to 170 of 227  
                                                                       More:   - +   
      Act     Object-Type    Objects                                           
      ************************************ TOP **************************************      
          *M  DB . . . . . . R1128C04                                                
          *M    TSR2 . . . .   R1128C04   T128PBR2                                   
                  TBBT . . .     R1128C04   T@T128PBR2                               
                    CK . . .       R1128C04   T@T128PBR2           CK@T128PBR2       
                    FK . . .       R1128C04   T@T128PBR2           FK@T128PBR2       
                    IXVD . .       R1128C04   I_DOCIDT@T128PBR2                      
                    IX . . .       R1128C04   I@T128PBR21                            
                    IXP. . .       R1128C04   I@T128PBR22                            
                      UCP. .         R1128C04   T@T128PBR2           PK@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR23                            
                      UCU. .         R1128C04   T@T128PBR2           UC@T128PBR2     
                    IXU. . .       R1128C04   I@T128PBR24                            
                    IXS. . .       R1128C04   I@T128PBR25                            
                    IXS. . .       R1128C04   I@T128PBR26                            
                    TRB. . .       R1128C04   TR@T128PBR2                            
                    VW . . .       R1128C04   V1@T128PBR2                            
                    VW . . .       R1128C04   V2@T128PBR2                            
                    VW . . .       R1128C04   V3@T128PBR2                            
                    VW . . .       R1128C04   V4@T128PBR2                            
                    VW . . .       R1128C04   V5@T128PBR2                            
    8. Press END to return to the Object Specification panel. Press END again.The Analysis Migrate Worklist Interface panel is displayed.

      ACMFANL2 --------------- Analysis Migrate Worklist Interface ------------------
      Command   ===>                                                                 
                                                                                    
      WORKID  . . . . . : RDACRJ.RD10405D                                            
                                                                                    
      Analyze "Migrate" WORKID                                                       
                                                                                    
      Select type of analysis.                                                       
      1 1. Analyze Specification entries (use the WORKID's change rules)             
        2. Analyze Specification entries (use a Migrate Profile's locations and      
           change rules)                                                             
        3. Analyze Migrate Profile scope (use the Migrate Profile's locations and    
           change rules)                                                             
                                                                                    
      Type an Outbound Migrate Profile, or type a wildcard pattern for a selection   
      list if analysis type is 2 or 3.                                               
        Migrate Profile . .                                                          
                                                                                    
      Select run type.  Then press Enter.                                            
        Run Type  . . . . . 2 1. Foreground                                          
                              2. Batch                                               
                                                                                    
      Commands:  HELP END                                                            
  4. Analyze the migration changes that you specified.The Analysis component of the product examines the changes that you specified and generates a worklist that contains the instructions that are necessary to implement the actions chosen during the specification stage.
    1. On the Analysis Migrate Worklist Interface panel, select the Analyze Specification entries (use the WORKID’s change rules) option. Then select to run the Analysis in Batch. Press Enter.

      Important

      If you run Analysis in foreground, your TSO session is unavailable until the processing has completed.

      The Analysis JCL Processing Interface panel is displayed.

      ACMFANL3 ---------------- Analysis JCL Processing Interface -------------------
      Command   ===>                                                                 
                                                                                    
      WORKID . . . . : RDACRJ.RD10405D                                               
                                                                                    
                                                                                    
      Specify Dataset Names                                                          
        JCL . . . . . . . . 'ACM.DB2V13.V131.ANLYJCL(RD10405D)'                      
        Worklist  . . . . . 'ACM.DB2V13.V131.WLBASE01(RD10405D)'                     
        Diagnostics . . . . SYSOUT                                                   
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
      Select batch processing options.  Then press Enter.                            
      S Override                                                                     
      S Create JCL                                                                   
      S Edit JCL                                                                     
      _ Submit JCL                                                                   
      _ Edit Worklist                                                                
                                                                                    
      Commands:  BROWSE PREVIOUS HELP END                                            
    2. On the Analysis JCL Processing Interface panel, specify your data set names, and type S to select the processing options. In this example, one of the options for analysis is overridden. Press Enter.

      Tip

      To change the default values, see the Overrides-of-default-processing-options section.

      The Analysis Worklist Options panel is displayed.

      ALUF0OA1 ----------------- Analysis Worklist Options --------------------------
      Command ===>                                                                    
                                                                                     
      Type information. Then press Enter to continue.                                 
                                                                                     
      Specify allocation parameters for new datasets.                                 
        Dataset    Unitname   Volume   Priqty   Secqty   Alloc Unit                   
        Worklist   SYSDA                   15        5   Tracks                       
                                                                                     
                                                                                     
      Specify optional Global AUTHID.                                                 
        Global AUTHID  . .                                                            
                                                                                     
      Specify sync point frequency.                                                   
        Frequency  . . . . 10                                                         
                                                                                     
      Analyze for ROLE as OWNER.                                                      
        ROLEOWN  . . . . . N                                                          
                                                                                     
      Use spanned records.                 Use ALTER TABLESPACE MOVE TABLE.           
        SPANNEDRECS  . . . Y                 MOVETB . . . N                           
                                                                                     
      Commands:  HELP END                                                 
    3. On the Analysis Worklist Options panel, press Enter to accept the defaults.

      Tip

      To change the default values, see the topics explaining overrides in the Overrides-of-default-processing-options section.

      The Analysis Worklist Command Options panel is displayed.


      ALUFOA20 ---------------- Analysis Worklist Command Options -------------------
      Command ===>                                                                   
                                                                                    
      Type information. Then press Enter to continue or PF12 for previous panel.     
                                                                                    
      Select the elements to include in this worklist.                               
                                                                                    
      S SQL                                                                          
      S Data                                                                         
        S Clone Data                                                                 
      S AMS                                                                          
        _ STORCLAS                                                                   
        _ MGMTCLAS                                                                   
        _ DATACLAS                                                                   
      _ BIND                                                                         
        _ DBRMLIB                                                                    
        _ BINDONIX                                                                   
        _ BINDAUTH                                                                   
                                                                                    
      Commands:  HELP END PREVIOUS                                                                       
    4. On the Analysis Worklist Command Options panel, press Enter to accept the defaults.The Analysis Input Stream Parameters panel is displayed.

      ALUFOA30 ---------------- Analysis Input Stream Parameters --------------------
      Command ===>                                                                   
                                                                                    
      Type information. Then press Enter to continue or PF12 for previous panel.     
                                                                                    
      Select any of the following analysis parameters.                               
      _ ENV             Display installation environment                             
      _ PKEYPROP        Propagate parent key changes to foreign keys                 
      _ VALWARN         Display errors as warnings for conditions in text            
      _ VVALPROP        Propagate table column changes to base views                 
      _ NOORDERBY       Omit the ORDER BY clause for unloads in the worklist         
      _ NOUNLOADEMPTY   Do not unload tables that IBM RUNSTATS indicates are empty   
      _ STOPCOMMIT      Generate an AT(COMMIT) statement for every STOP command      
      _ DEFERUNIQUEIX   Create unique indexes with DEFER YES                         
      _ CISIZE4K        Create all VSAM data sets with a CISIZE of 4 KB              
      _ PARALLEL        Enable worklist parallelism                                  
      _ SINGLEPHASE     Omit the -STOP command between phases of a migrate worklist  
      _ APPLCOVR        Include APPLCOMPAT overrides in worklist                     
                                                                                    
                                                                                    
                                                                                    
                                                                                    
      Commands:  HELP END PREVIOUS                 
    5. On the Analysis Input Stream Parameters panel, type S to select the option SINGLEPHASE. When you migrate within a single subsystem, you normally do not want to stop between phases in a migrate worklist. (For more information, see Overrides-of-the-Analysis-parameters.)
    6. Press END.The JCL Generation component is invoked and Batch Analysis JCL Generation is displayed, as shown below. The JCL includes the //ALUIN DD and //AJXPOFIN DD statements (input streams), which include keywords for processing the worklist. For more information about the input streams, see the Keywords-for-input-streams section.

      Click here to view the Batch Analysis JCL Generation
      //RDACRJA JOB (5715),'ANALYSIS-RD10405D',
      //  CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),
      //  NOTIFY=RDACRJ
      /*ROUTE XEQ BMCPLX1
      /*JOBPARM SYSAFF=DB2B
      //***************************************************
      //*  CREATED BY :  RDACRJ
      //*  TIMESTAMP  :  04/05/2022.17.42.36
      //*  ENVIRONMENT:  ISPF 7.4MVS     TSO
      //*  RELEASE    :  V13.01.00 05/31/2022
      //*  DB2 VERSION:  13015
      //***************************************************
      //*-------------------------------------------------------------------
      //*        ANALYSIS for BMC AMI Change Manager for Db2
      //*-------------------------------------------------------------------
      //ANALYSIS EXEC PGM=ALUAMAIN,
      //        REGION=0M,
      //        PARM='DMD1QEND'
      //STEPLIB DD  DSN=CSG.DEND.DSNEXIT,DISP=SHR
      //        DD  DSN=CSGI.DB2V13M.DSNLOAD,DISP=SHR
      //*
      //ABNLIGNR DD DUMMY
      //SYSTERM  DD SYSOUT=*
      //SYSTSPRT DD SYSOUT=*
      //SYSUDUMP DD SYSOUT=*
      //********************************************************
      //****  SAMPLE SYSMDUMP JCL ********
      //**** PLEASE REPLACE THE DSN AND UNIT WITH ONES THAT FITS
      //**** YOUR SHOP STANDARDS AND UNCOMMENT THE JCL
      //*SYSMDUMP DD DSN=CUSTOMER.SYSMDUMP,DISP=(,CATLG,CATLG),UNIT=XXXXXXX,
      //*  SPACE=(CYL,(200,50),RLSE),
      //*  DCB=(DSORG=PS,RECFM=FBS,LRECL=4160,BLKSIZE=24960)
      //********************************************************
      //ALUPRINT DD SYSOUT=*
      //AJXPOFVL DD DUMMY
      //ALUIN    DD *
        SSID DEND
        WORKID RDACRJ.RD10405D
        INCLUDE (DATA SQL AMS  )
        SORTDEVT SYSDA
        SMSINCLUDE (  )
        IBMUNLOAD IBMLOAD NOUSENGTUL
        IBMREORG NOUSENGTR
        IBMREBUILD
        STANDALONESTATS DB2STATSUPD TABLEALL
        NOHISTORY
        IBMCOPY
        NOUTILCOPY
        DYNUNLD
        DYNCOPY
        NOPARTCOPY
        COPYDDN (COPY01   )
        NOREGENIDENTITY
        SINGLEPHASE
        NOVVALPROP
        IBMCHECK
        SYNCPOINT 10
        NODBRMLIB
        ORDERBY
        UNLOADTABLE
        NOREORGALT
        UNLOADEMPTY
        NOSTOPCOMMIT
        TABLEACCESS
        NOAPPLCOVR
        NOPARALLEL
        REORGONLINE
        REORGALL
        REORGREF
        SPANNEDRECS
        NOBINDONIX
        NOMOVETB
        NODEFERCDC
      //*  POF INPUT FILE AJXAPOF
      //*  THE KEYWORDS MUST START IN COLUMN 1
      //AJXPOFIN DD   *,DLM=$$
      ACM_DYNSORTW_NUM=32
      ACM_DYNSORTW_UNIT=SYSDA
      ACM_IBMR_MAP_REQ=N
      ACM_ANALYSIS_SYSOUT=X
      ACM_WLORDER=
      ACM_WLORDERMSG=N
      ACM_PARALLEL_XIMGRP=XIMACM
      ARCH_DATACLASS_ALT=
      ARCH_DATACLASS=
      ARCH_EXPDT=
      ARCH_MGMTCLASS_ALT=
      ARCH_MGMTCLASS=
      ARCH_PREFIX=&PREFIX..&WKID
      ARCH_PRIQTY=10
      ARCH_RETPD=
      ARCH_SECQTY=2
      ARCH_STACK=N
      ARCH_STORCLASS_ALT=
      ARCH_STORCLASS=
      ARCH_THRESH=0
      ARCH_UNIT_ALT=
      ARCH_UNIT=SYSDA
      BLRP_DATACLASS_ALT=
      BLRP_DATACLASS=
      BLRP_EXPDT=
      BLRP_MGMTCLASS_ALT=
      BLRP_MGMTCLASS=
      BLRP_PREFIX=&PREFIX..&WKID..&OBNOD
      BLRP_PRIQTY=10
      BLRP_RETPD=
      BLRP_SECQTY=2
      BLRP_STACK=N
      BLRP_STORCLASS_ALT=
      BLRP_STORCLASS=
      BLRP_THRESH=0
      BLRP_UNIT_ALT=
      BLRP_UNIT=SYSDA
      BMC_REORG_XBMID=XV2B
      CHECKSTARTDB=N
      CPYEXP_DATACLASS=
      CPYEXP_EXPDT=
      CPYEXP_MGMTCLASS=
      CPYEXP_PREFIX=&PREFIX..&WKID
      CPYEXP_RETPD=
      CPYEXP_STORCLASS=
      CPYEXP_SUPPRESS_SUFF=N
      CPYEXP_UNIT=SYSDA
      DEF_GDG_BASE=N
      DEF_GDG_LIMIT=10
      DEF_GDG2_LIMIT=10
      DEF_GDG_NOSCR = N
      DIAG_MSGCLASS=X
      DISC_DATACLASS_ALT=
      DISC_DATACLASS=
      DISC_EXPDT=
      DISC_MGMTCLASS_ALT=
      DISC_MGMTCLASS=
      DISC_PREFIX=&PREFIX..&WKID
      DISC_PRIQTY=10
      DISC_RETPD=
      DISC_SECQTY=2
      DISC_STORCLASS_ALT=
      DISC_STORCLASS=
      DISC_THRESH=0
      DISC_UNIT_ALT=
      DISC_UNIT=SYSDA
      GDG_MODEL=SYS1.MODEL
      INFRALOAD=
      PCPY1_DATACLASS_ALT=
      PCPY1_DATACLASS=
      PCPY1_EXPDT=
      PCPY1_MGMTCLASS_ALT=
      PCPY1_MGMTCLASS=
      PCPY1_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
      PCPY1_PRIQTY=10
      PCPY1_RETPD=
      PCPY1_SECQTY=2
      PCPY1_STACK=N
      PCPY1_STORCLASS=
      PCPY1_STORCLASS_ALT=
      PCPY1_SUPPRESS_SUFF=N
      PCPY1_THRESH=0
      PCPY1_UNIT_ALT=
      PCPY1_UNIT=SYSDA
      PCPY2_DATACLASS_ALT=
      PCPY2_DATACLASS=
      PCPY2_EXPDT=
      PCPY2_MGMTCLASS_ALT=
      PCPY2_MGMTCLASS=
      PCPY2_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
      PCPY2_PRIQTY=10
      PCPY2_RETPD=
      PCPY2_SECQTY=2
      PCPY2_STACK=N
      PCPY2_STORCLASS=
      PCPY2_STORCLASS_ALT=
      PCPY2_SUPPRESS_SUFF=N
      PCPY2_THRESH=0
      PCPY2_UNIT_ALT=
      PCPY2_UNIT=SYSDA
      PUNCH_DATACLASS=
      PUNCH_EXPDT=
      PUNCH_MGMTCLASS=
      PUNCH_PREFIX=&PREFIX..&WKID..&STEPN
      PUNCH_PRIQTY=10
      PUNCH_RETPD=
      PUNCH_SECQTY=2
      PUNCH_STORCLASS=
      PUNCH_UNIT=SYSDA
      RCPY1_DATACLASS_ALT=
      RCPY1_DATACLASS=
      RCPY1_EXPDT=
      RCPY1_MGMTCLASS_ALT=
      RCPY1_MGMTCLASS=
      RCPY1_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
      RCPY1_PRIQTY=10
      RCPY1_RETPD=
      RCPY1_SECQTY=2
      RCPY1_STACK=N
      RCPY1_STORCLASS=
      RCPY1_STORCLASS_ALT=
      RCPY1_SUPPRESS_SUFF=N
      RCPY1_THRESH=0
      RCPY1_UNIT_ALT=
      RCPY1_UNIT=SYSDA
      RCPY2_DATACLASS_ALT=
      RCPY2_DATACLASS=
      RCPY2_EXPDT=
      RCPY2_MGMTCLASS_ALT=
      RCPY2_MGMTCLASS=
      RCPY2_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
      RCPY2_PRIQTY=10
      RCPY2_RETPD=
      RCPY2_SECQTY=2
      RCPY2_STACK=N
      RCPY2_STORCLASS=
      RCPY2_STORCLASS_ALT=
      RCPY2_SUPPRESS_SUFF=N
      RCPY2_THRESH=0
      RCPY2_UNIT_ALT=
      RCPY2_UNIT=SYSDA
      REORG_MAPDB=
      REORG_MAPTAB=
      SRTOUT_DATACLASS_ALT=
      SRTOUT_DATACLASS=
      SRTOUT_EXPDT=
      SRTOUT_MGMTCLASS_ALT=
      SRTOUT_MGMTCLASS=
      SRTOUT_PREFIX=&PREFIX..&WKID..&STEPN
      SRTOUT_PRIQTY=10
      SRTOUT_RETPD=
      SRTOUT_SECQTY=2
      SRTOUT_STORCLASS_ALT=
      SRTOUT_STORCLASS=
      SRTOUT_THRESH=0
      SRTOUT_UNIT_ALT=
      SRTOUT_UNIT=SYSDA
      SYSUT_DATACLASS_ALT=
      SYSUT_DATACLASS=
      SYSUT_EXPDT=
      SYSUT_MGMTCLASS_ALT=
      SYSUT_MGMTCLASS=
      SYSUT_PREFIX=&PREFIX..&WKID..&STEPN
      SYSUT_PRIQTY=10
      SYSUT_RETPD=
      SYSUT_SECQTY=2
      SYSUT_STORCLASS_ALT=
      SYSUT_STORCLASS=
      SYSUT_THRESH=0
      SYSUT_UNIT_ALT=
      SYSUT_UNIT=SYSDA
      TAPE_EXPDT=
      TAPE_RETPD=
      TAPE_VOLCNT=99
      TAPE1=CARTVTS
      TAPE2=CARTVTS
      TAPE3=CARTVTS
      TEMPUNIT=SYSDA
      UNLD1_DATACLASS_ALT=
      UNLD1_DATACLASS=
      UNLD1_EXPDT=
      UNLD1_MGMTCLASS_ALT=
      UNLD1_MGMTCLASS=
      UNLD1_PREFIX=&PREFIX..&MSSID..&WORKID8
      UNLD1_PRIQTY=10
      UNLD1_RETPD=
      UNLD1_SECQTY=2
      UNLD1_STACK=N
      UNLD1_STORCLASS_ALT=
      UNLD1_STORCLASS=
      UNLD1_SUPPRESS_SUFF=N
      UNLD1_THRESH=0
      UNLD1_UNIT_ALT=
      UNLD1_UNIT=SYSDA
      UNLD2_DATACLASS_ALT=
      UNLD2_DATACLASS=
      UNLD2_EXPDT=
      UNLD2_MGMTCLASS_ALT=
      UNLD2_MGMTCLASS=
      UNLD2_PREFIX=&PREFIX..&MSSID..&WORKID8
      UNLD2_PRIQTY =10
      UNLD2_RETPD=
      UNLD2_SECQTY =2
      UNLD2_STACK=N
      UNLD2_STORCLASS_ALT=
      UNLD2_STORCLASS=
      UNLD2_SUPPRESS_SUFF=N
      UNLD2_THRESH=0
      UNLD2_UNIT_ALT=
      UNLD2_UNIT=SYSDA
      UNLD3_DATACLASS=
      UNLD3_EXPDT=
      UNLD3_MGMTCLASS=
      UNLD3_PREFIX=&PREFIX..&MSSID..&WORKID8
      UNLD3_RETPD=
      UNLD3_STORCLASS=
      UNLD3_SUPPRESS_SUFF=N
      UNLD3_UNIT=SYSDA
      UNLD4_PREFIX=&PREFIX..&MSSID..&WORKID8
      UNLD4_STORCLASS=
      UNLD4_UNIT=SYSDA
      UNLD4_MGMTCLASS=
      UNLD4_DATACLASS=
      UNLD4_SUPPRESS_SUFF=N
      UNLD_FREF_DATACLASS=
      UNLD_FREF_MGMTCLASS=
      UNLD_FREF_PREFIX=&PREFIX..&MSSID..&WORKID8
      UNLD_FREF_STORCLASS=
      UNLD_FREF_UNIT=SYSDA
      UNLD_FREF_PRIQTY=10
      UNLD_FREF_DIRBLOCK=250
      UNLD_FREF_SECQTY=2
      UNLD_FREF_SUPPR_SUFF=N
      USE_NGT_AUTO=N
      USER_REXX_EXEC=
      USER_VAR1_CHAR=
      USER_VAR2_CHAR=
      USER_VAR3_CHAR=
      USER_VAR4_CHAR=0
      USER_VAR5_CHAR=0
      WORKLIST_BUFFERS=3
      $$
      //WORKL001 DD DISP=SHR,
      //   DSN=ACM.DB2V13.V131.WLBASE01(RD10405D)
      //*--------------------------------------------------------------------
      //* END OF JOB
      //*--------------------------------------------------------------------


    7. Press END to return to the Analysis JCL Processing Interface panel.

      ACMFANL3 ---------------- Analysis JCL Processing Interface -------------------
      Command   ===>                                                                 
                                                                                    
      WORKID . . . . : RDACRJ.RD10405D                                               
                                                                                    
                                                                                    
      Specify Dataset Names                                                          
        JCL . . . . . . . . 'ACM.DB2V13.V131.ANLYJCL(RD10405D)'                      
        Worklist  . . . . . 'ACM.DB2V13.V131.WLBASE01(RD10405D)'                     
        Diagnostics . . . . SYSOUT                                                   
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
      Select batch processing options.  Then press Enter.                            
      * Override                                                                     
      * Create JCL                                                                   
      * Edit JCL                                                                     
      S Submit JCL                                                                   
      _ Edit Worklist                                                                
                                                                                    
      Commands:  BROWSE PREVIOUS HELP END                                            
    8. On the Analysis JCL Processing Interface panel, press Enter to submit the JCL.
    9. After you submit the job, press Enter to return to the Analysis JCL Processing Interface panel.The results of Analysis are a diagnostic output file (ALUPRINT) and a worklist.
    10. To review the results of the analysis of the work ID (ALUPRINT), you can split your ISPF session or you can use your normal method to review SYSOUT. The last message in the diagnostic output indicates that the worklist completed successfully.

      SDSF OUTPUT DISPLAY RDACRJA  J0403937  DSID   106 LINE 0       COLUMNS 02- 81  
       COMMAND INPUT ===>                                            SCROLL ===> CSR  
      ********************************* TOP OF DATA **********************************
        SSID DEND                                                                     
        WORKID RDACRJ.RD10405D                                                        
        INCLUDE (DATA SQL AMS  )                                                      
        SORTDEVT SYSDA                                                                
        SMSINCLUDE (  )                                                               
        IBMUNLOAD IBMLOAD NOUSENGTUL                                                  
        IBMREORG NOUSENGTR                                                            
        IBMREBUILD                                                                    
        STANDALONESTATS DB2STATSUPD TABLEALL                                          
        NOHISTORY                                                                     
        IBMCOPY                                                                       
        NOUTILCOPY                                                                    
        DYNUNLD                                                                       
        DYNCOPY                                                                       
        NOPARTCOPY                                                                    
        COPYDDN (COPY01   )                                                           
        NOREGENIDENTITY                                                               
        SINGLEPHASE                                                                   
        NOVVALPROP                                                                    
        IBMCHECK                                                                      
        SYNCPOINT 10                                                                  
        NODBRMLIB                                                                     
        ORDERBY                                                                       
        UNLOADTABLE                                                                   
        NOREORGALT                                                                    
        UNLOADEMPTY                                                             
        NOSTOPCOMMIT                                                            
        TABLEACCESS                                                             
        NOAPPLCOVR                                                              
        NOPARALLEL                                                              
        REORGONLINE                                                             
        REORGALL                                                                
        REORGREF                                                                
        SPANNEDRECS                                                             
        NOBINDONIX                                                              
        NOMOVETB                                                                
        NODEFERCDC                                                              
      *BMC396243I DB2 VERSION 13 IN NEW FUNCTION MODE                           
      *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V13R1M501                        
      *BMC56464I DB2 CATALOG LEVEL IS V13R1M501                                 
      *BMC56464I APPLCOMPAT IS V13R1M501                                        
      *BMC56464I APPLCOMPAT FROM DSNZPARM IS V13R1M501                          
      *** BMC AMI Change Manager for Db2 13.01.00 BASE PTFs applied:            
      *** BQU3344                                                               
      *** EXECUTION (AEX) 13.01.00 BASE PTFs applied:                           
      *** NONE                                                                  
      ***********************************************************************   
      *** WORKLIST GENERATION 2022-04-05-17.44.51.080131                        
      *** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)     
      WORKLIST GENERATION EXECUTION FOR WORKID RDACRJ.RD10405D ON SSID DEND     
      ***********************************************************************     
      BMC45589I MULTITASKING DISABLED FOR TABLE R1128C04.T@T128PBR2 -             
                TABLE CONTAINS LOB OR XML COLUMN(S) AND IBM UNLOAD AND LOAD       
       WITH SPANNED RECORDS SELECTED                                              
      ***********************************************************************     
      ***  THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***     
      ***********************************************************************     
      *BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX     
      *           ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:           
      *            PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256     
      *            PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>      
      *BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION       
      *BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE      
      *           ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE           
      *           KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.       
      *BMC396476I FOR PARTITION BY RANGE TABLE SPACES THAT USE RELATIVE PAGE      
      *           NUMBERING, DB2 REQUIRES THAT THE TABLESPACE AND THE INDEX       
      *           SPACE USE EXTENDED ADDRESSIBILITY ENABLED DASD DEVICES          
      *           (STOGROUPS).                                                    
      *BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE          
      *            REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD            
      *            PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO       
      *            ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN     
      *            INPUT STREAM.                                                  
      ***********************************************************************     
      ***********************************************************************         
      ***  END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***         
      ***********************************************************************         
      WORKLIST WAS WRITTEN TO DATASET 'ACM.DB2V13.V131.WLBASE01(RD10405D)'            
      WORKLIST GENERATION COMPLETE WORKID RDACRJ.RD10405D                             
      ******************************** BOTTOM OF DATA ********************************

       The following figure shows the worklist that was written to the data set that you specified on the Analysis JCL Processing Interface panel:

      Click here to view the worklist
      ***********************************************************************
      *** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)
      ***********************************************************************
      *** BMC AMI Change Manager for Db2 13.01.00 BASE PTFs applied:
      *** BQU3344
      *** EXECUTION (AEX) 13.01.00 BASE PTFs applied:
      *** NONE
      ***********************************************************************
      * ALUIN PARMS:                                                        *
      *   SSID DEND                                                         *
      *   WORKID RDACRJ.RD10405D                                            *
      *   INCLUDE (DATA SQL AMS  )                                          *
      *   SORTDEVT SYSDA                                                    *
      *   SMSINCLUDE (  )                                                   *
      *   IBMUNLOAD IBMLOAD NOUSENGTUL                                      *
      *   IBMREORG NOUSENGTR                                                *
      *   IBMREBUILD                                                        *
      *   STANDALONESTATS DB2STATSUPD TABLEALL                              *
      *   NOHISTORY                                                         *
      *   IBMCOPY                                                           *
      *   NOUTILCOPY                                                        *
      *   DYNUNLD                                                           *
      *   DYNCOPY                                                           *
      *   NOPARTCOPY                                                        *
      *   COPYDDN (COPY01   )                                               *
      *   NOREGENIDENTITY                                                   *
      *   SINGLEPHASE                                                       *
      *   NOVVALPROP                                                        *
      *   IBMCHECK                                                          *
      *   SYNCPOINT 10                                                      *
      *   NODBRMLIB                                                         *
      *   ORDERBY                                                           *
      *   UNLOADTABLE                                                       *
      *   NOREORGALT                                                        *
      *   UNLOADEMPTY                                                       *
      *   NOSTOPCOMMIT                                                      *
      *   TABLEACCESS                                                       *
      *   NOAPPLCOVR                                                        *
      *   NOPARALLEL                                                        *
      *   REORGONLINE                                                       *
      *   REORGALL                                                          *
      *   REORGREF                                                          *
      *   SPANNEDRECS                                                       *
      *   NOBINDONIX                                                        *
      *   NOMOVETB                                                          *
      *   NODEFERCDC                                                        *
      ***********************************************************************
      -TIME 000050 '2022-04-05-17.44.51.080131'                               90576933
      -SSID 000100 DEND                                                       80514191
      -JCLP 000150 MIGR MSSID DEND                                            45842323
      -WKID 000200 RDACRJ.RD10405D                                            26594972
      -CENV 000250
                   TABLE_COL_NAME_EXPANSION ON                                24829915
      -SYNC 000300 END OF CHECK ENVIRONMENT SECTION                           99414218
      ***********************************************************************
      ***********************************************************************
      ***********************************************************************
      ***********************************************************************
      ***  THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
      ***********************************************************************
      *BMC396243I DB2 VERSION 13 IN NEW FUNCTION MODE
      *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
      *BMC56464I DB2 CATALOG LEVEL IS V13R1M501
      *BMC56464I APPLCOMPAT IS V13R1M501
      *BMC56464I APPLCOMPAT FROM DSNZPARM IS V13R1M501
      *BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
      *           ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
      *            PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
      *            PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
      *BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
      *BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
      *           ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
      *           KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
      *BMC396476I FOR PARTITION BY RANGE TABLE SPACES THAT USE RELATIVE PAGE
      *           NUMBERING, DB2 REQUIRES THAT THE TABLESPACE AND THE INDEX
      *           SPACE USE EXTENDED ADDRESSIBILITY ENABLED DASD DEVICES
      *           (STOGROUPS).
      *BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
      *            REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
      *            PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
      *            ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
      *            INPUT STREAM.
      ***********************************************************************
      ***  END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
      ***********************************************************************
      *** ORIGINATOR OF WORKLIST WAS WORKID RDACRJ.RD10405D ON SSID DEND ***
      -MIGR 000350 PHASE-1   START OF SECTION TO BE RUN ON SENDING SYSTEM     38352787
      -SYNC 000400 START OF EXECUTION SYNCPOINT                               86376801
      ***********************************************************************
      -UNLI 000450
        TEMPLATE SYRC
            DSN 'RDACRJ.DEND.RD10405D.SR000001'
            UNIT SYSDA

              UNLOAD FROM TABLE R1128C04.T@T128PBR2
                   HEADER NONE
        (
         COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP EXTERNAL(32)
       , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP WITH TIME ZONE EXTERNAL(32)
       , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP EXTERNAL(32)
       , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
         CLOB
       , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
         BLOB
       , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
         CLOB
       , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
         XML
         )
                   UNLDDN SYRC
                   SPANNED YES
                   EBCDIC CCSID(37,0,0)
                   NOPAD  MAXERR 1
                   IMPLICIT_TZ -05:00
                                                                              38763186
      -SYNC 000500 END OF UNLOAD TABLES SECTION                               53302971
      ***********************************************************************
      -SETS 000550 SET CURRENT SQLID = 'RDACRJ4'                              76602437
      -SQL  000600 CREATE DATABASE R1128C30
                          STOGROUP SYSDEFLT
                          BUFFERPOOL BP8K0
                                                                              71408394
      -SETS 000650 SET CURRENT SQLID = USER                                   95314987
      -SYNC 000700 END OF DATABASE SECTION                                    29545590
      ***********************************************************************
      -SETS 000750 SET CURRENT SQLID = 'RDACRJ4'                              76471365
      -SQL  000800 CREATE LOB TABLESPACE T128P2L3 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              05268805
      -SQL  000850 CREATE LOB TABLESPACE T128P2L4 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              05267269
      -SQL  000900 CREATE LOB TABLESPACE T128P2L5 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              05202757
      -SQL  000950 CREATE LOB TABLESPACE T128P2L6 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              05201221
      -SQL  001000 CREATE LOB TABLESPACE T128P2L1 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              10983611
      -SQL  001050 CREATE LOB TABLESPACE T128P2L2 IN R1128C30
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          GBPCACHE   SYSTEM
                          BUFFERPOOL BP8K0
                          DSSIZE        4G
                                                                              10985147
      -SQL  001100 CREATE  TABLESPACE T128PBR2 IN R1128C30
                          NUMPARTS 2
                         (PART 1
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          PCTFREE    0   FOR UPDATE -1
                          DSSIZE        1G
                         ,PART 2
                          USING STOGROUP R1EAV
                          PRIQTY     1440
                          SECQTY     720
                          PCTFREE    0   FOR UPDATE -1
                          DSSIZE        1G
                         )
                          CCSID EBCDIC
                          BUFFERPOOL BP1
                          LOCKSIZE   ANY
                          LOCKMAX    10
                          CLOSE      NO
                          SEGSIZE    4
                          PAGENUM    RELATIVE
                          DSSIZE        1G
                                                                              11397415
      -SETS 001150 SET CURRENT SQLID = USER                                   11764523
      -SYNC 001200 END OF CREATE TABLESPACE SECTION                           21677747
      ***********************************************************************
      -SQL  001250 CREATE TABLE RDACRJ4.T@T128PBR2
       (
        COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           CHAR(1) NOT NULL WITH DEFAULT
          'A'
       , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           VARCHAR(15) NOT NULL WITH DEFAULT
          'SEATTLE'
       , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           CLOB(1073741824)
           INLINE LENGTH 0
           WITH DEFAULT
       , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           BINARY(4) NOT NULL WITH DEFAULT
          BX'0102'
       , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           VARBINARY(5) NOT NULL WITH DEFAULT
          BX'030405'
       , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           BLOB(1073741824)
           INLINE LENGTH 0
           WITH DEFAULT
       , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           SMALLINT NOT NULL WITH DEFAULT
          55
       , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           INTEGER NOT NULL WITH DEFAULT
          1969
       , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           BIGINT NOT NULL WITH DEFAULT
          9223372036854775804
       , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           DECIMAL(5,2) NOT NULL WITH DEFAULT
          123.67
       , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           DECIMAL(10,1) NOT NULL WITH DEFAULT
          123456789.0
       , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           FLOAT NOT NULL WITH DEFAULT
          10.2E1
       , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           REAL NOT NULL WITH DEFAULT
          5.4E-075
       , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           FLOAT NOT NULL WITH DEFAULT
          5.4E-78
       , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           DECFLOAT(16) WITH DEFAULT
       , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           DECFLOAT(34) WITH DEFAULT
       , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           DATE NOT NULL WITH DEFAULT
          '2013-01-02'
       , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIME NOT NULL WITH DEFAULT
          '12.57.00'
       , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP NOT NULL WITH DEFAULT
          '2015-01-01-00.00.00.000000'
       , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP WITH TIME ZONE NOT NULL WITH DEFAULT
          '2015-01-02-05.30.00.000000-08:30'
       , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           TIMESTAMP NOT NULL WITH DEFAULT
          '2015-01-02-05.30.00.000000'
       , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           CHAR(2) WITH DEFAULT
       , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           CHAR(2) FOR BIT DATA WITH DEFAULT
       , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           VARCHAR(4) NOT NULL WITH DEFAULT
       , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           VARCHAR(4) FOR BIT DATA WITH DEFAULT
       , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           CLOB(1073741824)
           INLINE LENGTH 0
           WITH DEFAULT
       , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           XML NOT NULL
       )
                          CCSID EBCDIC
        IN R1128C30.T128PBR2
                          PARTITION BY
       ( COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T      )
                         (PARTITION 1 ENDING AT (2000)
                         ,PARTITION 2 ENDING AT (2010)
                         )
                                                                              07033474
      -SQL  001300 LABEL ON RDACRJ4.T@T128PBR2
                         (COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
       DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'D'
                         ,COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
       DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'E'
                         ,COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'F'
                         )
                                                                              59380357
      -SQL  001350 COMMENT ON RDACRJ4.T@T128PBR2
                         (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDR
       ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'COL 1 127'
                         ,COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'COL 2 127'
                         ,COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       RED@T
                           IS 'COL 3 127'
                         )                                                    05138706
      -SQL  001400 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L3
                          IN R1128C30.T128P2L3
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   1
                                                                              42016305
      -SQL  001450 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L4
                          IN R1128C30.T128P2L4
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   2
                                                                              42015022
      -SQL  001500 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L5
                          IN R1128C30.T128P2L5
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   1
                                                                              14110752
      -SQL  001550 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L6
                          IN R1128C30.T128P2L6
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   2
                                                                              14109469
      -SQL  001600 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L1
                          IN R1128C30.T128P2L1
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   1
                                                                              42278197
      -SQL  001650 CREATE AUXILIARY TABLE
                      RDACRJ4.T@T128PBR2L2
                          IN R1128C30.T128P2L2
                          STORES RDACRJ4.T@T128PBR2
                          COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T
                          PART   2
                                                                              42276914
      -SYNC 001700 END OF TABLE SECTION                                       91789030
      ***********************************************************************
      -SQL  001750 CREATE UNIQUE INDEX
                          RDACRJ4.I@T128PBR22
                       ON RDACRJ4.T@T128PBR2
       ( COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
                          USING STOGROUP R1EAV
                          PRIQTY     12
                          SECQTY     12
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              10584101
      -SQL  001800 ALTER  TABLE RDACRJ4.T@T128PBR2
                          ADD CONSTRAINT PK@T128PBR2
                          PRIMARY KEY (COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T,
                                       COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T)
                                                                              99403208
      -SQL  001850 CREATE INDEX
                          RDACRJ4.I@T128PBR2L3
                       ON RDACRJ4.T@T128PBR2L3
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              01130958
      -SQL  001900 CREATE INDEX
                          RDACRJ4.I@T128PBR2L4
                       ON RDACRJ4.T@T128PBR2L4
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              01195216
      -SQL  001950 CREATE INDEX
                          RDACRJ4.I@T128PBR2L5
                       ON RDACRJ4.T@T128PBR2L5
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              01196498
      -SQL  002000 CREATE INDEX
                          RDACRJ4.I@T128PBR2L6
                       ON RDACRJ4.T@T128PBR2L6
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              17382612
      -SQL  002050 CREATE INDEX
                          RDACRJ4.I@T128PBR2L1
                       ON RDACRJ4.T@T128PBR2L1
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              17383882
      -SQL  002100 CREATE INDEX
                          RDACRJ4.I@T128PBR2L2
                       ON RDACRJ4.T@T128PBR2L2
                          PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              17448140
      -SQL  002150 CREATE UNIQUE INDEX
                          RDACRJ4.I@T128PBR23
                       ON RDACRJ4.T@T128PBR2
       ( COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
                          NOT PADDED
                          USING STOGROUP R1EAV
                          PRIQTY     12
                          SECQTY     12
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              01276496
      -SQL  002200 CREATE UNIQUE INDEX
                          RDACRJ4.I@T128PBR24
                       ON RDACRJ4.T@T128PBR2
       ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
                          INCLUDE
       ( COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
                          NOT PADDED
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              83684506
      -SYNC 002250 AUTOMATIC SYNC POINT                                       71276645
      -SQL  002300 CREATE INDEX
                          RDACRJ4.I@T128PBR25
                       ON RDACRJ4.T@T128PBR2
       (
       SUBSTR( COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
       @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T, 1, 3
       )
       ,
       DATE( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@E
       IGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       )
                          USING STOGROUP SYSDEFLT
                          PRIQTY     -1
                          SECQTY     -1
                          BUFFERPOOL BP1
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              46947416
      -SQL  002350 CREATE INDEX
                          RDACRJ4.I@T128PBR21
                       ON RDACRJ4.T@T128PBR2
       ( COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
                          NOT PADDED
                          USING STOGROUP R1EAV
                          PRIQTY     12
                          SECQTY     12
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              24910753
      -SQL  002400 CREATE INDEX
                          RDACRJ4.I@T128PBR26
                       ON RDACRJ4.T@T128PBR2
       (
       COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T * COLIN@11@ON
       E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       ,
       COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T - 1
       )
                          USING STOGROUP R1EAV
                          PRIQTY     96
                          SECQTY     48
                          BUFFERPOOL BP0
                          CLOSE      YES
                          PIECESIZE  4194304 K
                                                                              57102322
      -SYNC 002450 END OF CREATE INDEX SECTION                                44006859
      ***********************************************************************
      -SQL  002500 ALTER  TABLE RDACRJ4.T@T128PBR2
                          ADD CONSTRAINT UC@T128PBR2
                               UNIQUE (COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T)
                                                                              38690960
      -SYNC 002550 END OF UNIQUE CONSTRAINTS SECTION                          13116438
      ***********************************************************************
      -LOAD 002600
        TEMPLATE SYRC
            DSN 'RDACRJ.DEND.RD10405D.SR000001'
            UNIT SYSDA

                   LOAD DATA  REPLACE
                   INDDN SYRC
                   ERRDDN SYSER001
                   DISCARDS 1
                   DISCARDDN SYSDS001
                   EBCDIC CCSID(37,0,0)
                   FORMAT SPANNED YES
                   WORKDDN SYSUT001
                   LOG NO
                   ENFORCE NO
                   REUSE
                   INTO TABLE RDACRJ4.T@T128PBR2
                   IGNOREFIELDS YES
       (
        COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
      ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) CHAR(1),
        COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) VARCHAR,
        COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) BINARY,
        COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) VARBINARY,
        COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) SMALLINT,
        COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) INTEGER,
        COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) BIGINT,
        COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) DECIMAL,
        COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) DECIMAL,
        COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) FLOAT(53),
        COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) FLOAT(21),
        COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) FLOAT(53),
                   NULL001             POSITION(*) CHAR(1),
        COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) DECFLOAT(16)
                               NULLIF NULL001=X'FF',
                   NULL002             POSITION(*) CHAR(1),
        COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) DECFLOAT(34)
                               NULLIF NULL002=X'FF',
        COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) DATE EXTERNAL,
        COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) TIME EXTERNAL,
        COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) TIMESTAMP EXTERNAL(32),
        COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) TIMESTAMP WITH TIME ZONE EXTERNAL(32),
        COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) TIMESTAMP EXTERNAL(32),
                   NULL003             POSITION(*) CHAR(1),
        COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) CHAR(2)
                               NULLIF NULL003=X'FF',
                   NULL004             POSITION(*) CHAR(1),
        COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) CHAR(2)
                               NULLIF NULL004=X'FF',
        COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) VARCHAR,
                   NULL005             POSITION(*) CHAR(1),
        COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) VARCHAR
                               NULLIF NULL005=X'FF',
                   NULL006             POSITION(*) CHAR(1),
        COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) CLOB
                               NULLIF NULL006=X'FF',
                   NULL007             POSITION(*) CHAR(1),
        COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) BLOB
                               NULLIF NULL007=X'FF',
                   NULL008             POSITION(*) CHAR(1),
        COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) CLOB
                               NULLIF NULL008=X'FF',
        COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
      ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
          POSITION(*) XML)
                                                                              54503458
      -SYNC 002650 LOAD TB RDACRJ4.T@T128PBR2 COMPLETE                        79008138
      -SYNC 002700 END OF LOAD TABLES SECTION                                 61090539
      ***********************************************************************
      *SQL  002750 ALTER  TABLE RDACRJ4.T@T128PBR2
      *           FOREIGN KEY FK@T128PBR2
      *( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      *@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
      *, COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      *@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
      *           REFERENCES RDACRJ4.T@T04TCP
      *                      ON DELETE RESTRICT
      *
      *
      -SYNC 002800 END OF FOREIGN KEYS SECTION                                79901525
      ***********************************************************************
      -SETP 002850 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SESSION_USER","R1UDT","R1UDF","R198573"                              63438759
      -SQL  002900 ALTER  TABLE RDACRJ4.T@T128PBR2
                       ADD CONSTRAINT CK@T128PBR2 CHECK (
         COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T <> 'AA'
                         )
                                                                              90091327
      -SETP 002950 SET CURRENT PATH = SYSTEM PATH                             90714802
      -SYNC 003000 END OF CHECK CONSTRAINTS SECTION                           29715932
      ***********************************************************************
      -CHEK 003050
                     CHECK DATA TABLESPACE R1128C30.T128PBR2
                           ERRDDN SYSER001 WORKDDN SYSUT001
                           EXCEPTIONS 0
                   SORTDEVT SYSDA
                                                                              96815248
      -SYNC 003100 CHECK DATA FOR TS R1128C30.T128PBR2 COMPLETE               11303406
      -SYNC 003150 END OF CHECK DATA SECTION                                  24204699
      ***********************************************************************
      -COPY 003200
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000001'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L3
                          COPYDDN (DCPYLOCP)
                                                                              91200417
      -SYNC 003250 COPY FOR TS R1128C30.T128P2L3 COMPLETE                     51040916
      -COPY 003300
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000002'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L4
                          COPYDDN (DCPYLOCP)
                                                                              91134879
      -SYNC 003350 COPY FOR TS R1128C30.T128P2L4 COMPLETE                     51171988
      -COPY 003400
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000003'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L5
                          COPYDDN (DCPYLOCP)
                                                                              91069341
      -SYNC 003450 COPY FOR TS R1128C30.T128P2L5 COMPLETE                     51303060
      -COPY 003500
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000004'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L6
                          COPYDDN (DCPYLOCP)
                                                                              91003803
      -SYNC 003550 COPY FOR TS R1128C30.T128P2L6 COMPLETE                     51434132
      -COPY 003600
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000005'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L1
                          COPYDDN (DCPYLOCP)
                                                                              90938271
      -SYNC 003650 COPY FOR TS R1128C30.T128P2L1 COMPLETE                     51171988
      -COPY 003700
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000006'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128P2L2
                          COPYDDN (DCPYLOCP)
                                                                              90872733
      -SYNC 003750 COPY FOR TS R1128C30.T128P2L2 COMPLETE                     51303060
      -COPY 003800
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000007'
            UNIT SYSDA
                     COPY TABLESPACE R1128C30.T128PBR2
                          COPYDDN (DCPYLOCP)
                                                                              93951388
      -SYNC 003850 COPY FOR TS R1128C30.T128PBR2 COMPLETE                     52031844
      -COPY 003900
       XMLTBO RDACRJ4
       XMLTBN T@T128PBR2
       XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
        TEMPLATE DCPYLOCP
            DSN 'RDACRJ.&UT..&SN..P&PART..LP000008'
            UNIT SYSDA
                     COPY TABLESPACE XML.TS
                          COPYDDN (DCPYLOCP)
                                                                              74390147
      -SYNC 003950 COPY FOR TS R1128C30.T128PBR2 COMPLETE                     52097380
      -SYNC 004000 END OF COPY SECTION                                        27133996
      ***********************************************************************
      -SETP 004050 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           56186103
      -SQL  004100 CREATE VIEW RDACRJ4.V5@T128PBR2
       ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
         AS SELECT *
         FROM RDACRJ4.T@T128PBR2
                                                                              96120416
      -SETP 004150 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           56120567
      -SQL  004200 CREATE VIEW RDACRJ4.V4@T128PBR2
       ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
         AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
       @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
       RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
       DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
       RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
       @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
       EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
       NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
       COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
       E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
       WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
       ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
       @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
       @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
       D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
       @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
       20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
       S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
       RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
       ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
       EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
       IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
       NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
       OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
       ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
       HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
       HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
       ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
       NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@
       T
         FROM RDACRJ4.T@T128PBR2
                                                                              71731536
      -SETP 004250 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           56055031
      -SQL  004300 CREATE VIEW RDACRJ4.V3@T128PBR2
         AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
           , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
       @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
       RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
       DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
       RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
       @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
       EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
       NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
       COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
       E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
       WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
       ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
       @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
       @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
       D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
       @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
       20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
       S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
       RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
       ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
       EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
       IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
       NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
       OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
       ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
       HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
       HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
       ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
       NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       NE@HUNDRED@T, COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TW
       ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T

         FROM RDACRJ4.T@T128PBR2
                                                                              65323940
      -SETP 004350 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           55989495
      -SQL  004400 CREATE VIEW RDACRJ4.V2@T128PBR2
         AS SELECT *
         FROM RDACRJ4.T@T128PBR2
                                                                              60777820
      -SETP 004450 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           55923959
      -SQL  004500 CREATE VIEW RDACRJ4.V1@T128PBR2
       ( A1
       , A2
       , A3
       , A4
       , A5
       , A6
       , A7
       , A8
       , A9
       , A10
       , A11
       , A12
       , A13
       , A14
       , A15
       , A16
       , A17
       , A18
       , A19
       , A20
       , A21
       , A22
       , A23
       , A24
       , A25
       , A26
       , A27 )
         AS SELECT *
         FROM RDACRJ4.T@T128PBR2
                                                                              58445972
      -SETP 004550 SET CURRENT PATH = SYSTEM PATH                             24007090
      -SYNC 004600 END OF CREATE VIEW NOT DEPENDENT ON MQT SECTION            15531780
      ***********************************************************************
      -SETS 004650 SET CURRENT SQLID = 'RDACRJ4'                              09428037
      -SETP 004700 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       ,"SYSIBMADM"                                                           55728631
      -SQL  004750 CREATE TRIGGER RDACRJ4.TR@T128PBR2
                          AFTER
                          UPDATE
                          OF COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       UNDRED@T
                          ON RDACRJ4.T@T128PBR2
                  REFERENCING NEW AS N@VAR
                          FOR EACH ROW MODE DB2SQL
         UPDATE RDACRJ4.T@T128PBR2 SET COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       TERS@ONE@HUNDRED@T = 60
         WHERE COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
       @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T =
           '11.11.00'
                                                                              71203551
      -SETS 004800 SET CURRENT SQLID = USER                                   62553643
      -SETP 004850 SET CURRENT PATH = SYSTEM PATH                             24203698
      -SYNC 004900 END OF TRIGGER SECTION                                     70815338
      ***********************************************************************
      -RNST 004950
                     RUNSTATS TABLESPACE R1128C30.T128PBR2
                              HISTORY NONE
                              INDEX (ALL)
                              TABLE ALL
                                                                              73962273
      -SYNC 005000 STATS FOR TS R1128C30.T128PBR2 COMPLETE                    60041444
      -RNST 005050
       XMLTBO RDACRJ4
       XMLTBN T@T128PBR2
       XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T

                     RUNSTATS TABLESPACE XML.TS
                              HISTORY NONE
                              INDEX (ALL)
                              TABLE ALL
                                                                              15001993
      -SYNC 005100 STATS FOR TS R1128C30.T128PBR2 COMPLETE                    59975908
      -RNST 005150
                     RUNSTATS TABLESPACE R1128C30.T128P2L3
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66232122
      -SYNC 005200 STATS FOR TS R1128C30.T128P2L3 COMPLETE                    45003036
      -RNST 005250
                     RUNSTATS TABLESPACE R1128C30.T128P2L4
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66297659
      -SYNC 005300 STATS FOR TS R1128C30.T128P2L4 COMPLETE                    45068828
      -RNST 005350
                     RUNSTATS TABLESPACE R1128C30.T128P2L5
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66363196
      -SYNC 005400 STATS FOR TS R1128C30.T128P2L5 COMPLETE                    45134620
      -RNST 005450
                     RUNSTATS TABLESPACE R1128C30.T128P2L6
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66428733
      -SYNC 005500 STATS FOR TS R1128C30.T128P2L6 COMPLETE                    45200412
      -RNST 005550
                     RUNSTATS TABLESPACE R1128C30.T128P2L1
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66494264
      -SYNC 005600 STATS FOR TS R1128C30.T128P2L1 COMPLETE                    45264668
      -RNST 005650
                     RUNSTATS TABLESPACE R1128C30.T128P2L2
                              HISTORY NONE
                              INDEX (ALL)
                                                                              66559801
      -SYNC 005700 STATS FOR TS R1128C30.T128P2L2 COMPLETE                    45330460
      -SYNC 005750 END OF TABLESPACE STATISTICS SECTION                       92291657
      ***********************************************************************
    11. Press END.The Execution JCL Build Interface panel is displayed, as shown in the following figure:

      ACMFEXC0 ------------------ Execution JCL Build Interface ---------------------
       Command ===>                                                                   
                                                                                     
       WORKID . . . . . : RDACRJ.RD10405D                                             
                                                                                     
       Select JCL and run type.  Then press Enter.                                    
         JCL Type . . 1 1.  Build Initial JCL                                         
                        2.  Build Restart JCL from previous execution JCL             
                        3.  Build Startover JCL from previous execution JCL           
                                                                                     
         Run Type . . 1 1.  Build JCL in Foreground                                   
                        2.  Build JCL in Batch                                        
                                                                                     
                                                                                     
                                                                                     
                                                                                     
                                                                                     
                                                                                     
                                                                                     
                                                                                     
                                                                                     
        Commands:  NEXT HELP END                                                      
  5. Execute the worklist.The Execution component executes the migrate worklist in a single phase. First, the data is unloaded from the objects. Then, the objects are created, the data is loaded, and the utilities are executed.

    The Execution component of the product uses the worklist as its input job stream and performs the tasks contained in the worklist. The worklist acts as a detailed procedure for implementing the changes that you defined in the specification stage.

    1. On the Execution JCL Build Interface panel, press Enter to accept the defaults.The Execution Pre- and Post-Processing Interface panel is displayed.

      ACMFEXC1 ---------- Execution Pre- and Post-Processing Interface --------------
      Command ===>                                                                   
                                                                                    
      WORKID . . . . . : RDACRJ.RD10405D                                             
      Specify additional steps to be included in this job.  Then press Enter.        
      Pre-Execution Compare                                                          
      1 1. Do not do a compare before execution                                      
        2. Compare two previous baselines                                            
        3. Compare a previous baseline to the current catalog                        
      Pre-Execution Baseline                                                         
      1 1. Do not build a baseline before execution                                  
        2. Build a baseline before execution                                         
                                                                                    
      Post-Execution Compare                                                         
      1 1. Do not do a compare after execution                                       
        2. Compare a previous baseline to the new catalog structures                 
        3. Compare the baseline built during a previous job step to the new          
              catalog structures                                                     
        4. Create CDL to fall back to a previous baseline                            
      Post-Execution Baseline                                                        
      1 1. Do not build a baseline after execution                                   
        2. Build a baseline after execution                                          
      Commands: HELP PREVIOUS END                                                    
    2. On the Execution Pre- and Post-Processing Interface panel, press Enter to accept the defaults.The Execution JCL Processing Interface panel is displayed.

      ACMFEXC3 --------------- Execution JCL Processing Interface -------------------
      Command ===>                                                                   
                                                                                    
      WORKID . . . . . : RDACRJ.RD10405D                                             
                                                                                    
      Specify Dataset Names.                                                         
        Execution JCL  . . 'ACM.DB2V13.V131.EXECJCL(RD10405D)'                       
        Worklist . . . . . 'ACM.DB2V13.V131.WLBASE01(RD10405D)'                      
        Diagnostics  . . . SYSOUT                                                    
                                                                                    
                                                                                    
      JCL Build Options.                                                             
        Dataset Sizing : No Sizing        (use Override Defaults to set or change)   
                                                                                    
      Select Processing Options.  Then press Enter to continue.                      
      _ Override Defaults                                                            
      _ Edit Worklist                                                                
      S Build Execution JCL                                                          
      S Edit Execution JCL                                                           
      _ Submit Execution JCL                                                         
                                                                                    
                                                                                    
       Commands:  BROWSE VIEWX PREVIOUS HELP END                                     
    3. On the Execution JCL Processing Interface panel, specify your data set names, specify SYSOUT for diagnostics, accept the defaults for your build option, and type S to select your processing options. Press Enter.The Execution JCL is displayed. The JCL includes the //AEXIN DD statement (input stream), which includes keywords that are used in executing the JCL. For more information about the input stream, see AEXIN-keywords.

      //RDACRJE JOB (5715),'EXECUTE-RD10405D',
      //  CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),
      //  NOTIFY=RDACRJ
      /*ROUTE XEQ BMCPLX1
      /*JOBPARM SYSAFF=DB2B
      //***************************************************
      //*  CREATED BY :  RDACRJ
      //*  TIMESTAMP  :  04/05/2022.17.48.48
      //*  ENVIRONMENT:  ISPF 7.4MVS     TSO
      //*  RELEASE    :  V13.01.00 05/31/2022
      //*  DB2 VERSION:  13015
      //***************************************************
      //*--------------------------------------------------------------------
      //*        EXECUTION for BMC AMI Change Manager for Db2
      //*--------------------------------------------------------------------
      //STEP1 EXEC PGM=AEXEMAIN,
      //     REGION=0M,MEMLIMIT=NOLIMIT,PARM='DMD1QEND',
      //     COND=(4,LT)
      //STEPLIB DD  DSN=CSG.DEND.DSNEXIT,DISP=SHR
      //        DD  DSN=CSGI.DB2V13M.DSNLOAD,DISP=SHR
      //*
      //ABNLIGNR DD DUMMY
      //SYSUDUMP DD SYSOUT=*
      //********************************************************
      //****  SAMPLE SYSMDUMP JCL ********
      //**** PLEASE REPLACE THE DSN AND UNIT WITH ONES THAT FITS
      //**** YOUR SHOP STANDARDS AND UNCOMMENT THE JCL
      //*SYSMDUMP DD DSN=CUSTOMER.SYSMDUMP,DISP=(,CATLG,CATLG),UNIT=XXXXXXX,
      //*  SPACE=(CYL,(200,50),RLSE),
      //*  DCB=(DSORG=PS,RECFM=FBS,LRECL=4160,BLKSIZE=24960)
      //********************************************************
      //SYSTERM  DD SYSOUT=*
      //ASUSRPRT DD SYSOUT=*
      //*--------------------------------------------------------------------
      //*  STATISTICS WORK DD STATEMENTS
      //*--------------------------------------------------------------------
      //STPRIN01 DD SYSOUT=*
      //UTPRINT  DD SYSOUT=*
      //RNPRIN01  DD SYSOUT=*
      //DDLOUT   DD SYSOUT=*
      //SYSOUT   DD SYSOUT=*
      //AJXERR   DD SYSOUT=*
      //AEXIN    DD *
        ACM
        SSID DEND WORKID RDACRJ.RD10405D
        DASDDOPT DSD1QDOP
        CATDOPT DCD1QDOP
        STOPWAIT 3
        STOPWTSECS 10
        LOCK EXCLUSIVE
      //SYSIN    DD SPACE=(CYL,(15,15)),UNIT=SYSDA,DISP=(NEW,DELETE),
      //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
      //SYSTSIN  DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
      //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
      //SYSPRINT DD SPACE=(CYL,(15,15)),UNIT=SYSDA,
      //            DISP=(NEW,DELETE)
      //SYSTSPRT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE),
      //            DSORG=PS,LRECL=137,BLKSIZE=4096,RECFM=VBA
      //ALUIN    DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
      //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
      //ALUPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
      //AJXPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
      //*** RUNTIME ENABLEMENT CHOSEN - MULTIPLE LLQS
      //SYSPROC  DD DSN=AEX.QA1310.CLIST,DISP=SHR
      //ISPSLIB  DD DSN=AEX.QA1310.SLIB,DISP=SHR
      //ISPTLIB  DD DSN=AEX.QA1310.TLIB,DISP=SHR
      //ISPPLIB  DD DSN=AEX.QA1310.PLIB,DISP=SHR
      //AEXPRINT DD SYSOUT=*
      //WORKLIST DD DISP=SHR,
      //   DSN=ACM.DB2V13.V131.WLBASE01(RD10405D)
      //*-----------------------------------------
      //*--------------------------------------------------------------------
      //*  UTILITY WORK DD STATEMENTS
      //*--------------------------------------------------------------------
      //SYSUT001 DD DSN=RDACRJ.RD10405D.STEP1.SYSUT001,
      //         DISP=(NEW,CATLG,CATLG),
      //         SPACE=(CYL,(10,2)),
      //         UNIT=SYSDA
      //*--------------------------------------------------------------------
      //*  UTILITY SORTOUT WORK DD STATEMENTS
      //*--------------------------------------------------------------------
      //SORTOUT DD DSN=RDACRJ.RD10405D.STEP1.SORTOUT,
      //         DISP=(NEW,CATLG,CATLG),
      //         SPACE=(CYL,(10,2)),
      //         UNIT=SYSDA
      //*--------------------------------------------------------------------
      //*  UTILITY DISCARD DD STATEMENTS
      //*--------------------------------------------------------------------
      //SYSDS001 DD DSN=RDACRJ.RD10405D.SYSDS001,
      //         DISP=(NEW,CATLG,CATLG),
      //         SPACE=(CYL,(10,2),RLSE),
      //         UNIT=SYSDA
      //*--------------------------------------------------------------------
      //*  MAPDDN OUTPUT DD STATEMENTS
      //*--------------------------------------------------------------------
      //SYSMAP DD DSN=RDACRJ.RD10405D.DEND.SYSMAP,
      //         DISP=(NEW,CATLG,CATLG),
      //         SPACE=(CYL,(10,2)),
      //         UNIT=SYSDA
      //*--------------------------------------------------------------------
      //*  ERRDDN OUTPUT DD STATEMENTS
      //*--------------------------------------------------------------------
      //SYSER001 DD DSN=RDACRJ.RD10405D.STEP1.SYSER001,
      //         DISP=(NEW,CATLG,CATLG),
      //         SPACE=(CYL,(10,2),RLSE),
      //         UNIT=SYSDA
      //*--------------------------------------------------------------------
      //*  SORT WORK DD STATEMENTS
      //*--------------------------------------------------------------------
      //* ESTIMATE /N
      //SORTWK01 DD SPACE=(CYL,(10,2)),
      //          UNIT=SYSDA,
      //          DISP=(NEW,DELETE)
      //* ESTIMATE /N
      //SORTWK02 DD SPACE=(CYL,(10,2)),
      //          UNIT=SYSDA,
      //          DISP=(NEW,DELETE)
      //* ESTIMATE /N
      //SORTWK03 DD SPACE=(CYL,(10,2)),
      //          UNIT=SYSDA,
      //          DISP=(NEW,DELETE)
      //* ESTIMATE /N
      //SORTWK04 DD SPACE=(CYL,(10,2)),
      //          UNIT=SYSDA,
      //          DISP=(NEW,DELETE)
      //* ESTIMATE /N
      //SORTWK05 DD SPACE=(CYL,(10,2)),
      //          UNIT=SYSDA,
      //          DISP=(NEW,DELETE)
      //*--------------------------------------------------------------------
      //* END OF JOBSTEP
      //*--------------------------------------------------------------------
      //*--------------------------------------------------------------------
      //* END OF JOB
      //*--------------------------------------------------------------------
    4. After you review the JCL, press END to return to the Execution JCL Processing Interface panel.
    5. From the Execution JCL Processing Interface panel, press Enter to submit the JCL and migrate your objects.The result of execution is a worklist execution log (AEXPRINT).
    6. To review the results of execution in the worklist execution log (AEXPRINT), you can split your ISPF session or you can use your normal method to review SYSOUT. The following figure shows the worklist execution log.The last message in the worklist indicates that the work ID status is complete and that the worklist completed successfully. The worklist migrated the objects that you specified.

      Click here to view the worklist execution log
      1

      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   1
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0BMC706707I  PTFS:

       BMC16815I  PARAMETERS:   ACM
       BMC16815I  PARAMETERS:   SSID DEND WORKID RDACRJ.RD10405D
       BMC16815I  PARAMETERS:   DASDDOPT DSD1QDOP
       BMC16815I  PARAMETERS:   CATDOPT DCD1QDOP
       BMC16815I  PARAMETERS:   STOPWAIT 3
       BMC16815I  PARAMETERS:   STOPWTSECS 10
       BMC16815I  PARAMETERS:   LOCK EXCLUSIVE
       BMC16992I  USING 'DSD1QDOP' AS OPTIONS FOR DASD MANAGER UTILITIES
       BMC16943I  USING 'DMD1QEND' FOR RUN OPTIONS
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16979I  WORKLIST DSNAME IS 'ACM.DB2V13.V131.WLBASE01(RD10405D)'
       BMC706708I DB2 RELEASE: 1315 MODE: NEW FUNCTION
       BMC70925I  CURRENT FUNCTION LEVEL  V13R1M501  CATALOG LEVEL           V13R1M501
       BMC70926I  HIGHEST ACTIVATED LEVEL V13R1M501  PREVIOUS FUNCTION LEVEL V13R1M500
       BMC16806I  PARAMETERS ACCEPTED, BEGINNING EXECUTION VERSION V13.01.00 BASE 05/31/2022 FOR BMC AMI Change Manager for Db2
       BMC16971I  AUTHID SWITCHING OPTION 'N' IS IN EFFECT. -AUTH NOT ALLOWED.
       BMC16957I  EXECUTION AUTHID IS RDACRJ

      0:***********************************************************************
       BMC70933I  WORKID DESCRIPTION:
       BMC16999I  INITIAL WORKID STATUS FOR RD10405D IS 'N' (NOT STARTED
       BMC16999I  UPDATED WORKID STATUS FOR RD10405D IS 'S' (STARTED)
      0:***********************************************************************
      0:*** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)
      0:***********************************************************************
      0:*** BMC AMI Change Manager for Db2 13.01.00 BASE PTFs applied:
      0:*** BQU3344
      0:*** EXECUTION (AEX) 13.01.00 BASE PTFs applied:
      0:*** NONE
      0:***********************************************************************
      0:* ALUIN PARMS:                                                        *
      0:*   SSID DEND                                                         *
      0:*   WORKID RDACRJ.RD10405D                                            *
      0:*   INCLUDE (DATA SQL AMS  )                                          *
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   2
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:*   SORTDEVT SYSDA                                                    *
      0:*   SMSINCLUDE (  )                                                   *
      0:*   IBMUNLOAD IBMLOAD NOUSENGTUL                                      *
      0:*   IBMREORG NOUSENGTR                                                *
      0:*   IBMREBUILD                                                        *
      0:*   STANDALONESTATS DB2STATSUPD TABLEALL                              *
      0:*   NOHISTORY                                                         *
      0:*   IBMCOPY                                                           *
      0:*   NOUTILCOPY                                                        *
      0:*   DYNUNLD                                                           *
      0:*   DYNCOPY                                                           *
      0:*   NOPARTCOPY                                                        *
      0:*   COPYDDN (COPY01   )                                               *
      0:*   NOREGENIDENTITY                                                   *
      0:*   SINGLEPHASE                                                       *
      0:*   NOVVALPROP                                                        *
      0:*   IBMCHECK                                                          *
      0:*   SYNCPOINT 10                                                      *
      0:*   NODBRMLIB                                                         *
      0:*   ORDERBY                                                           *
      0:*   UNLOADTABLE                                                       *
      0:*   NOREORGALT                                                        *
      0:*   UNLOADEMPTY                                                       *
      0:*   NOSTOPCOMMIT                                                      *
      0:*   TABLEACCESS                                                       *
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   3
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:*   NOAPPLCOVR                                                        *
      0:*   NOPARALLEL                                                        *
      0:*   REORGONLINE                                                       *
      0:*   REORGALL                                                          *
      0:*   REORGREF                                                          *
      0:*   SPANNEDRECS                                                       *
      0:*   NOBINDONIX                                                        *
      0:*   NOMOVETB                                                          *
      0:*   NODEFERCDC                                                        *
      0:***********************************************************************
      0:-TIME 000050 '2022-04-05-17.44.51.080131'                               90576933
      0:-SSID 000100 DEND                                                       80514191
      0:-JCLP 000150 MIGR MSSID DEND                                            45842323
       BMC16511I  -JCLP IGNORED IN THIS RUN.  SKIPPING WORKLIST RECORDS UNTIL NEXT COMMAND
      0:-WKID 000200 RDACRJ.RD10405D                                            26594972
      0:-CENV 000250
       :             TABLE_COL_NAME_EXPANSION ON                                24829915
       BMC16815I  PARAMETERS: DMD1QEND,DEND
       BMC16822I  CONTROL PASSED TO 'ALUZPARM'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16898I  DEBUG: ALUZPARM 0

       **********************************************************************
       ***                        BMC Software Inc.                       ***
       ***                  BMC AMI Change Manager for Db2                ***
       ***                     Version: 13.01.00 BASE                     ***
       **********************************************************************
       BMC396397I CHECK ENVIRONMENT ROUTINE STARTED - 04/05/2022 17:50:36
       ** ALUIN:              TABLE_COL_NAME_EXPANSION ON
       BMC56301I KEYWORDS ACCEPTED

       BMC56723I CONNECTING TO SSID 'DEND' USING PLAN 'ACMD1QXM'
       BMC56464I INITIAL Db2 ATTACH SUCCESSFUL. SSID(4)=DEND.
       BMC56464I Db2 PLAN 'ACMD1QXM' USED FOR THIS TASK. RC=0
       BMC56464I Db2 CONNECTED. VERSION 13 IN NEW FUNCTION MODE
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   4
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       BMC56464I Db2 CURRENT FUNCTION LEVEL IS V13R1M501
       BMC56464I Db2 CATALOG LEVEL IS V13R1M501
       BMC56464I APPLCOMPAT IS V13R1M501
       BMC56724I CONNECTION COMPLETED WITH SQLCODE 0, ERR 0, RC 0
       BMC396480I ZPARM SPECIFIED IN DOPTS DMD1QEND IS DSNZPARM
       BMC396400I CHECK ENVIRONMENT ROUTINE SUCCESSFUL  RC=0
      0:-SYNC 000300 END OF CHECK ENVIRONMENT SECTION                           99414218
      0:***********************************************************************
      0:***********************************************************************
      0:***********************************************************************
      0:***********************************************************************
      0:***  THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
      0:***********************************************************************
      0:*BMC396243I DB2 VERSION 13 IN NEW FUNCTION MODE
      0:*BMC56464I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
      0:*BMC56464I DB2 CATALOG LEVEL IS V13R1M501
      0:*BMC56464I APPLCOMPAT IS V13R1M501
      0:*BMC56464I APPLCOMPAT FROM DSNZPARM IS V13R1M501
      0:*BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
      0:*           ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
      0:*            PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
      0:*            PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
      0:*BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
      0:*BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
      0:*           ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
      0:*           KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
      0:*BMC396476I FOR PARTITION BY RANGE TABLE SPACES THAT USE RELATIVE PAGE
      0:*           NUMBERING, DB2 REQUIRES THAT THE TABLESPACE AND THE INDEX
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   5
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:*           SPACE USE EXTENDED ADDRESSIBILITY ENABLED DASD DEVICES
      0:*           (STOGROUPS).
      0:*BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
      0:*            REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
      0:*            PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
      0:*            ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
      0:*            INPUT STREAM.
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   6
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:***********************************************************************
      0:***  END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
      0:***********************************************************************
      0:*** ORIGINATOR OF WORKLIST WAS WORKID RDACRJ.RD10405D ON SSID DEND ***
      0:-MIGR 000350 PHASE-1   START OF SECTION TO BE RUN ON SENDING SYSTEM     38352787
      0:-SYNC 000400 START OF EXECUTION SYNCPOINT                               86376801
      0:***********************************************************************
      0:-UNLI 000450
       :  TEMPLATE SYRC
       :      DSN 'RDACRJ.DEND.RD10405D.SR000001'
       :      UNIT SYSDA
       :
       :        UNLOAD FROM TABLE R1128C04.T@T128PBR2
       :             HEADER NONE
       :  (
       :   COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   7
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP EXTERNAL(32)
       : , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP WITH TIME ZONE EXTERNAL(32)
       : , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP EXTERNAL(32)
       : , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :   CLOB
       : , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :   BLOB
       : , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       :@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :   CLOB
       : , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :   XML
       :   )
       :             UNLDDN SYRC
       :             SPANNED YES
       :             EBCDIC CCSID(37,0,0)
       :             NOPAD  MAXERR 1
       :             IMPLICIT_TZ -05:00
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.50.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   8
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                                                                        38763186
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:50:36.84 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:50:36.85 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:50:36.86 DSNUGUTC -  TEMPLATE SYRC DSN 'RDACRJ.DEND.RD10405D.SR000001' UNIT SYSDA
       DSNU1035I   095 17:50:36.86 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:50:36.86 DSNUGUTC -  UNLOAD
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -   FROM TABLE R1128C04.T@T128PBR2 HEADER NONE
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -    (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP EXTERNAL(32),
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  9
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP WITH TIME ZONE EXTERNAL(32),
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP EXTERNAL(32),
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T CLOB,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       @CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T BLOB,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
       T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T CLOB,
       DSNU650I  *DEND 095 17:50:36.87 DSNUUGMS -     COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T XML) UNLDDN SYRC SPANNED YES EBCDIC CCSID(37, 0, 0)
       NOPAD MAXERR 1 IMPLICIT_TZ -5:0
       DSNU1038I   095 17:51:24.22 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=SYRC
                              DDNAME=SYS00008
                              DSN=RDACRJ.DEND.RD10405D.SR000001
       DSNU253I    095 17:51:24.26 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLE
       R1128C04.T@T128PBR2
       DSNU252I    095 17:51:24.26 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
       R1128C04.T128PBR2
       DSNU250I    095 17:51:24.26 DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:47
       DSNU010I    095 17:51:24.27 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 000500 END OF UNLOAD TABLES SECTION                               53302971
      0:***********************************************************************
      0:-SETS 000550 SET CURRENT SQLID = 'RDACRJ4'                              76602437
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  000600 CREATE DATABASE R1128C30
       :                    STOGROUP SYSDEFLT
       :                    BUFFERPOOL BP8K0
       :                                                                        71408394
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETS 000650 SET CURRENT SQLID = USER                                   95314987
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 000700 END OF DATABASE SECTION                                    29545590
      0:***********************************************************************
      0:-SETS 000750 SET CURRENT SQLID = 'RDACRJ4'                              76471365
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  10
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  000800 CREATE LOB TABLESPACE T128P2L3 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        05268805
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  000850 CREATE LOB TABLESPACE T128P2L4 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        05267269
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  000900 CREATE LOB TABLESPACE T128P2L5 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        05202757
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  000950 CREATE LOB TABLESPACE T128P2L6 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        05201221
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001000 CREATE LOB TABLESPACE T128P2L1 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        10983611
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  11
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001050 CREATE LOB TABLESPACE T128P2L2 IN R1128C30
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    GBPCACHE   SYSTEM
       :                    BUFFERPOOL BP8K0
       :                    DSSIZE        4G
       :                                                                        10985147
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001100 CREATE  TABLESPACE T128PBR2 IN R1128C30
       :                    NUMPARTS 2
       :                   (PART 1
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    PCTFREE    0   FOR UPDATE -1
       :                    DSSIZE        1G
       :                   ,PART 2
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     1440
       :                    SECQTY     720
       :                    PCTFREE    0   FOR UPDATE -1
       :                    DSSIZE        1G
       :                   )
       :                    CCSID EBCDIC
       :                    BUFFERPOOL BP1
       :                    LOCKSIZE   ANY
       :                    LOCKMAX    10
       :                    CLOSE      NO
       :                    SEGSIZE    4
       :                    PAGENUM    RELATIVE
       :                    DSSIZE        1G
       :                                                                        11397415
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETS 001150 SET CURRENT SQLID = USER                                   11764523
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 001200 END OF CREATE TABLESPACE SECTION                           21677747
      0:***********************************************************************
      0:-SQL  001250 CREATE TABLE RDACRJ4.T@T128PBR2
       : (
       :  COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       : ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     CHAR(1) NOT NULL WITH DEFAULT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  12
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :    'A'
       : , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     VARCHAR(15) NOT NULL WITH DEFAULT
       :    'SEATTLE'
       : , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     CLOB(1073741824)
       :     INLINE LENGTH 0
       :     WITH DEFAULT
       : , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     BINARY(4) NOT NULL WITH DEFAULT
       :    BX'0102'
       : , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     VARBINARY(5) NOT NULL WITH DEFAULT
       :    BX'030405'
       : , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     BLOB(1073741824)
       :     INLINE LENGTH 0
       :     WITH DEFAULT
       : , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     SMALLINT NOT NULL WITH DEFAULT
       :    55
       : , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     INTEGER NOT NULL WITH DEFAULT
       :    1969
       : , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     BIGINT NOT NULL WITH DEFAULT
       :    9223372036854775804
       : , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     DECIMAL(5,2) NOT NULL WITH DEFAULT
       :    123.67
       : , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     DECIMAL(10,1) NOT NULL WITH DEFAULT
       :    123456789.0
       : , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     FLOAT NOT NULL WITH DEFAULT
       :    10.2E1
       : , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     REAL NOT NULL WITH DEFAULT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  13
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :    5.4E-075
       : , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     FLOAT NOT NULL WITH DEFAULT
       :    5.4E-78
       : , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     DECFLOAT(16) WITH DEFAULT
       : , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     DECFLOAT(34) WITH DEFAULT
       : , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     DATE NOT NULL WITH DEFAULT
       :    '2013-01-02'
       : , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIME NOT NULL WITH DEFAULT
       :    '12.57.00'
       : , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP NOT NULL WITH DEFAULT
       :    '2015-01-01-00.00.00.000000'
       : , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP WITH TIME ZONE NOT NULL WITH DEFAULT
       :    '2015-01-02-05.30.00.000000-08:30'
       : , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     TIMESTAMP NOT NULL WITH DEFAULT
       :    '2015-01-02-05.30.00.000000'
       : , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     CHAR(2) WITH DEFAULT
       : , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     CHAR(2) FOR BIT DATA WITH DEFAULT
       : , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     VARCHAR(4) NOT NULL WITH DEFAULT
       : , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     VARCHAR(4) FOR BIT DATA WITH DEFAULT
       : , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     CLOB(1073741824)
       :     INLINE LENGTH 0
       :     WITH DEFAULT
       : , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.24 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  14
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :     XML NOT NULL
       : )
       :                    CCSID EBCDIC
       :  IN R1128C30.T128PBR2
       :                    PARTITION BY
       : ( COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T      )
       :                   (PARTITION 1 ENDING AT (2000)
       :                   ,PARTITION 2 ENDING AT (2010)
       :                   )
       :                                                                        07033474
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001300 LABEL ON RDACRJ4.T@T128PBR2
       :                   (COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
       : DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'D'
       :                   ,COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
       : DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'E'
       :                   ,COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'F'
       :                   )
       :                                                                        59380357
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001350 COMMENT ON RDACRJ4.T@T128PBR2
       :                   (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDR
       : ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'COL 1 127'
       :                   ,COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'COL 2 127'
       :                   ,COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
       : RED@T
       :                     IS 'COL 3 127'
       :                   )                                                    05138706
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001400 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L3
       :                    IN R1128C30.T128P2L3
       :                    STORES RDACRJ4.T@T128PBR2
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.28 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  15
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                    COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   1
       :                                                                        42016305
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001450 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L4
       :                    IN R1128C30.T128P2L4
       :                    STORES RDACRJ4.T@T128PBR2
       :                    COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   2
       :                                                                        42015022
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001500 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L5
       :                    IN R1128C30.T128P2L5
       :                    STORES RDACRJ4.T@T128PBR2
       :                    COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   1
       :                                                                        14110752
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001550 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L6
       :                    IN R1128C30.T128P2L6
       :                    STORES RDACRJ4.T@T128PBR2
       :                    COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   2
       :                                                                        14109469
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001600 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L1
       :                    IN R1128C30.T128P2L1
       :                    STORES RDACRJ4.T@T128PBR2
       :                    COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   1
       :                                                                        42278197
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.28 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  16
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:-SQL  001650 CREATE AUXILIARY TABLE
       :                RDACRJ4.T@T128PBR2L2
       :                    IN R1128C30.T128P2L2
       :                    STORES RDACRJ4.T@T128PBR2
       :                    COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T
       :                    PART   2
       :                                                                        42276914
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 001700 END OF TABLE SECTION                                       91789030
      0:***********************************************************************
      0:-SQL  001750 CREATE UNIQUE INDEX
       :                    RDACRJ4.I@T128PBR22
       :                 ON RDACRJ4.T@T128PBR2
       : ( COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     12
       :                    SECQTY     12
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        10584101
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001800 ALTER  TABLE RDACRJ4.T@T128PBR2
       :                    ADD CONSTRAINT PK@T128PBR2
       :                    PRIMARY KEY (COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T,
       :                                 COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T)
       :                                                                        99403208
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001850 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L3
       :                 ON RDACRJ4.T@T128PBR2L3
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.28 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  17
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        01130958
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001900 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L4
       :                 ON RDACRJ4.T@T128PBR2L4
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        01195216
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  001950 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L5
       :                 ON RDACRJ4.T@T128PBR2L5
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        01196498
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002000 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L6
       :                 ON RDACRJ4.T@T128PBR2L6
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        17382612
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002050 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L1
       :                 ON RDACRJ4.T@T128PBR2L1
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.28 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  18
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        17383882
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002100 CREATE INDEX
       :                    RDACRJ4.I@T128PBR2L2
       :                 ON RDACRJ4.T@T128PBR2L2
       :                    PADDED
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        17448140
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002150 CREATE UNIQUE INDEX
       :                    RDACRJ4.I@T128PBR23
       :                 ON RDACRJ4.T@T128PBR2
       : ( COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :                    NOT PADDED
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     12
       :                    SECQTY     12
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        01276496
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002200 CREATE UNIQUE INDEX
       :                    RDACRJ4.I@T128PBR24
       :                 ON RDACRJ4.T@T128PBR2
       : ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :                    INCLUDE
       : ( COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :                    NOT PADDED
       :                    USING STOGROUP SYSDEFLT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.28 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  19
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        83684506
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 002250 AUTOMATIC SYNC POINT                                       71276645
      0:-SQL  002300 CREATE INDEX
       :                    RDACRJ4.I@T128PBR25
       :                 ON RDACRJ4.T@T128PBR2
       : (
       : SUBSTR( COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
       : @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T, 1, 3
       : )
       : ,
       : DATE( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@E
       : IGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       : )
       :                    USING STOGROUP SYSDEFLT
       :                    PRIQTY     -1
       :                    SECQTY     -1
       :                    BUFFERPOOL BP1
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        46947416
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002350 CREATE INDEX
       :                    RDACRJ4.I@T128PBR21
       :                 ON RDACRJ4.T@T128PBR2
       : ( COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :                    NOT PADDED
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     12
       :                    SECQTY     12
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        24910753
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002400 CREATE INDEX
       :                    RDACRJ4.I@T128PBR26
       :                 ON RDACRJ4.T@T128PBR2
       : (
       : COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.29 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  20
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T * COLIN@11@ON
       : E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       : @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : ,
       : COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T - 1
       : )
       :                    USING STOGROUP R1EAV
       :                    PRIQTY     96
       :                    SECQTY     48
       :                    BUFFERPOOL BP0
       :                    CLOSE      YES
       :                    PIECESIZE  4194304 K
       :                                                                        57102322
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 002450 END OF CREATE INDEX SECTION                                44006859
      0:***********************************************************************
      0:-SQL  002500 ALTER  TABLE RDACRJ4.T@T128PBR2
       :                    ADD CONSTRAINT UC@T128PBR2
       :                         UNIQUE (COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T)
       :                                                                        38690960
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 002550 END OF UNIQUE CONSTRAINTS SECTION                          13116438
      0:***********************************************************************
      0:-LOAD 002600
       :  TEMPLATE SYRC
       :      DSN 'RDACRJ.DEND.RD10405D.SR000001'
       :      UNIT SYSDA
       :
       :             LOAD DATA  REPLACE
       :             INDDN SYRC
       :             ERRDDN SYSER001
       :             DISCARDS 1
       :             DISCARDDN SYSDS001
       :             EBCDIC CCSID(37,0,0)
       :             FORMAT SPANNED YES
       :             WORKDDN SYSUT001
       :             LOG NO
       :             ENFORCE NO
       :             REUSE
       :             INTO TABLE RDACRJ4.T@T128PBR2
       :             IGNOREFIELDS YES
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.29 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  21
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : (
       :  COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       :ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) CHAR(1),
       :  COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) VARCHAR,
       :  COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) BINARY,
       :  COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) VARBINARY,
       :  COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) SMALLINT,
       :  COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) INTEGER,
       :  COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) BIGINT,
       :  COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) DECIMAL,
       :  COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) DECIMAL,
       :  COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) FLOAT(53),
       :  COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) FLOAT(21),
       :  COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) FLOAT(53),
       :             NULL001             POSITION(*) CHAR(1),
       :  COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) DECFLOAT(16)
       :                         NULLIF NULL001=X'FF',
       :             NULL002             POSITION(*) CHAR(1),
       :  COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) DECFLOAT(34)
       :                         NULLIF NULL002=X'FF',
       :  COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) DATE EXTERNAL,
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.29 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  22
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :  COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) TIME EXTERNAL,
       :  COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) TIMESTAMP EXTERNAL(32),
       :  COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) TIMESTAMP WITH TIME ZONE EXTERNAL(32),
       :  COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) TIMESTAMP EXTERNAL(32),
       :             NULL003             POSITION(*) CHAR(1),
       :  COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) CHAR(2)
       :                         NULLIF NULL003=X'FF',
       :             NULL004             POSITION(*) CHAR(1),
       :  COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) CHAR(2)
       :                         NULLIF NULL004=X'FF',
       :  COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) VARCHAR,
       :             NULL005             POSITION(*) CHAR(1),
       :  COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) VARCHAR
       :                         NULLIF NULL005=X'FF',
       :             NULL006             POSITION(*) CHAR(1),
       :  COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) CLOB
       :                         NULLIF NULL006=X'FF',
       :             NULL007             POSITION(*) CHAR(1),
       :  COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       :HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) BLOB
       :                         NULLIF NULL007=X'FF',
       :             NULL008             POSITION(*) CHAR(1),
       :  COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       :CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) CLOB
       :                         NULLIF NULL008=X'FF',
       :  COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       :ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :    POSITION(*) XML)
       :                                                                        54503458
       BMC16815I  PARAMETERS: DEND,RD10405D
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.29 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  23
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 4
      0BMC16820W  SUBTASK DSNUTILB RC NOT 0, RETURN CODE WAS: X'00000004'

      0DSNU000I    095 17:51:29.29 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:29.30 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:29.31 DSNUGUTC -  TEMPLATE SYRC DSN 'RDACRJ.DEND.RD10405D.SR000001' UNIT SYSDA
       DSNU1035I   095 17:51:29.31 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:29.31 DSNUGUTC -  LOAD DATA REPLACE INDDN SYRC ERRDDN SYSER001 DISCARDS 1 DISCARDDN SYSDS001
       EBCDIC CCSID(37, 0, 0) FORMAT SPANNED YES WORKDDN SYSUT001 LOG NO ENFORCE NO REUSE
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -  INTO TABLE RDACRJ4.T@T128PBR2 IGNOREFIELDS YES
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -   (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BINARY,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARBINARY,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) SMALLINT,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) INTEGER,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BIGINT,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECIMAL,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECIMAL,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(53),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(21),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(53),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL001 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECFLOAT(16) NULLIF NULL001=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL002 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECFLOAT(34) NULLIF NULL002=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DATE EXTERNAL,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.31 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  24
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIME EXTERNAL,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP EXTERNAL(32),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP WITH TIME ZONE EXTERNAL(32),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP EXTERNAL(32),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL003 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(2) NULLIF NULL003=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL004 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(2) NULLIF NULL004=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR,
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL005 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR NULLIF NULL005=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL006 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CLOB NULLIF NULL006=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL007 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BLOB NULLIF NULL007=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    NULL008 POSITION(*) CHAR(1),
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CLOB NULLIF NULL008=X'FF',
       DSNU650I  *DEND 095 17:51:29.32 DSNURWI -    COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
       ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) XML)
       DSNU1038I   095 17:51:29.37 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=SYRC
                              DDNAME=SYS00009
                              DSN=RDACRJ.DEND.RD10405D.SR000001
       DSNU350I  *DEND 095 17:51:30.98 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
       DSNU304I  *DEND 095 17:51:31.23 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE RDACRJ4.T@T128PBR2
       DSNU1147I *DEND 095 17:51:31.23 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=0 FOR TABLESPACE
       R1128C30.T128PBR2
       DSNU302I    095 17:51:31.23 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0
       DSNU300I    095 17:51:31.23 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:01
       DSNU1383I *DEND 095 17:51:31.23 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
       REASON = OBJECT IN RESTRICTIVE STATE
       DSNU380I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128PBR2 PARTITION 1 IS IN COPY PENDING
       DSNU380I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128PBR2 PARTITION 2 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L3 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L4 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L5 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L6 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L1 IS IN COPY PENDING
       DSNU381I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L2 IS IN COPY PENDING
       DSNU380I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.XTXT0000 PARTITION 1 IS IN COPY PENDING
       DSNU380I  *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.XTXT0000 PARTITION 2 IS IN COPY PENDING
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.31 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  25
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       DSNU010I    095 17:51:31.24 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
      0:-SYNC 002650 LOAD TB RDACRJ4.T@T128PBR2 COMPLETE                        79008138
      0:-SYNC 002700 END OF LOAD TABLES SECTION                                 61090539
      0:***********************************************************************
      0:*SQL  002750 ALTER  TABLE RDACRJ4.T@T128PBR2
      0:*           FOREIGN KEY FK@T128PBR2
      0:*( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      0:*@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
      0:*, COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      0:*@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
      0:*           REFERENCES RDACRJ4.T@T04TCP
      0:*                      ON DELETE RESTRICT
      0:*
      0:*
      0:-SYNC 002800 END OF FOREIGN KEYS SECTION                                79901525
      0:***********************************************************************
      0:-SETP 002850 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SESSION_USER","R1UDT","R1UDF","R198573"                              63438759
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  002900 ALTER  TABLE RDACRJ4.T@T128PBR2
       :                 ADD CONSTRAINT CK@T128PBR2 CHECK (
       :   COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T <> 'AA'
       :                   )
       :                                                                        90091327
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 002950 SET CURRENT PATH = SYSTEM PATH                             90714802
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 003000 END OF CHECK CONSTRAINTS SECTION                           29715932
      0:***********************************************************************
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.31 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  26
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:-CHEK 003050
       :               CHECK DATA TABLESPACE R1128C30.T128PBR2
       :                     ERRDDN SYSER001 WORKDDN SYSUT001
       :                     EXCEPTIONS 0
       :             SORTDEVT SYSDA
       :                                                                        96815248
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 4
      0BMC16820W  SUBTASK DSNUTILB RC NOT 0, RETURN CODE WAS: X'00000004'

      0DSNU000I    095 17:51:31.40 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:31.41 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:31.41 DSNUGUTC -  CHECK DATA TABLESPACE R1128C30.T128PBR2 ERRDDN SYSER001 WORKDDN SYSUT001
       EXCEPTIONS 0 SORTDEVT SYSDA
       DSNU727I  *DEND 095 17:51:31.41 DSNUKINP - TABLESPACE 'R1128C30.T128PBR2' IS NOT CHECK PENDING
       DSNU749I    095 17:51:31.41 DSNUK001 - CHECK DATA COMPLETE,ELAPSED TIME=00:00:00
       DSNU010I    095 17:51:31.42 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
      0:-SYNC 003100 CHECK DATA FOR TS R1128C30.T128PBR2 COMPLETE               11303406
      0:-SYNC 003150 END OF CHECK DATA SECTION                                  24204699
      0:***********************************************************************
      0:-COPY 003200
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000001'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L3
       :                    COPYDDN (DCPYLOCP)
       :                                                                        91200417
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:31.51 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:31.52 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:31.53 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000001' UNIT SYSDA
       DSNU1035I   095 17:51:31.53 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.31 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  27
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0DSNU050I    095 17:51:31.53 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L3 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:31.59 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00010
                              DSN=RDACRJ.RD10405D.T128P2L3.P00000.LP000001
       DSNU400I    095 17:51:31.71 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L3
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:31.73 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L3
       DSNU010I    095 17:51:31.74 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003250 COPY FOR TS R1128C30.T128P2L3 COMPLETE                     51040916
      0:-COPY 003300
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000002'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L4
       :                    COPYDDN (DCPYLOCP)
       :                                                                        91134879
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:31.84 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:31.86 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:31.86 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000002' UNIT SYSDA
       DSNU1035I   095 17:51:31.86 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:31.86 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L4 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:31.92 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00011
                              DSN=RDACRJ.RD10405D.T128P2L4.P00000.LP000002
       DSNU400I    095 17:51:32.01 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L4
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:32.02 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L4
       DSNU010I    095 17:51:32.03 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003350 COPY FOR TS R1128C30.T128P2L4 COMPLETE                     51171988
      0:-COPY 003400
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.32 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  28
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000003'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L5
       :                    COPYDDN (DCPYLOCP)
       :                                                                        91069341
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:32.12 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:32.13 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:32.14 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000003' UNIT SYSDA
       DSNU1035I   095 17:51:32.14 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:32.14 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L5 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:32.19 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00012
                              DSN=RDACRJ.RD10405D.T128P2L5.P00000.LP000003
       DSNU400I    095 17:51:32.30 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L5
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:32.32 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L5
       DSNU010I    095 17:51:32.32 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003450 COPY FOR TS R1128C30.T128P2L5 COMPLETE                     51303060
      0:-COPY 003500
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000004'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L6
       :                    COPYDDN (DCPYLOCP)
       :                                                                        91003803
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:32.46 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:32.47 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:32.47 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000004' UNIT SYSDA
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.36 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  29
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       DSNU1035I   095 17:51:32.47 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:32.48 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L6 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:34.87 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00013
                              DSN=RDACRJ.RD10405D.T128P2L6.P00000.LP000004
       DSNU400I    095 17:51:36.70 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L6
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:04
       DSNU428I  *DEND 095 17:51:36.73 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L6
       DSNU010I    095 17:51:36.73 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003550 COPY FOR TS R1128C30.T128P2L6 COMPLETE                     51434132
      0:-COPY 003600
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000005'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L1
       :                    COPYDDN (DCPYLOCP)
       :                                                                        90938271
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:36.85 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:36.86 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:36.87 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000005' UNIT SYSDA
       DSNU1035I   095 17:51:36.87 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:36.87 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L1 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:36.92 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00014
                              DSN=RDACRJ.RD10405D.T128P2L1.P00000.LP000005
       DSNU400I    095 17:51:36.98 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L1
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:37.01 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L1
       DSNU010I    095 17:51:37.01 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003650 COPY FOR TS R1128C30.T128P2L1 COMPLETE                     51171988
      0:-COPY 003700
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  30
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000006'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128P2L2
       :                    COPYDDN (DCPYLOCP)
       :                                                                        90872733
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:37.09 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:37.10 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:37.10 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000006' UNIT SYSDA
       DSNU1035I   095 17:51:37.10 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:37.10 DSNUGUTC -  COPY TABLESPACE R1128C30.T128P2L2 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:37.14 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00015
                              DSN=RDACRJ.RD10405D.T128P2L2.P00000.LP000006
       DSNU400I    095 17:51:37.21 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L2
                             NUMBER OF PAGES=21
                             AVERAGE PERCENT FREE SPACE PER PAGE =  1.00
                             PERCENT OF CHANGED PAGES =  0.00
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:37.23 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L2
       DSNU010I    095 17:51:37.23 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003750 COPY FOR TS R1128C30.T128P2L2 COMPLETE                     51303060
      0:-COPY 003800
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000007'
       :      UNIT SYSDA
       :               COPY TABLESPACE R1128C30.T128PBR2
       :                    COPYDDN (DCPYLOCP)
       :                                                                        93951388
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:37.33 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:37.34 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:37.35 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000007' UNIT SYSDA
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  31
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       DSNU1035I   095 17:51:37.35 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:37.35 DSNUGUTC -  COPY TABLESPACE R1128C30.T128PBR2 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:37.37 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00016
                              DSN=RDACRJ.RD10405D.T128PBR2.P00000.LP000007
       DSNU400I    095 17:51:37.46 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128PBR2
                             NUMBER OF PAGES=6
                             AVERAGE PERCENT FREE SPACE PER PAGE =  0.00
                             PERCENT OF CHANGED PAGES = 33.33
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:37.47 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128PBR2
       DSNU010I    095 17:51:37.48 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003850 COPY FOR TS R1128C30.T128PBR2 COMPLETE                     52031844
      0:-COPY 003900
       : XMLTBO RDACRJ4
       : XMLTBN T@T128PBR2
       : XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :  TEMPLATE DCPYLOCP
       :  TEMPLATE DCPYLOCP
       :      DSN 'RDACRJ.&UT..&SN..P&PART..LP000008'
       :      UNIT SYSDA
       :               COPY TABLESPACE XML.TS
       :                    COPYDDN (DCPYLOCP)
       :                                                                        74390147
       BMC16805W  HASH CHECK FAILED - COMMAND MODIFIED BY USER
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:37.57 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:37.58 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:37.58 DSNUGUTC -  TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000008' UNIT SYSDA
       DSNU1035I   095 17:51:37.58 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
      0DSNU050I    095 17:51:37.58 DSNUGUTC -  COPY TABLESPACE R1128C30.XTXT0000 COPYDDN(DCPYLOCP)
       DSNU1038I   095 17:51:37.63 DSNUGDYN - DATASET ALLOCATED.  TEMPLATE=DCPYLOCP
                              DDNAME=SYS00017
                              DSN=RDACRJ.RD10405D.XTXT0000.P00000.LP000008
       DSNU400I    095 17:51:37.71 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.XTXT0000
                             NUMBER OF PAGES=4
                             AVERAGE PERCENT FREE SPACE PER PAGE =  0.00
                             PERCENT OF CHANGED PAGES =  2.22
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  32
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
                             ELAPSED TIME=00:00:00
       DSNU428I  *DEND 095 17:51:37.72 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.XTXT0000
       DSNU010I    095 17:51:37.73 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 003950 COPY FOR TS R1128C30.T128PBR2 COMPLETE                     52097380
      0:-SYNC 004000 END OF COPY SECTION                                        27133996
      0:***********************************************************************
      0:-SETP 004050 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           56186103
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004100 CREATE VIEW RDACRJ4.V5@T128PBR2
       : ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  33
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :   AS SELECT *
       :   FROM RDACRJ4.T@T128PBR2
       :                                                                        96120416
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004150 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           56120567
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004200 CREATE VIEW RDACRJ4.V4@T128PBR2
       : ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  34
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
       : @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
       :   AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       : TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
       : @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
       : RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
       : DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
       : RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
       : @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
       : EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       : HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       : UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
       : NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
       : COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  35
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       : @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
       : WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
       : ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
       : @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
       : @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
       : D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
       : @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
       : 20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
       : S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
       : RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
       : ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
       : EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
       : IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       : UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
       : NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       : TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
       : OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
       : ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
       : HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
       : HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
       : ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
       : NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
       : CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       : WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@
       : T
       :   FROM RDACRJ4.T@T128PBR2
       :                                                                        71731536
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004250 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           56055031
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004300 CREATE VIEW RDACRJ4.V3@T128PBR2
       :   AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       : TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :     , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
       : @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
       : RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
       : DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  36
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
       : @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
       : EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       : HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       : UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
       : NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
       : COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
       : E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
       : @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
       : WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
       : ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
       : @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
       : CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
       : @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
       : D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
       : @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
       : 20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
       : S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
       : RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
       : ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
       : EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
       : IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       : UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
       : NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
       : TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
       : OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
       : ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
       : HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
       : HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
       : ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
       : NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
       : CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
       : HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
       : ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
       : NE@HUNDRED@T, COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TW
       : ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :
       :   FROM RDACRJ4.T@T128PBR2
       :                                                                        65323940
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004350 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           55989495
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  37
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004400 CREATE VIEW RDACRJ4.V2@T128PBR2
       :   AS SELECT *
       :   FROM RDACRJ4.T@T128PBR2
       :                                                                        60777820
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004450 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           55923959
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004500 CREATE VIEW RDACRJ4.V1@T128PBR2
       : ( A1
       : , A2
       : , A3
       : , A4
       : , A5
       : , A6
       : , A7
       : , A8
       : , A9
       : , A10
       : , A11
       : , A12
       : , A13
       : , A14
       : , A15
       : , A16
       : , A17
       : , A18
       : , A19
       : , A20
       : , A21
       : , A22
       : , A23
       : , A24
       : , A25
       : , A26
       : , A27 )
       :   AS SELECT *
       :   FROM RDACRJ4.T@T128PBR2
       :                                                                        58445972
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004550 SET CURRENT PATH = SYSTEM PATH                             24007090
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 004600 END OF CREATE VIEW NOT DEPENDENT ON MQT SECTION            15531780
      0:***********************************************************************
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.37 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  38
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:-SETS 004650 SET CURRENT SQLID = 'RDACRJ4'                              09428037
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004700 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
       : ,"SYSIBMADM"                                                           55728631
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SQL  004750 CREATE TRIGGER RDACRJ4.TR@T128PBR2
       :                    AFTER
       :                    UPDATE
       :                    OF COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
       : HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
       : UNDRED@T
       :                    ON RDACRJ4.T@T128PBR2
       :            REFERENCING NEW AS N@VAR
       :                    FOR EACH ROW MODE DB2SQL
       :   UPDATE RDACRJ4.T@T128PBR2 SET COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARA
       : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
       : TERS@ONE@HUNDRED@T = 60
       :   WHERE COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
       : @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T =
       :     '11.11.00'
       :                                                                        71203551
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETS 004800 SET CURRENT SQLID = USER                                   62553643
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SETP 004850 SET CURRENT PATH = SYSTEM PATH                             24203698
        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
      0:-SYNC 004900 END OF TRIGGER SECTION                                     70815338
      0:***********************************************************************
      0:-RNST 004950
       :               RUNSTATS TABLESPACE R1128C30.T128PBR2
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                        TABLE ALL
       :                                                                        73962273
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:37.93 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.38 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  39
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       DSNU1044I   095 17:51:37.95 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:37.95 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128PBR2 HISTORY NONE INDEX(ALL) TABLE ALL
       DSNU610I  *DEND 095 17:51:38.40 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.41 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.43 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.43 DSNUSEF2 - TABLESPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.43 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.45 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.45 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128PBR2 SUCCESSFUL
       DSNU1374I *DEND 095 17:51:38.45 DSNUSEF2 - SAMPLE SIZE USED :
           ROWS SAMPLED    = 0
           PAGES SAMPLED   = 0
           SAMPLE RATE USED =  100.00
           REPEATABLE       = 0
       DSNU610I  *DEND 095 17:51:38.45 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.45 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.47 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.47 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.47 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.47 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.47 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:38.47 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.37.963050
       DSNU010I    095 17:51:38.48 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005000 STATS FOR TS R1128C30.T128PBR2 COMPLETE                    60041444
      0:-RNST 005050
       : XMLTBO RDACRJ4
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.38 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  40
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       : XMLTBN T@T128PBR2
       : XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
       : GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
       :
       :
       :               RUNSTATS TABLESPACE XML.TS
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                        TABLE ALL
       :                                                                        15001993
       BMC16805W  HASH CHECK FAILED - COMMAND MODIFIED BY USER
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:38.57 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:38.58 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:38.58 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.XTXT0000 HISTORY NONE INDEX(ALL) TABLE ALL
       DSNU610I  *DEND 095 17:51:38.62 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.XTXT0000 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.62 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.62 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.62 DSNUSEF2 - TABLESPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.62 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.62 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.63 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.XTXT0000 SUCCESSFUL
       DSNU1374I *DEND 095 17:51:38.63 DSNUSEF2 - SAMPLE SIZE USED :
           ROWS SAMPLED    = 0
           PAGES SAMPLED   = 0
           SAMPLE RATE USED =  100.00
           REPEATABLE       = 0
       DSNU610I  *DEND 095 17:51:38.63 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.63 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.63 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.63 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:38.63 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.594650
       DSNU010I    095 17:51:38.64 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005100 STATS FOR TS R1128C30.T128PBR2 COMPLETE                    59975908
      0:-RNST 005150
       :               RUNSTATS TABLESPACE R1128C30.T128P2L3
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                                                                        66232122
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.38 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  41
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:38.74 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:38.76 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:38.77 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L3 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:38.81 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L3 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.81 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L3 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.81 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.81 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.81 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.81 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:38.81 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.782912
       DSNU010I    095 17:51:38.82 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005200 STATS FOR TS R1128C30.T128P2L3 COMPLETE                    45003036
      0:-RNST 005250
       :               RUNSTATS TABLESPACE R1128C30.T128P2L4
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                                                                        66297659
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:38.92 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:38.94 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:38.94 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L4 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:38.97 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L4 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.97 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L4 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.97 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:38.97 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:38.97 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:38.97 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:38.98 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.948891
       DSNU010I    095 17:51:38.98 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005300 STATS FOR TS R1128C30.T128P2L4 COMPLETE                    45068828
      0:-RNST 005350
       :               RUNSTATS TABLESPACE R1128C30.T128P2L5
       :                        HISTORY NONE
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.39 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  42
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       :                        INDEX (ALL)
       :                                                                        66363196
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:39.07 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:39.09 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:39.09 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L5 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:39.13 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L5 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.13 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L5 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.13 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:39.13 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:39.13 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.13 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:39.13 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.108672
       DSNU010I    095 17:51:39.14 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005400 STATS FOR TS R1128C30.T128P2L5 COMPLETE                    45134620
      0:-RNST 005450
       :               RUNSTATS TABLESPACE R1128C30.T128P2L6
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                                                                        66428733
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:39.23 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:39.24 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:39.25 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L6 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:39.29 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L6 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.29 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L6 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.29 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:39.29 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:39.29 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.29 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:39.30 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.264362
       DSNU010I    095 17:51:39.30 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005500 STATS FOR TS R1128C30.T128P2L6 COMPLETE                    45200412
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.39 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  43
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
      0:-RNST 005550
       :               RUNSTATS TABLESPACE R1128C30.T128P2L1
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                                                                        66494264
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:39.41 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:39.43 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:39.43 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L1 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:39.48 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L1 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.48 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L1 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.49 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:39.49 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:39.49 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.49 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
       DSNU620I  *DEND 095 17:51:39.49 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.441871
       DSNU010I    095 17:51:39.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005600 STATS FOR TS R1128C30.T128P2L1 COMPLETE                    45264668
      0:-RNST 005650
       :               RUNSTATS TABLESPACE R1128C30.T128P2L2
       :                        HISTORY NONE
       :                        INDEX (ALL)
       :                                                                        66559801
       BMC16815I  PARAMETERS: DEND,RD10405D
       BMC16822I  CONTROL PASSED TO 'DSNUTILB'
       BMC16898I  DEBUG: CONNECTED WITH USER: RDACRJ
       BMC16970I  CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
       BMC16898I  DEBUG: DSNUTILB 0

      0DSNU000I    095 17:51:39.60 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
       DSNU1044I   095 17:51:39.61 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
      0DSNU050I    095 17:51:39.62 DSNUGUTC -  RUNSTATS TABLESPACE R1128C30.T128P2L2 HISTORY NONE INDEX(ALL)
       DSNU610I  *DEND 095 17:51:39.66 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.66 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.66 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
       DSNU604I  *DEND 095 17:51:39.66 DSNUSEOF - INDEXSPACE IS EMPTY
       DSNU610I  *DEND 095 17:51:39.66 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
       DSNU610I  *DEND 095 17:51:39.67 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
      1                                         **** B M C   E X E C U T I O N   F O R   D B 2 ****
                                                          **** V E R S I O N:  V13.01.00
                                                       (C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.

       2022-04-05 17.51.39 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE  44
      0------------------------------------------------------------------------------------------------------------------------------------
                                                  LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
       ------------------------------------------------------------------------------------------------------------------------------------
       DSNU620I  *DEND 095 17:51:39.67 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.628859
       DSNU010I    095 17:51:39.67 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
      0:-SYNC 005700 STATS FOR TS R1128C30.T128P2L2 COMPLETE                    45330460
      0:-SYNC 005750 END OF TABLESPACE STATISTICS SECTION                       92291657
      0:***********************************************************************
       BMC16999I  UPDATED WORKID STATUS FOR RD10405D IS 'C' (COMPLETE)
      0BMC16833I  END OF WORKLIST EXECUTION
    7. Press END to return to the Migrate DB2 Objects Using Specification panel.
    8. Press END to return to the Task List Menu panel.
    9. Press END to return to the BMC AMI Change Manager for Db2 Main Menu.

    This example shows that with Change Manager you have the ability to quickly and accurately specify objects that you want to migrate to another environment, perform an in-depth analysis of the objects selected to determine their effect on your subsystem, and execute SQL statements, utilities, and other commands.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*