Remote Access Problem

[charles2006]

I am new to DB2.
I installed DB2 Runtime client
Then I run Catalog TCPIP NODE command which tell me the command completed successfully
Next I try to connect to the database, I got error:
SQLSTATE=58031, The database directory cannot be found on the indicated file system.

Thanks in advance

Charles

 

[juliane26]

you have to catalog the database:

>db2 catalog tcpip node (which you did)
>db2 catalog db xxx at node yyy (which is missing)

or use the Configuration Assistant GUI (db2ca)

Juliane

 

[charles2006]

Hi Juliane
After I run the catalg command, it tell me Directory changes may not be dffective until the directory cache is refreshed. what am I going to do for that?

thanks

 

[juliane26]

well, usually it is there in the same session.
To terminate and clean a session:
> db2 terminate

it will automatically refresh with the next db2 connect command.



Juliane

 

[charles2006]

Hi Juliane

Thanks for your help
I run the catalog db command then I run Terminate command
It works now


Cheers

Charles