test/system/Allocator/exp.test006.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> 111 </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 Table created
  39 Index created for f1
  40 Tables and Indexes are created
  41 Case 2: -d option with 1 table
  42 <Database Usage Statistics>
  43 <DatabaseStatistics>
  44   <Database Name>  SYSTEMDB </Database Name>
  45   <Max Size> 1048576 </Max Size>
  46   <First Page> 17d7c000 </First Page>
  47   <Total Pages> 111 </Total Pages>
  48   <Used Normal Pages> 13 </Used Normal Pages>
  49   <Used Merged Pages> 2 </Used Merged Pages>
  50   <Chunks Used> 15 </Chunks Used>
  51 </DatabaseStatistics>
  52 <ProcTable>
  53   <UsedSlots> 1 </UsedSlots>
  54   <FreeSlots> 99 </FreeSlots>
  55 </ProcTable>
  56 <TransactionTable>
  57   <UsedSlots> 0 </UsedSlots>
  58   <FreeSlots> 100 </FreeSlots>
  59   <UndoLogs>
  60     <TotalNodes> 0 </TotalNodes>
  61   </UndoLogs>
  62 </TransactionTable>
  63 <LockTable>
  64   <TotalBuckets> 2048  </TotalBuckets>
  65   <UsedBuckets> 0  </UsedBuckets>
  66   <TotalLockNodes> 0  </TotalLockNodes>
  67 </LockTable>
  68 <DatabaseStatistics>
  69   <Database Name>  userdb </Database Name>
  70   <Max Size> 10485760 </Max Size>
  71   <First Page> 17e7a000 </First Page>
  72   <Total Pages> 1276 </Total Pages>
  73   <Used Normal Pages> 2 </Used Normal Pages>
  74   <Used Merged Pages> 1 </Used Merged Pages>
  75   <Chunks Used> 3 </Chunks Used>
  76 </DatabaseStatistics>
  77 </Database Usage Statistics>
  78 Table Dropped
  79 Case 3: -d option after removing table
  80 <Database Usage Statistics>
  81 <DatabaseStatistics>
  82   <Database Name>  SYSTEMDB </Database Name>
  83   <Max Size> 1048576 </Max Size>
  84   <First Page> 17d7c000 </First Page>
  85   <Total Pages> 111 </Total Pages>
  86   <Used Normal Pages> 13 </Used Normal Pages>
  87   <Used Merged Pages> 2 </Used Merged Pages>
  88   <Chunks Used> 15 </Chunks Used>
  89 </DatabaseStatistics>
  90 <ProcTable>
  91   <UsedSlots> 1 </UsedSlots>
  92   <FreeSlots> 99 </FreeSlots>
  93 </ProcTable>
  94 <TransactionTable>
  95   <UsedSlots> 0 </UsedSlots>
  96   <FreeSlots> 100 </FreeSlots>
  97   <UndoLogs>
  98     <TotalNodes> 0 </TotalNodes>
  99   </UndoLogs>
 100 </TransactionTable>
 101 <LockTable>
 102   <TotalBuckets> 2048  </TotalBuckets>
 103   <UsedBuckets> 0  </UsedBuckets>
 104   <TotalLockNodes> 0  </TotalLockNodes>
 105 </LockTable>
 106 <DatabaseStatistics>
 107   <Database Name>  userdb </Database Name>
 108   <Max Size> 10485760 </Max Size>
 109   <First Page> 17e7a000 </First Page>
 110   <Total Pages> 1279 </Total Pages>
 111   <Used Normal Pages> 0 </Used Normal Pages>
 112   <Used Merged Pages> 0 </Used Merged Pages>
 113   <Chunks Used> 0 </Chunks Used>
 114 </DatabaseStatistics>
 115 </Database Usage Statistics>