I installed DB2 in Linux OS. I tried to create database and I am
getting the following error message:

SQL0444N Routine "db2spcat" (specific name "SQL060216094049640") is
implemented with code in library or path
".../sqllib/function/db2spcat", function "db2spcat" which cannot be
accessed. Reason code: "4". SQLSTATE=42724

I looked at
http://www-1.ibm.com/support/docview...=UTF-8&lang=en
The info given in the above link is for AIX 5.2 and 5.3 and I am
running DB2 on Redhat Linux (Fedora Core 4). Can anyone guide me to fix
this error in Linux system, please? Thanks for your time and help.
NG

Looks like your installation is corrupted or not complete. db2spcat is
shipped with DB2 and should always be under sqllib/function/. You can
check whether the file is there and make sure it's of valid linux
format. (reason code 4 means DB2 can't find the library or can't load
it). I would just reinstall DB2.

NG wrote:
> I installed DB2 in Linux OS. I tried to create database and I am
> getting the following error message:
>
> SQL0444N Routine "db2spcat" (specific name "SQL060216094049640") is
> implemented with code in library or path
> ".../sqllib/function/db2spcat", function "db2spcat" which cannot be
> accessed. Reason code: "4". SQLSTATE=42724
>
> I looked at
> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
> The info given in the above link is for AIX 5.2 and 5.3 and I am
> running DB2 on Redhat Linux (Fedora Core 4). Can anyone guide me to fix
> this error in Linux system, please? Thanks for your time and help.
> NG

On second thought, if I remember correctly, db2spcat is not fenced, so
it's should be under sqllib/function/unfenced.

Liu Liu wrote:
> Looks like your installation is corrupted or not complete. db2spcat is
> shipped with DB2 and should always be under sqllib/function/. You can
> check whether the file is there and make sure it's of valid linux
> format. (reason code 4 means DB2 can't find the library or can't load
> it). I would just reinstall DB2.
>
> NG wrote:
> > I installed DB2 in Linux OS. I tried to create database and I am
> > getting the following error message:
> >
> > SQL0444N Routine "db2spcat" (specific name "SQL060216094049640") is
> > implemented with code in library or path
> > ".../sqllib/function/db2spcat", function "db2spcat" which cannot be
> > accessed. Reason code: "4". SQLSTATE=42724
> >
> > I looked at
> > http://www-1.ibm.com/support/docview...=UTF-8&lang=en
> > The info given in the above link is for AIX 5.2 and 5.3 and I am
> > running DB2 on Redhat Linux (Fedora Core 4). Can anyone guide me to fix
> > this error in Linux system, please? Thanks for your time and help.
> > NG

Hi Liu:
Thanks for the info. I copied db2spcat from /sqllib/function/unfenced
to /sqllib/function and it fixed the problem! Thanks again.
NG