Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    8

    Unanswered: Restore database from backup file - error code : SQL2040N

    I am trying to restore a database using option 'Database -> create -> database from backup' option of Control Center. after filling in the fields for database name, backup device, backup file date & time, i am not able to successfully restore the database. the message displayed is 'SQL2040N - database alias paramater <dbalias> not valid'. I gave the same alias name as that of the database of which the backup was taken.

    SQL2040N - says database alias parameter not valid
    DB2 version - 4.0

    where am i going wrong ?

    Regds
    Prashant
    Last edited by Prashant K; 06-03-04 at 02:23.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Explanation

    Hi Prashant,

    Given below is the explanation of the error.

    -----------------------------------------------------
    C:\>db2 ? SQL2040N


    SQL2040N The database alias parameter "<dbalias>" is not valid
    or not specified.

    Explanation:

    The application calling the Backup or Restore utility has
    supplied a database alias parameter that is not valid. The alias
    must be 1 to 8 bytes and the characters must be chosen from the
    database manager base character set.

    User Response:

    Reissue the Backup or Restore command with a valid database
    alias.
    ---------------------------------------------------------------------

    Try giving a dbalias name which is in between 1-8 characters and I think that should solve your problem
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Feb 2004
    Posts
    1
    What a useless reply...

    The guy has this error in his face.. We know what the generic HELP says since it comes with the SQL2040N error message we are getting.

Posting Permissions

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