Troubleshooting
Problem
When using Query Tuning on DMC 3.1.12, it can fail with Error SQL1131 for the stored procedure SYSPROC.DESIGN_ADVISOR
Symptom
The view log panel in DMC is reporting an Error message
Status : error
The stored procedure did not run.
The stored procedure might not be installed and configured properly.
To configure the sotred procedure, open the Database Connections tab,
select the database and ensure it is connected, and the use the Query Tuning menu to select the Configure for Tuning option.
A stored procedure process has been terminated abonormally.
Routine name: "SYSPROC.DESIGN_ADVISOR". Specific name: "DESIGN_ADVISOR"..SQLCODE=-1311, SQLSTATE=38503, DRIVER=4.32.28
select the database and ensure it is connected, and the use the Query Tuning menu to select the Configure for Tuning option.
A stored procedure process has been terminated abonormally.
Routine name: "SYSPROC.DESIGN_ADVISOR". Specific name: "DESIGN_ADVISOR"..SQLCODE=-1311, SQLSTATE=38503, DRIVER=4.32.28
com.ibm.aps.tools.dsoe.wds.luw.db.DB2advisOperatorImpl.callDB2Advis(DB2advisOperatorImpl.java:181)
db2diag.log is printing Error message
2023-12-12-11.39.10.501049+060 E858624A946 LEVEL: Critical
PID : 23396650 TID : 1 PROC : db2fmp (20055) 0
INSTANCE: XXXXX NODE : 000 DB : XXXXXX
APPID : XXX.XXXXX.XXXX.XXXX
HOSTNAME: XXXXXX
EDUID : 1 EDUNAME: db2fmp (20055) 0
FUNCTION: DB2 UDB, oper system services, sqlo_dari_trca, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "FmpTrap".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"/path/sqllib/db2dump/FODC_FmpTrap_2023-12-12-11.39.1
0.499116_0000/". Please look in this directory for detailed evidence
about what happened and contact IBM support if necessary to diagnose
the problem.
PID : 23396650 TID : 1 PROC : db2fmp (20055) 0
INSTANCE: XXXXX NODE : 000 DB : XXXXXX
APPID : XXX.XXXXX.XXXX.XXXX
HOSTNAME: XXXXXX
EDUID : 1 EDUNAME: db2fmp (20055) 0
FUNCTION: DB2 UDB, oper system services, sqlo_dari_trca, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "FmpTrap".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"/path/sqllib/db2dump/FODC_FmpTrap_2023-12-12-11.39.1
0.499116_0000/". Please look in this directory for detailed evidence
about what happened and contact IBM support if necessary to diagnose
the problem.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m0z000000cwSsAAI","label":"DMC"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
ibm17099743