L


Label Based Access Control (LBAC), 44, 105, 110, 111

Large object (LOB) data types, 371–372, 371

Large-object support, 50

LDAP. See Lightweight Directory Access Protocol

Left outer joins, 301, 302, 302, 305, 592

Less than or equal to, 272–274. See also comparison operators; relational predicates

Less than, 272–274. See also comparison operators; relational predicates

Levels, 13

Libraries, stored procedures and, 234, 235, 237

License Center, 76, 77, 570

Lightweight Directory Access Protocol (LDAP), 53, 181

LIKE, 275–277, 591

Linux, 8, 11, 36, 40, 47, 49, 53, 54, 567, 568, 573

authentication and, 98, 155

buffer pools in, 169

Database Connection Services (DCS) directory in, 181–182, 249

privileges and, 119, 133, 135, 145

LIST COMMAND OPTIONS, 83

LIST DATABASE DIRECTORY, 179–180

LIST DCS DIRECTORY, 182, 580

LIST NODE DIRECTORY, 181

LIST TABLESPACES, 112

Load (LOAD) authority, 105, 112, 127, 137, 147t, 171, 576

LOAD command, 112

LOAD utility, 4, 7, 79

LOB, 7, 227

LOCAL CHECK OPTION, views and, 207, 207, 208

Local database directory, 180

Lock conversion, 612

LOCK TABLE, 483–484, 485, 491, 496, 500, 612

Locks, 2, 465, 477–494, 478, 610, 611, 612, 613

acquisition of, 483–485

ALTER TABLE and, 483, 485, 491

attributes of, 479–483

compatibility of, 487, 488t, 487, 500

conversion deadlock and, 494

conversion of, 489–490, 489, 500

Database Manager's actions in, 478, 483, 485–487, 492, 611–612

deadlocks and, 493–494, 493, 495, 499

DELETE and, 486t

determining which locks are acquired in, 485–487

Duration attribute of, 479

escalation of, 490–491, 491

exclusive (X), 482t, 484, 485, 486t, 488t, 489, 493, 495, 499, 500, 610

granularity of, and concurrency, 484–485

INSERT and, 486t

intent exclusive (IX) lock, 481t, 486t, 488t, 489

intent none (IN) lock, 480t, 486t, 488t

intent share (IS) lock, 480t, 486t, 488t

LOCK TABLE and, 483–484, 485, 491, 496, 500, 612

locktimeout configuration for, 492, 496, 500, 612

next key share (NS), 480t, 486t, 488t

next key weak exclusive (NW), 481t, 486t, 488t

Object attribute of, 479

performance and, 487

row- vs. table-level, 483

SELECT and, 486t

share (S), 480t, 484, 485, 486t, 488t, 489, 497, 500

share with intent exclusive (SIX), 481t, 486t, 488t

Size attribute of, 479

State (Mode) attribute of, 479

states of, 480–482t

super exclusive (Z), 482t, 486t, 488t

transactions and their associated, 486–487, 486t

update (U), 481t, 486t, 488t, 489, 500

UPDATE and, 486t

victim processes and, in deadlocks, 494

waits and timeouts for, 492

weak exclusive (WE), 482t, 486t, 488t

Locktimeout configuration, 492, 496, 500, 612

Log shipping, 11

Logging, 11

Logic. See division of business application and logic

Long varying-length character string (LONG VARCHAR), 199, 227, 270, 369, 601

Long varying-length double-byte character string (LONG VARGRAPHIC), 199, 227, 270, 369–370

Lost updates, 467–477, 469t. See also isolation levels

LPL, 6




DB2 9 Fundamentals Certification Study Guide
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
Year: 2007
Pages: 93

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net