Skip to Main Content
DB2® for z/OS® Version 8 DBA Certification Guide
book

DB2® for z/OS® Version 8 DBA Certification Guide

by Susan Lawson
October 2004
Intermediate to advanced content levelIntermediate to advanced
688 pages
16h 35m
English
IBM Press
Content preview from DB2® for z/OS® Version 8 DBA Certification Guide

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,

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

DB2® Universal Database for OS/390® Version 7.1 Certification Guide

DB2® Universal Database for OS/390® Version 7.1 Certification Guide

Richard Yevich, Susan Lawson
Security Functions of IBM DB2 10 for z/OS

Security Functions of IBM DB2 10 for z/OS

Paolo Bruni, Marcelo Antonelli, Hyun Baek, Rick Butler, Ernie Mancill
Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Paolo Bruni, Carlos Alberto Gomes da Silva Junior, Craig McKellar, Adilet Sabyrbaev, Tim Willging

Publisher Resources

ISBN: 0131491202Purchase book