IBM Support

STRDBMON - QQI1 fast delete reason code

News


Abstract

STRDBMON - QQI1 fast delete reason code

Content

When the DELETE SQL statement is used to remove all records from the table in a performance critical environment, you can now use the database monitor to understand when fast delete was used and WHY fast delete did not occur.
  • The QQI1 column will contain this reason code when QQRID=1000 and QQC21='DL'.
  • The QQI1 values are:

    WHEN 0 THEN 'UNKNOWN'

    WHEN 1 THEN 'SUCCESS'

    WHEN 4 THEN 'DISTRIBUTED_TABLE'

    WHEN 5 THEN 'DDS_LOGICAL_FILE'

    WHEN 6 THEN 'REFERENTIAL_INTEGRITY_PARENT'

    WHEN 7 THEN 'TABLE_HAS_TRIGGERS'

    WHEN 8 THEN 'NUMBER_OF_ROWS_TOO_SMALL'

    WHEN 9 THEN 'CONCURRENT_OPERATION_CONFLICT'

    WHEN 10 THEN 'LOCK_CONFLICT_ON_TABLE'

    WHEN 11 THEN 'LOCK_CONFLICT_ON_DATA_SPACE'

    WHEN 51 THEN 'WHERE_CLAUSE_SPECIFID'

    WHEN 52 THEN 'QAQQINI_DISABLED_FAST_DELETE'

    WHEN 53 THEN 'SINGLE_PARTITION_ALIAS'

 
In addition to the monitor support, a CPF9898 diagnostic message will appear in the joblog and QHST when:
  • The # of rows in the table is > = 100,000.
  • The SQL_FAST_DELETE_ROW_COUNT QAQQINI option is set to a non-default value and the # of rows in the table is > = to that QAQQINI value.
The CPF9898 message contains the same fast delete failed reason code.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11169092

Page Feedback