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