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 for Me (Login required).

Search for additional results

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