CA Recovery Analyzer REBUILD INDEX syntax not generated by partition as it was on previous releases.

Document ID : KB000014827
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Comparing CA Recovery Analyzer for DB2 for z/OS (PRA) disaster recovery JCL and noted
that REBUILD INDEX statements are generated without the PART clause.

Previous release example:

REBUILD INDEX
(
creator.index1
,creator.index2
,creator.index3 PART 0001
,creator.index3 PART 0002
,creator.index3 PART 0003
,creator.index3 PART 0004
,creator.index3 PART 0005
,creator.index3 PART 0006
,creator.index3 PART 0007
,creator.index3 PART 0008
,creator.index3 PART 0009
,creator.index3 PART 0010
)
SORTDEVT SYSDA
SORTNUM 08


Current release example:

REBUILD INDEX
(
creator.index1
,creator.index2
,creator.index3
)
SORTDEVT SYSDA
SORTNUM 08

Answer:

The current PRA generated REBUILD INDEX statements without the PART clause results in more efficient execution with overall cost savings.