The oncheck-pS option displays information
about smart-large-object extents and metadata areas in sbspace partitions.
If you do not specify an sbspace name on the command line, oncheck checks
and displays the metadata for all sbspaces.
To display information about smart large objects, execute the following
command:
oncheck -pS spacename
The oncheck -pS output displays the following information
for each smart large object in the sbspace:
Space chunk page
Size in bytes of each smart large object
Object ID that DataBlade®
API and functions use
Storage characteristics of each smart large object
When you use onspaces -c -S to create an sbspace, you can
use the -Df option to specify various storage characteristics
for the smart large objects. You can use onspaces -ch to change
attributes after the sbspace is created. The Create Flags field
in the oncheck -pS output displays these storage characteristics
and other attributes of each smart large object. In oncheck
-pS output , the Create Flags field
shows LO_LOG because the LOGGING tag was set to ON in the -Df option.
Figure 1: oncheck
-pS output
Space Chunk Page = [2,2,2] Object ID = 987122917
LO SW Version 4
LO Object Version 1
Created by Txid 7
Flags 0x31 LO_LOG LO_NOKEEP_LASTACCESS_TIME LO_HIGH_INTEG
Data Type 0
Extent Size -1
IO Size 0
Created Thu Apr 12 17:48:35 2007
Last Time Modified Thu Apr 12 17:48:43 2007
Last Time Accessed Thu Apr 12 17:48:43 2007
Last Time Attributes Modified Thu Apr 12 17:48:43 2007
Ref Count 1
Create Flags 0x31 LO_LOG LO_NOKEEP_LASTACCESS_TIME LO_HIGH_INTEG
Status Flags 0x0 LO_FROM_SERVER
Size (Bytes) 2048
Size Limit -1
Total Estimated Size -1
Deleting TxId -1
LO Map Size 200
LO Map Last Row -1
LO Map Extents 2
LO Map User Pages 2