test/system/Allocator/exp.test007.ksh

   1 Case 1: -d option with no table
   2 <Database Usage Statistics>
   3 <DatabaseStatistics>
   4   <Database Name>  SYSTEMDB </Database Name>
   5   <Max Size> 1048576 </Max Size>
   6   <First Page> 17d7c000 </First Page>
   7   <Total Pages> 113 </Total Pages>
   8   <Used Normal Pages> 13 </Used Normal Pages>
   9   <Used Merged Pages> 2 </Used Merged Pages>
  10   <Chunks Used> 15 </Chunks Used>
  11 </DatabaseStatistics>
  12 <ProcTable>
  13   <UsedSlots> 1 </UsedSlots>
  14   <FreeSlots> 99 </FreeSlots>
  15 </ProcTable>
  16 <TransactionTable>
  17   <UsedSlots> 0 </UsedSlots>
  18   <FreeSlots> 100 </FreeSlots>
  19   <UndoLogs>
  20     <TotalNodes> 0 </TotalNodes>
  21   </UndoLogs>
  22 </TransactionTable>
  23 <LockTable>
  24   <TotalBuckets> 2048  </TotalBuckets>
  25   <UsedBuckets> 0  </UsedBuckets>
  26   <TotalLockNodes> 0  </TotalLockNodes>
  27 </LockTable>
  28 <DatabaseStatistics>
  29   <Database Name>  userdb </Database Name>
  30   <Max Size> 10485760 </Max Size>
  31   <First Page> 17e7a000 </First Page>
  32   <Total Pages> 1279 </Total Pages>
  33   <Used Normal Pages> 0 </Used Normal Pages>
  34   <Used Merged Pages> 0 </Used Merged Pages>
  35   <Chunks Used> 0 </Chunks Used>
  36 </DatabaseStatistics>
  37 </Database Usage Statistics>
  38 Tables and Indexes are created
  39 Case 2: -d option with 1 table
  40 Table created
  41 Index created for f1
  42 Table Dropped
  43 Table created
  44 Index created for f1
  45 Table Dropped
  46 Table created
  47 Index created for f1
  48 Table Dropped
  49 Table created
  50 Index created for f1
  51 Table Dropped
  52 Table created
  53 Index created for f1
  54 Table Dropped
  55 Table created
  56 Index created for f1
  57 Table Dropped
  58 Table created
  59 Index created for f1
  60 Table Dropped
  61 Table created
  62 Index created for f1
  63 Table Dropped
  64 Table created
  65 Index created for f1
  66 Table Dropped
  67 Table created
  68 Index created for f1
  69 Table Dropped
  70 Table created
  71 Index created for f1
  72 Table Dropped
  73 Table created
  74 Index created for f1
  75 Table Dropped
  76 Table created
  77 Index created for f1
  78 Table Dropped
  79 Table created
  80 Index created for f1
  81 Table Dropped
  82 Table created
  83 Index created for f1
  84 Table Dropped
  85 Table created
  86 Index created for f1
  87 Table Dropped
  88 Table created
  89 Index created for f1
  90 Table Dropped
  91 Table created
  92 Index created for f1
  93 Table Dropped
  94 Table created
  95 Index created for f1
  96 Table Dropped
  97 Table created
  98 Index created for f1
  99 Table Dropped
 100 Table created
 101 Index created for f1
 102 Table Dropped
 103 Table created
 104 Index created for f1
 105 Table Dropped
 106 Table created
 107 Index created for f1
 108 Table Dropped
 109 Table created
 110 Index created for f1
 111 Table Dropped
 112 Table created
 113 Index created for f1
 114 Table Dropped
 115 Table created
 116 Index created for f1
 117 Table Dropped
 118 Table created
 119 Index created for f1
 120 Table Dropped
 121 Table created
 122 Index created for f1
 123 Table Dropped
 124 Table created
 125 Index created for f1
 126 Table Dropped
 127 Table created
 128 Index created for f1
 129 Table Dropped
 130 Table created
 131 Index created for f1
 132 Table Dropped
 133 Table created
 134 Index created for f1
 135 Table Dropped
 136 Table created
 137 Index created for f1
 138 Table Dropped
 139 Table created
 140 Index created for f1
 141 Table Dropped
 142 Table created
 143 Index created for f1
 144 Table Dropped
 145 Table created
 146 Index created for f1
 147 Table Dropped
 148 Table created
 149 Index created for f1
 150 Table Dropped
 151 Table created
 152 Index created for f1
 153 Table Dropped
 154 Table created
 155 Index created for f1
 156 Table Dropped
 157 Table created
 158 Index created for f1
 159 Table Dropped
 160 Table created
 161 Index created for f1
 162 Table Dropped
 163 Table created
 164 Index created for f1
 165 Table Dropped
 166 Table created
 167 Index created for f1
 168 Table Dropped
 169 Table created
 170 Index created for f1
 171 Table Dropped
 172 Table created
 173 Index created for f1
 174 Table Dropped
 175 Table created
 176 Index created for f1
 177 Table Dropped
 178 Table created
 179 Index created for f1
 180 Table Dropped
 181 Table created
 182 Index created for f1
 183 Table Dropped
 184 Table created
 185 Index created for f1
 186 Table Dropped
 187 Table created
 188 Index created for f1
 189 Table Dropped
 190 Table created
 191 Index created for f1
 192 Table Dropped
 193 Table created
 194 Index created for f1
 195 Table Dropped
 196 Table created
 197 Index created for f1
 198 Table Dropped
 199 Table created
 200 Index created for f1
 201 Table Dropped
 202 Table created
 203 Index created for f1
 204 Table Dropped
 205 Table created
 206 Index created for f1
 207 Table Dropped
 208 Table created
 209 Index created for f1
 210 Table Dropped
 211 Table created
 212 Index created for f1
 213 Table Dropped
 214 Table created
 215 Index created for f1
 216 Table Dropped
 217 Table created
 218 Index created for f1
 219 Table Dropped
 220 Table created
 221 Index created for f1
 222 Table Dropped
 223 Table created
 224 Index created for f1
 225 Table Dropped
 226 Table created
 227 Index created for f1
 228 Table Dropped
 229 Table created
 230 Index created for f1
 231 Table Dropped
 232 Table created
 233 Index created for f1
 234 Table Dropped
 235 Table created
 236 Index created for f1
 237 Table Dropped
 238 Table created
 239 Index created for f1
 240 Table Dropped
 241 Table created
 242 Index created for f1
 243 Table Dropped
 244 Table created
 245 Index created for f1
 246 Table Dropped
 247 Table created
 248 Index created for f1
 249 Table Dropped
 250 Table created
 251 Index created for f1
 252 Table Dropped
 253 Table created
 254 Index created for f1
 255 Table Dropped
 256 Table created
 257 Index created for f1
 258 Table Dropped
 259 Table created
 260 Index created for f1
 261 Table Dropped
 262 Table created
 263 Index created for f1
 264 Table Dropped
 265 Table created
 266 Index created for f1
 267 Table Dropped
 268 Table created
 269 Index created for f1
 270 Table Dropped
 271 Table created
 272 Index created for f1
 273 Table Dropped
 274 Table created
 275 Index created for f1
 276 Table Dropped
 277 Table created
 278 Index created for f1
 279 Table Dropped
 280 Table created
 281 Index created for f1
 282 Table Dropped
 283 Table created
 284 Index created for f1
 285 Table Dropped
 286 Table created
 287 Index created for f1
 288 Table Dropped
 289 Table created
 290 Index created for f1
 291 Table Dropped
 292 Table created
 293 Index created for f1
 294 Table Dropped
 295 Table created
 296 Index created for f1
 297 Table Dropped
 298 Table created
 299 Index created for f1
 300 Table Dropped
 301 Table created
 302 Index created for f1
 303 Table Dropped
 304 Table created
 305 Index created for f1
 306 Table Dropped
 307 Table created
 308 Index created for f1
 309 Table Dropped
 310 Table created
 311 Index created for f1
 312 Table Dropped
 313 Table created
 314 Index created for f1
 315 Table Dropped
 316 Table created
 317 Index created for f1
 318 Table Dropped
 319 Table created
 320 Index created for f1
 321 Table Dropped
 322 Table created
 323 Index created for f1
 324 Table Dropped
 325 Table created
 326 Index created for f1
 327 Table Dropped
 328 Table created
 329 Index created for f1
 330 Table Dropped
 331 Table created
 332 Index created for f1
 333 Table Dropped
 334 Table created
 335 Index created for f1
 336 Table Dropped
 337 Table created
 338 Index created for f1
 339 Table Dropped
 340 <Database Usage Statistics>
 341 <DatabaseStatistics>
 342   <Database Name>  SYSTEMDB </Database Name>
 343   <Max Size> 1048576 </Max Size>
 344   <First Page> 17d7c000 </First Page>
 345   <Total Pages> 113 </Total Pages>
 346   <Used Normal Pages> 13 </Used Normal Pages>
 347   <Used Merged Pages> 2 </Used Merged Pages>
 348   <Chunks Used> 15 </Chunks Used>
 349 </DatabaseStatistics>
 350 <ProcTable>
 351   <UsedSlots> 1 </UsedSlots>
 352   <FreeSlots> 99 </FreeSlots>
 353 </ProcTable>
 354 <TransactionTable>
 355   <UsedSlots> 0 </UsedSlots>
 356   <FreeSlots> 100 </FreeSlots>
 357   <UndoLogs>
 358     <TotalNodes> 0 </TotalNodes>
 359   </UndoLogs>
 360 </TransactionTable>
 361 <LockTable>
 362   <TotalBuckets> 2048  </TotalBuckets>
 363   <UsedBuckets> 0  </UsedBuckets>
 364   <TotalLockNodes> 0  </TotalLockNodes>
 365 </LockTable>
 366 <DatabaseStatistics>
 367   <Database Name>  userdb </Database Name>
 368   <Max Size> 10485760 </Max Size>
 369   <First Page> 17e7a000 </First Page>
 370   <Total Pages> 1279 </Total Pages>
 371   <Used Normal Pages> 0 </Used Normal Pages>
 372   <Used Merged Pages> 0 </Used Merged Pages>
 373   <Chunks Used> 0 </Chunks Used>
 374 </DatabaseStatistics>
 375 </Database Usage Statistics>