IBM E027SLL-H Troubleshooting Guide - Page 248
SQL0552N ITMUSER does not have the privilege to perform, operation CREATE BUFFERPOOL SQLSTATE=
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 248 highlights
DB2 error: SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22003 sqlstate = 22003 1. Set the environment variable DB2CODEPAGE=1208 as a system environment on the Windows computer where the Warehouse Proxy is installed. 2. Restart the Windows computer so that the Warehouse Proxy windows service recognizes the change. SQL0552N "ITMUSER" does not have the privilege to perform operation "CREATE BUFFERPOOL" SQLSTATE=42502 If the Warehouse database user does not have the correct permission, the following error can occur: (42ED71FA.0000-E4C:khdxbase.cpp,250,"setError") Error 20/3/-552(FFFFFDD8)/0 executing SQLExecute (42ED71FA.0001-E4C:khdxbase.cpp,266,"setError") Error "[IBM][CLI Driver][DB2/NT] SQL0552N "ITMUSER" does not have the privilege to perform operation "CREATE BUFFERPOOL" SQLSTATE=42502 When you configure a DB2 Warehouse Proxy connection from the Manage Tivoli Enterprise Monitoring Services utility using the Configure DB2 Datasource for Warehouse window, the user ID the Warehouse Proxy uses to connect to the warehouse database must have SYSADM permission. SYSADM permission is required to create an 8K Tablespace and Bufferpool. Windows If the database is on Windows, the user must be a member of the local Administrators group. UNIX-based system If the database is on Linux or UNIX user must belong to the SYSADM group. 1. Log in as the DB2 instance owner (usually "su - db2inst1"), 2. Run the following command to determine the group that the UNIX-based system user must belong. db2 get dbm cfg | grep SYSADM 230 IBM Tivoli Monitoring: Troubleshooting Guide
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
42
-
43
-
44
-
45
-
46
-
47
-
48
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81
-
82
-
83
-
84
-
85
-
86
-
87
-
88
-
89
-
90
-
91
-
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
-
131
-
132
-
133
-
134
-
135
-
136
-
137
-
138
-
139
-
140
-
141
-
142
-
143
-
144
-
145
-
146
-
147
-
148
-
149
-
150
-
151
-
152
-
153
-
154
-
155
-
156
-
157
-
158
-
159
-
160
-
161
-
162
-
163
-
164
-
165
-
166
-
167
-
168
-
169
-
170
-
171
-
172
-
173
-
174
-
175
-
176
-
177
-
178
-
179
-
180
-
181
-
182
-
183
-
184
-
185
-
186
-
187
-
188
-
189
-
190
-
191
-
192
-
193
-
194
-
195
-
196
-
197
-
198
-
199
-
200
-
201
-
202
-
203
-
204
-
205
-
206
-
207
-
208
-
209
-
210
-
211
-
212
-
213
-
214
-
215
-
216
-
217
-
218
-
219
-
220
-
221
-
222
-
223
-
224
-
225
-
226
-
227
-
228
-
229
-
230
-
231
-
232
-
233
-
234
-
235
-
236
-
237
-
238
-
239
-
240
-
241
-
242
-
243
-
244
-
245
-
246
-
247
-
248
-
249
-
250
-
251
-
252
-
253
-
254
-
255
-
256
-
257
-
258
-
259
-
260
-
261
-
262
-
263
-
264
-
265
-
266
-
267
-
268
-
269
-
270
-
271
-
272
-
273
-
274
-
275
-
276
-
277
-
278
-
279
-
280
-
281
-
282
-
283
-
284
-
285
-
286
-
287
-
288
-
289
-
290
-
291
-
292
-
293
-
294
-
295
-
296
-
297
-
298
-
299
-
300
-
301
-
302
-
303
-
304
-
305
-
306
-
307
-
308
-
309
-
310