We have two instances db2gwaf8 and db2gwaq8.They have different path for SQLLIB.
I backup/restore my database from instance db2gwaf8 to db2gwaq8.
When I tried to run stored procedure, I got the error SQL0444N.
I checked my db2diag.log file and find out that the db2 trying to load the
SQL stored procedure library from the path of db2gwaf8( the instance
from the backup has taken).
After I used the command the command db2rbind , the error has gone.
Now my question is that "Is there any catalog table or command that I
can search to find the path of the library. Remember that it is SQL stored
procedure. The library always goes to a specific path"