Creating, altering, or dropping Db2 objects

Creating, altering, or dropping Db2 objects in ALTER or

BMC AMI Change Manager for Db2

is a three-stage process: specification, analysis, and execution.

Specification
Specify the changes that you want to make to the objects.
Analysis
Analyze the specified 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 change the data structures and preserve all dependent objects.
Execution
Execute the worklist that is generated during the analysis stage.

Note

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.

For more information, view the Quick Course CHANGE MANAGER for DB2 - Performing Specification .

The following example illustrates these stages by showing you how to use the Task List feature of Change Manager to quickly and easily change the length of a column in a table in your database.

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.

To modify objects

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 (see Main Menu), select Task List and press Enter.
  ALUFTASK ------------------------- Task List Menu -----------------------------
  Command ===>
  
  
  
  Select a task. Then press Enter.
        1 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 Create, alter, or drop DB2 objects and press Enter.
  ALUFPALT -------------------- Create, Alter, or Drop Db2 Objects --------------
  Command   ===>
  
  Specify an Alter 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*.*)
  
  Alter WORKID:    RDACRJ.RCB0831E
  
  
  
  
  
  
  
  Type S to select processing options. Then press Enter to continue.
  
  _ Create or edit a WORKID
  _ Specify changes to Db2 objects
  _ Analyze the changes to create a worklist
  _ Execute the worklist to process the changes
  
  Commands: HELP END
Specify an alter-type work ID.A work ID enables you to identify, control, and track a unit of work. The alter-type work ID is used to store the changes to the Db2 objects that you specify.
1. On the Create, Alter, or Drop DB2 Objects panel, type the name of an alter-type work ID, type S to select all of the processing options, and press Enter.The Create WORKID panel is displayed.
  ALUFWRKC -------------------------- Create WORKID ----------- WORKID NOT FOUND
  Command ===>
  
  WORKID . . . . . . : RDACRJ.RCB0831E
  
  Type . . . . . . . . 1 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 Alter for the Type. Then, press Enter.
  ALUSOS TER   ---------------------- Object Specification ----------------------
  Command ===>
  
  WORKID . . . : RDACRJ.RCB0831E                         _ Changed Objects List
  Specify the object type(s) to be included in a list.
  
  Stogroup. .                                                      (SG     Name)
  Database. . R1BAS504                                             (DB     Name)
  Tablespace                                                       (DB.TS Name)
  Table . . .                                                      (Own.TB Name)
  Check Cnst                                                       (Own.TB.Chk )
  Foreign Key                                                      (Own.TB.Rel )
  Index . . .                                                      (Own.IX Name)
  Unique Cnst                                                      (Own.TB.Uniq)
  View. . . .                                                      (Own.VW Name)
  Trigger . .                                                      (Sch.TR Name)
  Alias . . .                                                      (Own.AL Name)
  Synonym . .                                                      (Own.SY Name)
  Permission                                                       (Sch.RP Name)
  Mask. . . .                                                      (Sch.MK Name)
  The following objects are retrieved independently of all other Db2 objects.
  Sequence. .                                                      (Sch.SQ Name)
  Stored Proc                                                      (Sch.SP Name)
Specify the changes that you want to make to the objects.The current values of the objects are displayed on panels. You can modify the attributes for objects by specifying new values or by typing new values over the existing values. All of your changes are stored in Db2 tables.
1. On the Object Specification panel, type the name of your database, table space, and table. Then, press Enter.From the Mixed List panel, you begin the process of specifying changes to the objects that are listed.
  ALUSMXL ER   --------------------------- Mixed List ---------------------------
  Command ===>                                                    Scroll. . CSR
  
  WORKID . . . . : RDACRJ.RCB0831E                             Commands: CANCEL
  
  Type action next to object and press Enter.
     E=Edit L=Like D=Drop U=Undo
                                                          Objects 1 to 21 of 28
                                                                   More:     +
  Act     Object-Type    Objects
  ************************************ TOP **************************************
          DB . . . . . . R1BAS504
            TSR. . . . .   R1BAS504   T05APBR
              TBT. . . .     R1BAS504   T_T05APBR
                IXT. . .       R1BAS504   I_T05APBR<>RTITIONED
                IXCT . .       R1BAS504   I_T05APBR<>TITIONING
                IX . . .       R1BAS504   I_T05APBR2
                VW . . .       R1BAS504   V_T05APBR1
                  VW . .         R1BAS504   V_T05APBR2
            TSG. . . . .   R1BAS504   T06APBG
              TB . . . .     R1BAS504   T_T06APBG
                IXUC . .       R1BAS504   I_T06APBG1
                IX . . .       R1BAS504   I_T06APBG2
                IX . . .       R1BAS504   I_T06APBG3
            TSG. . . . .   R1BAS504   T07APBG
              TB . . . .     R1BAS504   T_T07APBG
                CK . . .       R1BAS504   T_T07APBG            C_T07APBG
                IXC. . .       R1BAS504   I_T07APBG_1
            TSR. . . . .   R1BAS504   T08APBR
              TBT. . . .     R1BAS504   T_T08APBR
                IXT. . .       R1BAS504   I_T08APBR<>RTITIONED
                IXCT . .       R1BAS504   I_T08APBR<>TITIONING
2. On the Mixed List panel, in the Act field type E next to the table that you want to edit and press Enter.
  ALUS2TB ER   -------------------------- Table Detail --------------------------
  Command ===>
  
  WORKID . . . . : RDACRJ.RCB0831E
                                                 New Values
  TB Owner : R1BAS504                         .
  TB Name : T_T05APBR                        .
  
  Database Name . : R1BAS504              . . :
  Tablespace Name : T05APBR               . . :
  Audit . . . . . : NONE                  . . .           (NONE,ALL,CHANGES)
  Validproc . . . :                       . . .
  Editproc . . . :                       . . .
  With Row Attr . :                       . . .           (Y,N)
  Data Capture . : N                     . . .           (Y,N)
  Restrict Drop . : N                     . . .           (Y,N)
  Obid . . . . . : 3                     . . .
  Volatile . . . : N                     . . .           (N,Y)
  Append . . . . : N                     . . .           (N,Y)
  Label:                                  . . .
  Link History TB :                       . . .           (N,Y,E)
  Link Archive TB :                       . . .           (N,Y)
  Table Access . :                       . . .           (C,R,B,blank)
  CCSID . . . . . : EBCDIC     Partitions . . :    4 (Table Controlled)
  Key Label . . . :                       . . .
  
  _ Convert to Index Controlled Partitioning
  _ Convert to Materialized Query Table
  
  Select additional panels to display then press Enter.
  _ Table Column List                 _ Table Comment
  _ Primary Key Columns               _ Auxiliary Objects List
  _ Partitioning Key Columns          _ Parts List and LimitKey Values
  _ MQT Parameters                    _ Implicit TS Dssize
  _ History Table Information         _ Archive Table Information
  
  Commands: HELP END CANCEL PF4=ZOOM
