Maximum values for working with the SESAM/SQL DBH

You can use DBH start statements and options to set limit values for certain parameters. The following table lists the maximum values for important parameters in a DBH session.

Maximum value	Number
Entries in the SQL database catalog	254
Entries in the CALL DML table catalog	254
Simultaneously accessible spaces	101 600
Concurrent users	32 767
Concurrent SQL access plans in the plan buffer	999 999
Parallel SQL cursors	999 999
Concurrent suborders (scans in the case of SQL and logical files in the case of CALL DML)	262 143
DBH tasks	16
Service tasks in the case of the independent DBH	64
CO-LOG files	9 999
Sorted rows in an SQL cursor table	2,147,483, 647
Spaces per database	1000
Threads in the case of the independent DBH	1024
Write threads in the case of the independent DBH	512
Maximum value	Length
Area for retrieval statements (in columns)	1024
Cursor buffer (in Kbytes)	1 500 000
System-data buffer (in Kbytes)	64 000 000
Transfer container (in Kbytes)	1 000 000
User-data buffer (in Kbytes)	64 000 000
Work container (in Kbytes)	1 000 000

Table 80: Maximum values for working with the SESAM/SQL DBH