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.

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.

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.RD10405A
  
  
  
  
  
  
  
  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.RD10405A
  
  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.RD10405A                         _ Changed Objects List
  Specify the object type(s) to be included in a list.
  
  Stogroup. .                                                      (SG     Name)
  Database. . R1128C01                                             (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.RD10405A                             Commands: CANCEL
  
  Type action next to object and press Enter.
      E=Edit L=Like D=Drop U=Undo
                                                        Objects 92 to 113 of 227
                                                                    More:   - +
  Act     Object-Type    Objects
  ************************************ TOP **************************************
            TSG. . . . .   R1128C01   T128PBG
              TBB. . . .     R1128C01   T@T128PBG
                CK . . .       R1128C01   T@T128PBG            CK@T128PBG
                FK . . .       R1128C01   T@T128PBG            FK@T128PBG
                IXVD . .       R1128C01   I_DOCIDT@T128PBG
                IXC. . .       R1128C01   I@T128PBG1
                IXU. . .       R1128C01   I@T128PBG2
                  UCU. .         R1128C01   T@T128PBG            UC@T128PBG
                IXP. . .       R1128C01   I@T128PBG3
                  UCP. .         R1128C01   T@T128PBG            PK@T128PBG
                TRB. . .       R1128C01   TR@T128PBG
                VW . . .       R1128C01   V1@T128PBG
                VW . . .       R1128C01   V2@T128PBG
                VW . . .       R1128C01   V3@T128PBG
                VW . . .       R1128C01   V4@T128PBG
                VW . . .       R1128C01   V5@T128PBG
            TSR2 . . . .   R1128C01   T128PBR2
              TBBT . . .     R1128C01   T@T128PBR2
                CK . . .       R1128C01   T@T128PBR2           CK@T128PBR2
                FK . . .       R1128C01   T@T128PBR2           FK@T128PBR2
                IXVD . .       R1128C01   I_DOCIDT@T128PBR2
                IX . . .       R1128C01   I@T128PBR21
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.RD10405A
                                                 New Values
  TB Owner : R1128C01                         .
  TB Name : T@T128PBG                        .
  
  Database Name . : R1128C01              . . :
  Tablespace Name : T128PBG               . . :
  Audit . . . . . : NONE                  . . .           (NONE,ALL,CHANGES)
  Validproc . . . :                       . . .
  Editproc . . . :                       . . .
  With Row Attr . :                       . . .           (Y,N)
  Data Capture . : N                     . . .           (Y,N)
  Restrict Drop . : N                     . . .           (Y,N)
  Obid . . . . . : 163                   . . .
  Volatile . . . : N                     . . .           (N,Y)
  Append . . . . : N                     . . .           (N,Y)
  Label:                                  . . .
  Link History TB : N                     . . .           (N,Y,E)
  Link Archive TB : N                     . . .           (N,Y)
  Table Access . :                       . . .           (C,R,B,blank)
  CCSID . . . . . : EBCDIC     Partitions . . :    1 (Partition By Growth)
  Key Label . . . :                       . . .
  
  _ Convert to Partition by Range
  _ 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.RD10405A                             Commands: CANCEL
  
  Table Owner . . : R1128C01
  Table Name . . : T@T128PBG
  
  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 18 of 29
                                                                   More:     + >
  Act   Column Name ..+....20...+....30. Column Type          Length Nl Df Hi UDT
  *** ******************************** TOP **************************************
        + COLC@1@ONE@HUN<>@ONE@HUNDRED@1 CHAR                      1 N Y
        + COLVC@2@ONE@HU<>@ONE@HUNDRED@1 VARCHAR                  15 N Y
        + COLCL@3@ONE@HU<>@ONE@HUNDRED@1 CLOB                     1G Y Y
        + COLBIN@7@ONE@H<>@ONE@HUNDRED@1 BINARY                    4 N Y
        + COLVBI@8@ONE@H<>@ONE@HUNDRED@1 VARBIN                    5 N Y
        + COLBL@9@ONE@HU<>@ONE@HUNDRED@1 BLOB                     1G Y Y
        + COLSI@10@ONE@H<>@ONE@HUNDRED@1 SMALLINT                     N Y
        + COLIN@11@ONE@H<>@ONE@HUNDRED@1 INTEGER                      N Y
        + COLBI@12@ONE@H<>@ONE@HUNDRED@1 BIGINT                       N Y
        + COLDE@13@ONE@H<>@ONE@HUNDRED@1 DECIMAL                 5,2 N Y
        + COLNU@14@ONE@H<>@ONE@HUNDRED@1 DECIMAL                10,1 N Y
        + COLFL@15@ONE@H<>@ONE@HUNDRED@1 FLOAT                    53 N Y
        + COLRE@16@ONE@H<>@ONE@HUNDRED@1 FLOAT                    21 N Y
        + COLDB@17@ONE@H<>@ONE@HUNDRED@1 FLOAT                    53 N Y
        + COLDF@19@ONE@H<>@ONE@HUNDRED@1 DECFLOAT                 16 Y Y
        + COLDF@20@ONE@H<>@ONE@HUNDRED@1 DECFLOAT                 34 Y Y
        + COLDT@21@ONE@H<>@ONE@HUNDRED@1 DATE                         N Y
        + COLTI@22@ONE@H<>@ONE@HUNDRED@1 TIME                         N Y
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.RD10405A                             Commands: CANCEL
  
  Type action next to object and press Enter.
     E=Edit L=Like D=Drop U=Undo
                                                      Objects 133 to 154 of 227
                                                                   More:   - +
  Act     Object-Type    Objects
            TSG. . . . .   R1128C01   T128PBG
      *A      TBB. . . .     R1128C01   T@T128PBG
                CK . . .       R1128C01   T@T128PBG            CK@T128PBG
                FK . . .       R1128C01   T@T128PBG            FK@T128PBG
                IXVD . .       R1128C01   I_DOCIDT@T128PBG
                IXC. . .       R1128C01   I@T128PBG1
                IXU. . .       R1128C01   I@T128PBG2
                  UCU. .         R1128C01   T@T128PBG            UC@T128PBG
                IXP. . .       R1128C01   I@T128PBG3
                  UCP. .         R1128C01   T@T128PBG            PK@T128PBG
                TRB. . .       R1128C01   TR@T128PBG
                VW . . .       R1128C01   V1@T128PBG
                VW . . .       R1128C01   V2@T128PBG
                VW . . .       R1128C01   V3@T128PBG
                VW . . .       R1128C01   V4@T128PBG
                VW . . .       R1128C01   V5@T128PBG
            TSR2 . . . .   R1128C01   T128PBR2
              TBBT . . .     R1128C01   T@T128PBR2
                CK . . .       R1128C01   T@T128PBR2           CK@T128PBR2
                FK . . .       R1128C01   T@T128PBR2           FK@T128PBR2
                IXVD . .       R1128C01   I_DOCIDT@T128PBR2
                IX . . .       R1128C01   I@T128PBR21
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.RD10405A
  
  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.
  Important
  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.RD10405A
  
  
  
  Specify Dataset Names
    Worklist . . . . . 'ACM.DB2V13.V131.WLBASE01(RD10405A)'
    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   SYS22095.T123911.RA000.RDACRJ.WLIN.H02          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 DEND
  000002 WORKID RDACRJ.RD10405A
  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 NODEFERCDC
  000017 STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY
  000018 IBMCOPY
  000019 SPANNEDRECS
  000020 NOBINDONIX
  000021 NOMOVETB
  000022 MAXSYSUT 20
  000023 DYNCOPY
  000024 NOPARTCOPY
  000025 COPYDDN(COPY01   )
  000026 NOUTILCOPY
  000027 NOPARALLEL CLONEDATA
  000028 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   T0397365 DSID   105 LINE 0       COLUMNS 02- 81
  COMMAND INPUT ===>                                            SCROLL ===> CSR
  ********************************* TOP OF DATA **********************************
  SSID DEND
  WORKID RDACRJ.RD10405A
  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
  NODEFERCDC
  STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY
  IBMCOPY
  SPANNEDRECS
  NOBINDONIX
  NOMOVETB
  MAXSYSUT 20
  DYNCOPY
  NOPARTCOPY
  COPYDDN(COPY01   )
  NOUTILCOPY
  NOPARALLEL CLONEDATA
  NOREGENIDENTITY
  *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-12.39.58.577614
  *** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)
  WORKLIST GENERATION EXECUTION FOR WORKID RDACRJ.RD10405A ON SSID DEND
  ***********************************************************************
  ***********************************************************************
  *** 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.
  BMC16058W WORKID DEM.D0221B HAS CHANGES FOR TB R1128C01.T@T128PBG
  ***********************************************************************
  *** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  ***********************************************************************
  WORKLIST WAS WRITTEN TO DATASET 'ACM.DB2V13.V131.WLBASE01(RD10405A)'
  WORKLIST GENERATION COMPLETE WORKID RDACRJ.RD10405A
  ******************************** 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.DB2V13.V131.WLBASE01(RD10405A) - 01.00      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.
  ==MSG> -CAUTION- Profile is set to STATS ON. Statistics did not exist for
  ==MSG>           this member, but will be generated if data is saved.
  000001 ***********************************************************************
  000002 *** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)
  000003 ***********************************************************************
  000004 *** BMC AMI Change Manager for Db2 13.01.00 BASE PTFs applied:
  000005 *** BQU3344
  000006 *** EXECUTION (AEX) 13.01.00 BASE PTFs applied:
  000007 *** NONE
  000008 ***********************************************************************
  000009 * ALUIN PARMS:                                                        *
  000010 * SSID DEND                                                           *
  000011 * WORKID RDACRJ.RD10405A                                              *
  000012 * SORTDEVT SYSDA                                                      *
  000013 * INCLUDE (DATA AMS SQL REBIND )                                      *
  000014 * SMSINCLUDE ()                                                       *
  000015 * IBMUNLOAD IBMLOAD NOUSENGTUL                                        *
  000016 * IBMREORG NOUSENGTR                                                  *
  000017 * NODBRMLIB ORDERBY                                                   *
  000018 * NOVVALPROP                                                          *
  000019 * UNLOADEMPTY NOSTOPCOMMIT TABLEACCESS NOAPPLCOVR IBMCHECK            *
  000020 * NOREORGALT                                                          *
  000021 * REORGONLINE DYNREORG REORGALL REORGREF                              *
  000022 * IBMREBUILD                                                          *
  000023 * SYNCPOINT 10                                                        *
  000024 * NOROLEOWN                                                           *
  000025 * NODEFERCDC                                                          *
  000026 * STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY            *
  000027 * IBMCOPY                                                             *
  000028 * SPANNEDRECS                                                         *
  000029 * NOBINDONIX                                                          *
  000030 * NOMOVETB                                                            *
  000031 * MAXSYSUT 20                                                         *
  000032 * DYNCOPY                                                             *
  000033 * NOPARTCOPY                                                          *
  000034 * COPYDDN(COPY01   )                                                  *
  000035 * NOUTILCOPY                                                          *
  000036 * NOPARALLEL CLONEDATA                                                *
  000037 * NOREGENIDENTITY                                                     *
  000038 ***********************************************************************
  000039 -TIME 000050 '2022-04-05-12.39.58.577614'
  000040 -SSID 000100 DEND
  000041 -WKID 000150 RDACRJ.RD10405A
  000042 -CENV 000200
  000043              DDL_MATERIALIZATION      ALWAYS_IMMEDIATE
  000044              TABLE_COL_NAME_EXPANSION ON
  000045 -SYNC 000250 END OF CHECK ENVIRONMENT SECTION
  000046 ***********************************************************************
  000047 ***********************************************************************
  000048 *** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY     ***
  000049 ***********************************************************************
  000050 *BMC396243I DB2 VERSION 13 IN NEW FUNCTION MODE
  000051 *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
  000052 *BMC56464I DB2 CATALOG LEVEL IS V13R1M501
  000053 *BMC56464I APPLCOMPAT IS V13R1M501
  000054 *BMC56464I APPLCOMPAT FROM DSNZPARM IS V13R1M501
  000055 *BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
  000056 *           ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
  000057 *            PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
  000058 *            PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
  000059 *BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
  000060 *BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
  000061 *           ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
  000062 *           KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
  000063 *** WORKID DEM.D0221B HAS CHANGES FOR TB R1128C01.T@T128PBG
  000064 ***********************************************************************
  000065 *** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  000066 ***********************************************************************
  000067 -SYNC 000300 START OF EXECUTION SYNCPOINT
  000068 ***********************************************************************
  000069 -SQL 000350 DROP TRIGGER    R1128C01.TR@T128PBG RESTRICT
  000070 -SYNC 000400 END OF DROP OBJECTS SECTION
  000071 ***********************************************************************
  000072 -SQL 000450 ALTER TABLE R1128C01.T@T128PBG
  000073              ALTER COLUMN COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ON
  000074 E@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ON
  000075 E@HUNDRED@1
  000076              SET DATA TYPE VARCHAR(30)
  000077
  000078 -SYNC 000500 END OF ALTER TABLE SECTION
  000079 ***********************************************************************
  000080 -SETS 000550 SET CURRENT SQLID = 'RDACRJ'
  000081 -SETP 000600 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
  000082 ,"SYSIBMADM"
  000083 -SQL 000650 CREATE TRIGGER R1128C01.TR@T128PBG
  000084                     AFTER
  000085                     UPDATE
  000086                    OF COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
  000087 HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
  000088 UNDRED@1
  000089                     ON R1128C01.T@T128PBG
  000090             REFERENCING NEW AS N@VAR
  000091                     FOR EACH ROW MODE DB2SQL
  000092    UPDATE R1128C01.T@T128PBG SET COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARA
  000093 CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
  000094 TERS@ONE@HUNDRED@1 = 60
  000095    WHERE COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
  000096 @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@1 =
  000097      '11.11.00'
  000098
  000099 -SETS 000700 SET CURRENT SQLID = USER
  000100 -SETP 000750 SET CURRENT PATH = SYSTEM PATH
  000101 -SYNC 000800 END OF TRIGGER SECTION
  000102 ***********************************************************************
  000103 -REBD 000850
  000104 REBIND TRIGGER PACKAGE ( -
  000105 R1128C01.TR@T128PBG +
  000106 ) -
  000107              APREUSE(NONE)         -
  000108              BUSTIMESENSITIVE(YES) -
  000109              SYSTIMESENSITIVE(YES) -
  000110              ARCHIVESENSITIVE(YES) -
  000111              PLANMGMT(EXTENDED)    -
  000112              EXPLAIN(NO)
  000113
  000114 -SYNC 000900 END OF REBIND PLANS SECTION
  000115 ***********************************************************************
  ****** **************************** Bottom of Data ****************************
