Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2010
    Posts
    3

    Unanswered: Get SQL1031N after restart

    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.
    Last edited by PandaVN; 11-24-10 at 05:43.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you add entries for db2panda to the services files on both machines?

  3. #3
    Join Date
    Nov 2010
    Posts
    3
    Quote Originally Posted by n_i View Post
    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

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Please show the actual database catalog contents on the server.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by PandaVN View Post
    (on client)
    >db2 catalog tcpip node db2tcp1 remote <servername> server db2panda
    Try this on the client:
    Code:
    db2 catalog tcpip node db2tcp1 remote <servername> server 5038
    (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.

  6. #6
    Join Date
    Nov 2010
    Posts
    3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •