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...RETRIEVING | 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 (for crash dumps) |
48 | Internal use only (for crash dumps) | 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 |
231 | Create Map | 232 | Set Session UPT | 233 | Drop Map |
234 | Grant Map | 235 | Revoke Map | 236 | Sess Dot No. |
237 | Create Schema | 238 | Drop Schema | 239 | Debug Function |
240 | Foreign Server | 241 | Set Transform Group | 242 | Create Alias |
243 | Replace Alias | 244 | Drop Alias | 245 | Incremental Restore |
246 | Execute Analytic Function | 247 | Set Session UDFSearchPath | 248 | Select with table |
249 | Insert with table | 250 | Execute Analytic Func No ART table output |