Hello everyone,

I have two machine, one for server(Win server 2003) and one for client(Win XP).Both of them use DB2 version 8.

The first time I created new instance and database, I could connect to database server. I did following steps:

(on server, the user name is same with instance name)
>db2icrt panda
>db2 update database manager configuration using svcename db2panda
>db2 catalog database mydb
>db2 -td~ -ascvf *.ddl (create mydb)
>db2 list database directory
database alias = mydb
database name = mydb
database drive = C:\panda
directory entry type = Indirect
....

>db2 connect to mydb user panda using <password>
>successfully

(on client)
>db2 catalog tcpip node db2tcp1 remote <servername> server db2panda
>db2 catalog database mydb at node db2tcp1
>db2 connect to mydb user panda using <password>
>successfully

After I restart server machine:
>db2 connect to mydb user panda using <password>
> SQL1031N The database directory cannot be found on the indicated file system.SQLSTATE=58031

Please help me solve this problem.
Thanks.

Did you add entries for db2panda to the services files on both machines?

I added "db2panda 5038/tcp" to services files on both of them. I try drop mydb database but also get SQL1031N. I drop panda instance and did steps at the beginning but the problem still occur. I saw mydb database in control center but I couldnot access tables because of SQL1031N

Please show the actual database catalog contents on the server.

Try this on the client:(after first dropping the client). The "/etc/services" is suppose to indicate to which ports the machine should be listening. This is true for the server but not for the client. The client tries to access this port on the server.

Thank n_i and dr_te_z for giving me your instructions. I found why the problem happen
I am sorry about fogetting to tell that my server machine has 6 user name and 6 DB2 instances. I checked service name of all instances and saw another one use svcename db2panda ! I updated them and could connect to database server correctly.

Thanks ,
PandaVN