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>
40 Tables and Indexes are created
41 Case 2: -d option with 1 table
42 <Database Usage Statistics>
44 <Database Name> SYSTEMDB </Database Name>
45 <Max Size> 1048576 </Max Size>
46 <First Page> 17d7c000 </First Page>
47 <Total Pages> 112 </Total Pages>
48 <Used Normal Pages> 13 </Used Normal Pages>
49 <Used Merged Pages> 2 </Used Merged Pages>
50 <Chunks Used> 15 </Chunks Used>
53 <UsedSlots> 1 </UsedSlots>
54 <FreeSlots> 99 </FreeSlots>
57 <UsedSlots> 0 </UsedSlots>
58 <FreeSlots> 100 </FreeSlots>
60 <TotalNodes> 0 </TotalNodes>
64 <TotalBuckets> 2048 </TotalBuckets>
65 <UsedBuckets> 0 </UsedBuckets>
66 <TotalLockNodes> 0 </TotalLockNodes>
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>
77 </Database Usage Statistics>
79 Case 3: -d option after removing table
80 <Database Usage Statistics>
82 <Database Name> SYSTEMDB </Database Name>
83 <Max Size> 1048576 </Max Size>
84 <First Page> 17d7c000 </First Page>
85 <Total Pages> 112 </Total Pages>
86 <Used Normal Pages> 13 </Used Normal Pages>
87 <Used Merged Pages> 2 </Used Merged Pages>
88 <Chunks Used> 15 </Chunks Used>
91 <UsedSlots> 1 </UsedSlots>
92 <FreeSlots> 99 </FreeSlots>
95 <UsedSlots> 0 </UsedSlots>
96 <FreeSlots> 100 </FreeSlots>
98 <TotalNodes> 0 </TotalNodes>
102 <TotalBuckets> 2048 </TotalBuckets>
103 <UsedBuckets> 0 </UsedBuckets>
104 <TotalLockNodes> 0 </TotalLockNodes>
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>