SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-13
L
L
LABEL command, PUP 11-31, B-1
Labels, shadow 11-36
LARGEINT data type 5-22
Levels of indexes 13-2, 14-7
Licensed SQLCI2 process A-1
LIKE clause, CREATE TABLE
statement 9-3, 9-21
LIKE predicate 6-4
LISTALL clause 7-35
Listing
catalog names 9-34
NOREGISTER option 10-40
REGISTERONLY option 10-40
SQL objects 9-34
LOAD utility
compared to COPY 8-7, 9-3
DataLoader/MP 8-9, 8-15
DSLACK option 8-7
ISLACK option 8-7
MOVE option 8-12
MOVEBYNAME option 7-26
moving data 8-7
moving database 9-23
moving tables 9-16, 9-20
operations 9-2, 9-3
options 8-3, 8-8
partitions 8-9
reorganizing tables 8-2
restructuring database 8-1
rules 8-8
SLACK option 8-7
tables 5-53, 7-27, 8-7
Local autonomy
description 12-2, 12-5
SQL compiler options 10-9
Local partitions 12-9
Locally distributed database 12-1
Location requirements for catalogs 5-4
Lock length, altering 14-21
LOCK statement 10-41
LOCKLENGTH attribute
generic locking 14-21
similarity check rules 10-28
Locks
AUDITONLY option 4-17
controlling 14-21
ESCALATIONS counter 13-11
generic 14-21
limit 14-23
LOCK-WAITS counters, Measure 13-10,
13-11
Logging, SQL compilation 10-5
Logical DEFINE
See DEFINEs
Logical file structures 3-1
Logical names
See also DEFINEs
specifying 10-29
Logical primary key 3-2
Low PINs, running 2-13
M
Managing a database 7-1
MAP DEFINE, name resolution 10-13
MAP NAMES option 9-27
MAP NAMES parameter, RECOVER FILES
command 11-28
Mapping schemes 9-30
Mapping strategy, program 10-44
Masking, row and column 3-15
MAX function, optimization 3-22
MAXEXTENTS file attribute, similarity
check rules 10-28
Measure product
CALLS counter 13-9
description 13-5
DISK-READS counters 13-9, 13-10
ELAPSED-BUSY-TIME counter 13-9