Table 1. SQL-92 Configuration database properties
Property Description
Java classpath (-classpath) The pathname of the classpath
Number of open SQL cursors (-SQLCursors) The number of open cursors per connection
SQL stack size (-SQLStack) The size, in MB, of the SQL Stack
SQL statement cache size (-SQLStmtCache) The number of statements allowed in the SQL statement cache
SQL sorting memory (-SQLTempBuff) The size of the temporary table buffer in memory
SQL sorting on disk (-SQLTempDisk) The size of the temporary table for backup storage
SQL temporary data page size (-SQLTempPgSize) The size of the temporary table data page
Maximum number of JTA transactions (-maxxids) The number of JTA transactions simultaneously allowed
SQL Truncate Too Large (-SQLTruncateTooLarge) Truncates the data returned to the user when its size exceeds the column size.