1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

You are getting an error message SQL1092N (DB2)

Friday, 23 January 2015 10:08

Written by Prakash Palani

Print E-mail

1. Make sure that the connect user "SAP" has necessary permissions :

db2 "SELECT DISTINCT GRANTEE, GRANTEETYPE, DBADMAUTH, SECURITYADMAUTH FROM SYSCAT.DBAUTH"

if not : assign using

db2 "grant dbadm on database to user SAP"

2. Make sure that SAPBA1 is part of OS Level Group : dbmnt

3. Make sure that DBM configurations have appropriate group settings as indicated below.

db2 get dbm cfg | grep group

SYSADM group name                        (SYSADM_GROUP) = DBADM

SYSCTRL group name                      (SYSCTRL_GROUP) = DBCTL

SYSMAINT group name                    (SYSMAINT_GROUP) =

SYSMON group name                        (SYSMON_GROUP) =

if not, then assign using :

db2 => UPDATE DBM CFG USING SYSMAINT_GROUP DBMNT

DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed

successfully.

db2 => UPDATE DBM CFG USING SYSMON_GROUP DBMON

DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed

Thanks

PrakashP

 

You are getting an error message SQL1092N (DB2)