Learn how to check available space on the ObjectServer.
About this task
The cloud native analytics
service introduces new columns to the Netcool®/OMNIbus
ObjectServer, which take up space. Before starting your cloud native Netcool Operations Insight® components deployment, ensure
that you have sufficient space on the ObjectServer for these columns. The ObjectServer has a fixed
row size of 64 kilobytes. The standard ObjectServer columns use up some of this space, and as you
add custom fields, or integrate products, more of this space is used up.
Procedure
- From the command line, start the ObjectServer SQL interface,
nco_sql
, by
running the following
command. bin/nco_sql -user root -server server_name
Where
server_name
is the name of the ObjectServer.
- At the prompt, specify the root password.
- In the ObjectServer SQL interface, issue the following command.
The system returns a listing of the ObjectServer alerts.status
columns, together with columns indicating the type, size in bytes, and key for each
column.
- Save the output as a text file, and then import it into a spreadsheet program of your
choice, so that each column in the text file generates a separate column in the resulting
spreadsheet.
- Use a spreadsheet formula to calculate your ObjectServer row size in
kilobytes.
- Subtract the value determined in the previous step from the 64-kilobytes maximum row
size. This is the available space in your ObjectServer row.
- The cloud native analytics
service introduces a number of new columns to the ObjectServer that total 8 kilobytes. If you do not
have sufficient space in your ObjectServer row, then consider removing any redundant custom
columns.