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 | 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 CONSTRAINT | 189 | ALTER CONSTRAINT |
190 | DROP CONSTRAINT | 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 RESOURCE PM/API |
202 | MONITOR WD - PM/API | 203 | REGISTER XML SCHEMA/XSLT STYLESHEET/XQUERY MODULE | 204 | CALENDAR CHANGED |
205 | MONITOR REQUEST - PM/API |