How to interpret the "Most Frequent Return Codes" in SteelCentral AppResponse 11 dbperf insights?

Categories: SteelCentral AppResponse 11
Solution Number: S32923

Issue

We are running SteelCentral AppResponse 11 and we are unable to interpret the "Most Frequent Codes" card in the insights?

E.G. How do we make sense of codes shown below?

Solution

The format of the codes which are shown in the above chart vary from each Database Management System.
  • The return code for SQL Server is built in the following way - MSGNUM_MSGSTATE_MSGCLASS

    For example "8152_14_16" is for SQL Server DBMS.
    8152 means “the value would be truncated”
    16 indicates “general error”
    14 indicates msg state
     
  • The return code for DB2 is built in the following way - SQLCODE(SQLSTATE)

    For example "-204(42704)" is for DB2 DBMS
    -204 means name IS AN UNDEFINED NAME
    42704 means object does not exist
     
  • The return code for Oracle is built in the following way - ORA-<error> or SQL-<error>

    For example "ORA-12154" is for Oracle DBMS
    ORA-12154 means TNS:could not resolve the connect identifier specified
     
  • The return code for Sybase is built in the same way as SQL SERVER - MSGNUM_MSGSTATE_MSGCLASS
     
  • The return code for Teradata is built in the following way - ErrorCode_InfoCode

Return codes for some popular DB types can be found below
  • Oracle:
    https://docs.oracle.com/cd/E57185_01/EPMBU/ch01s03.html
  • DB2:
    https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/codes/src/tpc/db2z_n.html
  • Informix:
    https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.em.doc/errors.html
  • SQL Server:
    For SQL Server you can execute the below command on MASTER DB to get the list of codes
    USE MASTER
    GO

    SELECT * FROM SYS.MESSAGES
  • Sybase:
    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.mainframeconnect_12.6.msgcds/html/msgcds/msgcds31.htm
  • Teradata:
    https://docs.teradata.com/reader/AqtT8IJdAuhShWsvC9N9Og/eJNCtr0bAXMLaksoHp6Rog

 

Environment

SteelCentral AppResponse 11
NOTICE: Riverbed® product names have changed. Please refer to the Product List for a complete list of product names.
Last Modified: 2019-01-09
Can't find an answer? Create a case