IBM Support

DB2 Java routine may fail with SQL1646N error on AIX and db2fmp process killed with signal 4

Troubleshooting


Problem

Calling a Java stored procedure or user defined function on DB2 running on AIX systems may fail with a SQL1646N error as well as the db2fmp processes will be killed with a signal 4 (SIGILL)

Symptom

The following error may be seen when calling the Java Routine:

SQL1646N A routine failed because the fenced user ID cannot access
required files in the sqllib directory or other instance or
database directories.

In the db2diag.log, the following errors may be reported:

2014-02-05-23.27.55.861318+060 I9193A672 LEVEL: Severe
PID : 10158550 TID : 18021 PROC : db2sysc 0
INSTANCE: instance NODE : 000 DB : db
APPHDL : 0-2185 APPID: *LOCAL.instance.140205222738
AUTHID : authid HOSTNAME: host
EDUID : 18021 EDUNAME: db2agent (DB) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFF992=-1646
SQL1646N A routine failed because the fenced user ID cannot access
required files in the sqllib directory or other instance or database
directories.


2014-02-05-23.27.55.861313+060 E9866A447 LEVEL: Error
PID : 11731124 TID : 258 PROC : db2wdog 0 [db]
INSTANCE: instance NODE : 000
HOSTNAME: host
EDUID : 258 EDUNAME: db2wdog 0 [instance]
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:6921
DATA #1 : <preformatted>
Beginning cleanup of Process id: 18874612, OSS term code: 0x101, signal: 4

2014-02-05-23.27.55.873511+060 E10314A478 LEVEL: Error
PID : 11731124 TID : 258 PROC : db2wdog 0 [db]
INSTANCE: instance NODE : 000
HOSTNAME: host
EDUID : 258 EDUNAME: db2wdog 0 [instance]
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:7127
DATA #1 : <preformatted>
A 64-bit fenced mode process crashed. Process id: 18874612, OSS term code: 0x101, signal: 4, bringDown: 0

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.1;10.5;9.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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.

Document Information

Modified date:
30 April 2025

UID

swg21666901

Page Feedback