Skip to main content
commvault.com commvault.com
Answer

DB2 Restore Fails - SQLCODE = SQL2040N

  • June 11, 2025
  • 2 replies
  • 33 views
I
Byte
Forum|alt.badge.img+10

Hi.

I am attempting a restore of a database on a standalone DB2 server but get the following error.

Version: SQL11055 64bit

 

Error Code: [59:42]
Description: Restore operation on database [RESEOBFDB] could not be completed. Error [ ---- error report ---- app. message = restoring database line = 8778 file = ClDb2AgentLib.cpp SQLCODE = -2040 SQL2040N The database alias parameter "RESEOBFDB" is not valid or not specified. --- end error report --- ]. Please check the database configurations and ensure that the product's services are running on client, server, MediaAgent and resume.
Source: wdbmr02, Process: ClDb2Agent

 

Any help will be appreciated.

Thanks.

Ignes

 

Best answer by CV_GK

Hi ​@Iggy 

Please check https://www.ibm.com/docs/en/db2/11.1.0?topic=messages-sql2000-sql2249 for SQL2040N 

2 replies

CV_GK
Vaulter
Forum|alt.badge.img+7
  • CV_GKVaulter
  • Vaulter
  • Answer
  • June 12, 2025

Hi ​@Iggy 

Please check https://www.ibm.com/docs/en/db2/11.1.0?topic=messages-sql2000-sql2249 for SQL2040N 

I
Byte
Forum|alt.badge.img+10
  • Iggy
  • Author
  • Byte
  • June 12, 2025

Hi ​@CV_GK,

I am not really familiar with DB2 so wasn’t sure what was meant with an alias. Turns out the db name specified must be 8 characters maximum.

Thanks.

 

Terms & ConditionsCookie settingsAccessibility statement