ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
HINT_$PHY$ is not working
Article ID: 106270
DatacomDATACOM - AD
I ran an SQL SELECT using hint key HINT_$PHY$ to do physical reads only but find that my index is still accessed.
Table involved in the SQL SELECT resides in an area for which a BA24 (blocksize alter) process has been run. Once a BA24 process has been run, so even if that ended successfully , it is not possible to do physical sequential reading .
z/OS CA Datacom 15.1
After running DBUTLTY BACKUP/LOAD all physical reads will be restored.
DEFECT DE370752 has been opened for the CBS Diagnostic report to reflect the use of physical data scan or not . And if not, for what reason.