Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Ohio
    Posts
    38

    Unanswered: SQL1013N Error connecting to DB

    I'm stumped on this one...

    I have a db on AIX that I can't connect to remotely. It is cataloged. I also have a NODE defined (not sure if even need that).

    Here is a listing of the nodes and db

    $ db2 list node directory

    Node Directory

    Number of entries in the directory = 1

    Node 1 entry:

    Node name = NODE1
    Comment =
    Protocol = TCPIP
    Hostname = myhost
    Service name = 50000

    $ db2 list db directory

    System Database Directory

    Number of entries in the directory = 1

    Database 1 entry:

    Database alias = LDAPDB2
    Database name = LDAPDB2
    Local database directory = /home/ldapdb2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = 0


    When I try to connect to it remotely (as the instance owner), I get the following error:
    "SQL1013N The database alias name or database name "LDAPDB2" could not be found. SQLSTATE=42705"

    What am I missing???

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: SQL1013N Error connecting to DB

    Originally posted by jodie
    I'm stumped on this one...

    I have a db on AIX that I can't connect to remotely. It is cataloged. I also have a NODE defined (not sure if even need that).

    Here is a listing of the nodes and db

    $ db2 list node directory

    Node Directory

    Number of entries in the directory = 1

    Node 1 entry:

    Node name = NODE1
    Comment =
    Protocol = TCPIP
    Hostname = myhost
    Service name = 50000

    $ db2 list db directory

    System Database Directory

    Number of entries in the directory = 1

    Database 1 entry:

    Database alias = LDAPDB2
    Database name = LDAPDB2
    Local database directory = /home/ldapdb2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = 0


    When I try to connect to it remotely (as the instance owner), I get the following error:
    "SQL1013N The database alias name or database name "LDAPDB2" could not be found. SQLSTATE=42705"

    What am I missing???
    You ran "list db directory" on the server, apparently. Is the database cataloged on the machine from which you're trying to connect?

  3. #3
    Join Date
    Aug 2003
    Location
    Ohio
    Posts
    38
    That's what I'm trying to do. On my PC, when I try to catalog it, I get the error.

    I also tried creating a remote listing in the catalog on the same machine. Same error.

    $ db2 list db directory

    System Database Directory

    Number of entries in the directory = 2

    Database 1 entry:

    Database alias = LDAP
    Database name = LDAPDB2
    Node name = NODE1
    Database release level = 9.00
    Comment =
    Directory entry type = Remote
    Catalog node number = -1

    Database 2 entry:

    Database alias = LDAPDB2
    Database name = LDAPDB2
    Local database directory = /home/ldapdb2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = 0

    $ db2 connect to ldapdb2

    Database Connection Information

    Database server = DB2/6000 7.2.8
    SQL authorization ID = LDAPDB2
    Local database alias = LDAPDB2

    $ db2 connect to ldap
    SQL1013N The database alias name or database name "LDAPDB2" could not be found. SQLSTATE=42705

    Hmmm...

Posting Permissions

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