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

book

Article ID: 14827

calendar_today

Updated On:

Products

CA Log Analyzer CA Fast Recover CA Fast Recover for DB2 for z/OS CA Log Analyzer for DB2 for z/OS CA Merge Modify for DB2 for z/OS CA Quick Copy for DB2 for z/OS CA Recovery Analyzer

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.