O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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,

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required