SAP Note 438727 - DB2/390: Changing Clustering Index

Component : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/438727 (SAP Service marketplace login required)

Key words :
transaction se14 'extras->database object->check', symptom bad transactions response times caused, manner greatly improves subsequent retrievals, large average response times, index-sequential access occurs, optimal response times, database administration guide, sequential prefetch reason, sequential prefetch feature, sap defines tables

Related Notes :

496904Performance notes database parameters FS-AM for DB2 z/OS
306908DB2/390: Primary index created without CLUSTER
184399DB2/390: DDIC corrections (Releases 4.6A,4.6B,4.6C,4.6D)