Приложение 11. Процессы ядра СУБД ЛИНТЕР

Идентификатор процесса Описание процесса
0 Канал не активен, запрос еще не обрабатывается
1 SELECT
2 INSERT
3 UPDATE
4 DELETE
5 CREATE TABLE
6 CREATE VIEW
7 DROP TABLE
8 CREATE INDEX
9 DROP INDEX
10 GRANT: 1 form
11 GRANT: 2 form
12 REVOKE: 1 form
13 REVOKE: 2 form
14 ADD COLUMNS
15 ADD DATA FILE
16 ADD INDEX FILE
17 ADD BLOB FILE
18 MODIFY DATA FILE
19 MODIFY INDEX FILE
20 MODIFY BLOB FILE
21 DROP DATA FILE
22 DROP INDEX FILE
23 DROP BLOB FILE
24 PRESS TABLE
25 REBUILD TABLE
26 GETF (получить первую запись текущей выборки)
27 GETL (получить последнюю запись текущей выборки)
28 GETP (получить предыдущую запись текущей выборки)
29 GETN (получить следующую запись текущей выборки)
30 GETS (получить указанную запись текущей выборки)
31 UPDATE CURRENT CURSOR
32 DELETE CURRENT CURSOR
33 UPDATE CURRENT
34 DELETE CURRENT
35 CREATE NODE
36 DROP NODE
37 CREATE EVENT
38 DROP EVENT
39 GET EVENT
40 WAIT EVENT
41 SET EVENT
42 CLEAR EVENT
43 CREATE ROLE
44 DROP ROLE
45 GRANT ROLE
46 REVOKE ROLE
47 GRANT USER
48 REVOKE USER
49 LOCK TABLE
50 UNLOCK TABLE
51 GET MANY ROWS
52 EXECUTE PROCEDURE
53 START AUDIT
54 STOP AUDIT
55 COMMIT
56 ROLLBACK
57 ALTER TABLE SET READ LEVEL | WRITE LEVEL
58 CREATE PROCEDURE
59 DROP PROCEDURE
60 ALTER PROCEDURE
61 CREATE GROUP
62 CREATE LEVEL
63 ALTER GROUP
64 ALTER LEVEL
65 GRANT ACCESS ON GROUP
66 REVOKE ACCESS ON GROUP
67 SOME AUDIT COMMAND
68 CREATE STATION
69 DROP STATION
70 ALTER STATION
71 CREATE DEVICE
72 DROP DEVICE
73 ALTER DEVICE
74 GRANT ACCESS ON STATION
75 REVOKE ACCESS ON STATION
76 GRANT ACCESS ON DEVICE
77 REVOKE ACCESS ON DEVICE
78 DEBUG PROCEDURE
79 START APPEND
80 END APPEND
81 ALTER TABLE ADD PRIMARY KEY
82 ALTER TABLE ADD FOREIGN KEY
83 ALTER TABLE ADD UNIQUE
84 ALTER TABLE DROP PRIMARY KEY
85 ALTER TABLE DROP FOREIGN KEY
86 ALTER TABLE DROP UNIQUE
87 ALTER TABLE SET COLUMN READ LEVEL | WRITE LEVEL
88 CREATE REPLICATION RULE
89 DROP REPLICATION RULE
90 ALTER REPLICATION RULE
91 CREATE TRIGGER
92 DROP TRIGGER
93 ALTER TRIGGER
94 SET TRANSACTION READ ONLY
95 SET TRANSACTION ISOLATION LEVEL
96 SET SAVEPOINT
97 PUT SEVERAL ROWS
98 ALTER TABLE ALTER COLUMN SET DEFAULT
99 ALTER TABLE ALTER COLUMN DROP DEFAULT
100 ALTER TABLE RENAME COLUMN
101 ALTER TABLE ALTER COLUMN SIZE
102 ALTER TABLE RENAME
103 ALTER TABLE ADD CHECK
104 ALTER TABLE DROP CHECK
105 ALTER TABLE ALTER COLUMN ADD CHECK
106 ALTER TABLE ALTER COLUMN DROP CHECK
107 Создание составного индекса
108 Удаление составного индекса
109 ALTER TABLE ALTER COLUMN ENABLE NULL
110 ALTER TABLE ALTER COLUMN DISABLE NULL
111 SET PRIORITY
112 TEST TABLE
113 CREATE PHRASE INDEX
114 DROP PHRASE INDEX
115 REBUILD PHRASE INDEX
116 BACKUP
117 CREATE FILTER
118 DROP FILTER
119 ALTER FILTER SET MODULE
120 SET DEFAULT FILTER FOR EXTENSION
121 CANCEL DEFAULT FILTER FOR EXTENSION
122 ALTER TABLE ALTER COLUMN SET DEFAULT FILTER
123 ALTER TABLE ALTER COLUMN CANCEL DEFAULT FILTER
124 SYNCHRONIZE RULE
125 ALTER TABLE ALTER COLUMN ADD RANGE
126 GET COMPLEX EVENT
127 WAIT COMPLEX EVENT
128 ALTER PHRASE INDEX
129 SET LOG
130 SET L_TTRUE COMMIT
131 SET ROW QUANT
132 SET INDEX QUANT
133 SET WORKSPACE LIMIT
134 CREATE TEMPORARY INDEX (INTERNAL)
135 CREATE SEQUENCE
136 DROP SEQUENCE
137 GRANT PROCEDURE
138 REVOKE PROCEDURE
139 CREATE CHARACTER SET
140 DROP CHARACTER SET
141 CREATE TRANSLATION
142 DROP TRANSLATION
143 SET NAMES
144 SET DATABASE NAMES
145 Один из процессов модификация параметров функционирования БД:
SET RECORD SIZE LIMIT
SET CHANNEL MEMORY LIMIT
SET PHRASE INDEX FIRST CACHE SIZE
SET PHRASE INDEX SECOND CACHE SIZE
146 BACKUP
147 SET CHANNEL AUTOCOMMIT
148 SET CHANNEL WAIT|NOWAIT
149 PURGE TABLE
150 ADD BLOB
151 CLEAR BLOB
152 GET LINTER DUMP
153 CREATE ALIAS
154 DROP ALIAS
155 ALTER CHARACTER SET SET DESCRIPTION
156 ALTER CHARACTER SET DROP DESCRIPTION
157 SET DATABASE DEFAULT CHARACTER SET
158 SET OPTIMIZATION ENABLE/DISABLE
159 TRUNCATE TABLE
160 SET CONSTRAINTS ALL DEFERRED/IMMEDIATE
161 SET TRANSACTION READ WRITE
162 SET SORTPOOL LIMIT/UNLIMITED
163 TEST INTERNAL DATA
164 SET SESSION BLOB LOG {OFF|ON}
165 SAVE TABLE
166 RESTORE TABLE
167 ALTER TABLE [NOT] IN-MEMORY
168 SET SESSION PROCEDURE EXECUTE BY DEFAULT AS {DEFINER|CURRENT_USER}
169 SET DATABASE GEODATA VALIDITY CHECKING ON/OFF
170 SET CONNECTION GEODATA VALIDITY CHECKING ON/OFF
171 SET SESSION DEFAULT SECURITY
172 ALTER SEQUENCE
173 SET SESSION QUANT TIMEOUT {LIMIT|UNLIMITED}
174 SET QUANT TIMEOUT {LIMIT|UNLIMITED} FOR USER
175 ALTER TABLE RENAME INDEX
176 SET DATABASE QUANTUM
177 SET SESSION QUANTUM
178 CORRECT INDEX|CONVERTER|BITMAP
179 Канал ожидает отсылки данных утилите LHB
180 ALTER PROCEDURE DROP SOURCE TEXT
181 ALTER TRIGGER DROP SOURCE TEXT
182 ALTER TABLE ENABLE/DISABLE KEY
183 ALTER EVENT
222 ALTER TABLE {SET|CANCEL} RECORDS LIMIT
223 EXECUTE BLOCK
225 DROP COLUMNS
226 PREPARE
227 MERGE
229 SET SCHEMA
230 CREATE COMMENT
231 CREATE VARIABLE
232 DROP VARIABLE