Troubleshooting
Problem
When migrating a DB2 database, the db2ckupgrade command could produce an error as follows:
[IBM][CLI Driver][DB2/AIX64] SQL0430N User defined function "
Cause
The DB2 fenced user id has been removed or does not have adequate permission on the DB2 instance.
Diagnosing The Problem
To check if the DB2 fenced user id exists, issue the following command:
ls -al $HOME/sqllib/.fenced
... where $HOME is the instance home directory
For example:
$ ls -al /home/db2inst1/sqllib/adm/.fenced
-r--r--r-- 1 8413 db2fadm1 0 Jun 5 09:59
The owner of the .fenced file should be the fenced user id on the system. If this user shows up as a numeric value then that represents the id of a user that was dropped. That is confirmation that the user does not exist. In the above example "8413" would represent the id of a fenced user that no longer exists on the system.
Resolving The Problem
Issue the db2iupdt command with the -u option and select a valid fenced user id.
For example:
$ db2iupdt -u db2fenc1
The db2iupdt command needs to be run as root and executed from the $DB2DIR/instance directory, where $DB2DIR is the installation directory for DB2 (for example: /opt/ibm/db2/V10.5).
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21675643