cancel
Showing results for 
Search instead for 
Did you mean: 

error during restoring DB2 database using command line

tarmizi
Level 5
Partner Accredited Certified

Hi all,

We are in the midst of trying to perform DB2 database restoration at another location. Using the db2 command "restore db xxx load "C:\Program Files\Veritas\NetBackup\bin\nbdb2.dll" taken at 20180520044218 into xxx-test redirect" , we facing an error "SQL2040N The database alias parameter "xxx-test" is not valid or not specified". 

Have any idea? For information, the db2.conf file is configured for alternate restore. Any place to check?

Thank you

1 REPLY 1

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

This is a DB2 error.

See https://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql0...

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.