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

Products

• Fast Recover for DB2 for z/OS
• Log Analyzer for DB2 for z/OS
• Quick Copy for DB2 for z/OS

Issue/Introduction

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

Environment

Release:
Component: PRA

Resolution

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