Monitoring sbspaces with oncheck -pS

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.

Figure 1 shows an example of the -pS output for s9_sbspc.

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 Informix® ESQL/C 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 Figure 1, 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