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