After system copy facing error in DBACOCKPIT

[Former Member]

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

[Former Member]

Hi,

It might be helpful for you to check the SAP note 1072206 and change administration connection accordingly.

Regards,

Masako

[former_member570797]

I agree with Masako's reply.

[former_member204746]

you answer can be found with the following link:

http://lmgtfy.com/?q=systemcopyerror+DBACOCKPIT