Activity Type
The Activity Type field indicates the type of processing performed for the request.
Value |
Statement |
Value |
Statement |
Value |
Statement |
0 |
Not available |
1 |
SQL SELECT |
2 |
SQL INSERT |
3 |
SQL UPDATE |
4 |
UPDATE... |
5 |
SQL DELETE |
6 |
SQL CREATE TABLE |
7 |
SQL ALTER TABLE |
8 |
SQL CREATE VIEW |
9 |
SQL CREATE MACRO |
10 |
SQL DROP TABLE |
11 |
SQL DROP VIEW |
12 |
SQL DROP MACRO |
13 |
SQL DROP INDEX |
14 |
SQL RENAME TABLE |
15 |
SQL RENAME VIEW |
16 |
SQL RENAME MACRO |
17 |
SQL CREATE INDEX |
18 |
SQL CREATE DATABASE |
19 |
SQL CREATE USER |
20 |
SQL GRANT |
21 |
SQL REVOKE |
22 |
Give |
23 |
SQL DROP DATABASE |
24 |
SQL MODIFY DATABASE |
25 |
SQL DATABASE |
26 |
SQL BEGIN TRANSACTION |
27 |
SQL END TRANSACTION |
28 |
SQL ABORT |
29 |
Null |
30 |
SQL EXECUTE |
31 |
SQL COMMENT SET |
32 |
SQL COMMENT |
33 |
SQL ECHO |
34 |
Replace View |
35 |
Replace Macro |
36 |
SQL CHECKPOINT |
37 |
Delete Journal |
38 |
SQL ROLLBACK |
39 |
Release Lock |
40 |
HUT Config |
41 |
VerifyCheckpoint |
42 |
Dump Journal |
43 |
Dump |
44 |
Restore |
45 |
RollForward |
46 |
SQL Delete Database |
47 |
Internal use only |
48 |
Internal use only |
49 |
SQL Show |
50 |
SQL Help |
51 |
Begin Loading |
52 |
Check Point Load |
53 |
End Loading |
54 |
Insert |
55 |
Grant Logon |
56 |
Revoke Logon |
57 |
Begin Access Log |
58 |
End Access Log |
59 |
Collect Statistics |
60 |
Drop Statistics |
61 |
Session Set |
62 |
Begin Multiload |
63 |
Multiload |
64 |
Execute Multiload |
65 |
End Multiload |
66 |
Release Multiload |
67 |
Multiload Delete |
68 |
Multiload Insert |
69 |
Multiload Update |
70 |
Begin Delete Multiload |
71 |
Data Status |
72 |
Reserved for B1 security |
73 |
Reserved for B1 security |
74 |
Begin Export |
75 |
End Export |
76 |
2PC Vote Request |
77 |
2PC Vote and Terminate Request |
78 |
2PC Commit |
79 |
2PC Abort |
80 |
2PC Yes/Done Response to Vote Request |
81 |
Obsolete |
82 |
Obsolete |
83 |
Set Session Rate |
84 |
Monitor Session |
85 |
Identify |
86 |
Abort Session |
87 |
Set Resource Rate |
88 |
Obsolete |
89 |
Revalidate RI references |
90 |
ANSI SQL COMMIT WORK |
91 |
Monitor Virtual Config |
92 |
Monitor Physical Config |
93 |
Monitor Virtual Summary |
94 |
Monitor Physical Summary |
95 |
Monitor Virtual Resource |
96 |
Monitor Physical Resource |
97 |
SQL CREATE TRIGGER |
98 |
SQL DROP TRIGGER |
99 |
SQL RENAME TRIGGER |
100 |
Replace Trigger |
101 |
SQL ALTER TRIGGER |
102 |
Replication |
103 |
Drop Procedure |
104 |
Create Procedure |
105 |
Call |
106 |
SQL RENAME PROCEDURE |
107 |
Replace Procedure |
108 |
Set Session Account |
109 |
Locking logger |
110 |
Monitor Session |
111 |
Monitor Version |
112 |
Begin Database Query Log |
113 |
End Database Query Log |
114 |
SQL Create Role |
115 |
SQL DROP ROLE |
116 |
Grant Role |
117 |
Revoke Role |
118 |
SQL Create Profile |
119 |
SQL Modify Profile |
120 |
SQL Drop Profile |
121 |
SQL SET ROLE |
122 |
Create UDF |
123 |
Replace UDF |
124 |
Drop UDF |
125 |
Alter UDF |
126 |
Rename UDF |
127 |
SQL MERGE INTO, updates and inserts |
128 |
SQL MERGE INTO, updates, no inserts |
129 |
SQL MERGE INTO, all inserts, no updates |
130 |
SQL ALTER PROCEDURE |
131 |
PM/API request TDWM ENABLE |
132 |
PM/API request TDWM STATISTICS |
133 |
TDWM Perf Groups |
134 |
Create UDT |
135 |
Drop UDT |
136 |
Alter UDT |
137 |
Replace UDT |
138 |
SQL CREATE METHOD |
139 |
Alter Method |
140 |
Replace Method |
141 |
Create Cast |
142 |
Replace Cast |
143 |
Drop Cast |
144 |
SQL CREATE ORDERING |
145 |
Replace Ordering |
146 |
Drop Ordering |
147 |
SQL CREATE TRANSFORM |
148 |
Replace Transform |
149 |
SQL DROP TRANSFORM |
150 |
Create Authorization |
151 |
Drop Authorization |
152 |
Create Replication Group |
153 |
Alter Replication Group |
154 |
Drop Replication Group |
155 |
TDWM Delete Request Change stmt |
156 |
TDWM Summary stmt |
157 |
TDWM Dyn Rule stmt |
158 |
TDWM Dyn Obj stmt |
159 |
TDWM Wd Assignment stmt |
160 |
TDWM Dyn Build |
161 |
TDWM List Wd stmt |
162 |
Set Session Isolation Level |
163 |
Initiate Index Analysis |
164 |
Replace Auth stmt |
165 |
Set QUERY_BAND stmt |
166 |
LOGGING ONLINE ARCHIVE ON |
167 |
LOGGING ONLINE ARCHIVE OFF |
168 |
MONITOR QUERYBAND |
169 |
Create Column Correlation |
170 |
Replace Column Correlation |
171 |
Drop Column Correlation |
172 |
Alter Column Correlation |
173 |
USER EVENT CONTROL |
174 |
EVENT STATUS |
175 |
MONITOR AWT RESOURCE |
176 |
SP Dynamic Result Set |
177 |
Create Replication Rule Set |
178 |
Replace Replication Rule Set |
179 |
Drop Replication Rule Set |
180 |
CREATE OPERATOR |
181 |
REPLACE OPERATOR |
182 |
RENAME OPERATOR |
183 |
DROP OPERATOR |
184 |
GRANT CONNECT THROUGH |
185 |
REVOKE CONNECT THROUGH |
186 |
CREATE GLOP SET |
187 |
DROP GLOP SET |
188 |
Create Security Constraint |
189 |
Alter Security Restraint |
190 |
Drop Security Restraint |
191 |
CREATE INDEX TYPE |
192 |
DROP INDEX TYPE |
193 |
REPLACE INDEX TYPE |
194 |
ALTER INDEX |
195 |
CHECK WORKLOAD FOR |
196 |
FastExport No Spooling |
197 |
CHECK WORKLOAD END |
198 |
FLUSH DBQL CACHE |
199 |
TDWMEXCEPTION PM/API |
200 |
TDWMTEST PM/API |
201 |
MONITOR TDWM RESORCE PM/API |
202 |
MONITOR WD - PM/API |
203 |
REGISTER XML SCHEMA/XSLT STYLESHEET/XQUERY MODULE |
204 |
CALENDAR CHANGED |
205 |
MONITOR REQUEST - PM/API |
206 |
Merge-Into-Delete |
207 |
Begin QUERY CAPTURE |
208 |
End QUERY CAPTURE |
209 |
SHOW IN XML [DB_OBJECT/DML] |
210 |
GTW HOSTGROUP PROPERTIES |
211 |
ProxyConfig - From client when it supports Proxy |
212 |
SecureAttribute Parcel |
213 |
VH FSG Cache |
214 |
Unity SQL Stmt |
215 |
Aster Support |
216 |
Create Zone |
217 |
Alter Zone |
218 |
Drop Zone |
219 |
Create Fore Srv |
220 |
Alter Fore Srv |
221 |
Drop Foreign Srv |
222 |
Begin Iso Load |
223 |
Checkpt Iso Load |
224 |
End Iso Load |
225 |
Set Sess Load |
226 |
Grant Zone |
227 |
Revoke Zone |
228 |
For Viewpoint |
229 |
Set Sess JSON |
230 |
CheckJI Act Type |