Checking space on the ObjectServer in your cloud deployment

Edit online

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 more space. Before you start your cloud native components deployment, ensure that you have sufficient space on the ObjectServer for these columns. The ObjectServer has a fixed row size of 64 kB. 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

  1. 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.
  2. At the prompt, specify the root password.
  3. In the ObjectServer SQL interface, issue the following command. 
    describe status;
go
    The system returns a listing of the ObjectServer alerts.status columns, together with columns that indicate the type, size in bytes, and key for each alerts.status column.
  4. Save the output as a text file. Import the text file into a spreadsheet program of your choice so that each column in the text file generates a separate column in the resulting spreadsheet.
  5. Use a spreadsheet formula to calculate your ObjectServer row size in kilobytes.
  6. Subtract the value determined in the previous step from the 64 kB maximum row size. This value is the available space in your ObjectServer row.
  7. The cloud native analytics service introduces several new columns to the ObjectServer that total 8 kB. If you do not have sufficient space in your ObjectServer row, then consider removing any redundant custom columns.