D.1 Maximum and minimum values related to system configuration

1

Total number of HADB users

1

30,000

Users

2

Total number of DB areas

5

1,024

Areas

3

Number of master directory DB areas

1

Areas

4

Number of dictionary DB areas

1

Areas

5

Number of system-table DB areas

1

Areas

6

Number of work table DB areas

1

4^#1

Areas

7

Number of data DB areas

1

1,014

Areas

8

DB area name

1

30

Bytes

9

DB area file relative path name

1

100

Bytes

10

Size of dictionary DB area

--

16

Terabytes

11

Size of system-table DB area

--

16

Terabytes

12

Size of work table DB area

--

Work table DB area page size x 4,294,967,295

Bytes

13

Size of data DB area

--

128

Exabytes

14

Size of files in data DB area

--

128

Petabytes

15

Number of configuration files per DB area in data DB area

1

1,024

Files

16

Size of one work table

--

Work table DB area page size x 4,294,967,295

Bytes

17

Number of base tables that an HADB user can define

0

4,096

Tables

18

Number of viewed tables that an HADB user can define

0

30,000

Tables

19

Number of indexes that an HADB user can define

0

8,192

Indexes

20

Number of base tables in a DB area

0

200

Tables

21

Number of indexes per DB area

0

400

Indexes

22

Maximum number of statement handles

4,095

Handles

23

Maximum number of concurrent connections^#2

1,024

Connections

24

Page size (excluding work table DB areas)

4,096

32,768

Bytes

25

Work table DB area page size

32,768

33,554,432

Bytes

26

Number of master log files

1

Files

27

Number of user log files

1

10,240

Files

28

Number of chunks in a DB area

1

30,000

Chunks

29

Number of chunks that can be created in a base table

1

30,000

Chunks

30

Number of nodes when the multi-node function is used

2

4

Nodes

31

Number of synonym dictionaries an HADB user can register

0

50

Synonym dictionaries