Example 28: Using XCOPYDEL option with MODIFY to remove orphaned rows from BMCXCOPY

This job example uses XCOPYDEL option with MODIFY to remove orphaned rows from BMCXCOPY.

SYSPRINT from a SELECT statement to BMCXCOPY prior to the XCOPYDEL YES command

   +-------------------------------------------------------------------------------------------------------
   | DBNAME | IXNAME |     DSNUM      | ICTYPE | OTYPE |                    DSNAME                    |
   +-------------------------------------------------------------------------------------------------------
1_| TMPDBMX | ICMXN1   |              1 | F      | I     | ACP.V120.TMPDBMX.ICMXN1.D01.LP123223         |
2_| TMPDBMX | ICMXP1   |              1 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D01.LP123223         |
3_| TMPDBMX | ICMXP1   |              2 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D02.LP123223         |
4_| TMPDBMX | ICMXP1   |              3 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D03.LP123223         |
5_| TMPDBMX | ICMXP1   |              4 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D04.LP123223         |
6_| TMPDBMX | ICMXP1   |              5 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D05.LP123223         |
7_| TMPDBMX | ICMXP1   |              7 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D07.LP123223         |
8_| TMPDBMX | ICMXP1   |              6 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D06.LP123223         |
9_| TMPDBMX | ICMXP1   |              8 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D08.LP123223         |
10_| TMPDBMX | ICMXP1   |              9 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D09.LP123223         |
11_| TMPDBMX | ICMXP1   |             11 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D11.LP123223         |
12_| TMPDBMX | ICMXP1   |             10 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D10.LP123223         |
13_| TMPDBMX | ICMXP1   |             12 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D12.LP123224         |
14_| TMPDBMX | ICMXP1   |             13 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D13.LP123224         |
15_| TMPDBMX | ICMXP1   |             14 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D14.LP123224         |
16_| TMPDBMX | ICMXP1   |             15 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D15.LP123224         |
17_| TMPDBMX | ICMXP1   |             17 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D17.LP123224         |
18_| TMPDBMX | ICMXP1   |             19 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D19.LP123224         |
19_| TMPDBMX | ICMXP1   |             18 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D18.LP123224         |
20_| TMPDBMX | ICMXP1   |             16 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D16.LP123224         |
21_| TMPDBMX | ICMXP1   |             20 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D20.LP123224         |
22_| TMPDBMX | ICMXP1   |             21 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D21.LP123225         |
23_| TMPDBMX | ICMXP1   |             22 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D22.LP123225         |
24_| TMPDBMX | ICMXP1   |             23 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D23.LP123225         |
25_| TMPDBMX | ICMXP1   |             24 | F      | I     | ACP.V120.TMPDBMX.ICMXP1.D24.LP123225         |
26_| TMPDBMX | INMXN1   |              1 | F      | I     | ACP.V120.TMPDBMX.INMXN1.D01.LP123223         |
27_| TMPDBMX | INMXP1   |              1 | F      | I     | ACP.V120.TMPDBMX.INMXP1.D01.LP123225         |
28_| TMPDBMX | ICMXP32 |              1 | F      | I     | ACP.V120.TMPDBMX.ICMXP32.D01.LP123227        |
29_| TMPDBMX | ICMXP32 |              2 | F      | I     | ACP.V120.TMPDBMX.ICMXP32.D02.LP123227        |
30_| TMPDBMX | ICMXP32 |              4 | F      | I     | ACP.V120.TMPDBMX.ICMXP32.D04.LP123227        |
31_| TMPDBMX | ICMXP32 |              3 | F      | I     | ACP.V120.TMPDBMX.ICMXP32.D03.LP123227        |
32_| TMPDBMX | INMXP32 |              1 | F      | I     | ACP.V120.TMPDBMX.INMXP32.D01.LP123227        |

0SUCCESSFUL RETRIEVAL OF         32 ROW(S)

To specify XCOPYDEL YES on the MODIFY command

BMC30101I   OPTIONS XCOPYDEL YES
BMC30101I   MODIFY TABLESPACE ACPDB240.*
BMC30101I    DELETE
BMC30101I    COMMIT 500

Partial SYSPRINT output

BMC47347I BEGINNING INITIALIZATION FOR ACPDB240.LS240G11 (00), COMMAND NBR 1
BMC30593I TABLESPACE INFO COMPLETE, TIME = 2018-10-01-12.32.49.679365
BMC30593I AUTHORIZATION COMPLETE, TIME = 2018-10-01-12.32.49.680926
BMC47332I 000000000251780AB183 TMPDBMX ICMXN1   0001 01 I ACP.V120.TMPDBMX.ICMXN1.D01.LP123223
IDCAMS SYSTEM SERVICES                                           TIME: 12:32:49

DELETE -
ACP.V120.TMPDBMX.ICMXN1.D01.LP123223 -
PURGE
IDC0550I ENTRY (A) ACP.V120.TMPDBMX.ICMXN1.D01.LP123223 DELETED
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0

IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 0
BMC47332I 000000000251780AB183 TMPDBMX ICMXP1   0001 01 I ACP.V120.TMPDBMX.ICMXP1.D01.LP123223
IDCAMS SYSTEM SERVICES                                           TIME: 12:32:50

DELETE -
ACP.V120.TMPDBMX.ICMXP1.D01.LP123223 -
PURGE
IDC0550I ENTRY (A) ACP.V120.TMPDBMX.ICMXP1.D01.LP123223 DELETED
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0

SYSPRINT from a SELECT statement to BMCXCOPY after the XCOPYDEL has executed

***INPUT STATEMENT:
   SELECT *
     FROM BMCUTIL.CMN_BMCXCOPY
   WHERE DBNAME = 'TMPDBMX' ;
SUCCESSFUL RETRIEVAL OF          0 ROW(S)

Example 28: Using XCOPYDEL option with MODIFY to remove orphaned rows from BMCXCOPY

On this page