test/tools/catalog/exp.test008.ksh

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