onstat -g smb command: Print sbspaces information

Use the onstat -g smb command to display detailed information about sbspaces.

Figure 1: Syntax:

1  onstat   -g smb
2.1 c
2.1 fdd
2.1 lod
2.1 s
2.1 e
2.1  h
2.2.1 cad
2.2.1 fdd
2.2.1 lod

Command Explanation
onstat -g smb c Lists all the chunks in the sbspace.
onstat -g smb e Lists the entries of all smart-large-object table types.
onstat -g smb e cad Lists the entries for the smart-large-object chunk adjunct table.
onstat -g smb e fdd Lists the entries for the smart-large-object file descriptor table.
onstat -g smb e lod Lists the entries in the smart-large-object header table.
onstat -g smb fdd Lists the smart-large-object file descriptors.
onstat -g smb h Lists the headers of all smart-large-object table types.
onstat -g smb h cad Lists the header for the smart-large-object chunk adjunct table.
onstat -g smb h fdd Lists the header for the smart-large-object file descriptor table.
onstat -g smb h lod Lists the header for the smart-large-object header table.
onstat -g smb lod Lists the header and entries in the smart-large-object header table.
onstat -g smb s Lists the sbspace attributes (owner, name, page size, -Df flag settings). Fields with a value of 0 or -1 were not initialized during sbspace creation.

Example output for the onstat -g smb c command

Use the onstat -g smb c command to monitor the amount of free space in each sbspace chunk, and the size in pages of the user data and metadata. The onstat -g smb c command displays the following information for each sbspace chunk:
  • Chunk number and sbspace name
  • Chunk size and pathname
  • Total user data pages and free user data pages
  • Location and number of pages in each user-data and metadata areas
In the following example, chunk 2 of sbspace1 has 2253 original free pages (orig fr), 2253 user pages (usr pgs), and 2245 free pages (free pg). For the first user-data area (Ud1), the starting page offset is 53 and the number of pages is 1126. For the metadata area (Md), the starting page offset is 1179 and the number of pages is 194. For the second user data area (Ud2), the starting page offset is 1373 and the number of pages is 1127. 
Chunk Summary:

sbnum 2  chunk 2 
chunk:   address   flags    offset   size   orig fr   usr pgs   free pg
         303cf2a8  F------- 0        2500   2253      2253      2245          
         path: /usr11/myname/sbspace1

         start pg   npages 
Ud1  :   53         1126 
Md   :   1179       194 
Ud2  :   1373       1127

Output for the onstat -g smb s command

The onstat -g smb s command displays the storage attributes for all sbspaces in the system:
  • sbspace name, flags, owner
  • logging status
  • average smart-large-object size
  • first extent size, next extent size, and minimum extent size
  • maximum I/O access time
  • lock mode

For more information on the onstat -g smb command, see the HCL OneDB™ Performance Guide.