3. On the Table Detail panel, type S to select the Table Column List, and press Enter.The Table Columns List panel displays the current column attributes for the table. In this example, you will change the length of a column.
  ALUSTBC ER   ----------------------- Table Columns List -----------------------
  Command ===>                                                    Scroll. . CSR
  
  WORKID . . . . : RDACRJ.RCB0831E                             Commands: CANCEL
  
  Table Owner . . : R1BAS504
  Table Name . . : T_T05APBR
  
  Type action next to object and press Enter.
    E=Edit L=Like I=Insert D=Drop U=Undo CM=Comment ID=Identity_Detail
    DV=Default_Value AX=Aux_Obj_List CAX=Create_Aux_Obj     Lines 1 to 17 of 17
                                                                   More:       >
  Act   Column Name ..+....20...+....30. Column Type          Length Nl Df Hi UDT
  *** ******************************** TOP **************************************
        COLC_1                           CHAR                     50 N N
        COLSI_2                          SMALLINT                     N N
        COLIN_3                          INTEGER                      N N
        COLSI_4                          SMALLINT                     N N
        COLDC_5                          DECIMAL                 6,2 N N
        COLDC_6                          DECIMAL                   9 N N
        COLDC_7                          DECIMAL                 5,2 N N
        COLVC_8                          VARCHAR                  15 N N
        COLF1_9                          FLOAT                    21 N N
        COLF2_10                         FLOAT                    53 N N
        COLVC_11                         VARCHAR                  15 N N
        COLDT_12                         DATE                         N N
        COLTS_13                         TIMESTAMP                 6 N N
        COLC_14                          CHAR                    100 N N
        COLVC_15                         VARCHAR                1000 N N
        COLBN_16                         BINARY                    5 N N
        COLVB_17                         VARBIN                   10 N N
  *** ******************************* BOTTOM ************************************
4. On the Table Columns List panel, tab to the Length field for the column that you are modifying. Type a new value for the length of the column over the existing value. Press Enter.
5. Press END to return to the Table Detail panel. Press END again to return to the Mixed List Panel.The Mixed List panel displays an '*A' next to the table, indicating that you have made a change to the table.
  ALUSMXL ER   --------------------------- Mixed List ---------------------------
  Command ===>                                                    Scroll. . CSR
  
  WORKID . . . . : RDACRJ.RCB0831E                             Commands: CANCEL
  
  Type action next to object and press Enter.
     E=Edit L=Like D=Drop U=Undo
                                                          Objects 1 to 19 of 28
                                                                   More:     +
  Act     Object-Type    Objects
  ************************************ TOP **************************************
          DB . . . . . . R1BAS504
            TSR. . . . .   R1BAS504   T05APBR
       *A     TBT. . . .     R1BAS504   T_T05APBR
                IXT. . .       R1BAS504   I_T05APBR<>RTITIONED
                IXCT . .       R1BAS504   I_T05APBR<>TITIONING
                IX . . .       R1BAS504   I_T05APBR2
                VW . . .       R1BAS504   V_T05APBR1
                  VW . .         R1BAS504   V_T05APBR2
            TSG. . . . .   R1BAS504   T06APBG
              TB . . . .     R1BAS504   T_T06APBG
                IXUC . .       R1BAS504   I_T06APBG1
                IX . . .       R1BAS504   I_T06APBG2
                IX . . .       R1BAS504   I_T06APBG3
            TSG. . . . .   R1BAS504   T07APBG
              TB . . . .     R1BAS504   T_T07APBG
                CK . . .       R1BAS504   T_T07APBG            C_T07APBG
                IXC. . .       R1BAS504   I_T07APBG_1
            TSR. . . . .   R1BAS504   T08APBR
              TBT. . . .     R1BAS504   T_T08APBR
                IXT. . .       R1BAS504   I_T08APBR<>RTITIONED
                IXCT . .       R1BAS504   I_T08APBR<>TITIONING
6. Press END to return to the Object Specification panel. Press END again.The Analysis Alter Worklist Interface panel is displayed.
  ACMFANL1 ---------------- Analysis Alter Worklist Interface -------------------
  Command   ===>
  
  WORKID . . . . . : RDACRJ.RCB0831E
  
  Analyze "Alter" WORKID
  
  Select type of analysis.
  1 1. Generate a worklist which will convert and reload current data.
    2. Generate a worklist which will convert and reload current data and
        establish a full recovery baseline.
    3. Generate a worklist which will reload data from a previous
        full recovery baseline.
  
  Select run type. Then press Enter.
    Run Type . . . . 1 1. Foreground
                        2. Batch
  
  
  
  
  Commands: HELP END
Analyze the changes that you specified.The Analysis component of the product examines the changes that you specified to determine the effect that the changes have on the structure and the related or dependent objects.
1. On the Analysis Alter Worklist Interface panel, select the option to Generate a worklist which will convert and reload current data. Then select to run the analysis in Foreground. Press Enter.
  Note
  When you run Analysis in foreground, your TSO session will be unavailable until the processing has completed.
  The Analysis JCL Processing Interface panel is displayed.
  ACMFANL3 ---------------- Analysis JCL Processing Interface -------------------
  Command   ===>
  
  WORKID . . . . : RDACRJ.RCB0831E
  
  
  
  Specify Dataset Names
    Worklist . . . . . 'ACM.DB2V12.V121.WLBASE01(RCB0831E)'
    Diagnostics . . . . SYSOUT
    Sysout Class . . . X                 (Used only when Diagnostics = SYSOUT)
  
  
  
  
  Select foreground processing options. Then press Enter.
  _ Override
  S Create analysis input
  S Edit analysis input
  _ Run analysis
  _ Edit Worklist
  
  Commands: BROWSE PREVIOUS HELP END
