Results 1 to 4 of 4

Thread: DB Connection

  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Unanswered: DB Connection

    Database server = DB2/LINUX 8.1.3

    SQL1013N The database alias name or database name "DXDMIS01" could not be found. SQLSTATE=42705

    Encountered this problem after RESTARTING THE INSTANCE.
    Can somebody please tell me how I can get back the database.

    Obviously Cannot connect to the database. If not connect atleast Drop the Database.


    Thank You
    Vikram

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Re: DB Connection

    Start by running the 'db2 list database directory'
    command, this should give you information on
    existing databases. If ypur database is not on the list
    and you're attached to the right instance - the db
    doesn't exist and you dont need to drop it.

    If it exists and you cannat access it, simply run the
    'db2 drop database databasename' command.

    Tank

  3. #3
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96

    Re: DB Connection

    Originally posted by bollin99
    Database server = DB2/LINUX 8.1.3

    SQL1013N The database alias name or database name "DXDMIS01" could not be found. SQLSTATE=42705

    Encountered this problem after RESTARTING THE INSTANCE.
    Can somebody please tell me how I can get back the database.

    Obviously Cannot connect to the database. If not connect atleast Drop the Database.


    Thank You
    Vikram
    If 'db2 list db directory' doesn't show it you first need to check if it's still on disk. If nothing special was specified when creating the database it should be in the default db directory which is specified in the instance variable DFTDBPATH.
    If so, you can catalog the db again using the command
    'db2 catalog db DXDMIS01 on <DFTDBPATH>'.

    If you specified another location for your database when creating it you need to check that location and use it in the 'catalog db' command.

    Hope this helps.

    Kind regards, Gert

  4. #4
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    Vikram,

    R U try to access, DB from Db server or remote location ,


    If you are try access DB from remote site , you need to catalog DB at remote location.


    to catalog DB at remote site.


    db2 " catalog tcpip node NODENAME remote DBserverhostname server indtanceportnumber"

    db2 " catalog db DBNAME at NODENAME "

    db2 terminate

    Note : NODENAME ( generally instance name )
    indtanceportnumber you can port number from
    1. more /etc/services | grep instance

    you will get port number

    stiil , if have in issues, check your DBM config

    2 db2 get dbm cfg | grep SVCENAME


    if 1 & 2 command output is differ

    update dbm cfg by following command

    db2 update dbm cfg using SVCENAME ( 1 command output)

    restart the instance.


    that will work


    Let me know , if any questions


    Thank You

    Lekharaju Ennam

Posting Permissions

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