Question & Answer
Question
Why do DB2 commands like db2start or db2stop when executed from db2cmd.exe sometimes fail with SQL1092N ?
Cause
SQL1092N is received when the requested command or operation fails because the user ID does not have the authority to perform the requested command or operation.
This may be caused due to an User Access Control feature introduced by Microsoft® Windows in Windows 2008, Windows 2012, Windows Vista and Windows 7.
Answer
On Microsoft® Windows 2008, Windows 2012, Windows Vista, and Windows 7, by default, applications start with only standard user rights, even if the user is a local administrator.
To start an application with further privileges, you should use db2cmdadmin.exe instead of db2cmd.exe .
The DB2 installation process creates a shortcut called "Command window - Administrator" in 'Start Menu > Programs > IBM DB2 > DB2COPY* > Command Line Tools'. This shortcut calls db2cmdadmin.exe internally.
Alternatively you may want to disable User Access Control feature on Windows Operating system level or you may right click on db2cmd.exe and then select 'Run as Administrator' option to execute privileged commands like db2start or db2stop from db2cmd.exe itself.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21662159