1 Case 1: -d option with no table
2 <Database Usage Statistics>
4 <Database Name> SYSTEMDB </Database Name>
5 <Max Size> 1048576 </Max Size>
6 <First Page> 17d7c000 </First Page>
7 <Total Pages> 112 </Total Pages>
8 <Used Normal Pages> 13 </Used Normal Pages>
9 <Used Merged Pages> 2 </Used Merged Pages>
10 <Chunks Used> 15 </Chunks Used>
13 <UsedSlots> 1 </UsedSlots>
14 <FreeSlots> 99 </FreeSlots>
17 <UsedSlots> 0 </UsedSlots>
18 <FreeSlots> 100 </FreeSlots>
20 <TotalNodes> 0 </TotalNodes>
24 <TotalBuckets> 2048 </TotalBuckets>
25 <UsedBuckets> 0 </UsedBuckets>
26 <TotalLockNodes> 0 </TotalLockNodes>
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>
37 </Database Usage Statistics>
39 Tables and Indexes are created
40 Case 2: -d option with 1 table
41 <Database Usage Statistics>
43 <Database Name> SYSTEMDB </Database Name>
44 <Max Size> 1048576 </Max Size>
45 <First Page> 17d7c000 </First Page>
46 <Total Pages> 112 </Total Pages>
47 <Used Normal Pages> 13 </Used Normal Pages>
48 <Used Merged Pages> 2 </Used Merged Pages>
49 <Chunks Used> 15 </Chunks Used>
52 <UsedSlots> 1 </UsedSlots>
53 <FreeSlots> 99 </FreeSlots>
56 <UsedSlots> 0 </UsedSlots>
57 <FreeSlots> 100 </FreeSlots>
59 <TotalNodes> 0 </TotalNodes>
63 <TotalBuckets> 2048 </TotalBuckets>
64 <UsedBuckets> 0 </UsedBuckets>
65 <TotalLockNodes> 0 </TotalLockNodes>
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>
76 </Database Usage Statistics>
78 Case 3: -d option after removing table
79 <Database Usage Statistics>
81 <Database Name> SYSTEMDB </Database Name>
82 <Max Size> 1048576 </Max Size>
83 <First Page> 17d7c000 </First Page>
84 <Total Pages> 112 </Total Pages>
85 <Used Normal Pages> 13 </Used Normal Pages>
86 <Used Merged Pages> 2 </Used Merged Pages>
87 <Chunks Used> 15 </Chunks Used>
90 <UsedSlots> 1 </UsedSlots>
91 <FreeSlots> 99 </FreeSlots>
94 <UsedSlots> 0 </UsedSlots>
95 <FreeSlots> 100 </FreeSlots>
97 <TotalNodes> 0 </TotalNodes>
101 <TotalBuckets> 2048 </TotalBuckets>
102 <UsedBuckets> 0 </UsedBuckets>
103 <TotalLockNodes> 0 </TotalLockNodes>
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>