6. Press END.The Execution JCL Build Interface panel is displayed.
  ACMFEXC0 ------------------ Execution JCL Build Interface ---------------------
  Command ===>
  
  WORKID . . . . . : RDACRJ.RD10405A
  
  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.RD10405A
  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.RD10405A
  
  Specify Dataset Names.
    Execution JCL . . 'ACM.DB2V13.V131.EXECJCL(RD10405A)'
    Worklist . . . . . 'ACM.DB2V13.V131.WLBASE01(RD10405A)'
    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.DB2V13.V131.EXECJCL(RD10405A) - 01.00       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 //RDACRJE JOB (5715),'EXECUTE-RD10405A',
  000002 // CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),
  000003 // NOTIFY=RDACRJ
  000004 /*ROUTE XEQ BMCPLX1
  000005 /*JOBPARM SYSAFF=DB2B
  000006 //***************************************************
  000007 //* CREATED BY : RDACRJ
  000008 //* TIMESTAMP : 04/05/2022.12.50.16
  000009 //* ENVIRONMENT: ISPF 7.4MVS     TSO
  000010 //* RELEASE    : V13.01.00 05/31/2022
  000011 //* DB2 VERSION: 13015
  000012 //***************************************************
  000013 //*--------------------------------------------------------------------
  000014 //*        EXECUTION for BMC AMI Change Manager for Db2
  000015 //*--------------------------------------------------------------------
  000016 //STEP1 EXEC PGM=AEXEMAIN,
  000017 //     REGION=0M,MEMLIMIT=NOLIMIT,PARM='DMD1QEND',
  000018 //     COND=(4,LT)
  000019 //STEPLIB DD DSN=CSG.DEND.DSNEXIT,DISP=SHR
  000020 //        DD DSN=CSGI.DB2V13M.DSNLOAD,DISP=SHR
  . . .
  000048 //* ****************************************************************
  000049 //*
  000050 //ABNLIGNR DD DUMMY
  000051 //SYSUDUMP DD SYSOUT=*
  000052 //********************************************************
  000053 //**** SAMPLE SYSMDUMP JCL ********
  000054 //**** PLEASE REPLACE THE DSN AND UNIT WITH ONES THAT FITS
  000055 //**** YOUR SHOP STANDARDS AND UNCOMMENT THE JCL
  000056 //*SYSMDUMP DD DSN=CUSTOMER.SYSMDUMP,DISP=(,CATLG,CATLG),UNIT=XXXXXXX,
  000057 //* SPACE=(CYL,(200,50),RLSE),
  000058 //* DCB=(DSORG=PS,RECFM=FBS,LRECL=4160,BLKSIZE=24960)
  000059 //********************************************************
  000060 //SYSTERM DD SYSOUT=*
  000061 //ASUSRPRT DD SYSOUT=*
  000062 //*--------------------------------------------------------------------
  000063 //* STATISTICS WORK DD STATEMENTS
  000064 //*--------------------------------------------------------------------
  000065 //STPRIN01 DD SYSOUT=*
  000066 //UTPRINT DD SYSOUT=*
  000067 //RNPRIN01 DD SYSOUT=*
  000068 //DDLOUT   DD SYSOUT=*
  000069 //SYSOUT   DD SYSOUT=*
  000070 //AJXERR   DD SYSOUT=*
  000071 //AEXIN    DD *
  000072   ACM
  000073   SSID DEND WORKID RDACRJ.RD10405A
  000074   DASDDOPT DSD1QDOP
  000075   CATDOPT DCD1QDOP
  000076   STOPWAIT 3
  000077   STOPWTSECS 10
  000078   LOCK EXCLUSIVE
  000079 //SYSIN    DD SPACE=(CYL,(15,15)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000080 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000081 //SYSTSIN DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000082 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000083 //SYSPRINT DD SPACE=(CYL,(15,15)),UNIT=SYSDA,
  000084 //            DISP=(NEW,DELETE)
  000085 //SYSTSPRT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000086 //            DSORG=PS,LRECL=137,BLKSIZE=4096,RECFM=VBA
  000087 //ALUIN    DD SPACE=(TRK,(1,1)),UNIT=SYSDA,DISP=(NEW,DELETE),
  000088 //            DSORG=PS,LRECL=80,BLKSIZE=3200,RECFM=FB
  000089 //ALUPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
  000090 //AJXPRINT DD SPACE=(CYL,(5,5)),UNIT=SYSDA,DISP=(NEW,DELETE)
  000091 //*** RUNTIME ENABLEMENT CHOSEN - MULTIPLE LLQS
  000092 //SYSPROC DD DSN=AEX.QA1310.CLIST,DISP=SHR
  . . .
  000104 //ISPMLIB DD DSN=AEX.QA1310.MLIB,DISP=SHR
  . . .
  000114 //ISPSLIB DD DSN=AEX.QA1310.SLIB,DISP=SHR
  000115 //ISPTLIB DD DSN=AEX.QA1310.TLIB,DISP=SHR
  000116 //ISPPLIB DD DSN=AEX.QA1310.PLIB,DISP=SHR
  . . .
  000123 //AEXPRINT DD SYSOUT=*
  000124 //WORKLIST DD DISP=SHR,
  000125 //   DSN=ACM.DB2V13.V131.WLBASE01(RD10405A)
  000126 //*-----------------------------------------
  000127 //*--------------------------------------------------------------------
  000128 //* END OF JOBSTEP
  000129 //*--------------------------------------------------------------------
  000130 //*--------------------------------------------------------------------
  000131 //* END OF JOB
  000132 //*--------------------------------------------------------------------
  ****** **************************** Bottom of Data ****************************
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...
  
  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 12.55.13 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.RD10405A
  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(RD10405A)'
  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 RD10405A IS 'N' (NOT STARTED
  BMC16999I UPDATED WORKID STATUS FOR RD10405A 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.RD10405A                                              *
  0:* SORTDEVT 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 12.55.14 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   2
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  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:* NODEFERCDC                                                          *
  0:* STANDALONESTATS DB2STATSUPD TABLEALL NOKEYCARD NOHISTORY            *
  0:* IBMCOPY                                                             *
  0:* SPANNEDRECS                                                         *
  0:* NOBINDONIX                                                          *
  0:* NOMOVETB                                                            *
  0:* MAXSYSUT 20                                                         *
  0:* DYNCOPY                                                             *
  0:* NOPARTCOPY                                                          *
  0:* COPYDDN(COPY01   )                                                  *
  0:* NOUTILCOPY                                                          *
  0:* NOPARALLEL CLONEDATA                                                *
  0:* NOREGENIDENTITY                                                     *
  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 12.55.14 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   3
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:***********************************************************************
  0:-TIME 000050 '2022-04-05-12.39.58.577614'                               09273393
  0:-SSID 000100 DEND                                                       80576389
  0:-WKID 000150 RDACRJ.RD10405A                                            26468515
  0:-CENV 000200
  :             DDL_MATERIALIZATION      ALWAYS_IMMEDIATE                  33973879
  :             TABLE_COL_NAME_EXPANSION ON                                51995524
  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 12:55:14
  ** ALUIN:              DDL_MATERIALIZATION      ALWAYS_IMMEDIATE
  ** 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
  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 000250 END OF CHECK ENVIRONMENT SECTION                           99287764
  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
  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 12.55.15 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   4
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  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:*** WORKID DEM.D0221B HAS CHANGES FOR TB R1128C01.T@T128PBG
  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 12.55.15 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   5
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  0:***********************************************************************
  0:*** END OF WARNING MESSAGES - WARNINGS WERE ISSUED                 ***
  0:***********************************************************************
  0:-SYNC 000300 START OF EXECUTION SYNCPOINT                               86249067
  0:***********************************************************************
  0:-SQL 000350 DROP TRIGGER    R1128C01.TR@T128PBG RESTRICT               00813564
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SYNC 000400 END OF DROP OBJECTS SECTION                                32091992
  0:***********************************************************************
  0:-SQL 000450 ALTER TABLE R1128C01.T@T128PBG
  :             ALTER COLUMN COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ON
  : E@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ON
  : E@HUNDRED@1
  :             SET DATA TYPE VARCHAR(30)
  :                                                                        97203122
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SYNC 000500 END OF ALTER TABLE SECTION                                 74921759
  0:***********************************************************************
  0:-SETS 000550 SET CURRENT SQLID = 'RDACRJ'                               17816261
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SETP 000600 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
  : ,"SYSIBMADM"                                                           22965229
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SQL 000650 CREATE TRIGGER R1128C01.TR@T128PBG
  :                    AFTER
  :                    UPDATE
  :                    OF COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
  : HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
  : UNDRED@1
  :                    ON R1128C01.T@T128PBG
  :            REFERENCING NEW AS N@VAR
  :                    FOR EACH ROW MODE DB2SQL
  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 12.55.16 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   6
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
  :   UPDATE R1128C01.T@T128PBG SET COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARA
  : CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
  : TERS@ONE@HUNDRED@1 = 60
  :   WHERE COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
  : @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@1 =
  :     '11.11.00'
  :                                                                        30892092
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SETS 000700 SET CURRENT SQLID = USER                                   95317045
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SETP 000750 SET CURRENT PATH = SYSTEM PATH                             56967100
    DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
  0:-SYNC 000800 END OF TRIGGER SECTION                                     38051936
  0:***********************************************************************
  0:-REBD 000850
  : REBIND TRIGGER PACKAGE ( -
  : R1128C01.TR@T128PBG +
  : ) -
  :             APREUSE(NONE)         -
  :             BUSTIMESENSITIVE(YES) -
  :             SYSTIMESENSITIVE(YES) -
  :             ARCHIVESENSITIVE(YES) -
  :             PLANMGMT(EXTENDED)    -
  :             EXPLAIN(NO)
  :                                                                        58248093
  BMC16822I CONTROL PASSED TO 'IKJEFT01'
  BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
  BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
  BMC16898I DEBUG: IKJEFT01 0
  
  0READY
    DSN SYSTEM(DEND)
  DSN
  REBIND TRIGGER PACKAGE ( R1128C01.TR@T128PBG )             APREUSE(NONE)                     BUSTIMESENSITIVE(YES)             SYSTI
  MESENSITIVE(YES)             ARCHIVESENSITIVE(YES)             PLANMGMT(EXTENDED)                EXPLAIN(NO)
  DSNT254I *DEND DSNTBRB2 REBIND OPTIONS FOR
              PACKAGE = DEND.R1128C01.TR@T128PBG.()
              ACTION
              OWNER         RDACRJ
              QUALIFIER     RDACRJ
              VALIDATE      BIND
              EXPLAIN       NO
              ISOLATION     CS
              RELEASE       COMMIT
  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 12.55.16 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   7
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
              COPY
              APREUSE       NONE
              APCOMPARE
              APRETAINDUP   YES
              BUSTIMESENSITIVE YES
              SYSTIMESENSITIVE YES
              ARCHIVESENSITIVE YES
              APPLCOMPAT V13R1M501
              DESCSTAT YES
              APREUSESOURCE CURRENT
  DSNT255I *DEND DSNTBRB2 REBIND OPTIONS FOR
              PACKAGE = DEND.R1128C01.TR@T128PBG.()
              SQLERROR      NOPACKAGE
              CURRENTDATA   NO
              DEGREE        1
              DYNAMICRULES BIND
              NODEFER       PREPARE
              REOPT         NONE
              KEEPDYNAMIC   NO
              IMMEDWRITE    NO
              DBPROTOCOL    DRDA
              OPTHINT
              ENCODING      EBCDIC(00000)
              PLANMGMT      EXTENDED
              PLANMGMTSCOPE STATIC
              CONCURRENTACCESSRESOLUTION
              EXTENDEDINDICATOR
                            NO
              PATH          "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM"
  DSNT275I *DEND DSNTBRB2 REBIND OPTIONS FOR
              PACKAGE = DEND.R1128C01.TR@T128PBG.()
              QUERYACCELERATION
              GETACCELARCHIVE
              ACCELERATOR
              CONCENTRATESTMT   NO
              ACCELERATIONWAITFORDATA
              RESTSERVICEDEFAULT
              OWNERTYPE         USER
  DSNT232I *DEND SUCCESSFUL REBIND FOR
              PACKAGE = DEND.R1128C01.TR@T128PBG.()
  0DSN
  END
  0:-SYNC 000900 END OF REBIND PLANS SECTION                                78203312
  0:***********************************************************************
  BMC16999I UPDATED WORKID STATUS FOR RD10405A IS 'C' (COMPLETE)
  0BMC16833I END OF WORKLIST 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 12.55.16 ON SYSID DB2B                      WORKLIST EXECUTION LOG                                               PAGE   8
  0------------------------------------------------------------------------------------------------------------------------------------
                                              LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
  ------------------------------------------------------------------------------------------------------------------------------------
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