SAP Knowledge Base Article - Preview

3060416 - SQL1390C The environment variable DB2INSTANCE is not defined or is invalid.

Symptom

Following Db2 upgrade sql error SQL1390C is reporting on db startup.
============================================================================
c:\Windows\system32> echo %DB2INSTANCE%
db2tst
    
c:\Windows\system32> db2start
SQL1390C  The environment variable DB2INSTANCE is not defined or is invalid.
============================================================================
  
The db2diag.log reports the following:
============================================================================
2021-05-25-15.18.45.009000+480 E3102F461            LEVEL: Severe
PID     : 1448                 TID : 1828           PROC : db2start.exe
INSTANCE: DB2TST               NODE : 000
HOSTNAME: VM-Temp1
EDUID   : 1828
FUNCTION: DB2 UDB, oper system services, sqloStartDB2Service, probe:20
DATA #1 : <preformatted>
Service start error.
Service name: DB2TST
Machine name: (null)
Error: DB2TST : The specified service does not exist as an installed service.
============================================================================


Read more...

Environment

DB2 LUW (DB6) any version

Product

SAP ERP 6.0

Keywords

-1390 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.