IBM Support

"Cannot upload any more data, the custom DB has reached its quota."

Troubleshooting


Problem

  1. My "Enterprise S-TAP View" Report on the CM is not showing all S-TAPs
  2. Earlier the report was showing correct number of S-TAPs
  3. When I manually go and do an "Upload Data" > "Run Once Now" for the S-TAP Info entity an alert box prompts as :

     Cannot upload any more data, the custom DB has reached its quota.

Symptom

  1. Enterprise S-TAP View report on CM affected
  2. Custom table upload issues - Alert Prompt : Cannot upload any more data, the custom DB has reached its quota.
  3. There could be DATAMART related issues too.

Cause

CUSTOM database and DATAMART database both collaborate to use the same space.
Currently there is no way to see the utilization of the DATAMART database.

Environment

V9.x and V10.x

Diagnosing The Problem

CLI Commands For CUSTOM DB

.ibm.com> comm custom
show monitor custom_db_usage
show system custom_db_max_size
show system custom_db_usage
store monitor custom_db_usage
store system custom_db_max_size
ok

Find the current consumption of the CUSTOM DB which should also contain the DATAMART DB consumption

.ibm.com> show system custom_db_usage

-------------------------------------------------------
TOTAL NUMBER_OF_MYISAM_TABLES - 342
TOTAL SIZE_OF_MYISAM_TABLES - 9144
TOTAL NUMBER_OF_INNODB_TABLES - 0
TOTAL SIZE_OF_INNODB_TABLES - 0
TOTAL NUMBER_OF_TABLES -  350
ok

This "TOTAL SIZE_OF_MYISAM_TABLES - 9144" means that the approximate size of the CUSTOM+DATAMART database is 9 Gb.

Resolving The Problem

There are 2 ways to handle this:

  1. Try to optimize the CUSTOM database and DATAMART database using the below cli command in quiet hours -

    Optimization of CUSTOM DB

    ibm.com> support optimize tables CUSTOM %
    This process can take some time, please wait...
    Processing CLASSIFICATION_DATA_IMPORT...
    CUSTOM.CLASSIFICATION_DATA_IMPORT optimize status Table is already up to date
    Processing CM_GDM_STATISTICS...
    .
    .
    .

    Processing ZSECURE_VIEW_PRIVILEGES_GRANTED_TO_GRANTEE...
    CUSTOM.ZSECURE_VIEW_PRIVILEGES_GRANTED_TO_GRANTEE optimize status Table is already up to date
    ok

    Similarly go ahead for the DATAMART database optimization too using the below cli command in quiet hours -
     

    Optimization of DATAMART DB

    ibm.com> support optimize tables DATAMART %
    This process can take some time, please wait...
    Processing ADMIN_DASHBOARD_AP...
    DATAMART.ADMIN_DASHBOARD_AP optimize status OK
    Processing ADMIN_DASHBOARD_VA...
    .
    .
    .

    DATAMART.SQL_ERRORS optimize status Table is already up to date
    Processing TBLLOCATOR...
    DATAMART.TBLLOCATOR optimize status Table is already up to date
    ok

    Now check the space utilization again using the cli command - "show system custom_db_usage" to note that "TOTAL SIZE_OF_MYISAM_TABLES" is reduced in number.

  2. If the above does not work, then increase the custom db allocation using the cli command :

    Increase CUSTOM DB Size

    .ibm.com> store system custom_db_max_size ?
    USAGE: store system custom_db_max_size <N>
           where N is number larger than 4000.
    ok

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Component":"CUSTOM DB;DATAMART DB;Enterprise S-TAP View Report;","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
01 March 2019

UID

ibm10740615

Page Feedback