Migrating Db2 objects
Just as changing Db2 objects is a three-stage process, migrating Db2 objects from one environment to another within the same Db2 subsystem in ALTER or
BMC AMI Change Manager for Db2
is also a three-stage process.
The three stages are specification, analysis, and execution.
Specification
Identify the objects to be migrated and specify changes to the data structures.
Analysis
Analyze the specified migration changes for accuracy and completeness. The result of the analysis stage is a worklist that contains the SQL and the information that is necessary to generate the data structure in the target Db2 system.
Execution
Execute the worklist that is generated during the analysis stage.
The following example illustrates these three stages by showing how to use the Task List feature of Change Manager to quickly and easily migrate objects from one environment to another environment within the same Db2 subsystem.
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.
| For more information, view the Quick Course CHANGE MANAGER for DB2 - Migrating in Same Subsystem. |
To migrate 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.
On the BMC AMI Change Manager for Db2 Main Menu, select Task List and press Enter.The Task List Menu is displayed.
ALUFTASK ------------------------- Task List Menu -----------------------------
Command ===>
Select a task. Then press Enter.
2 1. Create, alter, or drop Db2 objects
2. Migrate Db2 objects using Specification
3. Migrate Db2 objects using scope rules from a Migrate Profile
Commands: HELP ENDOn the Task List Menu, select Migrate Db2 objects using Specification and press Enter.The Migrate Db2 Objects Using Specification panel is displayed:
ALUFPALT -------------------- Migrate Db2 Objects Using Specification ---------
Command ===>
Specify a Migrate WORKID.
If the WORKID does not exist, the Create WORKID panel will be displayed.
To see a list of WORKIDs, type a wildcard pattern. (For example BM*.*)
Migrate WORKID: RDACRJ.RCB0831F
Optionally specify a Migrate Profile.
If the profile does not exist, the Create Profile panel will be displayed.
To see a list of profiles, type a wildcard pattern. For example BM*.*)
Migrate Profile:
Type S to select processing options. Then press Enter to continue.
_ Create or edit a Migrate Profile
_ Create or edit a WORKID
_ Specify changes to Db2 objects
_ Analyze the changes to create a worklist
_ Execute the worklist to process the changes
Commands: HELP END
- On the Migrate Db2 Objects Using Specification panel, specify a migrate-type work ID.A work ID enables you to identify, control, and track a unit of work. The migrate-type work ID is used to specify data structure definitions to be migrated from one Db2 subsystem to another, or to duplicate structures within the same subsystem.
On the Migrate Db2 Objects Using Specification panel, type the name of a migrate-type work ID, and type S to select all of the processing options except Create or edit a Migrate Profile. Then, press Enter.The Create WORKID panel is displayed.
ALUFWRKC -------------------------- Create WORKID ----------- WORKID NOT FOUND
Command ===>
WORKID . . . . . . : RDACRJ.RCB0831F
Type . . . . . . . . 2 1. Alter
2. Migrate
3. Receive
Comment . . . . . .
Select additional panels to display for Migrate type WORKID. Then press Enter.
_ WORKID Migrate Options
_ WORKID Change Rules
Commands: HELP END CANCELOn the Create WORKID panel, select Migrate for the Type. Type S to select the WORKID Change Rules. Then, press Enter.The Change Rules panel is displayed.
ALUFRULL ------------------ Change Rules ------------------------------------
Command ===> SCROLL ===> 0008
WORKID . . . . : RDACRJ.RCB0831F
Type action next to existing rule or overtype existing values.
Rules 1 to 1 of 1
E=Edit I=Insert D=Delete L=Like C=Create More: >
Act Opt Obj Attribute Current Attribute Value New Attribute Value
************************************** TOP ************************************
************************************* BOTTOM **********************************Change rules enable you to specify global changes to the name, owner, creator, or other attributes of the objects. The new attributes that you specify apply to all objects in the migration that possess the attributes.
On the Change Rules panel, type E in the Act field to select Edit. Press Enter.The Edit Change Rules panel is displayed.
ALUF2RLE ---------------------- Edit Change Rules --- "DOWN " is not active
Command ===>
Option . . . 1 1. Change 2. Include 3. Exclude 4. Force
Object . . . 1. Stogroup 8. Unique Cnst 15. Stored Procs
2. Database 9. View 16. Sequences
3. Tablespace 10. Trigger 17. Functions
4. Table 11. Alias 18. Row Permissions
5. Check Cnst 12. Synonym 19. Column Masks
6. Foreign Key 13. Plan 20. All
7. Index 14. Package
Attribute. . _ Display Attribute List
Current Attribute Value. .
New Attribute Value. . . .
Specify optional object name(s).
Part1 (SG, DB, owner, schema)
Part2 (TS, name)
Part3 (SP, version)
Commands: HELP END CANCEL PF4=ZOOMOn the Edit Change Rules panel, select Change as the Option for the attribute, select All as the Object, and type S to select Display Attribute List. Press Enter.By selecting All objects, you can specify one change rule that changes an attribute for all of the tables, indexes, views, and so on. You can change an attribute that applies to all of the migrated objects that have that attribute.
The Edit Rules Attribute Selection panel is displayed.
ALUF2RL2 --------------- Edit Rules Attribute Selection ---- Invalid Attribute
Command ===>
Option . . . . . . Change
Object . . . . . . All
Attribute Name . .
Select from attribute list below.
Attribute Number. .
1. Activate 17. Debug_Mode *. Log 49. SPType
2. Append 18. Define 34. Maxparts 50. Stog_VCAT
3. Asutime 19. Devtype 35. Name *. Stogroup
4. Audit 20. Dssize 36. Owner 52. Tablespace
5. BuffpoolIX 21. DssizeRPN 37. Pctfree 53. Trackmod
6. BuffpoolTS 22. Editproc 38. Pctfreeupd 54. Validproc
7. CCSID 23. Erase 39. Piecesize 55. VCAT
8. Close 24. Fieldproc 40. PKOwner 56. VCAT_Stog
9. Collection 25. Freepage 41. Priqty 57. Version
10. Colname 26. Grantee 42. Qualifier 58. Volatile
11. Compress 27. Grantor 43. Resident 59. Volorder
12. Createdby *. Inline 44. Restrict 60. Volume
13. Creator 29. Keylabel *. Schema 61. WLM_Env
14. Database 30. Location 46. Secqty
15. DataCapture 31. Lockmax 47. Segsize
16. Dbrmlib 32. Locksize 48. SPAlter
Commands: HELP END CANCEL PF4=ZOOMOn the Edit Rules Attribute Selection panel, select the number for the Name attribute. Press Enter and then press END.The Edit Change Rules panel is displayed.
ALUF2RLE ---------------------- Edit Change Rules -----------------------------
Command ===>
Option . . . 1 1. Change 2. Include 3. Exclude 4. Force
Object . . . 20 1. Stogroup 8. Unique Cnst 15. Stored Procs
2. Database 9. View 16. Sequences
3. Tablespace 10. Trigger 17. Functions
4. Table 11. Alias 18. Row Permissions
5. Check Cnst 12. Synonym 19. Column Masks
6. Foreign Key 13. Plan 20. All
7. Index 14. Package
Attribute. . NAME _ Display Attribute List
Current Attribute Value. .
New Attribute Value. . . .
Specify optional object name(s).
Part1 (SG, DB, owner, schema)
Part2 (TS, name)
Part3 (SP, version)
Commands: HELP END CANCEL PF4=ZOOMOn the Edit Change Rules panel, type the Current Attribute Value and the New Attribute Value for the database name. Press END.
The change rules are displayed in the Change Rules panel.
ALUFRULL ------------------ Change Rules ------------------------------------
Command ===> SCROLL ===> 0008
WORKID . . . . : RDACRJ.RCB0831F
Type action next to existing rule or overtype existing values.
Rules 1 to 1 of 1
E=Edit I=Insert D=Delete L=Like C=Create More: >
Act Opt Obj Attribute Current Attribute Value New Attribute Value
************************************** TOP ************************************
C ** NAME R1BAS504 R1BAS505
************************************* BOTTOM **********************************- On the Change Rules panel, type L in the Act field for the name rule. The L enables you to create a new rule like the existing rule. Press Enter.
On the second line, type OWNER over NAME in the Attribute field, type * for the Current Attribute Value (if you do not know the current owner), and type your TSO logon ID (or other desired value) for the New Attribute Value. Press Enter.The Change Rules panel is displayed.
ALUFRULL ------------------ Change Rules ------------------------------------
Command ===> SCROLL ===> 0008
WORKID . . . . : RDACRJ.RCB0831F
Type action next to existing rule or overtype existing values.
Rules 1 to 2 of 2
E=Edit I=Insert D=Delete L=Like C=Create More: >
Act Opt Obj Attribute Current Attribute Value New Attribute Value
************************************** TOP ************************************
C ** NAME R1BAS504 R1BAS505
c ** OWNER * RDACRJ
************************************* BOTTOM **********************************- Press END.The Edit WORKID Migration Options panel is displayed.
Press END to return to the Object Specification panel.
ALUSOS GRATE ---------------------- Object Specification ----------------------
Command ===>
WORKID . . . : RDACRJ.RCB0831F _ 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)
- Identify the objects and dependent objects that you want to migrate.
On the Object Specification panel, type the name of a Database. Press Enter.The Mixed List panel is displayed with the dependent objects of the database.
ALUSMXL RATE --------------------------- Mixed List ---------------------------
Command ===> Scroll. . CSR
WORKID . . . . : RDACRJ.RCB0831F Commands: CANCEL
Type action next to object and press Enter.
E=Edit L=Like D=Drop U=Undo M=Migrate MO=Migrate options
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- On the Mixed List panel, type M in the Act field next to the database that you want to migrate. Press Enter.
Type MO in the Act field next to the database that you selected. Press Enter.The Migrate Options Overrides panel is displayed.
ALUSMO GRATE -------------------- Migrate Options Overrides -------------------
Command ===>
Commands: CANCEL
WORKID . . . . : RDACRJ.RCB0831F
Database . . . : R1BAS504
Specify dependencies that should also be migrated.
(Y=include them; N=omit them)
_ Migrate Data
_ Migrate Tablespaces
_ Migrate Tables
_ Migrate Unique Constraints
_ Migrate Check Constraints
_ Migrate Foreign Keys
_ Migrate Indexes
_ Migrate Views
_ Migrate Authorizations
_ Migrate Synonyms
_ Migrate Aliases
_ Migrate Trigger
_ Migrate Auxiliary Objects
_ Migrate Row Permissions
_ Migrate Column Masks
Commands: HELP END CANCELOn the Migrate Options Overrides panel, type Y to select the dependent objects that you want to migrate. Press Enter, and then press END.In this example, data was selected. No dependent objects were selected.
The Mixed List panel is displayed, as shown below. An '*M' is displayed next to the database that you selected to migrate.
ALUSMXL RATE --------------------------- Mixed List ---------------------------
Command ===> Scroll. . CSR
WORKID . . . . : RDACRJ.RCB0831F Commands: CANCEL
Type action next to object and press Enter.
E=Edit L=Like D=Drop U=Undo M=Migrate MO=Migrate options
Objects 1 to 21 of 28
More: +
Act Object-Type Objects
************************************ TOP **************************************
*M 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- On the Mixed List panel, type M in the Act field next to the table space that you want to migrate. Press Enter.
- Type MO in the Act field next to the table space that you selected. Press Enter.The Migrate Options Overrides panel is displayed.
On the Migrate Options Overrides panel, type Y to select the dependent objects that you want to migrate. Press Enter, and then press END.In this example, data and all of the dependent objects were selected.
The Mixed List panel is displayed, as shown below. An '*M' is displayed next to the table space that you selected to migrate.
ALUSMXL RATE --------------------------- Mixed List ---------------------------
Command ===> Scroll. . CSR
WORKID . . . . : RDACRJ.RCB0831F Commands: CANCEL
Type action next to object and press Enter.
E=Edit L=Like D=Drop U=Undo M=Migrate MO=Migrate options
Objects 1 to 21 of 28
More: +
Act Object-Type Objects
************************************ TOP **************************************
*M 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
*M TSR. . . . . R1BAS504 T08APBR
TBT. . . . R1BAS504 T_T08APBR
IXT. . . R1BAS504 I_T08APBR<>RTITIONED
IXCT . . R1BAS504 I_T08APBR<>TITIONINGPress END to return to the Object Specification panel. Press END again.The Analysis Migrate Worklist Interface panel is displayed.
ACMFANL2 --------------- Analysis Migrate Worklist Interface ------------------
Command ===>
WORKID . . . . . : RDACRJ.RCB0831F
Analyze "Migrate" WORKID
Select type of analysis.
1 1. Analyze Specification entries (use the WORKID's change rules)
2. Analyze Specification entries (use a Migrate Profile's locations and
change rules)
3. Analyze Migrate Profile scope (use the Migrate Profile's locations and
change rules)
Type an Outbound Migrate Profile, or type a wildcard pattern for a selection
list if analysis type is 2 or 3.
Migrate Profile . .
Select run type. Then press Enter.
Run Type . . . . . 2 1. Foreground
2. Batch
Commands: HELP END
- Analyze the migration changes that you specified.The Analysis component of the product examines the changes that you specified and generates a worklist that contains the instructions that are necessary to implement the actions chosen during the specification stage.
On the Analysis Migrate Worklist Interface panel, select the Analyze Specification entries (use the WORKID’s change rules) option. Then select to run the Analysis in Batch. Press Enter.
The Analysis JCL Processing Interface panel is displayed.
ACMFANL3 ---------------- Analysis JCL Processing Interface -------------------
Command ===>
WORKID . . . . : RDACRJ.RCB0831F
Specify Dataset Names
JCL . . . . . . . . 'ACM.DB2V12.V121.ANLYJCL(RCB0831F)'
Worklist . . . . . 'ACM.DB2V12.V121.WLBASE01(RCB0831F)'
Diagnostics . . . . SYSOUT
Select batch processing options. Then press Enter.
S Override
S Create JCL
S Edit JCL
_ Submit JCL
_ Edit Worklist
Commands: BROWSE PREVIOUS HELP ENDOn the Analysis JCL Processing Interface panel, specify your data set names, and type S to select the processing options. In this example, one of the options for analysis is overridden. Press Enter.
The Analysis Worklist Options panel is displayed.
ALUF0OA1 ----------------- Analysis Worklist Options --------------------------
Command ===>
Type information. Then press Enter to continue.
Specify allocation parameters for new datasets.
Dataset Unitname Volume Priqty Secqty Alloc Unit
Worklist SYSDA 15 5 Tracks
Specify optional Global AUTHID.
Global AUTHID . .
Specify sync point frequency.
Frequency . . . . 10
Analyze for ROLE as OWNER.
ROLEOWN . . . . . N
Use spanned records. Use ALTER TABLESPACE MOVE TABLE.
SPANNEDRECS . . . Y MOVETB . . . N
Commands: HELP ENDOn the Analysis Worklist Options panel, press Enter to accept the defaults.
The Analysis Worklist Command Options panel is displayed.
ALUFOA20 ---------------- Analysis Worklist Command Options -------------------
Command ===>
Type information. Then press Enter to continue or PF12 for previous panel.
Select the elements to include in this worklist.
S SQL
S Data
S Clone Data
S AMS
_ STORCLAS
_ MGMTCLAS
_ DATACLAS
_ BIND
_ DBRMLIB
_ BINDONIX
_ BINDAUTH
Commands: HELP END PREVIOUSOn the Analysis Worklist Command Options panel, press Enter to accept the defaults.The Analysis Input Stream Parameters panel is displayed.
ALUFOA30 ---------------- Analysis Input Stream Parameters --------------------
Command ===>
Type information. Then press Enter to continue or PF12 for previous panel.
Select any of the following analysis parameters.
_ ENV Display installation environment
_ PKEYPROP Propagate parent key changes to foreign keys
_ VALWARN Display errors as warnings for conditions in text
_ VVALPROP Propagate table column changes to base views
_ NOORDERBY Omit the ORDER BY clause for unloads in the worklist
_ NOUNLOADEMPTY Do not unload tables that IBM RUNSTATS indicates are empty
_ STOPCOMMIT Generate an AT(COMMIT) statement for every STOP command
_ DEFERUNIQUEIX Create unique indexes with DEFER YES
_ CISIZE4K Create all VSAM data sets with a CISIZE of 4 KB
_ PARALLEL Enable worklist parallelism
_ SINGLEPHASE Omit the -STOP command between phases of a migrate worklist
_ APPLCOVR Include APPLCOMPAT overrides in worklist
Commands: HELP END PREVIOUS- On the Analysis Input Stream Parameters panel, type S to select the option SINGLEPHASE. When you migrate within a single subsystem, you normally do not want to stop between phases in a migrate worklist. (For more information, see Overrides-of-the-Analysis-parameters.)
Press END.The JCL Generation component is invoked and Batch Analysis JCL Generation is displayed, as shown below. The JCL includes the //ALUIN DD and //AJXPOFIN DD statements (input streams), which include keywords for processing the worklist. For more information about the input streams, see the Keywords-for-input-streams section.
000001 //RDACRJA JOB (5715),'ANALYSIS-RCB0831F',
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.16.29.45
000009 //* ENVIRONMENT: ISPF 7.3MVS TSO
000010 //* RELEASE : V12.01.01 12/08/2016
000011 //* DB2 VERSION: 12015
000012 //***************************************************
000013 //*-------------------------------------------------------------------
000014 //* ANALYSIS for BMC AMI Change Manager for Db2
000015 //*-------------------------------------------------------------------
000016 //ANALYSIS EXEC PGM=ALUAMAIN,
000017 // REGION=0M,
000018 // PARM='DMCBQELT'
000019 //STEPLIB DD DSN=CSG.DELT.DSNEXIT,DISP=SHR
000020 // DD DSN=CSGI.DB2V12M.DSNLOAD,DISP=SHR
000021 //ABNLIGNR DD DUMMY
000022 //SYSTERM DD SYSOUT=*
000023 //SYSTSPRT DD SYSOUT=*
000024 //SYSUDUMP DD SYSOUT=*
000025 //********************************************************
000026 //**** SAMPLE SYSMDUMP JCL ********
000027 //**** PLEASE REPLACE THE DSN AND UNIT WITH ONES THAT FITS
000028 //**** YOUR SHOP STANDARDS AND UNCOMMENT THE JCL
000029 //*SYSMDUMP DD DSN=CUSTOMER.SYSMDUMP,DISP=(,CATLG,CATLG),UNIT=XXXXXXX,
000030 //* SPACE=(CYL,(200,50),RLSE),
000031 //* DCB=(DSORG=PS,RECFM=FBS,LRECL=4160,BLKSIZE=24960)
000032 //********************************************************
000033 //ALUPRINT DD SYSOUT=*
000034 //AJXPOFVL DD DUMMY
000035 //ALUIN DD *
000036 SSID DELT
000037 WORKID RDACRJ.RCB0831F
000038 INCLUDE (DATA SQL AMS )
000039 SORTDEVT SYSDA
000040 SMSINCLUDE ( )
000041 IBMUNLOAD IBMLOAD NOUSENGTUL
000042 IBMREORG NOUSENGTR
000043 IBMREBUILD
000044 STANDALONESTATS DB2STATSUPD TABLEALL
000045 NOHISTORY
000046 IBMCOPY
000047 NOUTILCOPY
000048 DYNUNLD
000049 DYNCOPY
000050 NOPARTCOPY
000051 COPYDDN (COPY01 )
000052 NOREGENIDENTITY
000053 SINGLEPHASE
000054 NOVVALPROP
000055 IBMCHECK
000056 SYNCPOINT 10
000057 NODBRMLIB
000058 ORDERBY
000059 UNLOADTABLE
000060 UNLOADEMPTY
000061 NOSTOPCOMMIT
000062 TABLEACCESS
000063 NOAPPLCOVR
000064 NOPARALLEL
000065 REORGONLINE
000066 NOKEYCARD
000067 REORGALL
000068 REORGREF
000069 DYNREORG
000070 NOROLEOWN
000071 CLONEDATA
000072 SPANNEDRECS
000073 NOBINDONIX
000074 //* POF INPUT FILE AJXAPOF
000075 //* THE KEYWORDS MUST START IN COLUMN 1
000076 //AJXPOFIN DD *,DLM=$$
000077 ACM_DYNSORTW_NUM=32
000078 ACM_DYNSORTW_UNIT=SYSDA
000079 ACM_IBMR_MAP_REQ=Y
000080 ACM_ANALYSIS_SYSOUT=X
000081 ACM_WLORDER=
000082 ACM_WLORDERMSG=N
000083 ACM_PARALLEL_XIMGRP=XIMACM
000084 ARCH_DATACLASS_ALT=
000085 ARCH_DATACLASS=
000086 ARCH_EXPDT=
000087 ARCH_MGMTCLASS_ALT=
000088 ARCH_MGMTCLASS=
000089 ARCH_PREFIX=&PREFIX..&WKID
000090 ARCH_PRIQTY=10
000091 ARCH_RETPD=
000092 ARCH_SECQTY=2
000093 ARCH_STACK=N
000094 ARCH_STORCLASS_ALT=
000095 ARCH_STORCLASS=
000096 ARCH_THRESH=0
000097 ARCH_UNIT_ALT=
000098 ARCH_UNIT=SYSDA
000099 BLRP_DATACLASS_ALT=
000100 BLRP_DATACLASS=
000101 BLRP_EXPDT=
000102 BLRP_MGMTCLASS_ALT=
000103 BLRP_MGMTCLASS=
000104 BLRP_PREFIX=&PREFIX..&WKID..&OBNOD
000105 BLRP_PRIQTY=10
000106 BLRP_RETPD=
000107 BLRP_SECQTY=2
000108 BLRP_STACK=N
000109 BLRP_STORCLASS_ALT=
000110 BLRP_STORCLASS=
000111 BLRP_THRESH=0
000112 BLRP_UNIT_ALT=
000113 BLRP_UNIT=SYSDA
000114 BMC_REORG_XBMID=XBMB
000115 CPYEXP_DATACLASS=
000116 CPYEXP_EXPDT=
000117 CPYEXP_MGMTCLASS=
000118 CPYEXP_PREFIX=&PREFIX..&WKID
000119 CPYEXP_RETPD=
000120 CPYEXP_STORCLASS=
000121 CPYEXP_SUPPRESS_SUFF=N
000122 CPYEXP_UNIT=SYSDA
000123 DEF_GDG_BASE=N
000124 DEF_GDG_LIMIT=10
000125 DEF_GDG2_LIMIT=10
000126 DEF_GDG_NOSCR = N
000127 DIAG_MSGCLASS=X
000128 DISC_DATACLASS_ALT=
000129 DISC_DATACLASS=
000130 DISC_EXPDT=
000131 DISC_MGMTCLASS_ALT=
000132 DISC_MGMTCLASS=
000133 DISC_PREFIX=&PREFIX..&WKID
000134 DISC_PRIQTY=10
000135 DISC_RETPD=
000136 DISC_SECQTY=2
000137 DISC_STORCLASS_ALT=
000138 DISC_STORCLASS=
000139 DISC_THRESH=0
000140 DISC_UNIT_ALT=
000141 DISC_UNIT=SYSDA
000142 GDG_MODEL=SYS1.MODEL
000143 PCPY1_DATACLASS_ALT=
000144 PCPY1_DATACLASS=
000145 PCPY1_EXPDT=
000146 PCPY1_MGMTCLASS_ALT=
000147 PCPY1_MGMTCLASS=
000148 PCPY1_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
000149 PCPY1_PRIQTY=10
000150 PCPY1_RETPD=
000151 PCPY1_SECQTY=2
000152 PCPY1_STACK=N
000153 PCPY1_STORCLASS=
000154 PCPY1_STORCLASS_ALT=
000155 PCPY1_SUPPRESS_SUFF=N
000156 PCPY1_THRESH=0
000157 PCPY1_UNIT_ALT=
000158 PCPY1_UNIT=SYSDA
000159 PCPY2_DATACLASS_ALT=
000160 PCPY2_DATACLASS=
000161 PCPY2_EXPDT=
000162 PCPY2_MGMTCLASS_ALT=
000163 PCPY2_MGMTCLASS=
000164 PCPY2_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
000165 PCPY2_PRIQTY=10
000166 PCPY2_RETPD=
000167 PCPY2_SECQTY=2
000168 PCPY2_STACK=N
000169 PCPY2_STORCLASS=
000170 PCPY2_STORCLASS_ALT=
000171 PCPY2_SUPPRESS_SUFF=N
000172 PCPY2_THRESH=0
000173 PCPY2_UNIT_ALT=
000174 PCPY2_UNIT=SYSDA
000175 PUNCH_DATACLASS=
000176 PUNCH_EXPDT=
000177 PUNCH_MGMTCLASS=
000178 PUNCH_PREFIX=&PREFIX..&WKID..&STEPN
000179 PUNCH_PRIQTY=10
000180 PUNCH_RETPD=
000181 PUNCH_SECQTY=2
000182 PUNCH_STORCLASS=
000183 PUNCH_UNIT=SYSDA
000184 RCPY1_DATACLASS_ALT=
000185 RCPY1_DATACLASS=
000186 RCPY1_EXPDT=
000187 RCPY1_MGMTCLASS_ALT=
000188 RCPY1_MGMTCLASS=
000189 RCPY1_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
000190 RCPY1_PRIQTY=10
000191 RCPY1_RETPD=
000192 RCPY1_SECQTY=2
000193 RCPY1_STACK=N
000194 RCPY1_STORCLASS=
000195 RCPY1_STORCLASS_ALT=
000196 RCPY1_SUPPRESS_SUFF=N
000197 RCPY1_THRESH=0
000198 RCPY1_UNIT_ALT=
000199 RCPY1_UNIT=SYSDA
000200 RCPY2_DATACLASS_ALT=
000201 RCPY2_DATACLASS=
000202 RCPY2_EXPDT=
000203 RCPY2_MGMTCLASS_ALT=
000204 RCPY2_MGMTCLASS=
000205 RCPY2_PREFIX=&PREFIX..&WKID..&SPNAME..P&PART
000206 RCPY2_PRIQTY=10
000207 RCPY2_RETPD=
000208 RCPY2_SECQTY=2
000209 RCPY2_STACK=N
000210 RCPY2_STORCLASS=
000211 RCPY2_STORCLASS_ALT=
000212 RCPY2_SUPPRESS_SUFF=N
000213 RCPY2_THRESH=0
000214 RCPY2_UNIT_ALT=
000215 RCPY2_UNIT=SYSDA
000216 REORG_MAPDB=
000217 REORG_MAPTAB=RDAJZB.JZBTBMAP
000218 SRTOUT_DATACLASS_ALT=
000219 SRTOUT_DATACLASS=
000220 SRTOUT_EXPDT=
000221 SRTOUT_MGMTCLASS_ALT=
000222 SRTOUT_MGMTCLASS=
000223 SRTOUT_PREFIX=&PREFIX..&WKID..&STEPN
000224 SRTOUT_PRIQTY=10
000225 SRTOUT_RETPD=
000226 SRTOUT_SECQTY=2
000227 SRTOUT_STORCLASS_ALT=
000228 SRTOUT_STORCLASS=
000229 SRTOUT_THRESH=0
000230 SRTOUT_UNIT_ALT=
000231 SRTOUT_UNIT=SYSDA
000232 SYSUT_DATACLASS_ALT=
000233 SYSUT_DATACLASS=
000234 SYSUT_EXPDT=
000235 SYSUT_MGMTCLASS_ALT=
000236 SYSUT_MGMTCLASS=
000237 SYSUT_PREFIX=&PREFIX..&WKID..&STEPN
000238 SYSUT_PRIQTY=10
000239 SYSUT_RETPD=
000240 SYSUT_SECQTY=2
000241 SYSUT_STORCLASS_ALT=
000242 SYSUT_STORCLASS=
000243 SYSUT_THRESH=0
000244 SYSUT_UNIT_ALT=
000245 SYSUT_UNIT=SYSDA
000246 TAPE_EXPDT=
000247 TAPE_RETPD=
000248 TAPE_VOLCNT=99
000249 TAPE1=CARTVTS
000250 TAPE2=CARTVTS
000251 TAPE3=CARTVTS
000252 TEMPUNIT=SYSDA
000253 UNLD1_DATACLASS_ALT=
000254 UNLD1_DATACLASS=
000255 UNLD1_EXPDT=
000256 UNLD1_MGMTCLASS_ALT=
000257 UNLD1_MGMTCLASS=
000258 UNLD1_PREFIX=&PREFIX..&MSSID..&WORKID8
000259 UNLD1_PRIQTY=10
000260 UNLD1_RETPD=
000261 UNLD1_SECQTY=2
000262 UNLD1_STACK=N
000263 UNLD1_STORCLASS_ALT=
000264 UNLD1_STORCLASS=
000265 UNLD1_SUPPRESS_SUFF=N
000266 UNLD1_THRESH=0
000267 UNLD1_UNIT_ALT=
000268 UNLD1_UNIT=SYSDA
000269 UNLD2_DATACLASS_ALT=
000270 UNLD2_DATACLASS=
000271 UNLD2_EXPDT=
000272 UNLD2_MGMTCLASS_ALT=
000273 UNLD2_MGMTCLASS=
000274 UNLD2_PREFIX=&PREFIX..&MSSID..&WORKID8
000275 UNLD2_PRIQTY =10
000276 UNLD2_RETPD=
000277 UNLD2_SECQTY =2
000278 UNLD2_STACK=N
000279 UNLD2_STORCLASS_ALT=
000280 UNLD2_STORCLASS=
000281 UNLD2_SUPPRESS_SUFF=N
000282 UNLD2_THRESH=0
000283 UNLD2_UNIT_ALT=
000284 UNLD2_UNIT=SYSDA
000285 UNLD3_DATACLASS=
000286 UNLD3_EXPDT=
000287 UNLD3_MGMTCLASS=
000288 UNLD3_PREFIX=&PREFIX..&MSSID..&WORKID8
000289 UNLD3_RETPD=
000290 UNLD3_STORCLASS=
000291 UNLD3_SUPPRESS_SUFF=N
000292 UNLD3_UNIT=SYSDA
000293 UNLD4_PREFIX=&PREFIX..&MSSID..&WORKID8
000294 UNLD4_STORCLASS=
000295 UNLD4_UNIT=SYSDA
000296 UNLD4_MGMTCLASS=
000297 UNLD4_DATACLASS=
000298 UNLD4_SUPPRESS_SUFF=N
000299 UNLD_FREF_DATACLASS=
000300 UNLD_FREF_MGMTCLASS=
000301 UNLD_FREF_PREFIX=&PREFIX..&MSSID..&WORKID8
000302 UNLD_FREF_STORCLASS=
000303 UNLD_FREF_UNIT=SYSDA
000304 UNLD_FREF_PRIQTY=10
000305 UNLD_FREF_DIRBLOCK=250
000306 UNLD_FREF_SECQTY=2
000307 UNLD_FREF_SUPPR_SUFF=N
000308 USE_NGT_AUTO=N
000309 USER_REXX_EXEC=
000310 USER_VAR1_CHAR=
000311 USER_VAR2_CHAR=
000312 USER_VAR3_CHAR=
000313 USER_VAR4_CHAR=0
000314 USER_VAR5_CHAR=0
000315 WORKLIST_BUFFERS=4
000316 CHECKSTARTDB=N
000317 $$
000318 //WORKL001 DD DISP=SHR,
000319 // DSN=ACM.DB2V12.V121.WLBASE01(RCB0831F)
000320 //*--------------------------------------------------------------------
000321 //* END OF JOB
000322 //*--------------------------------------------------------------------
****** **************************** Bottom of Data ****************************Press END to return to the Analysis JCL Processing Interface panel.
ACMFANL3 ---------------- Analysis JCL Processing Interface -------------------
Command ===>
WORKID . . . . : RDACRJ.RCB0831F
Specify Dataset Names
JCL . . . . . . . . 'ACM.DB2V12.V121.ANLYJCL(RCB0831F)'
Worklist . . . . . 'ACM.DB2V12.V121.WLBASE01(RCB0831F)'
Diagnostics . . . . SYSOUT
Select batch processing options. Then press Enter.
* Override
* Create JCL
* Edit JCL
S Submit JCL
_ Edit Worklist
Commands: BROWSE PREVIOUS HELP END- On the Analysis JCL Processing Interface panel, press Enter to submit the JCL.
- After you submit the job, press Enter to return to the Analysis JCL Processing Interface panel.The results of Analysis are a diagnostic output file (ALUPRINT) and a worklist.
To review the results of the analysis of the work ID (ALUPRINT), you can split your ISPF session or you can use your normal method to review SYSOUT. The last message in the diagnostic output indicates that the worklist completed successfully.
SDSF OUTPUT DISPLAY RDACRJA J0261694 DSID 106 LINE 0 COLUMNS 02- 81
COMMAND INPUT ===> SCROLL ===> CSR
********************************* TOP OF DATA **********************************
SSID DELT
WORKID RDACRJ.RCB0831F
INCLUDE (DATA SQL AMS )
SORTDEVT SYSDA
SMSINCLUDE ( )
IBMUNLOAD IBMLOAD NOUSENGTUL
IBMREORG NOUSENGTR
IBMREBUILD
STANDALONESTATS DB2STATSUPD TABLEALL
NOHISTORY
IBMCOPY
NOUTILCOPY
DYNUNLD
DYNCOPY
NOPARTCOPY
COPYDDN (COPY01 )
NOREGENIDENTITY
SINGLEPHASE
NOVVALPROP
IBMCHECK
SYNCPOINT 10
NODBRMLIB
ORDERBY
UNLOADTABLE
UNLOADEMPTY
NOSTOPCOMMIT
TABLEACCESS
NOAPPLCOVR
NOPARALLEL
REORGONLINE
NOKEYCARD
REORGALL
REORGREF
DYNREORG
NOROLEOWN
CLONEDATA
SPANNEDRECS
NOBINDONIX
*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-16.36.29.628305
*** BMC AMI Change Manager for Db2 VERSION 12.01.01(10/15/2020)
*** CURRENT SPE LEVEL SPE2010 (BQU2829)
WORKLIST GENERATION EXECUTION FOR WORKID RDACRJ.RCB0831F 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.
*BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
* REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
* PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
* ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
* INPUT STREAM.
***********************************************************************
*** END OF WARNING MESSAGES - WARNINGS WERE ISSUED ***
***********************************************************************
WORKLIST WAS WRITTEN TO DATASET 'ACM.DB2V12.V121.WLBASE01(RCB0831F)'
WORKLIST GENERATION COMPLETE WORKID RDACRJ.RCB0831F
******************************** 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:
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.RCB0831F *
000013 * INCLUDE (DATA SQL AMS ) *
000014 * SORTDEVT SYSDA *
000015 * SMSINCLUDE ( ) *
000016 * IBMUNLOAD IBMLOAD NOUSENGTUL *
000017 * IBMREORG NOUSENGTR *
000018 * IBMREBUILD *
000019 * STANDALONESTATS DB2STATSUPD TABLEALL *
000020 * NOHISTORY *
000021 * IBMCOPY *
000022 * NOUTILCOPY *
000023 * DYNUNLD *
000024 * DYNCOPY *
000025 * NOPARTCOPY *
000026 * COPYDDN (COPY01 ) *
000027 * NOREGENIDENTITY *
000028 * SINGLEPHASE *
000029 * NOVVALPROP *
000030 * IBMCHECK *
000031 * SYNCPOINT 10 *
000032 * NODBRMLIB *
000033 * ORDERBY *
000034 * UNLOADTABLE *
000035 * UNLOADEMPTY *
000036 * NOSTOPCOMMIT *
000037 * TABLEACCESS *
000038 * NOAPPLCOVR *
000039 * NOPARALLEL *
000040 * REORGONLINE *
000041 * NOKEYCARD *
000042 * REORGALL *
000043 * REORGREF *
000044 * DYNREORG *
000045 * NOROLEOWN *
000046 * CLONEDATA *
000047 * SPANNEDRECS *
000048 * NOBINDONIX *
000049 ***********************************************************************
000050 -TIME 000050 '2020-08-31-16.36.29.628305' 42847006
000051 -SSID 000100 DELT 27049871
000052 -JCLP 000150 MIGR MSSID DELT 79212468
000053 -WKID 000200 RDACRJ.RCB0831F 27192480
000054 ***********************************************************************
000055 ***********************************************************************
000056 ***********************************************************************
000057 *** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY ***
000058 ***********************************************************************
000059 *BMC396243I DB2 VERSION 12 NFM
000060 *BMC56464I DB2 CURRENT FUNCTION LEVEL IS V12R1M504
000061 *BMC56464I DB2 CATALOG LEVEL IS V12R1M503
000062 *BMC56464I APPLCOMPAT IS V12R1M504
000063 *BMC56464I APPLCOMPAT FROM DSNZPARM IS V12R1M504
000064 *BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
000065 * ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
000066 * PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
000067 * PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
000068 *BMC396469W THE FOLLOWING UTILITIES ARE NOT SUPPORTED AT FUNCTION
000069 * LEVEL V12R1M504 OR GREATER ON A COMPRESSED OBJECT USING
000070 * HUFFMAN.
000071 * BMC UNLOAD PLUS / BMC LOADPLUS / BMC REORG PLUS
000072 * THE ANALYSIS PROCESS DOES NOT PREVENT INCLUDING THESE
000073 * UTILITIES IN THE WORKLIST.
000074 *BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
000075 *BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
000076 * ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
000077 * KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
000078 *BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
000079 * REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
000080 * PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
000081 * ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
000082 * INPUT STREAM.
000083 ***********************************************************************
000084 *** END OF WARNING MESSAGES - WARNINGS WERE ISSUED ***
000085 ***********************************************************************
000086 *** ORIGINATOR OF WORKLIST WAS WORKID RDACRJ.RCB0831F ON SSID DELT ***
000087 -MIGR 000250 PHASE-1 START OF SECTION TO BE RUN ON SENDING SYSTEM 05047697
000088 -SYNC 000300 START OF EXECUTION SYNCPOINT 19681891
000089 ***********************************************************************
000090 -UNLI 000350
000091 TEMPLATE SYRC
000092 DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.'
000093 UNIT SYSDA
000094
000095 UNLOAD FROM TABLE R1BAS504.T_T08APBR
000096 HEADER NONE
000097 (
000098 COLC_1
000099 , COLSI_2
000100 , COLIN_3
000101 , COLSI_4
000102 , COLDC_5
000103 , COLDC_6
000104 , COLDC_7
000105 , COLVC_8
000106 , COLF1_9
000107 , COLF2_10
000108 , COLVC_11
000109 , COLDT_12
000110 , COLTS_13
000111 TIMESTAMP EXTERNAL(32)
000112 , COLC_14
000113 , COLVC_15
000114 )
000115 UNLDDN SYRC
000116 EBCDIC CCSID(37,0,0)
000117 NOPAD MAXERR 1
000118 IMPLICIT_TZ -05:00
000119 60299480
000120 -SYNC 000400 END OF UNLOAD TABLES SECTION 19997881
000121 ***********************************************************************
000122 -SETS 000450 SET CURRENT SQLID = 'RDACRJ' 51183549
000123 -SQL 000500 CREATE DATABASE R1BAS505
000124 STOGROUP SYSDEFLT
000125 BUFFERPOOL BP8K0
000126 77729850
000127 -SETS 000550 SET CURRENT SQLID = USER 28620077
000128 -SYNC 000600 END OF DATABASE SECTION 03759500
000129 ***********************************************************************
000130 -SETS 000650 SET CURRENT SQLID = 'RDACRJ' 51314621
000131 -SQL 000700 CREATE TABLESPACE T08APBR IN R1BAS505
000132 NUMPARTS 4
000133 (PART 1
000134 USING STOGROUP SYSDEFLT
000135 PRIQTY 448
000136 SECQTY 224
000137 PCTFREE 0 FOR UPDATE -1
000138 ,PART 2
000139 USING STOGROUP SYSDEFLT
000140 PRIQTY 448
000141 SECQTY 224
000142 PCTFREE 0 FOR UPDATE -1
000143 ,PART 3
000144 USING STOGROUP SYSDEFLT
000145 PRIQTY 448
000146 SECQTY 224
000147 PCTFREE 0 FOR UPDATE -1
000148 ,PART 4
000149 USING STOGROUP SYSDEFLT
000150 PRIQTY 448
000151 SECQTY 224
000152 PCTFREE 0 FOR UPDATE -1
000153 )
000154 CCSID EBCDIC
000155 BUFFERPOOL BP32K1
000156 LOCKSIZE ANY
000157 LOCKMAX 10
000158 CLOSE NO
000159 SEGSIZE 16
000160 PAGENUM ABSOLUTE
000161 DSSIZE 4G
000162 86783750
000163 -SETS 000750 SET CURRENT SQLID = USER 28751149
000164 -SYNC 000800 END OF CREATE TABLESPACE SECTION 38664373
000165 ***********************************************************************
000166 -SQL 000850 CREATE TABLE RDACRJ.T_T08APBR
000167 (
000168 COLC_1
000169 CHAR(50) NOT NULL
000170 , COLSI_2
000171 SMALLINT NOT NULL
000172 , COLIN_3
000173 INTEGER NOT NULL
000174 , COLSI_4
000175 SMALLINT NOT NULL
000176 , COLDC_5
000177 DECIMAL(6,2) NOT NULL
000178 , COLDC_6
000179 DECIMAL(9,0) NOT NULL
000180 , COLDC_7
000181 DECIMAL(5,2) NOT NULL
000182 , COLVC_8
000183 VARCHAR(15) NOT NULL
000184 , COLF1_9
000185 REAL NOT NULL
000186 , COLF2_10
000187 FLOAT NOT NULL
000188 , COLVC_11
000189 VARCHAR(15) NOT NULL
000190 , COLDT_12
000191 DATE NOT NULL
000192 , COLTS_13
000193 TIMESTAMP NOT NULL
000194 , COLC_14
000195 CHAR(100) NOT NULL
000196 , COLVC_15
000197 VARCHAR(1000) NOT NULL
000198 )
000199 CCSID EBCDIC
000200 IN R1BAS505.T08APBR
000201 PARTITION BY
000202 ( COLC_1
000203 , COLDC_5 )
000204 (PARTITION 1 ENDING AT ('GGG',5.01)
000205 ,PARTITION 2 ENDING AT ('LLL',98.01)
000206 ,PARTITION 3 ENDING AT ('RRR',987.01)
000207 ,PARTITION 4 ENDING AT ('ZZZ',9876.54)
000208 )
000209 14841842
000210 -SYNC 000900 END OF TABLE SECTION 75064548
000211 ***********************************************************************
000212 -SQL 000950 CREATE INDEX
000213 RDACRJ.I_T08APBR2
000214 ON RDACRJ.T_T08APBR
000215 ( COLVC_8
000216 , COLVC_11 )
000217 NOT PADDED
000218 USING STOGROUP SYSDEFLT
000219 PRIQTY 220
000220 SECQTY 120
000221 PCTFREE 0
000222 BUFFERPOOL BP1
000223 CLOSE YES
000224 PIECESIZE 4194304 K
000225 61038175
000226 -SQL 001000 CREATE INDEX
000227 RDACRJ.I_T08APBR_PARTITIONED
000228 ON RDACRJ.T_T08APBR
000229 ( COLC_1
000230 , COLDC_5 )
000231 PARTITIONED
000232 (PART 1
000233 USING STOGROUP SYSDEFLT
000234 PRIQTY 220
000235 SECQTY 120
000236 PCTFREE 0
000237 ,PART 2
000238 USING STOGROUP SYSDEFLT
000239 PRIQTY 220
000240 SECQTY 120
000241 PCTFREE 0
000242 ,PART 3
000243 USING STOGROUP SYSDEFLT
000244 PRIQTY 220
000245 SECQTY 120
000246 PCTFREE 0
000247 ,PART 4
000248 USING STOGROUP SYSDEFLT
000249 PRIQTY 220
000250 SECQTY 120
000251 PCTFREE 0
000252 )
000253 BUFFERPOOL BP1
000254 CLOSE YES
000255 11226127
000256 -SQL 001050 CREATE INDEX
000257 RDACRJ.I_T08APBR_PARTITIONING
000258 ON RDACRJ.T_T08APBR
000259 ( COLC_1
000260 , COLDC_5 )
000261 PARTITIONED
000262 CLUSTER
000263 (PART 1
000264 USING STOGROUP SYSDEFLT
000265 PRIQTY 220
000266 SECQTY 120
000267 PCTFREE 0
000268 ,PART 2
000269 USING STOGROUP SYSDEFLT
000270 PRIQTY 220
000271 SECQTY 120
000272 PCTFREE 0
000273 ,PART 3
000274 USING STOGROUP SYSDEFLT
000275 PRIQTY 220
000276 SECQTY 120
000277 PCTFREE 0
000278 ,PART 4
000279 USING STOGROUP SYSDEFLT
000280 PRIQTY 220
000281 SECQTY 120
000282 PCTFREE 0
000283 )
000284 BUFFERPOOL BP1
000285 CLOSE YES
000286 34539198
000287 -SYNC 001100 END OF CREATE INDEX SECTION 27611337
000288 ***********************************************************************
000289 -LDXT 001150
000290 TEMPLATE SYRC
000291 DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.'
000292 UNIT SYSDA
000293 TEMPLATE SYDS
000294 DSN 'RDACRJ.RCB0831F.SD000001.P&PART.'
000295 UNIT SYSDA
000296 SPACE(1,1) TRK
000297
000298 LOAD DATA REPLACE
000299 ERRDDN SYSER001
000300 DISCARDS 1
000301 EBCDIC CCSID(37,0,0)
000302 WORKDDN SYSUT001
000303 LOG NO
000304 ENFORCE NO
000305 REUSE
000306 INTO TABLE RDACRJ.T_T08APBR
000307 IGNOREFIELDS YES
000308 PART 1 INDDN SYRC
000309 DISCARDDN SYDS
000310 (
000311 COLC_1
000312 POSITION(*) CHAR(50),
000313 COLSI_2
000314 POSITION(*) SMALLINT,
000315 COLIN_3
000316 POSITION(*) INTEGER,
000317 COLSI_4
000318 POSITION(*) SMALLINT,
000319 COLDC_5
000320 POSITION(*) DECIMAL,
000321 COLDC_6
000322 POSITION(*) DECIMAL,
000323 COLDC_7
000324 POSITION(*) DECIMAL,
000325 COLVC_8
000326 POSITION(*) VARCHAR,
000327 COLF1_9
000328 POSITION(*) FLOAT(21),
000329 COLF2_10
000330 POSITION(*) FLOAT(53),
000331 COLVC_11
000332 POSITION(*) VARCHAR,
000333 COLDT_12
000334 POSITION(*) DATE EXTERNAL,
000335 COLTS_13
000336 POSITION(*) TIMESTAMP EXTERNAL(32),
000337 COLC_14
000338 POSITION(*) CHAR(100),
000339 COLVC_15
000340 POSITION(*) VARCHAR)
000341 INTO TABLE RDACRJ.T_T08APBR
000342 IGNOREFIELDS YES
000343 PART 2 INDDN SYRC
000344 DISCARDDN SYDS
000345 (
000346 COLC_1
000347 POSITION(*) CHAR(50),
000348 COLSI_2
000349 POSITION(*) SMALLINT,
000350 COLIN_3
000351 POSITION(*) INTEGER,
000352 COLSI_4
000353 POSITION(*) SMALLINT,
000354 COLDC_5
000355 POSITION(*) DECIMAL,
000356 COLDC_6
000357 POSITION(*) DECIMAL,
000358 COLDC_7
000359 POSITION(*) DECIMAL,
000360 COLVC_8
000361 POSITION(*) VARCHAR,
000362 COLF1_9
000363 POSITION(*) FLOAT(21),
000364 COLF2_10
000365 POSITION(*) FLOAT(53),
000366 COLVC_11
000367 POSITION(*) VARCHAR,
000368 COLDT_12
000369 POSITION(*) DATE EXTERNAL,
000370 COLTS_13
000371 POSITION(*) TIMESTAMP EXTERNAL(32),
000372 COLC_14
000373 POSITION(*) CHAR(100),
000374 COLVC_15
000375 POSITION(*) VARCHAR)
000376 INTO TABLE RDACRJ.T_T08APBR
000377 IGNOREFIELDS YES
000378 PART 3 INDDN SYRC
000379 DISCARDDN SYDS
000380 (
000381 COLC_1
000382 POSITION(*) CHAR(50),
000383 COLSI_2
000384 POSITION(*) SMALLINT,
000385 COLIN_3
000386 POSITION(*) INTEGER,
000387 COLSI_4
000388 POSITION(*) SMALLINT,
000389 COLDC_5
000390 POSITION(*) DECIMAL,
000391 COLDC_6
000392 POSITION(*) DECIMAL,
000393 COLDC_7
000394 POSITION(*) DECIMAL,
000395 COLVC_8
000396 POSITION(*) VARCHAR,
000397 COLF1_9
000398 POSITION(*) FLOAT(21),
000399 COLF2_10
000400 POSITION(*) FLOAT(53),
000401 COLVC_11
000402 POSITION(*) VARCHAR,
000403 COLDT_12
000404 POSITION(*) DATE EXTERNAL,
000405 COLTS_13
000406 POSITION(*) TIMESTAMP EXTERNAL(32),
000407 COLC_14
000408 POSITION(*) CHAR(100),
000409 COLVC_15
000410 POSITION(*) VARCHAR)
000411 INTO TABLE RDACRJ.T_T08APBR
000412 IGNOREFIELDS YES
000413 PART 4 INDDN SYRC
000414 DISCARDDN SYDS
000415 (
000416 COLC_1
000417 POSITION(*) CHAR(50),
000418 COLSI_2
000419 POSITION(*) SMALLINT,
000420 COLIN_3
000421 POSITION(*) INTEGER,
000422 COLSI_4
000423 POSITION(*) SMALLINT,
000424 COLDC_5
000425 POSITION(*) DECIMAL,
000426 COLDC_6
000427 POSITION(*) DECIMAL,
000428 COLDC_7
000429 POSITION(*) DECIMAL,
000430 COLVC_8
000431 POSITION(*) VARCHAR,
000432 COLF1_9
000433 POSITION(*) FLOAT(21),
000434 COLF2_10
000435 POSITION(*) FLOAT(53),
000436 COLVC_11
000437 POSITION(*) VARCHAR,
000438 COLDT_12
000439 POSITION(*) DATE EXTERNAL,
000440 COLTS_13
000441 POSITION(*) TIMESTAMP EXTERNAL(32),
000442 COLC_14
000443 POSITION(*) CHAR(100),
000444 COLVC_15
000445 POSITION(*) VARCHAR)
000446 83701563
000447 -SYNC 001200 LOAD TB RDACRJ.T_T08APBR COMPLETE 71486266
000448 -SYNC 001250 END OF LOAD TABLES SECTION 44823529
000449 ***********************************************************************
000450 -COPY 001300
000451 TEMPLATE DCPYLOCP
000452 DSN 'RDACRJ.&UT..&SN..P&PART..LP000001'
000453 UNIT SYSDA
000454 COPY TABLESPACE R1BAS505.T08APBR
000455 COPYDDN (DCPYLOCP)
000456 58954399
000457 -SYNC 001350 COPY FOR TS R1BAS505.T08APBR COMPLETE 65278264
000458 -SYNC 001400 END OF COPY SECTION 84532178
000459 ***********************************************************************
000460 -SETP 001450 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
000461 ,"SYSIBMADM","RDACRJ" 05112515
000462 -SQL 001500 CREATE VIEW RDACRJ.V_T08APBR1
000463 ( COLC_1
000464 , SI2
000465 , IN3
000466 , SI4
000467 , DC5
000468 , DC6
000469 , DC7
000470 , VC8
000471 , F1
000472 , F2
000473 , VC11
000474 , DT12
000475 , TS13
000476 , C14
000477 , VC15 )
000478 AS SELECT *
000479 FROM RDACRJ.T_T08APBR
000480 WHERE COLDC_5 > 1 AND COLVC_11 <> 'HOHOHO'
000481 58617621
000482 -SETP 001550 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
000483 ,"SYSIBMADM","RDACRJ" 05046979
000484 -SQL 001600 CREATE VIEW RDACRJ.V_T08APBR2
000485 AS SELECT CONCAT(T5.COLVC_15, ' HOHOHO ' ) AS C1, COLDC_5, CASE WHEN
000486 COLIN_3 >= 999
000487 THEN CONCAT (T5.COLC_1, T5.COLC_14 ) CONCAT ('HOLIDAYS' ) WHEN
000488 COLIN_3 < 999
000489 THEN 'BIG'
000490 END AS CAT1, COLDT_12
000491 FROM RDACRJ.T_T08APBR T5
000492 WHERE COLDT_12 > '03/11/1989'
000493 56566522
000494 -SETP 001650 SET CURRENT PATH = SYSTEM PATH 07111604
000495 -SYNC 001700 END OF CREATE VIEW NOT DEPENDENT ON MQT SECTION 67572734
000496 ***********************************************************************
000497 -RNST 001750
000498 RUNSTATS TABLESPACE R1BAS505.T08APBR
000499 HISTORY NONE
000500 INDEX (ALL)
000501 TABLE ALL
000502 55545886
000503 -SYNC 001800 STATS FOR TS R1BAS505.T08APBR COMPLETE 65734838
000504 -SYNC 001850 END OF TABLESPACE STATISTICS SECTION 58618955
000505 ***********************************************************************
****** **************************** Bottom of Data ****************************Press END.The Execution JCL Build Interface panel is displayed, as shown in the following figure:
ACMFEXC0 ------------------ Execution JCL Build Interface ---------------------
Command ===>
WORKID . . . . . : RDACRJ.RCB0831F
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 worklist.The Execution component executes the migrate worklist in a single phase. First, the data is unloaded from the objects. Then, the objects are created, the data is loaded, and the utilities are executed.
The Execution component of the product uses the worklist as its input job stream and performs the tasks contained in the worklist. The worklist acts as a detailed procedure for implementing the changes that you defined in the specification stage.
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.RCB0831F
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 ENDOn 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.RCB0831F
Specify Dataset Names.
Execution JCL . . 'ACM.DB2V12.V121.EXECJCL(RCB0831F)'
Worklist . . . . . 'ACM.DB2V12.V121.WLBASE01(RCB0831F)'
Diagnostics . . . SYSOUT
JCL Build Options.
Dataset Sizing : No Sizing (use Override Defaults to set or change)
Select Processing Options. Then press Enter to continue.
_ Override Defaults
_ Edit Worklist
S Build Execution JCL
S Edit Execution JCL
_ Submit Execution JCL
Commands: BROWSE VIEWX PREVIOUS HELP ENDOn the Execution JCL Processing Interface panel, specify your data set names, specify SYSOUT for diagnostics, accept the defaults for your build option, and type S to select your processing options. Press Enter.The Execution JCL is displayed. The JCL includes the //AEXIN DD statement (input stream), which includes keywords that are used in executing the JCL. For more information about the input stream, see AEXIN-keywords.
000001 //RDACRJE JOB (5715),'EXECUTE-RCB0831F',
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.16.42.02
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.RCB0831F
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 //***************************************************
000067 //ACT$MSGS DD DSN=AEX.QA1211.BMCMLIB,DISP=SHR
000068 //***************************************************
000069 //ISPMLIB DD DSN=AEX.QA1211.BMCMLIB,DISP=SHR
000070 //ISPSLIB DD DSN=AEX.QA1211.BMCSLIB,DISP=SHR
000071 //ISPTLIB DD DSN=AEX.QA1211.BMCTLIB,DISP=SHR
000072 //ISPPLIB DD DSN=AEX.QA1211.BMCPLIB,DISP=SHR
000073 //AEXPRINT DD SYSOUT=*
000074 //WORKLIST DD DISP=SHR,
000075 // DSN=ACM.DB2V12.V121.WLBASE01(RCB0831F)
000076 //*-----------------------------------------
000077 //*--------------------------------------------------------------------
000078 //* UTILITY WORK DD STATEMENTS
000079 //*--------------------------------------------------------------------
000080 //SYSUT001 DD DSN=RDACRJ.RCB0831F.STEP1.SYSUT001,
000081 // DISP=(NEW,CATLG,CATLG),
000082 // SPACE=(CYL,(10,2)),
000083 // UNIT=SYSDA
000084 //*--------------------------------------------------------------------
000085 //* UTILITY SORTOUT WORK DD STATEMENTS
000086 //*--------------------------------------------------------------------
000087 //SORTOUT DD DSN=RDACRJ.RCB0831F.STEP1.SORTOUT,
000088 // DISP=(NEW,CATLG,CATLG),
000089 // SPACE=(CYL,(10,2)),
000090 // UNIT=SYSDA
000091 //*--------------------------------------------------------------------
000092 //* MAPDDN OUTPUT DD STATEMENTS
000093 //*--------------------------------------------------------------------
000094 //SYSMAP DD DSN=RDACRJ.RCB0831F.DELT.SYSMAP,
000095 // DISP=(NEW,CATLG,CATLG),
000096 // SPACE=(CYL,(10,2)),
000097 // UNIT=SYSDA
000098 //*--------------------------------------------------------------------
000099 //* ERRDDN OUTPUT DD STATEMENTS
000100 //*--------------------------------------------------------------------
000101 //SYSER001 DD DSN=RDACRJ.RCB0831F.STEP1.SYSER001,
000102 // DISP=(NEW,CATLG,CATLG),
000103 // SPACE=(CYL,(10,2),RLSE),
000104 // UNIT=SYSDA
000105 //*--------------------------------------------------------------------
000106 //* SORT WORK DD STATEMENTS
000107 //*--------------------------------------------------------------------
000108 //* ESTIMATE /N
000109 //SORTWK01 DD SPACE=(CYL,(10,2)),
000110 // UNIT=SYSDA,
000111 // DISP=(NEW,DELETE)
000112 //* ESTIMATE /N
000113 //SORTWK02 DD SPACE=(CYL,(10,2)),
000114 // UNIT=SYSDA,
000115 // DISP=(NEW,DELETE)
000116 //* ESTIMATE /N
000117 //SORTWK03 DD SPACE=(CYL,(10,2)),
000118 // UNIT=SYSDA,
000119 // DISP=(NEW,DELETE)
000120 //* ESTIMATE /N
000121 //SORTWK04 DD SPACE=(CYL,(10,2)),
000122 // UNIT=SYSDA,
000123 // DISP=(NEW,DELETE)
000124 //* ESTIMATE /N
000125 //SORTWK05 DD SPACE=(CYL,(10,2)),
000126 // UNIT=SYSDA,
000127 // DISP=(NEW,DELETE)
000128 //*--------------------------------------------------------------------
000129 //* END OF JOBSTEP
000130 //*--------------------------------------------------------------------
000131 //*--------------------------------------------------------------------
000132 //* END OF JOB
000133 //*--------------------------------------------------------------------
000134 **************************** Bottom of Data ****************************- After you review the JCL, press END to return to the Execution JCL Processing Interface panel.
- From the Execution JCL Processing Interface panel, press Enter to submit the JCL and migrate your objects.The result of execution is a worklist execution log (AEXPRINT).
To review the results of execution in the worklist execution log (AEXPRINT), you can split your ISPF session or you can use your normal method to review SYSOUT. The following figure shows the worklist execution log.The last message in the worklist indicates that the work ID status is complete and that the worklist completed successfully. The worklist migrated the objects that you specified.
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 16.51.26 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.RCB0831F
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(RCB0831F)'
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.RCB0831F IS 'N' (NOT STARTED
BMC16999I UPDATED WORKID STATUS FOR RDACRJ.RCB0831F 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.RCB0831F *
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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 2
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:* INCLUDE (DATA SQL AMS ) *
0:* SORTDEVT SYSDA *
0:* SMSINCLUDE ( ) *
0:* IBMUNLOAD IBMLOAD NOUSENGTUL *
0:* IBMREORG NOUSENGTR *
0:* IBMREBUILD *
0:* STANDALONESTATS DB2STATSUPD TABLEALL *
0:* NOHISTORY *
0:* IBMCOPY *
0:* NOUTILCOPY *
0:* DYNUNLD *
0:* DYNCOPY *
0:* NOPARTCOPY *
0:* COPYDDN (COPY01 ) *
0:* NOREGENIDENTITY *
0:* SINGLEPHASE *
0:* NOVVALPROP *
0:* IBMCHECK *
0:* SYNCPOINT 10 *
0:* NODBRMLIB *
0:* ORDERBY *
0:* UNLOADTABLE *
0:* UNLOADEMPTY *
0:* NOSTOPCOMMIT *
0:* TABLEACCESS *
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V12.01.01
(C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
2020-08-31 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 3
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:* NOAPPLCOVR *
0:* NOPARALLEL *
0:* REORGONLINE *
0:* NOKEYCARD *
0:* REORGALL *
0:* REORGREF *
0:* DYNREORG *
0:* NOROLEOWN *
0:* CLONEDATA *
0:* SPANNEDRECS *
0:* NOBINDONIX *
0:***********************************************************************
0:-TIME 000050 '2020-08-31-16.36.29.628305' 42847006
0:-SSID 000100 DELT 27049871
0:-JCLP 000150 MIGR MSSID DELT 79212468
BMC16511I -JCLP IGNORED IN THIS RUN. SKIPPING WORKLIST RECORDS UNTIL NEXT COMMAND
0:-WKID 000200 RDACRJ.RCB0831F 27192480
0:***********************************************************************
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
0:*BMC56464I APPLCOMPAT IS V12R1M504
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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 4
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
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:*BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
0:* REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
0:* PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
0:* ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
0:* INPUT STREAM.
0:***********************************************************************
0:*** END OF WARNING MESSAGES - WARNINGS WERE ISSUED ***
0:***********************************************************************
0:*** ORIGINATOR OF WORKLIST WAS WORKID RDACRJ.RCB0831F ON SSID DELT ***
0:-MIGR 000250 PHASE-1 START OF SECTION TO BE RUN ON SENDING SYSTEM 05047697
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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 5
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-SYNC 000300 START OF EXECUTION SYNCPOINT 19681891
0:***********************************************************************
0:-UNLI 000350
: TEMPLATE SYRC
: DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.'
: UNIT SYSDA
:
: UNLOAD FROM TABLE R1BAS504.T_T08APBR
: HEADER NONE
: (
: COLC_1
: , COLSI_2
: , COLIN_3
: , COLSI_4
: , COLDC_5
: , COLDC_6
: , COLDC_7
: , COLVC_8
: , COLF1_9
: , COLF2_10
: , COLVC_11
: , COLDT_12
: , COLTS_13
: TIMESTAMP EXTERNAL(32)
: , COLC_14
: , COLVC_15
: )
: UNLDDN SYRC
: EBCDIC CCSID(37,0,0)
: NOPAD MAXERR 1
: IMPLICIT_TZ -05:00
: 60299480
BMC16815I PARAMETERS: DELT,RCB0831F
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 244 16:51:26.54 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831F
DSNU1044I 244 16:51:26.56 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 244 16:51:26.56 DSNUGUTC - TEMPLATE SYRC DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.' UNIT SYSDA
DSNU1035I 244 16:51:26.57 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 244 16:51:26.57 DSNUGUTC - UNLOAD
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - FROM TABLE R1BAS504.T_T08APBR HEADER NONE
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - (COLC_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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 6
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLSI_2,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLIN_3,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLSI_4,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLDC_5,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLDC_6,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLDC_7,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLVC_8,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLF1_9,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLF2_10,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLVC_11,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLDT_12,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLTS_13 TIMESTAMP EXTERNAL(32),
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLC_14,
DSNU650I *DELT 244 16:51:26.57 DSNUUGMS - COLVC_15) UNLDDN SYRC EBCDIC CCSID(37, 0, 0) NOPAD MAXERR 1
IMPLICIT_TZ -5:0
DSNU1201I 244 16:51:26.57 DSNUUNLD - PARTITIONS WILL BE UNLOADED IN PARALLEL, NUMBER OF TASKS = 3
DSNU3345I 244 16:51:26.57 DSNUUNLD - MAXIMUM PARTITION PARALLELISM IS 4 BASED ON NUMBER OF PARTITIONS
DSNU397I 244 16:51:26.57 DSNUUNLD - NUMBER OF TASKS CONSTRAINED BY CPUS TO 3
DSNU1038I 244 16:51:26.59 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00008
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00001
DSNU1038I 244 16:51:26.68 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00009
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00002
DSNU1038I 244 16:51:26.70 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00010
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00003
DSNU251I 244 16:51:26.72 DSNUULPB - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLESPACE
R1BAS504.T08APBR PART 1
DSNU1038I 244 16:51:26.84 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00011
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00004
DSNU251I 244 16:51:26.88 DSNUULPB - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
R1BAS504.T08APBR PART 2
DSNU251I 244 16:51:26.89 DSNUULPB - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
R1BAS504.T08APBR PART 3
DSNU251I 244 16:51:26.90 DSNUULPB - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
R1BAS504.T08APBR PART 4
DSNU253I 244 16:51:26.90 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLE
R1BAS504.T_T08APBR
DSNU252I 244 16:51:26.90 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=1 FOR TABLESPACE
R1BAS504.T08APBR
DSNU250I 244 16:51:26.90 DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU010I 244 16:51:26.91 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 000400 END OF UNLOAD TABLES SECTION 19997881
0:***********************************************************************
0:-SETS 000450 SET CURRENT SQLID = 'RDACRJ' 51183549
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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 7
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000500 CREATE DATABASE R1BAS505
: STOGROUP SYSDEFLT
: BUFFERPOOL BP8K0
: 77729850
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETS 000550 SET CURRENT SQLID = USER 28620077
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 000600 END OF DATABASE SECTION 03759500
0:***********************************************************************
0:-SETS 000650 SET CURRENT SQLID = 'RDACRJ' 51314621
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000700 CREATE TABLESPACE T08APBR IN R1BAS505
: NUMPARTS 4
: (PART 1
: USING STOGROUP SYSDEFLT
: PRIQTY 448
: SECQTY 224
: PCTFREE 0 FOR UPDATE -1
: ,PART 2
: USING STOGROUP SYSDEFLT
: PRIQTY 448
: SECQTY 224
: PCTFREE 0 FOR UPDATE -1
: ,PART 3
: USING STOGROUP SYSDEFLT
: PRIQTY 448
: SECQTY 224
: PCTFREE 0 FOR UPDATE -1
: ,PART 4
: USING STOGROUP SYSDEFLT
: PRIQTY 448
: SECQTY 224
: PCTFREE 0 FOR UPDATE -1
: )
: CCSID EBCDIC
: BUFFERPOOL BP32K1
: LOCKSIZE ANY
: LOCKMAX 10
: CLOSE NO
: SEGSIZE 16
: PAGENUM ABSOLUTE
: DSSIZE 4G
: 86783750
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 16.51.26 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 8
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETS 000750 SET CURRENT SQLID = USER 28751149
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 000800 END OF CREATE TABLESPACE SECTION 38664373
0:***********************************************************************
0:-SQL 000850 CREATE TABLE RDACRJ.T_T08APBR
: (
: COLC_1
: CHAR(50) NOT NULL
: , COLSI_2
: SMALLINT NOT NULL
: , COLIN_3
: INTEGER NOT NULL
: , COLSI_4
: SMALLINT NOT NULL
: , COLDC_5
: DECIMAL(6,2) NOT NULL
: , COLDC_6
: DECIMAL(9,0) NOT NULL
: , COLDC_7
: DECIMAL(5,2) NOT NULL
: , COLVC_8
: VARCHAR(15) NOT NULL
: , COLF1_9
: REAL NOT NULL
: , COLF2_10
: FLOAT NOT NULL
: , COLVC_11
: VARCHAR(15) NOT NULL
: , COLDT_12
: DATE NOT NULL
: , COLTS_13
: TIMESTAMP NOT NULL
: , COLC_14
: CHAR(100) NOT NULL
: , COLVC_15
: VARCHAR(1000) NOT NULL
: )
: CCSID EBCDIC
: IN R1BAS505.T08APBR
: PARTITION BY
: ( COLC_1
: , COLDC_5 )
: (PARTITION 1 ENDING AT ('GGG',5.01)
: ,PARTITION 2 ENDING AT ('LLL',98.01)
: ,PARTITION 3 ENDING AT ('RRR',987.01)
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 16.51.27 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 9
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: ,PARTITION 4 ENDING AT ('ZZZ',9876.54)
: )
: 14841842
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 000900 END OF TABLE SECTION 75064548
0:***********************************************************************
0:-SQL 000950 CREATE INDEX
: RDACRJ.I_T08APBR2
: ON RDACRJ.T_T08APBR
: ( COLVC_8
: , COLVC_11 )
: NOT PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: BUFFERPOOL BP1
: CLOSE YES
: PIECESIZE 4194304 K
: 61038175
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001000 CREATE INDEX
: RDACRJ.I_T08APBR_PARTITIONED
: ON RDACRJ.T_T08APBR
: ( COLC_1
: , COLDC_5 )
: PARTITIONED
: (PART 1
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 2
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 3
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 4
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
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 16.51.27 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 10
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: PCTFREE 0
: )
: BUFFERPOOL BP1
: CLOSE YES
: 11226127
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001050 CREATE INDEX
: RDACRJ.I_T08APBR_PARTITIONING
: ON RDACRJ.T_T08APBR
: ( COLC_1
: , COLDC_5 )
: PARTITIONED
: CLUSTER
: (PART 1
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 2
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 3
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: ,PART 4
: USING STOGROUP SYSDEFLT
: PRIQTY 220
: SECQTY 120
: PCTFREE 0
: )
: BUFFERPOOL BP1
: CLOSE YES
: 34539198
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 001100 END OF CREATE INDEX SECTION 27611337
0:***********************************************************************
0:-LDXT 001150
: TEMPLATE SYRC
: DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.'
: UNIT SYSDA
: TEMPLATE SYDS
: DSN 'RDACRJ.RCB0831F.SD000001.P&PART.'
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 16.51.28 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 11
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: UNIT SYSDA
: SPACE(1,1) TRK
:
: LOAD DATA REPLACE
: ERRDDN SYSER001
: DISCARDS 1
: EBCDIC CCSID(37,0,0)
: WORKDDN SYSUT001
: LOG NO
: ENFORCE NO
: REUSE
: INTO TABLE RDACRJ.T_T08APBR
: IGNOREFIELDS YES
: PART 1 INDDN SYRC
: DISCARDDN SYDS
: (
: COLC_1
: POSITION(*) CHAR(50),
: COLSI_2
: POSITION(*) SMALLINT,
: COLIN_3
: POSITION(*) INTEGER,
: COLSI_4
: POSITION(*) SMALLINT,
: COLDC_5
: POSITION(*) DECIMAL,
: COLDC_6
: POSITION(*) DECIMAL,
: COLDC_7
: POSITION(*) DECIMAL,
: COLVC_8
: POSITION(*) VARCHAR,
: COLF1_9
: POSITION(*) FLOAT(21),
: COLF2_10
: POSITION(*) FLOAT(53),
: COLVC_11
: POSITION(*) VARCHAR,
: COLDT_12
: POSITION(*) DATE EXTERNAL,
: COLTS_13
: POSITION(*) TIMESTAMP EXTERNAL(32),
: COLC_14
: POSITION(*) CHAR(100),
: COLVC_15
: POSITION(*) VARCHAR)
: INTO TABLE RDACRJ.T_T08APBR
: IGNOREFIELDS YES
: PART 2 INDDN SYRC
: DISCARDDN SYDS
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 16.51.28 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 12
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: (
: COLC_1
: POSITION(*) CHAR(50),
: COLSI_2
: POSITION(*) SMALLINT,
: COLIN_3
: POSITION(*) INTEGER,
: COLSI_4
: POSITION(*) SMALLINT,
: COLDC_5
: POSITION(*) DECIMAL,
: COLDC_6
: POSITION(*) DECIMAL,
: COLDC_7
: POSITION(*) DECIMAL,
: COLVC_8
: POSITION(*) VARCHAR,
: COLF1_9
: POSITION(*) FLOAT(21),
: COLF2_10
: POSITION(*) FLOAT(53),
: COLVC_11
: POSITION(*) VARCHAR,
: COLDT_12
: POSITION(*) DATE EXTERNAL,
: COLTS_13
: POSITION(*) TIMESTAMP EXTERNAL(32),
: COLC_14
: POSITION(*) CHAR(100),
: COLVC_15
: POSITION(*) VARCHAR)
: INTO TABLE RDACRJ.T_T08APBR
: IGNOREFIELDS YES
: PART 3 INDDN SYRC
: DISCARDDN SYDS
: (
: COLC_1
: POSITION(*) CHAR(50),
: COLSI_2
: POSITION(*) SMALLINT,
: COLIN_3
: POSITION(*) INTEGER,
: COLSI_4
: POSITION(*) SMALLINT,
: COLDC_5
: POSITION(*) DECIMAL,
: COLDC_6
: POSITION(*) DECIMAL,
: COLDC_7
: POSITION(*) DECIMAL,
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 16.51.28 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 13
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: COLVC_8
: POSITION(*) VARCHAR,
: COLF1_9
: POSITION(*) FLOAT(21),
: COLF2_10
: POSITION(*) FLOAT(53),
: COLVC_11
: POSITION(*) VARCHAR,
: COLDT_12
: POSITION(*) DATE EXTERNAL,
: COLTS_13
: POSITION(*) TIMESTAMP EXTERNAL(32),
: COLC_14
: POSITION(*) CHAR(100),
: COLVC_15
: POSITION(*) VARCHAR)
: INTO TABLE RDACRJ.T_T08APBR
: IGNOREFIELDS YES
: PART 4 INDDN SYRC
: DISCARDDN SYDS
: (
: COLC_1
: POSITION(*) CHAR(50),
: COLSI_2
: POSITION(*) SMALLINT,
: COLIN_3
: POSITION(*) INTEGER,
: COLSI_4
: POSITION(*) SMALLINT,
: COLDC_5
: POSITION(*) DECIMAL,
: COLDC_6
: POSITION(*) DECIMAL,
: COLDC_7
: POSITION(*) DECIMAL,
: COLVC_8
: POSITION(*) VARCHAR,
: COLF1_9
: POSITION(*) FLOAT(21),
: COLF2_10
: POSITION(*) FLOAT(53),
: COLVC_11
: POSITION(*) VARCHAR,
: COLDT_12
: POSITION(*) DATE EXTERNAL,
: COLTS_13
: POSITION(*) TIMESTAMP EXTERNAL(32),
: COLC_14
: POSITION(*) CHAR(100),
: COLVC_15
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 16.51.28 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 14
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: POSITION(*) VARCHAR)
: 83701563
BMC16815I PARAMETERS: DELT,RCB0831F
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 4
0BMC16820W SUBTASK DSNUTILB RC NOT 0, RETURN CODE WAS: X'00000004'
0DSNU000I 244 16:51:28.28 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831F
DSNU1044I 244 16:51:28.29 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 244 16:51:28.31 DSNUGUTC - TEMPLATE SYRC DSN 'RDACRJ.DELT.RCB0831F.SR000001.P&PART.' UNIT SYSDA
DSNU1035I 244 16:51:28.31 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 244 16:51:28.31 DSNUGUTC - TEMPLATE SYDS DSN 'RDACRJ.RCB0831F.SD000001.P&PART.' UNIT SYSDA SPACE(1, 1)
TRK
DSNU1035I 244 16:51:28.31 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 244 16:51:28.31 DSNUGUTC - LOAD DATA REPLACE ERRDDN SYSER001 DISCARDS 1 EBCDIC CCSID(37, 0, 0) WORKDDN
SYSUT001 LOG NO ENFORCE NO REUSE
DSNU650I *DELT 244 16:51:28.32 DSNURWI - INTO TABLE RDACRJ.T_T08APBR IGNOREFIELDS YES PART 1 INDDN SYRC DISCARDDN
SYDS
DSNU650I *DELT 244 16:51:28.32 DSNURWI - (COLC_1 POSITION(*) CHAR(50),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_2 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLIN_3 POSITION(*) INTEGER,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_4 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_5 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_6 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_7 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_8 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF1_9 POSITION(*) FLOAT(21),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF2_10 POSITION(*) FLOAT(53),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_11 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDT_12 POSITION(*) DATE EXTERNAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLTS_13 POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLC_14 POSITION(*) CHAR(100),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_15 POSITION(*) VARCHAR)
DSNU650I *DELT 244 16:51:28.32 DSNURWI - INTO TABLE RDACRJ.T_T08APBR IGNOREFIELDS YES PART 2 INDDN SYRC DISCARDDN
SYDS
DSNU650I *DELT 244 16:51:28.32 DSNURWI - (COLC_1 POSITION(*) CHAR(50),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_2 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLIN_3 POSITION(*) INTEGER,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_4 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_5 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_6 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_7 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_8 POSITION(*) VARCHAR,
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 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 15
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF1_9 POSITION(*) FLOAT(21),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF2_10 POSITION(*) FLOAT(53),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_11 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDT_12 POSITION(*) DATE EXTERNAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLTS_13 POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLC_14 POSITION(*) CHAR(100),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_15 POSITION(*) VARCHAR)
DSNU650I *DELT 244 16:51:28.32 DSNURWI - INTO TABLE RDACRJ.T_T08APBR IGNOREFIELDS YES PART 3 INDDN SYRC DISCARDDN
SYDS
DSNU650I *DELT 244 16:51:28.32 DSNURWI - (COLC_1 POSITION(*) CHAR(50),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_2 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLIN_3 POSITION(*) INTEGER,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_4 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_5 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_6 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_7 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_8 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF1_9 POSITION(*) FLOAT(21),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF2_10 POSITION(*) FLOAT(53),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_11 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDT_12 POSITION(*) DATE EXTERNAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLTS_13 POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLC_14 POSITION(*) CHAR(100),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_15 POSITION(*) VARCHAR)
DSNU650I *DELT 244 16:51:28.32 DSNURWI - INTO TABLE RDACRJ.T_T08APBR IGNOREFIELDS YES PART 4 INDDN SYRC DISCARDDN
SYDS
DSNU650I *DELT 244 16:51:28.32 DSNURWI - (COLC_1 POSITION(*) CHAR(50),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_2 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLIN_3 POSITION(*) INTEGER,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLSI_4 POSITION(*) SMALLINT,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_5 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_6 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDC_7 POSITION(*) DECIMAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_8 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF1_9 POSITION(*) FLOAT(21),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLF2_10 POSITION(*) FLOAT(53),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_11 POSITION(*) VARCHAR,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLDT_12 POSITION(*) DATE EXTERNAL,
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLTS_13 POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLC_14 POSITION(*) CHAR(100),
DSNU650I *DELT 244 16:51:28.32 DSNURWI - COLVC_15 POSITION(*) VARCHAR)
DSNU1038I 244 16:51:28.34 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00012
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00001
DSNU1038I 244 16:51:28.57 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYDS
DDNAME=SYS00013
DSN=RDACRJ.RCB0831F.SD000001.P00001
DSNU1038I 244 16:51:28.57 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00014
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00002
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 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 16
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU1038I 244 16:51:28.63 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYDS
DDNAME=SYS00015
DSN=RDACRJ.RCB0831F.SD000001.P00002
DSNU1038I 244 16:51:28.64 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00016
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00003
DSNU1038I 244 16:51:28.69 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYDS
DDNAME=SYS00017
DSN=RDACRJ.RCB0831F.SD000001.P00003
DSNU1038I 244 16:51:28.70 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00018
DSN=RDACRJ.DELT.RCB0831F.SR000001.P00004
DSNU1038I 244 16:51:28.76 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYDS
DDNAME=SYS00019
DSN=RDACRJ.RCB0831F.SD000001.P00004
DSNU350I *DELT 244 16:51:29.18 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
DSNU3345I 244 16:51:29.24 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 10 BASED ON NUMBER OF PARTITIONS AND INDEXES
DSNU397I 244 16:51:29.24 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY MISSING SORTDEVT TO 6
DSNU364I 244 16:51:29.24 DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF TASKS = 4
DSNU3345I 244 16:51:29.24 DSNURPPL - MAXIMUM PARTITION PARALLELISM IS 4 BASED ON NUMBER OF INPUT FILES
DSNU1148I 244 16:51:29.52 DSNURPLD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0 FOR PART 2
DSNU1148I 244 16:51:29.52 DSNURPLD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0 FOR PART 4
DSNU1148I 244 16:51:29.52 DSNURPLD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1 FOR PART 1
DSNU1148I 244 16:51:29.52 DSNURPLD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0 FOR PART 3
DSNU303I *DELT 244 16:51:29.60 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1 FOR TABLE RDACRJ.T_T08APBR
PART=1
DSNU303I *DELT 244 16:51:29.60 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE RDACRJ.T_T08APBR
PART=2
DSNU303I *DELT 244 16:51:29.60 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE RDACRJ.T_T08APBR
PART=3
DSNU303I *DELT 244 16:51:29.60 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE RDACRJ.T_T08APBR
PART=4
DSNU1147I *DELT 244 16:51:29.60 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=1 FOR TABLESPACE
R1BAS505.T08APBR
DSNU302I 244 16:51:29.61 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1
DSNU300I 244 16:51:29.61 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU042I 244 16:51:29.61 DSNUGSOR - SORT PHASE STATISTICS -
NUMBER OF RECORDS=3
ELAPSED TIME=00:00:00
DSNU349I *DELT 244 16:51:29.64 DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX RDACRJ.I_T08APBR2
DSNU348I *DELT 244 16:51:29.66 DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX
RDACRJ.I_T08APBR_PARTITIONED PART 1
DSNU348I *DELT 244 16:51:29.68 DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=1 FOR INDEX
RDACRJ.I_T08APBR_PARTITIONING PART 1
DSNU258I 244 16:51:29.68 DSNURBXD - BUILD PHASE STATISTICS - NUMBER OF INDEXES=3
DSNU259I 244 16:51:29.68 DSNURBXD - BUILD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU3350I 244 16:51:29.70 DSNUGSOR - SORT TASK SORT: 3 RECORDS SORTED, ESTIMATED 138, VARIATION 98 PERCENT
DSNU3352I 244 16:51:29.70 DSNUGSOR - SORT TASK SORT: USED DFSORT
DSNU3354I 244 16:51:29.70 DSNUGSOR - SORT TASK SORT: MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU380I *DELT 244 16:51:29.99 DSNUGSRX - TABLESPACE R1BAS505.T08APBR PARTITION 1 IS IN COPY PENDING
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V12.01.01
(C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
2020-08-31 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 17
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU380I *DELT 244 16:51:29.99 DSNUGSRX - TABLESPACE R1BAS505.T08APBR PARTITION 2 IS IN COPY PENDING
DSNU380I *DELT 244 16:51:29.99 DSNUGSRX - TABLESPACE R1BAS505.T08APBR PARTITION 3 IS IN COPY PENDING
DSNU380I *DELT 244 16:51:29.99 DSNUGSRX - TABLESPACE R1BAS505.T08APBR PARTITION 4 IS IN COPY PENDING
DSNU3357I 244 16:51:29.99 DSNUGUTC - MAXIMUM SORT AMOUNT ESTIMATION VARIATION WAS 98 PERCENT
DSNU3355I 244 16:51:29.99 DSNUGUTC - TOTAL SORT MEMORY BELOW THE BAR: OPTIMAL 6 MB, USED 6 MB
DSNU010I 244 16:51:30.00 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
0:-SYNC 001200 LOAD TB RDACRJ.T_T08APBR COMPLETE 71486266
0:-SYNC 001250 END OF LOAD TABLES SECTION 44823529
0:***********************************************************************
0:-COPY 001300
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000001'
: UNIT SYSDA
: COPY TABLESPACE R1BAS505.T08APBR
: COPYDDN (DCPYLOCP)
: 58954399
BMC16815I PARAMETERS: DELT,RCB0831F
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 244 16:51:30.12 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831F
DSNU1044I 244 16:51:30.13 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 244 16:51:30.14 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000001' UNIT SYSDA
DSNU1035I 244 16:51:30.14 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 244 16:51:30.14 DSNUGUTC - COPY TABLESPACE R1BAS505.T08APBR COPYDDN(DCPYLOCP)
DSNU1038I 244 16:51:30.22 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00020
DSN=RDACRJ.RCB0831F.T08APBR.P00000.LP000001
DSNU400I 244 16:51:30.32 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1BAS505.T08APBR
NUMBER OF PAGES=13
AVERAGE PERCENT FREE SPACE PER PAGE = 7.61
PERCENT OF CHANGED PAGES = 14.28
ELAPSED TIME=00:00:00
DSNU428I *DELT 244 16:51:30.34 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1BAS505.T08APBR
DSNU010I 244 16:51:30.34 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 001350 COPY FOR TS R1BAS505.T08APBR COMPLETE 65278264
0:-SYNC 001400 END OF COPY SECTION 84532178
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 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 18
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-SETP 001450 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM","RDACRJ" 05112515
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001500 CREATE VIEW RDACRJ.V_T08APBR1
: ( COLC_1
: , SI2
: , IN3
: , SI4
: , DC5
: , DC6
: , DC7
: , VC8
: , F1
: , F2
: , VC11
: , DT12
: , TS13
: , C14
: , VC15 )
: AS SELECT *
: FROM RDACRJ.T_T08APBR
: WHERE COLDC_5 > 1 AND COLVC_11 <> 'HOHOHO'
: 58617621
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 001550 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM","RDACRJ" 05046979
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001600 CREATE VIEW RDACRJ.V_T08APBR2
: AS SELECT CONCAT(T5.COLVC_15, ' HOHOHO ' ) AS C1, COLDC_5, CASE WHEN
: COLIN_3 >= 999
: THEN CONCAT (T5.COLC_1, T5.COLC_14 ) CONCAT ('HOLIDAYS' ) WHEN
: COLIN_3 < 999
: THEN 'BIG'
: END AS CAT1, COLDT_12
: FROM RDACRJ.T_T08APBR T5
: WHERE COLDT_12 > '03/11/1989'
: 56566522
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 001650 SET CURRENT PATH = SYSTEM PATH 07111604
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 001700 END OF CREATE VIEW NOT DEPENDENT ON MQT SECTION 67572734
0:***********************************************************************
0:-RNST 001750
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 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 19
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: RUNSTATS TABLESPACE R1BAS505.T08APBR
: HISTORY NONE
: INDEX (ALL)
: TABLE ALL
: 55545886
BMC16815I PARAMETERS: DELT,RCB0831F
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 244 16:51:30.46 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RCB0831F
DSNU1044I 244 16:51:30.48 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 244 16:51:30.48 DSNUGUTC - RUNSTATS TABLESPACE R1BAS505.T08APBR HISTORY NONE INDEX(ALL) TABLE ALL
DSNU610I *DELT 244 16:51:30.79 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1BAS505.T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.79 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR RDACRJ.T_T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.80 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ.T_T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.80 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR RDACRJ.T_T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.80 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ.T_T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.81 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1BAS505.T08APBR SUCCESSFUL
DSNU610I *DELT 244 16:51:30.82 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.82 DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.83 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.83 DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.83 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ.I_T08APBR2 SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUPI - SYSINDEXSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUPD - SYSCOLDISTSTATS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ.I_T08APBR2 SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ.I_T08APBR2 SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONING SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR RDACRJ.I_T08APBR2 SUCCESSFUL
DSNU610I *DELT 244 16:51:30.84 DSNUSUCD - SYSCOLDIST CATALOG UPDATE FOR RDACRJ.I_T08APBR_PARTITIONED SUCCESSFUL
DSNU620I *DELT 244 16:51:30.84 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2020-08-31-16.51.30.490700
DSNU010I 244 16:51:30.85 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 001800 STATS FOR TS R1BAS505.T08APBR COMPLETE 65734838
0:-SYNC 001850 END OF TABLESPACE STATISTICS SECTION 58618955
0:***********************************************************************
BMC16999I UPDATED WORKID STATUS FOR RDACRJ.RCB0831F 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: V12.01.01
(C) COPYRIGHT 1991 - 2020 BMC SOFTWARE, INC.
2020-08-31 16.51.30 ON SYSID DB2A WORKLIST EXECUTION LOG PAGE 20
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------- Press END to return to the Migrate DB2 Objects Using Specification panel.
- Press END to return to the Task List Menu panel.
- Press END to return to the BMC AMI Change Manager for Db2 Main Menu.
This example shows that with Change Manager you have the ability to quickly and accurately specify objects that you want to migrate to another environment, perform an in-depth analysis of the objects selected to determine their effect on your subsystem, and execute SQL statements, utilities, and other commands.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*