*** empty log message ***
[csql.git] / test / system / Allocator / exp.test005.ksh
blob4e580b232fa235f1e4d06cb34f7bf487b7f159d4
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> 113 </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> 113 </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> 113 </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>