SQL0444n when running select * from syscat.sequences

[harry smith]

Hello all,
I am having this weird issue. We have 5 different database in one db2
instance. when run following SQL 3 out of 5 database returns rows and in
another 2 databases its erroring out.

SQL: select * from syscat.sequences

Error:
SQL0444N Routine "SYSCAT.GETSEQ" (specific name "SQL0205071537") is
implemented with code in library or path "...sqllib/function/db2cl",
function
"CLI_udfGETSEQPD" which cannot be accessed. Reason code: "4".
SQLSTATE=42724

Any help is greatly appreciated.

-hrysmth

[faridx]

I believe you are using AIX as an operating system and you have more
than one instance. In such a case, instance owners should have proper
access to each others' path.
Please login as the instance owner who experiences the problem and cd to
home directory of the other instance owner(s). Then issue /usr/bin/pwd.
If it complains about lack of permission. That's the actual cause of
the problem. If not, cd to sqllib and issue the same command and then
cd to sqllib/function and do the same thing. One of these has a
permission problem. To solve the problem you should see your Unix
admin. It could be a mounting issue at Unix level.
This issue happens just on AIX and there is a good explanation for that
based on AIX architecture.
Regards,

--
Posted via http://dbforums.com