Index

A

Access and security, 73

auditing in, 95–98

data set protection, 76

multilevel security, 94–95

to objects, 77

administrative authorities for, 83–88

authorization identifiers for, 77–78

catalog table information for, 93

explicit privileges for, 77–83

ownership with, 88–93

plan execution authorization for, 93

views for, 94

subsystem, 74–76

ACCESS_DEGREE column, 534

Access paths, 529

in bind process, 393

DSN_FUNCTION_TABLE for, 548–549

DSN_STATMNT_TABLE for, 546–548

Explain for, 529–531, 551–553

hints for, 549–550

PLAN_TABLE for, 530

columns in, 531–537

index access in, 537–539

table access in, 539–546

production environment models for, 550–551

ACCESS_PGROUP_ID column, 534

Access plans, 529

ACCESS (UT) option, 314

ACCESSCREATOR column,

Get DB2® for z/OS® Version 8 DBA Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.