05-23-2018 11:34 PM
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
05-23-2018 11:54 PM
This is a DB2 error.
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.
Reissue the Backup or Restore command with a valid database alias.