IBM E027SLL-H Troubleshooting Guide - Page 42

Example

Page 42 highlights

v If the MQ agent is running in its own address space, check its RKPDLOG (time stamp not shown): Response: &philev.RMQSGRP3 Response: &philev.RMQSGRP2 Response: &philev.RMQSGRP1 Response: &philev.RKMQPDS3 Response: &philev.RKMQPDS2 Response: &philev.RKMQPDS1 1700 1700 1700 23327 23327 23327 83 25 25 31 6598 3523 14 5000 Active Write 0 5000 Empty Read Access 0 5000 Empty Read Access 0 4000 Empty Read Access 143 4000 Partial Read Access 105 4000 Active Write 4. Verify that the files are not being used by another task. 5. Verify that the files are initialized correctly and that the KppPDICT is inserted into the persistent data store files. 6. Verify that the maintenance procedure is correctly processing the persistent data store files. Example Examples of the error codes in the RKPDLOG: Error code 25804 Indicates that an attempt was made to read slot 0 of the GENHIST dataset. This is a protected record and the persistent data store will not allow the slot to be read. One possible cause is a problem with DELETE processing. The warehouse code, which is the only code that attempts to use the delete logic, might be generating a bad condition. Run the RECOVERY command which will save the data and rebuild the indexes so that the data is once again usable. Error code 3205 The last 3 digits represent the error and the beginning digits represent the persistent data store function that was being called. The 205 indicates the error RowExceedsFileFormat. This error is generated if the row you attempt to insert is larger than what will fit in a block allocated to the persistent data store data set. The actual maximum length is about 100 bytes smaller than the block size. Therefore, if you allocate a block size of 1000 (Window=1) and attempt to write a row greater then 900, you receive this message. The persistent data store cannot span a data row across multiple blocks. One other possibility is that either the API calls to the persistent data store to do the insert are specifying an invalid row length or the lengths of all the columns put together for the insert exceed the buffer length. Error code 35404 This code has many causes. One possibility is that a PARMA parameter intended for the agent processing is mistakenly set to the monitoring server and interpreted as a column name. This might be due to obsolete SQL saved in the monitoring server database. In most cases you can ignore this error. Set monitoring server traces to (UNIT:kdssqprs input,error). The UNIT:kdssqprs input, error trace returns large amounts of data. Turn the trace off as soon as you finish troubleshooting. KFAPERR : error code 14209 Persistent data store Filename is Not Available messages in the RKLVLOG of an agent or monitoring server on z/OS: Error 8 trying to set up table , KRAIRA000, Starting UADVISOR_Kpp_table-name, where pp is the two-character component or product code and table-name is the application table name. 24 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

v
If the MQ agent is running in its own address space, check its RKPDLOG
(time stamp not shown):
Response: &philev.RMQSGRP3
1700
83
14
5000 Active
Write
Response: &philev.RMQSGRP2
1700
25
0
5000 Empty
Read Access
Response: &philev.RMQSGRP1
1700
25
0
5000 Empty
Read Access
Response: &philev.RKMQPDS3
23327
31
0
4000 Empty
Read Access
Response: &philev.RKMQPDS2
23327
6598
143
4000 Partial
Read Access
Response: &philev.RKMQPDS1
23327
3523
105
4000 Active
Write
4.
Verify that the files are not being used by another task.
5.
Verify that the files are initialized correctly and that the
K
pp
PDICT
is inserted
into the persistent data store files.
6.
Verify that the maintenance procedure is correctly processing the persistent
data store files.
Example
Examples of the error codes in the RKPDLOG:
Error code 25804
Indicates that an attempt was made to read slot 0 of the GENHIST dataset.
This is a protected record and the persistent data store will not allow the
slot to be read. One possible cause is a problem with DELETE processing.
The warehouse code, which is the only code that attempts to use the delete
logic, might be generating a bad condition.
Run the
RECOVERY
command which will save the data and rebuild the
indexes so that the data is once again usable.
Error code 3205
The last 3 digits represent the error and the beginning digits represent the
persistent data store function that was being called. The 205 indicates the
error
RowExceedsFileFormat
.
This error is generated if the row you attempt to insert is larger than what
will fit in a block allocated to the persistent data store data set. The actual
maximum length is about 100 bytes smaller than the block size. Therefore,
if you allocate a block size of 1000 (Window=1) and attempt to write a row
greater then 900, you receive this message. The persistent data store cannot
span a data row across multiple blocks. One other possibility is that either
the API calls to the persistent data store to do the insert are specifying an
invalid row length or the lengths of all the columns put together for the
insert exceed the buffer length.
Error code 35404
This code has many causes. One possibility is that a
PARMA
parameter
intended for the agent processing is mistakenly set to the monitoring
server and interpreted as a column name. This might be due to obsolete
SQL saved in the monitoring server database. In most cases you can ignore
this error. Set monitoring server traces to
(UNIT:kdssqprs input,error)
.
The
UNIT:kdssqprs input, error
trace returns large amounts of data. Turn
the trace off as soon as you finish troubleshooting.
KFAPERR : error code 14209
Persistent data store
Filename is Not Available
messages in the
RKLVLOG of an agent or monitoring server on z/OS: Error 8 trying to set
up table
<table-name>
, KRAIRA000, Starting UADVISOR_K
pp
_
table-name
,
where pp is the two-character component or product code and table-name
is the application table name.
24
IBM Tivoli Monitoring: Troubleshooting Guide