Skip to Content
0
Former Member
Aug 17, 2011 at 03:03 PM

After system copy facing error in DBACOCKPIT

283 Views

Dear All

We are installing QAS server through system copy from DEV server.But after installtion when we run transction it's give us errors.

Wed Aug 17 15:44:29 2011

M ThEMsgArrived: sysmsg_for_rfc = 0

B Connect to +++DB6ADM as DB2DEV with DB6_DB_NAME=QAS;DB6_DB_SCHEMA=SAPQAS

C *** ERROR in DB6Connect[dbdb6.c, 1792] CON = 1 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQ

C &+ LSTATE=08004

C &+

C &+

C &+ ABAP location info 'CL_SQL_CONNECTION=============CP', 334

C &+ SAP user 'SM_IBM', transaction code 'DBACOCKPIT'

C &+

C *** ERROR in DB6Connect[dbdb6.c, 1792] (END)

C *** ERROR => DbSlConnect to 'QAS' as 'DB2DEV' failed

[dbdb6.c 1797]

C {root-id=0050563700011ED0B297BB2AFD244193}_{conn-id=00000000000000000000000000000000}_0

B ***LOG BY2=> sql error -1060 performing CON [dbds 902]

B ***LOG BY0=> SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQLSTATE=08004 [dbds 902]

B ***LOG BY1=> sql error -1060 [dbacds 1496]

B

B Wed Aug 17 15:44:30 2011

B Connect to +++DB6ADM as DB2DEV with DB6_DB_NAME=QAS;DB6_DB_SCHEMA=SAPQAS

C *** ERROR in DB6Connect[dbdb6.c, 1792] CON = 1 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQ

C &+ LSTATE=08004

C &+

C &+

C &+ ABAP location info 'CL_SQL_CONNECTION=============CP', 334

C &+ SAP user 'SM_IBM', transaction code 'DBACOCKPIT'

C &+

C *** ERROR in DB6Connect[dbdb6.c, 1792] (END)

C *** ERROR => DbSlConnect to 'QAS' as 'DB2DEV' failed

[dbdb6.c 1797]

C {root-id=0050563700011ED0B297BB2AFD244193}_{conn-id=00000000000000000000000000000000}_0

B ***LOG BY2=> sql error -1060 performing CON [dbds 902]

B ***LOG BY0=> SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQLSTATE=08004 [dbds 902]

B ***LOG BY1=> sql error -1060 [dbacds 1496]

B Connect to +++DB6ADM as DB2DEV with DB6_DB_NAME=QAS;DB6_DB_SCHEMA=SAPQAS

C *** ERROR in DB6Connect[dbdb6.c, 1792] CON = 1 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQ

C &+ LSTATE=08004

C &+

C &+

C &+ ABAP location info 'CL_SQL_CONNECTION=============CP', 334

C &+ SAP user 'SM_IBM', transaction code 'DBACOCKPIT'

C &+

C *** ERROR in DB6Connect[dbdb6.c, 1792] (END)

C *** ERROR => DbSlConnect to 'QAS' as 'DB2DEV' failed

[dbdb6.c 1797]

C {root-id=0050563700011ED0B297BB2AFD244193}_{conn-id=00000000000000000000000000000000}_0

B ***LOG BY2=> sql error -1060 performing CON [dbds 902]

B ***LOG BY0=> SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQLSTATE=08004 [dbds 902]

B ***LOG BY1=> sql error -1060 [dbacds 1496]

B Connect to +++DB6ADM as DB2DEV with DB6_DB_NAME=QAS;DB6_DB_SCHEMA=SAPQAS

C *** ERROR in DB6Connect[dbdb6.c, 1792] CON = 1 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQ

C &+ LSTATE=08004

C &+

C &+

C &+ ABAP location info 'CL_SQL_CONNECTION=============CP', 334

C &+ SAP user 'SM_IBM', transaction code 'DBACOCKPIT'

C &+

C *** ERROR in DB6Connect[dbdb6.c, 1792] (END)

C *** ERROR => DbSlConnect to 'QAS' as 'DB2DEV' failed

[dbdb6.c 1797]

C {root-id=0050563700011ED0B297BB2AFD244193}_{conn-id=00000000000000000000000000000000}_0

B ***LOG BY2=> sql error -1060 performing CON [dbds 902]

B ***LOG BY0=> SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQLSTATE=08004 [dbds 902]

B ***LOG BY1=> sql error -1060 [dbacds 1496]

B

B Wed Aug 17 16:12:36 2011

B Connect to +++DB6ADM as DB2DEV with DB6_DB_NAME=QAS;DB6_DB_SCHEMA=SAPQAS

C *** ERROR in DB6Connect[dbdb6.c, 1792] CON = 1 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1060N User "DB2DEV " does not have the CONNECT privilege. SQ

C &+ LSTATE=08004

C &+

I can't understand we are installed QAS server why it's show User "DB2DEV for connection

I am also oracle DBA but new in DB2

Please guide me

Regards