2. On the Analysis JCL Processing Interface panel, type the name of your Worklist, and type S to select your processing options. Press Enter.The input for the Analysis process is displayed. The input includes the ALUIN input stream, which provides keywords for analyzing the changes. For more information about the input stream, see ALUIN-keywords.
  ISREDDE2   SYS20244.T152350.RA000.RDACRJ.WLIN.H05          Columns 00001 00072
  Command ===>                                                  Scroll ===> CSR
  ****** ***************************** Top of Data ******************************
  ==MSG> -Warning- The UNDO command is not available until you change
  ==MSG>           your edit profile using the command RECOVERY ON.
  000001 SSID DELT
  000002 WORKID RDACRJ.RCB0831E
  000003 SORTDEVT SYSDA
  000004 INCLUDE (DATA AMS SQL REBIND )
  000005 SMSINCLUDE ()
  000006 IBMUNLOAD IBMLOAD NOUSENGTUL
  000007 IBMREORG NOUSENGTR
  000008 NODBRMLIB ORDERBY
  000009 NOVVALPROP
  000010 UNLOADEMPTY NOSTOPCOMMIT TABLEACCESS NOAPPLCOVR IBMCHECK
  000011 NOREORGALT
  000012 REORGONLINE DYNREORG REORGALL REORGREF
  000013 IBMREBUILD
  000014 SYNCPOINT 10
  000015 NOROLEOWN
  000016 STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY
  000017 IBMCOPY
  000018 SPANNEDRECS
  000019 NOBINDONIX
  000020 MAXSYSUT 20
  000021 DYNCOPY
  000022 NOPARTCOPY
  000023 COPYDDN(COPY01   )
  000024 NOUTILCOPY
  000025 NOPARALLEL CLONEDATA
  000026 NOREGENIDENTITY
  ****** **************************** Bottom of Data ****************************
