Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ JDBC Driver GuideThe HCL OneDB™ JDBC Driver Programmer's Guide describes how to install, load, and use HCL OneDB™ JDBC Driver to connect to the HCL OneDB™ database from within a Java™ application.
Work with HCL OneDB™ types
Smart large object data types
Work with storage characteristics
System-specified storage characteristics
Example of setting sbspace characteristics

Example of setting sbspace characteristics

The following call to the onspaces utility creates an sbspace called sb1 in the /dev/sbspace1 partition:

onspaces -c -S sb1 -p /dev/sbspace1 -o 500 -s 2000
   -Df "AVG_LO_SIZE=32"

The following table shows the resulting system-specified storage characteristics for all smart large objects in the sb1 sbspace.

Table 1. System-specified storage characteristics for the sb1 sbspace
Disk-storage information	System-specified value	Specified by onspaces utility
Size of extent	Calculated by database server	System default
Size of next extent	Calculated by database server	System default
Minimum extent size	Calculated by database server	System default
Size of smart large object	32 kilobytes (database server uses as size estimate)	AVG_LO_SIZE
Maximum size of I/O block	Calculated by database server	System default
Name of sbspace	sb1	-S option
Logging	OFF	System default
Last-access time	OFF	System default

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.