3. Press F8 to scroll down the input. Press END.
4. Press Enter to run Analysis.The results of Analysis are a diagnostic output file (ALUPRINT) and a worklist.
5. To review the results of Analysis (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 RDACRJ   T0254246 DSID   113 LINE 0       COLUMNS 02- 81
  COMMAND INPUT ===>                                            SCROLL ===> CSR
  ********************************* TOP OF DATA **********************************
  SSID DELT
  WORKID RDACRJ.RCB0831E
  SORTDEVT SYSDA
  INCLUDE (DATA AMS SQL REBIND )
  SMSINCLUDE ()
  IBMUNLOAD IBMLOAD NOUSENGTUL
  IBMREORG NOUSENGTR
  NODBRMLIB ORDERBY
  NOVVALPROP
  UNLOADEMPTY NOSTOPCOMMIT TABLEACCESS NOAPPLCOVR IBMCHECK
  NOREORGALT
  REORGONLINE DYNREORG REORGALL REORGREF
  IBMREBUILD
  SYNCPOINT 10
  NOROLEOWN
  STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY
  IBMCOPY
  SPANNEDRECS
  NOBINDONIX
  MAXSYSUT 20
  DYNCOPY
  NOPARTCOPY
  COPYDDN(COPY01   )
  NOUTILCOPY
  NOPARALLEL CLONEDATA
  NOREGENIDENTITY
  *BMC396243I DB2 VERSION 12 NFM
  *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V12R1M504
  *BMC56464I DB2 CATALOG LEVEL IS V12R1M503
  *BMC56464I APPLCOMPAT IS V12R1M504
  *BMC56464I APPLCOMPAT FROM DSNZPARM IS V12R1M504
  *** BMC AMI Change Manager for Db2 12.01.01 PTFs applied:
  *** NONE
  *** EXECUTION (AEX) 12.01.01 PTFs applied:
  *** NONE
  ***********************************************************************
  *** WORKLIST GENERATION 2020-08-31-15.24.34.844186
  *** BMC AMI Change Manager for Db2 VERSION 12.01.01(10/15/2020)
  *** CURRENT SPE LEVEL SPE2010 (BQU2829)
  WORKLIST GENERATION EXECUTION FOR WORKID RDACRJ.RCB0831E ON SSID DELT
  ***********************************************************************
  ***********************************************************************
  *** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
  ***********************************************************************
  *BMC396243I DB2 VERSION 12 NFM
  *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>
  *BMC396469W THE FOLLOWING UTILITIES ARE NOT SUPPORTED AT FUNCTION
  *           LEVEL V12R1M504 OR GREATER ON A COMPRESSED OBJECT USING
  *           HUFFMAN.
  *            BMC UNLOAD PLUS / BMC LOADPLUS / BMC REORG PLUS
  *           THE ANALYSIS PROCESS DOES NOT PREVENT INCLUDING THESE
  *           UTILITIES IN THE WORKLIST.
  *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.
  ***********************************************************************
  *** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  ***********************************************************************
  WORKLIST WAS WRITTEN TO DATASET 'ACM.DB2V12.V121.WLBASE01(RCB0831E)'
  WORKLIST GENERATION COMPLETE WORKID RDACRJ.RCB0831E
  ******************************** 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 expand worklist...
  
  ISREDDE2   ACM.DB2V12.V121.WLBASE01(RCB0831E) - 01.00      Columns 00001 00072
  Command ===>                                                  Scroll ===> CSR
  ****** ***************************** Top of Data ******************************
  000001 ***********************************************************************
  000002 *** BMC AMI Change Manager for Db2 VERSION 12.01.01(10/15/2020)
  000003 *** CURRENT SPE LEVEL SPE2010 (BQU2829)
  000004 ***********************************************************************
  000005 *** BMC AMI Change Manager for Db2 12.01.01 PTFs applied:
  000006 *** NONE
  000007 *** EXECUTION (AEX) 12.01.01 PTFs applied:
  000008 *** NONE
  000009 ***********************************************************************
  000010 * ALUIN PARMS:                                                        *
  000011 * SSID DELT                                                           *
  000012 * WORKID RDACRJ.RCB0831E                                              *
  000013 * SORTDEVT SYSDA                                                      *
  000014 * INCLUDE (DATA AMS SQL REBIND )                                      *
  000015 * SMSINCLUDE ()                                                       *
  000016 * IBMUNLOAD IBMLOAD NOUSENGTUL                                        *
  000017 * IBMREORG NOUSENGTR                                                  *
  000018 * NODBRMLIB ORDERBY                                                   *
  000019 * NOVVALPROP                                                          *
  000020 * UNLOADEMPTY NOSTOPCOMMIT TABLEACCESS NOAPPLCOVR IBMCHECK            *
  000021 * NOREORGALT                                                          *
  000022 * REORGONLINE DYNREORG REORGALL REORGREF                              *
  000023 * IBMREBUILD                                                          *
  000024 * SYNCPOINT 10                                                        *
  000025 * NOROLEOWN                                                           *
  000026 * STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY            *
  000027 * IBMCOPY                                                             *
  000028 * SPANNEDRECS                                                         *
  000029 * NOBINDONIX                                                          *
  000030 * MAXSYSUT 20                                                         *
  000031 * DYNCOPY                                                             *
  000032 * NOPARTCOPY                                                          *
  000033 * COPYDDN(COPY01   )                                                  *
  000034 * NOUTILCOPY                                                          *
  000035 * NOPARALLEL CLONEDATA                                                *
  000036 * NOREGENIDENTITY                                                     *
  000037 ***********************************************************************
  000038 -TIME 000050 '2020-08-31-15.24.34.844186'
  000039 -SSID 000100 DELT
  000040 -WKID 000150 RDACRJ.RCB0831E
  000041 -CENV 000200
  000042              DDL_MATERIALIZATION      ALWAYS_IMMEDIATE
  000043 -SYNC 000250 END OF CHECK ENVIRONMENT SECTION
  000044 ***********************************************************************
  000045 ***********************************************************************
  000046 *** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
  000047 ***********************************************************************
  000048 *BMC396243I DB2 VERSION 12 NFM
  000049 *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V12R1M504
  000050 *BMC56464I DB2 CATALOG LEVEL IS V12R1M503
  000051 *BMC56464I APPLCOMPAT IS V12R1M504
  000052 *BMC56464I APPLCOMPAT FROM DSNZPARM IS V12R1M504
  000053 *BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
  000054 *           ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
  000055 *            PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
  000056 *            PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
  000057 *BMC396469W THE FOLLOWING UTILITIES ARE NOT SUPPORTED AT FUNCTION
  000058 *           LEVEL V12R1M504 OR GREATER ON A COMPRESSED OBJECT USING
  000059 *           HUFFMAN.
  000060 *            BMC UNLOAD PLUS / BMC LOADPLUS / BMC REORG PLUS
  000061 *           THE ANALYSIS PROCESS DOES NOT PREVENT INCLUDING THESE
  000062 *           UTILITIES IN THE WORKLIST.
  000063 *BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
  000064 *BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
  000065 *           ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
  000066 *           KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
  000067 ***********************************************************************
  000068 *** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  000069 ***********************************************************************
  000070 -SYNC 000300 START OF EXECUTION SYNCPOINT
  000071 ***********************************************************************
  000072 -SQL 000350 ALTER TABLE R1BAS504.T_T05APBR
  000073              ALTER COLUMN COLC_1
  000074              SET DATA TYPE CHAR(70)
  000075
  000076 -SYNC 000400 END OF ALTER TABLE SECTION
  000077 ***********************************************************************
  000078 -REOR 000450
  000079   TEMPLATE SYRC
  000080       DSN 'RDACRJ.DELT.RCB0831E.SR000001'
  000081       UNIT SYSDA
  000082
  000083   TEMPLATE SYDS
  000084       DSN 'RDACRJ.RCB0831E.SD000001'
  000085       UNIT SYSDA
  000086
  000087   TEMPLATE SYPU
  000088       DSN 'RDACRJ.RCB0831E.STEP1.SP000001'
  000089       UNIT SYSDA
  000090
  000091   TEMPLATE DCPYLOCP
  000092       DSN 'RDACRJ.RCB0831E.T05APBR.P000.LP000001'
  000093       UNIT SYSDA
  000094
  000095              REORG TABLESPACE R1BAS504.T05APBR
  000096              UNLDDN SYRC
  000097                     COPYDDN (DCPYLOCP)
  000098              SORTKEYS
  000099              SORTNUM 32
  000100              SORTDEVT SYSDA
  000101              SORTDATA LOG NO
  000102              SHRLEVEL CHANGE
  000103              MAXRO 0
  000104              MAPPINGTABLE RDAJZB.JZBTBMAP
  000105
  000106 -SYNC 000500 REORG OF TABLESPACE R1BAS504.T05APBR COMPLETE
  000107 -SYNC 000550 END OF REORG TABLESPACE SECTION
  000108 ***********************************************************************
  000109 -RNST 000600
  000110                RUNSTATS TABLESPACE R1BAS504.T05APBR
  000111                         HISTORY NONE
  000112                         INDEX (ALL)
  000113                         TABLE ALL
  000114
  000115 -SYNC 000650 STATS FOR TS R1BAS504.T05APBR COMPLETE
  000116 -SYNC 000700 END OF TABLESPACE STATISTICS SECTION
  000117 ***********************************************************************
  ****** **************************** Bottom of Data ****************************
6. Press END.The Execution JCL Build Interface panel is displayed.
  ACMFEXC0 ------------------ Execution JCL Build Interface ---------------------
  Command ===>
  
  WORKID . . . . . : RDACRJ.RCB0831E
  
  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
Execute the changes that you specified and analyzed.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.RCB0831E
  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.RCB0831E
  
  Specify Dataset Names.
    Execution JCL . . 'ACM.DB2V12.V121.EXECJCL(RCB0831E)'
    Worklist . . . . . 'ACM.DB2V12.V121.WLBASE01(RCB0831E)'
    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
  S 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 the data set name for the Execution JCL, accept the defaults for the JCL build options, and type S to select the 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.
  
  Click here to expand Execution JCL...
  
  ISREDDE2   ACM.DB2V12.V121.EXECJCL(RCB0831D) - 01.00       Columns 00001 00072
  Command ===>                                                  Scroll ===> CSR
  ****** ***************************** Top of Data ******************************
  000001 //RDACRJE JOB (5715),'EXECUTE-RCB0831E',
  000002 // class="A",MSGCLASS=X,MSGLEVEL=(1,1),
  000003 // NOTIFY=RDACRJ
  000004 /*ROUTE XEQ BMCPLX1
  000005 /*JOBPARM SYSAFF=DB2A
  000006 //***************************************************
  000007 //* CREATED BY : RDACRJ
  000008 //* TIMESTAMP : 08/31/2020.13.19.04
  000009 //* ENVIRONMENT: ISPF 7.3MVS     TSO
  000010 //* RELEASE    : V12.01.01 12/08/2016
  000011 //* DB2 VERSION: 12015
  000012 //***************************************************
  000013 //*--------------------------------------------------------------------
  000014 //*        EXECUTION for BMC AMI Change Manager for Db2
  000015 //*--------------------------------------------------------------------
  000016 //STEP1 EXEC PGM=AEXEMAIN,
  000017 //     REGION=0M,MEMLIMIT=NOLIMIT,PARM='DMCBQELT',
  000018 //     COND=(4,LT)
  000019 //STEPLIB DD DSN=CSG.DELT.DSNEXIT,DISP=SHR
  000020 //        DD DSN=CSGI.DB2V12M.DSNLOAD,DISP=SHR
  000021 //* ****************************************************************
  000022 //ABNLIGNR DD DUMMY
  000023 //SYSUDUMP DD SYSOUT=*
  000024 //********************************************************
  000025 //**** SAMPLE SYSMDUMP JCL ********
  000026 //**** PLEASE REPLACE THE DSN AND UNIT WITH ONES THAT FITS
  000027 //**** YOUR SHOP STANDARDS AND UNCOMMENT THE JCL
  000028 //*SYSMDUMP DD DSN=CUSTOMER.SYSMDUMP,DISP=(,CATLG,CATLG),UNIT=XXXXXXX,
  000029 //* SPACE=(CYL,(200,50),RLSE),
  000030 //* DCB=(DSORG=PS,RECFM=FBS,LRECL=4160,BLKSIZE=24960)
  000031 //********************************************************
  000032 //SYSTERM DD SYSOUT=*
  000033 //ASUSRPRT DD SYSOUT=*
  000034 //*--------------------------------------------------------------------
  000035 //* STATISTICS WORK DD STATEMENTS
  000036 //*--------------------------------------------------------------------
  000037 //STPRIN01 DD SYSOUT=*
  000038 //UTPRINT DD SYSOUT=*
  000039 //RNPRIN01 DD SYSOUT=*
  000040 //DDLOUT   DD SYSOUT=*
  000041 //SYSOUT   DD SYSOUT=*
  000042 //AJXERR   DD SYSOUT=*
  000043 //AEXIN    DD *
  000044   ACM
  000045   SSID DELT WORKID RDACRJ.RCB0831E
  000046   DYNWORKUNIT SYSDA
  000047   DASDDOPT DSC1SDOP
  000048   CATDOPT DC112DOP
  000049   STOPWAIT 3
  000050   STOPWTSECS 10
  000051   LOCK EXCLUSIVE
  000052 //SYSIN    DD SPACE=(CYL,(15,15)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000053 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000054 //SYSTSIN DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000055 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000056 //SYSPRINT DD SPACE=(CYL,(15,15)),UNIT=SYSDA,
  000057 //            DISP=(NEW,DELETE)
  000058 //SYSTSPRT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000059 //            DSORG=PS,LRECL=137,BLKSIZE=4096,RECFM=VBA
  000060 //ALUIN    DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000061 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000062 //ALUPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
  000063 //AJXPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
  000064 //*** RUNTIME ENABLEMENT CHOSEN
  000065 //SYSPROC DD DSN=AEX.QA1211.BMCCLIB,DISP=SHR
  000066 //ISPMLIB DD DSN=AEX.QA1211.BMCMLIB,DISP=SHR
  000067 //ISPSLIB DD DSN=AEX.QA1211.BMCSLIB,DISP=SHR
  000068 //ISPTLIB DD DSN=AEX.QA1211.BMCTLIB,DISP=SHR
  000069 //ISPPLIB DD DSN=AEX.QA1211.BMCPLIB,DISP=SHR
  000070 //AEXPRINT DD SYSOUT=*
  000071 //WORKLIST DD DISP=SHR,
  000072 //   DSN=ACM.DB2V12.V121.WLBASE01(RCB0831E)
  000073 //*-----------------------------------------
  000074 //*--------------------------------------------------------------------
  000075 //* UTILITY INPUT DD STATEMENTS
  000076 //*--------------------------------------------------------------------
  000077 //SYSIDCIN DD DUMMY
  000078 //*--------------------------------------------------------------------
  000079 //* END OF JOBSTEP
  000080 //*--------------------------------------------------------------------
  000081 //*--------------------------------------------------------------------
  000082 //* END OF JOB
  000083 //*--------------------------------------------------------------------
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 process your changes.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 last message in the diagnostic output indicates that the work ID status is complete and that the worklist completed successfully. The worklist implemented the structure changes that you specified.
  
  Click here to expand Execution results...
  
  SDSF OUTPUT DISPLAY RDACRJE J0261182 DSID   111 LINE 0       COLUMNS 02- 81
  COMMAND INPUT ===>                                            SCROLL ===> CSR
  ********************************* TOP OF DATA **************************************************************************************
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.28.56 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   1
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0BMC706707I PTFS:
  
  BMC16815I PARAMETERS:   ACM
  BMC16815I PARAMETERS:   SSID DELT WORKID RDACRJ.RCB0831E
  BMC16815I PARAMETERS:   DYNWORKUNIT SYSDA
  BMC16815I PARAMETERS:   DASDDOPT DSC1SDOP
  BMC16815I PARAMETERS:   CATDOPT DC112DOP
  BMC16815I PARAMETERS:   STOPWAIT 3
  BMC16815I PARAMETERS:   STOPWTSECS 10
  BMC16815I PARAMETERS:   LOCK EXCLUSIVE
  BMC16992I USING 'DSC1SDOP' AS OPTIONS FOR DASD MANAGER UTILITIES
  BMC16943I USING 'DMCBQELT' FOR RUN OPTIONS
  BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
  BMC16979I WORKLIST DSNAME IS 'ACM.DB2V12.V121.WLBASE01(RCB0831E)'
  BMC706708I DB2 RELEASE: 1215 MODE: NEW FUNCTION
  BMC70925I CURRENT FUNCTION LEVEL V12R1M504 CATALOG LEVEL           V12R1M503
  BMC70926I HIGHEST ACTIVATED LEVEL V12R1M504 PREVIOUS FUNCTION LEVEL V12R1M503
  BMC16806I PARAMETERS ACCEPTED, BEGINNING EXECUTION VERSION V12.01.01 SPE2010 07/21/2020 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 RDACRJ.RCB0831E IS 'N' (NOT STARTED
  BMC16999I UPDATED WORKID STATUS FOR RDACRJ.RCB0831E IS 'S' (STARTED)
  0:***********************************************************************
  0:*** BMC AMI Change Manager for Db2 VERSION 12.01.01(10/15/2020)
  0:*** CURRENT SPE LEVEL SPE2010 (BQU2829)
  0:***********************************************************************
  0:*** BMC AMI Change Manager for Db2 12.01.01 PTFs applied:
  0:*** NONE
  0:*** EXECUTION (AEX) 12.01.01 PTFs applied:
  0:*** NONE
  0:***********************************************************************
  0:* ALUIN PARMS:                                                        *
  0:* SSID DELT                                                           *
  0:* WORKID RDACRJ.RCB0831E                                              *
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.28.59 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   2
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:* SORTDEVT SYSDA                                                      *
  0:* INCLUDE (DATA AMS SQL REBIND )                                      *
  0:* SMSINCLUDE ()                                                       *
  0:* IBMUNLOAD IBMLOAD NOUSENGTUL                                        *
  0:* IBMREORG NOUSENGTR                                                  *
  0:* NODBRMLIB ORDERBY                                                   *
  0:* NOVVALPROP                                                          *
  0:* UNLOADEMPTY NOSTOPCOMMIT TABLEACCESS NOAPPLCOVR IBMCHECK            *
  0:* NOREORGALT                                                          *
  0:* REORGONLINE DYNREORG REORGALL REORGREF                              *
  0:* IBMREBUILD                                                          *
  0:* SYNCPOINT 10                                                        *
  0:* NOROLEOWN                                                           *
  0:* STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY            *
  0:* IBMCOPY                                                             *
  0:* SPANNEDRECS                                                         *
  0:* NOBINDONIX                                                          *
  0:* MAXSYSUT 20                                                         *
  0:* DYNCOPY                                                             *
  0:* NOPARTCOPY                                                          *
  0:* COPYDDN(COPY01   )                                                  *
  0:* NOUTILCOPY                                                          *
  0:* NOPARALLEL CLONEDATA                                                *
  0:* NOREGENIDENTITY                                                     *
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.28.59 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   3
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:-TIME 000050 '2020-08-31-15.24.34.844186'                               91786270
  0:-SSID 000100 DELT                                                       10078611
  0:-WKID 000150 RDACRJ.RCB0831E                                            44099483
  0:-CENV 000200
  :             DDL_MATERIALIZATION      ALWAYS_IMMEDIATE                  83569795
  BMC16815I PARAMETERS: DMCBQELT,DELT
  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: 12.01.01                       ***
  ***              Current SPE level: SPE2010 (BQU2829)              ***
  **********************************************************************
  BMC396397I CHECK ENVIRONMENT ROUTINE STARTED - 08/31/2020 15:29:02
  ** ALUIN:              DDL_MATERIALIZATION      ALWAYS_IMMEDIATE
  BMC56301I KEYWORDS ACCEPTED
  
  BMC56723I CONNECTING TO SSID 'DELT' USING PLAN 'ACMCBQXM'
  BMC56464I INITIAL Db2 ATTACH SUCCESSFUL. SSID(4)=DELT.
  BMC56464I Db2 PLAN 'ACMCBQXM' USED FOR THIS TASK. RC=0
  BMC56464I Db2 CONNECTED. VERSION 12 IN NEW FUNCTION MODE
  BMC56464I Db2 CURRENT FUNCTION LEVEL IS V12R1M504
  BMC56464I Db2 CATALOG LEVEL IS V12R1M503
  BMC56464I APPLCOMPAT IS V12R1M504
  BMC56724I CONNECTION COMPLETED WITH SQLCODE 0, ERR 0, RC 0
  BMC396480I ZPARM SPECIFIED IN DOPTS DMCBQELT IS DSNZPARM
  BMC396400I CHECK ENVIRONMENT ROUTINE SUCCESSFUL RC=0
  0:-SYNC 000250 END OF CHECK ENVIRONMENT SECTION                           49691848
  0:***********************************************************************
  0:***********************************************************************
  0:*** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
  0:***********************************************************************
  0:*BMC396243I DB2 VERSION 12 NFM
  0:*BMC56464I DB2 CURRENT FUNCTION LEVEL IS V12R1M504
  0:*BMC56464I DB2 CATALOG LEVEL IS V12R1M503
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.29.04 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   4
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:*BMC56464I APPLCOMPAT IS V12R1M504
  0:*BMC56464I APPLCOMPAT FROM DSNZPARM IS V12R1M504
  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:*BMC396469W THE FOLLOWING UTILITIES ARE NOT SUPPORTED AT FUNCTION
  0:*           LEVEL V12R1M504 OR GREATER ON A COMPRESSED OBJECT USING
  0:*           HUFFMAN.
  0:*            BMC UNLOAD PLUS / BMC LOADPLUS / BMC REORG PLUS
  0:*           THE ANALYSIS PROCESS DOES NOT PREVENT INCLUDING THESE
  0:*           UTILITIES IN THE WORKLIST.
  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:***********************************************************************
  0:*** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  0:***********************************************************************
  0:-SYNC 000300 START OF EXECUTION SYNCPOINT                               36653151
  0:***********************************************************************
  0:-SQL 000350 ALTER TABLE R1BAS504.T_T05APBR
  :             ALTER COLUMN COLC_1
  :             SET DATA TYPE CHAR(70)
  :                                                                        85784720
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SYNC 000400 END OF ALTER TABLE SECTION                                 25260307
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.29.04 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   5
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:***********************************************************************
  0:-REOR 000450
  : TEMPLATE SYRC
  :      DSN 'RDACRJ.DELT.RCB0831E.SR000001'
  :      UNIT SYSDA
  :
  : TEMPLATE SYDS
  :      DSN 'RDACRJ.RCB0831E.SD000001'
  :      UNIT SYSDA
  :
  : TEMPLATE SYPU
  :      DSN 'RDACRJ.RCB0831E.STEP1.SP000001'
  :      UNIT SYSDA
  :
  : TEMPLATE DCPYLOCP
  :      DSN 'RDACRJ.RCB0831E.T05APBR.P000.LP000001'
  :      UNIT SYSDA
  :
  :             REORG TABLESPACE R1BAS504.T05APBR
  :             UNLDDN SYRC
  :                    COPYDDN (DCPYLOCP)
  :             SORTKEYS
  :             SORTNUM 32
  :             SORTDEVT SYSDA
  :             SORTDATA LOG NO
  :             SHRLEVEL CHANGE
  :             MAXRO 0
  :             MAPPINGTABLE RDAJZB.JZBTBMAP
  :                                                                        98447758
  BMC16815I PARAMETERS: DELT,RCB0831EXXXX
  BMC16822I CONTROL PASSED TO 'DSNUTILB'
  BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
  BMC16898I DEBUG: DSNUTILB 0
  
  0DSNU000I    244 15:29:05.67 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831EXXXX
  DSNU1044I   244 15:29:05.91 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
  0DSNU050I    244 15:29:05.93 DSNUGUTC - TEMPLATE SYRC DSN 'RDACRJ.DELT.RCB0831E.SR000001' UNIT SYSDA
  DSNU1035I   244 15:29:05.94 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
  0DSNU050I    244 15:29:05.95 DSNUGUTC - TEMPLATE SYDS DSN 'RDACRJ.RCB0831E.SD000001' UNIT SYSDA
  DSNU1035I   244 15:29:06.03 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
  0DSNU050I    244 15:29:06.12 DSNUGUTC - TEMPLATE SYPU DSN 'RDACRJ.RCB0831E.STEP1.SP000001' UNIT SYSDA
  DSNU1035I   244 15:29:06.14 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
  0DSNU050I    244 15:29:06.16 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.RCB0831E.T05APBR.P000.LP000001' 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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.29.41 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   6
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  DSNU1035I   244 15:29:06.18 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
  0DSNU050I    244 15:29:06.20 DSNUGUTC - REORG TABLESPACE R1BAS504.T05APBR UNLDDN SYRC COPYDDN(DCPYLOCP) SORTKEYS
  SORTNUM 32 SORTDEVT SYSDA SORTDATA LOG NO SHRLEVEL CHANGE MAXRO 0 MAPPINGTABLE RDAJZB.JZBTBMAP
  DSNU2900I *DELT 244 15:29:06.33 DSNURMAP - MAPPING TABLE IS SPECIFIED WITH A NON-EXPANDED LRSN COLUMN
  DSNU2901I *DELT 244 15:29:11.23 DSNURMAP - MAPPING TABLE RDACRJ.RTD2FB74_MAPTABLE_RCB0831EXXXX_0000
               AND MAPPING INDEX RDACRJ.IXD2FB74_MAPINDEX_RCB0831EXXXX_0000
               CREATED IN JFLDBMAP.RMD2FB74
  DSNU1038I   244 15:29:12.04 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
                          DDNAME=SYS00008
                          DSN=RDACRJ.RCB0831E.T05APBR.P000.LP000001
  DSNU3345I   244 15:29:12.42 DSNURPCT - MAXIMUM UTILITY PARALLELISM IS 12 BASED ON NUMBER OF PARTITIONS AND INDEXES
  DSNU2904I   244 15:29:12.53 DSNURPCT - DATA RECORDS WILL BE UNLOADED VIA TABLE SPACE SCAN
  DSNU1160I   244 15:29:12.53 DSNURPRD - PARTITIONS WILL BE UNLOADED/RELOADED IN PARALLEL, NUMBER OF TASKS = 4
  DSNU395I    244 15:29:12.54 DSNURPRD - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 8
  DSNU251I *DELT 244 15:29:22.37 DSNURPUT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLESPACE
  R1BAS504.T05APBR PART 1
  DSNU251I *DELT 244 15:29:22.37 DSNURPUT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
  R1BAS504.T05APBR PART 2
  DSNU251I *DELT 244 15:29:22.37 DSNURPUT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
  R1BAS504.T05APBR PART 3
  DSNU251I *DELT 244 15:29:22.37 DSNURPUT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
  R1BAS504.T05APBR PART 4
  DSNU252I *DELT 244 15:29:22.37 DSNURPUT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLESPACE
  R1BAS504.T05APBR
  DSNU250I    244 15:29:22.37 DSNURPRD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:09
  DSNU3350I   244 15:29:27.72 DSNUGSRT - SORT TASK DA02: 0 RECORDS SORTED, ESTIMATED 0, VARIATION -1 PERCENT
  DSNU3352I   244 15:29:27.78 DSNUGSRT - SORT TASK DA02: USED DFSORT
  DSNU3354I   244 15:29:27.78 DSNUGSRT - SORT TASK DA02: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:27.72 DSNUGSRT - SORT TASK DA01: 0 RECORDS SORTED, ESTIMATED 0, VARIATION -1 PERCENT
  DSNU3352I   244 15:29:27.83 DSNUGSRT - SORT TASK DA01: USED DFSORT
  DSNU3354I   244 15:29:27.83 DSNUGSRT - SORT TASK DA01: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:27.72 DSNUGSRT - SORT TASK DA03: 0 RECORDS SORTED, ESTIMATED 0, VARIATION -1 PERCENT
  DSNU3352I   244 15:29:27.92 DSNUGSRT - SORT TASK DA03: USED DFSORT
  DSNU3354I   244 15:29:27.92 DSNUGSRT - SORT TASK DA03: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:31.56 DSNUGSRT - SORT TASK DA04: 1 RECORDS SORTED, ESTIMATED 1, VARIATION 0 PERCENT
  DSNU3351I   244 15:29:31.61 DSNUGSRT - SORT TASK DA04: AVERAGE RECORD LENGTH PROCESSED 383, ESTIMATED 363, VARIATION 6
  PERCENT
  DSNU3352I   244 15:29:31.61 DSNUGSRT - SORT TASK DA04: USED DFSORT
  DSNU3354I   244 15:29:31.61 DSNUGSRT - SORT TASK DA04: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU303I *DELT 244 15:29:31.68 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1 FOR TABLE R1BAS504.T_T05APBR
  PART=1
  DSNU303I *DELT 244 15:29:31.68 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE R1BAS504.T_T05APBR
  PART=2
  DSNU303I *DELT 244 15:29:31.68 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE R1BAS504.T_T05APBR
  PART=3
  DSNU303I *DELT 244 15:29:31.68 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE R1BAS504.T_T05APBR
  PART=4
  DSNU304I *DELT 244 15:29:31.68 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1 FOR TABLE R1BAS504.T_T05APBR
  DSNU302I    244 15:29:31.72 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.29.41 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   7
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  DSNU300I    244 15:29:31.72 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:09
  DSNU394I *DELT 244 15:29:31.81 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX
  RDACRJ.IXD2FB74_MAPINDEX_RCB0831EXXXX_0000
  DSNU393I *DELT 244 15:29:31.81 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX
  R1BAS504.I_T05APBR_PARTITIONED PART 1
  DSNU394I *DELT 244 15:29:31.81 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX R1BAS504.I_T05APBR2
  DSNU393I *DELT 244 15:29:31.82 DSNURBXA - SORTBLD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX
  R1BAS504.I_T05APBR_PARTITIONING PART 1
  DSNU3350I   244 15:29:33.90 DSNUGSRP - SORT TASK SW04: 1 RECORDS SORTED, ESTIMATED 1, VARIATION 0 PERCENT
  DSNU3352I   244 15:29:34.13 DSNUGSRP - SORT TASK SW04: USED DFSORT
  DSNU3354I   244 15:29:34.13 DSNUGSRP - SORT TASK SW04: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:33.90 DSNUGSRP - SORT TASK SW01: 1 RECORDS SORTED, ESTIMATED 1, VARIATION 0 PERCENT
  DSNU3352I   244 15:29:34.22 DSNUGSRP - SORT TASK SW01: USED DFSORT
  DSNU3354I   244 15:29:34.22 DSNUGSRP - SORT TASK SW01: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:33.90 DSNUGSRP - SORT TASK SW03: 1 RECORDS SORTED, ESTIMATED 1, VARIATION 0 PERCENT
  DSNU3352I   244 15:29:34.36 DSNUGSRP - SORT TASK SW03: USED DFSORT
  DSNU3354I   244 15:29:34.36 DSNUGSRP - SORT TASK SW03: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU3350I   244 15:29:33.90 DSNUGSRP - SORT TASK SW02: 1 RECORDS SORTED, ESTIMATED 1, VARIATION 0 PERCENT
  DSNU3352I   244 15:29:34.56 DSNUGSRP - SORT TASK SW02: USED DFSORT
  DSNU3354I   244 15:29:34.56 DSNUGSRP - SORT TASK SW02: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
  DSNU391I    244 15:29:34.87 DSNURPTB - SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 4
  DSNU392I    244 15:29:34.87 DSNURPTB - SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:00:03
  DSNU1162I   244 15:29:34.87 DSNURLGD - LOG APPLIES WILL BE PERFORMED IN PARALLEL, NUMBER OF TASKS = 4
  DSNU1138I *DELT 244 15:29:36.06 DSNURLOG - DRAIN ALL WITH START TIME 2020-08-31-15.29.36.048649 HAS COMPLETED
  SUCCESSFULLY
  DSNU1139I   244 15:29:36.39 DSNURLGD - FINAL LOG ITERATION STATISTICS. NUMBER OF LOG RECORDS = 0
  DSNU386I    244 15:29:36.39 DSNURLGD - LOG PHASE STATISTICS. NUMBER OF ITERATIONS = 2, NUMBER OF LOG RECORDS = 0
  DSNU385I    244 15:29:36.39 DSNURLGD - LOG PHASE COMPLETE, ELAPSED TIME = 00:00:01
  DSNU400I    244 15:29:36.62 DSNURBID - COPY PROCESSED FOR TABLESPACE R1BAS504.T05APBR
                         NUMBER OF PAGES=21
                         AVERAGE PERCENT FREE SPACE PER PAGE = 4.71
                         PERCENT OF CHANGED PAGES =100.00
                         ELAPSED TIME=00:00:24
  DSNU387I    244 15:29:37.24 DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:00:00
  DSNU428I    244 15:29:37.28 DSNURSWT - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1BAS504.T05APBR
  DSNU3357I   244 15:29:40.31 DSNUGUTC - MAXIMUM SORT AMOUNT ESTIMATION VARIATION WAS 6 PERCENT
  DSNU3355I   244 15:29:40.31 DSNUGUTC - TOTAL SORT MEMORY BELOW THE BAR: OPTIMAL 48 MB, USED 48 MB
  DSNU010I    244 15:29:40.52 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
  0:-SYNC 000500 REORG OF TABLESPACE R1BAS504.T05APBR COMPLETE              75904569
  0:-SYNC 000550 END OF REORG TABLESPACE SECTION                            86265283
  0:***********************************************************************
  0:-RNST 000600
  :               RUNSTATS TABLESPACE R1BAS504.T05APBR
  :                        HISTORY NONE
  :                        INDEX (ALL)
  :                        TABLE ALL
  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: V12.01.01
                                                   (C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
  
  2020-08-31 15.29.42 ON SYSID DB2A                      WORKLIST EXECUTION LOG                                               PAGE   8
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  :                                                                        55419682
  BMC16815I PARAMETERS: DELT,RCB0831E
  BMC16822I CONTROL PASSED TO 'DSNUTILB'
  BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
  BMC16898I DEBUG: DSNUTILB 0
  
  0DSNU000I    244 15:29:43.08 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831E
  DSNU1044I   244 15:29:43.20 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
  0DSNU050I    244 15:29:43.23 DSNUGUTC - RUNSTATS TABLESPACE R1BAS504.T05APBR HISTORY NONE INDEX(ALL) TABLE ALL
  DSNU610I *DELT 244 15:29:45.53 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1BAS504.T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.54 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR R1BAS504.T_T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.62 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR R1BAS504.T_T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.63 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR R1BAS504.T_T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.71 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR R1BAS504.T_T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.71 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1BAS504.T05APBR SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.90 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.91 DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.91 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:45.91 DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING
  SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.08 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.08 DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.08 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.09 DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.10 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR R1BAS504.I_T05APBR2 SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.11 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR R1BAS504.I_T05APBR2 SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR R1BAS504.I_T05APBR2 SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.12 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONING SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.17 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR R1BAS504.I_T05APBR_PARTITIONED SUCCESSFUL
  DSNU610I *DELT 244 15:29:46.19 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR R1BAS504.I_T05APBR2 SUCCESSFUL
  DSNU620I *DELT 244 15:29:46.21 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2020-08-31-15.29.43.336339
  DSNU010I    244 15:29:46.35 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
  0:-SYNC 000650 STATS FOR TS R1BAS504.T05APBR COMPLETE                     65932730
  0:-SYNC 000700 END OF TABLESPACE STATISTICS SECTION                       58746183
  0:***********************************************************************
  BMC16999I UPDATED WORKID STATUS FOR RDACRJ.RCB0831E IS 'C' (COMPLETE)
  0BMC16833I END OF WORKLIST EXECUTION
7. Press END to return to the Create, Alter, or Drop DB2 Objects 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 changes to your data structures, perform an in-depth analysis of those changes to determine their effect on your subsystem, and execute SQL and utilities, while collecting statistics on your Db2 objects.

Creating, altering, or dropping Db2 objects

To modify objects

On this page