no tablepsace information in dbacockpit

[Former Member]

Hi Experts,

Recently we have done system refresh to our  development box .We are facing one issue where we are not able to see the tablespace information in DBACOCKPIT transaction.

System details:

OS -->Linux x86_64

DB--->"DB2 v9.7.0.5  64 bit

SAP--->SAP ECC6.0

We have cross checked the SAP Note 956214 - DB6: SQL0443N after upgrade to a new SAP release and followed the instructions given in the note.

As per the note , we have checked the db settings & user settings , but still we are facing the issue.Below is the observation too.pls provide us few workarounds

Further the error in DBACOCKPIT is also attached for reference.

GROUP:

sapsys:x:201:ZZZadm,sapZZZ,sapZZZdb,sapsr3,sapsr3db

sapinst:x:59278:ZZZadm,db2ZZZ

dbZZZctl:x:21708:ZZZadm

dbZZZmnt:x:21709:sapZZZ,sapZZZdb,sapsr3,sapsr3db

dbZZZadm:x:21710:sapZZZ,sapZZZdb,db2ZZZ,sapsr3

dbZZZmon:x:21711:sapZZZ,sapZZZdb,sapsr3db,sapsr3

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

db2ZZZ> db2 get dbm cfg

Database Manager Configuration

Diagnostic data directory path               (DIAGPATH) = /db2/ZZZ/db2dump/

SYSADM group name                        (SYSADM_GROUP) = DBZZZADM

SYSCTRL group name                      (SYSCTRL_GROUP) = DBZZZCTL

SYSMAINT group name                    (SYSMAINT_GROUP) = DBZZZMNT

SYSMON group name                        (SYSMON_GROUP) = DBZZZMON

Default database path                       (DFTDBPATH) = /db2/ZZZ

TCP/IP Service name                          (SVCENAME) = sapdb2ZZZ

Discovery mode                               (DISCOVER) = SEARCH

Discover server instance                (DISCOVER_INST) = ENABLE

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

id sapZZZ

uid=21595(sapZZZ) gid=21709(dbZZZmnt) groups=21709(dbZZZmnt),201(sapsys),21710(dbZZZadm),21711(dbZZZmon)

id sapsr3

uid=44136(sapsr3) ,201(sapsys),21709(dbZZZmnt),21710(dbZZZadm),21711(dbZZZmon).

Regards

Ram

[paul_power · Accepted solution]

Hi Ram,

you mentioned that this is after a refresh of the dev systems, assuming the system id is DEV and that it was copied from QAS.

Then I presume the error you are seeing in the system log is:

Database error -443 at FET

SQL0443N Routine "SNAPSHOT_DBM" (specific name

"SNAPSHOT_DBM") has returned an error SQLSTATE with diagnostic

text "SQL1092 Reason code or token: SAPQAS".

In this example, the sid of the new system is DEV, so it looks like the wrong

user is logged for the database connection in dbacockpit. and the logon

info of this user can be updated in table DBCON by transaction dbco.

then please update the logon info to the correct  user 'SAPDEV' with the correct

password with the transaction dbco. After this please check to see if

current errors you met could be solved.

Please update if issues persist.

Regards,

Paul

[Former Member · Accepted solution]

Hi Paul,

You have pointed the exact error am facing now.Let me know if i have to update user DB2xxx in table DBCON in Tx dbco , do i need to restart the application & the database?

Will it have any impact ?

Regards

Ram

[paul_power · Accepted solution]

Hi Ram,

After updating DBCON to the correct user and password of the new system, it should not be needed to restart application and db. As far as I know, just closing and then restarting the dbacockpit should pick up the new connect user. Then when the background procedure  SNAPSHOT_DBM runs, it should not end with the mentioned error and you will then start to see tablespace data (will need to wait for the background SNAPSHOT_DBM to complete next before it shows)

regards,

Paul

[Former Member · Accepted solution]

Hi Paul,

Thanks for your valuable input.

Rightnow, i don't have the password for DB2<sid> user while i log into to DB2 instance manager via putty server

.

Therefore, initially i need to change the password for db2<sid> user.

Let me know for updating the password for db2<sid> user do i need to bounce the DB and the application or it can be done runtime.(dynamically) without downtime...?

Regards

Ram

[paul_power · Accepted solution]

Hi Ram,

Please use the following command to set the password for the users:

passwd <sid>adm <password> ,
passwd sap<sid> <password> or if the system is created via a upgrade
passwd sapr3 <password>

after you have done this, you need to ensure the same password is updated in the db6conf file. Perform the following:

logon as <sid>adm
dscdb6up <sid>adm <password>
dscdb6up sap<sid> <password> or if the system is created via a upgrade
dscdb6up sapr3 <password>

You will need to restart sap and the db to pick up the new values.

regards,

Paul

[Former Member · Accepted solution]

Hi Paul,

I changed the password for user db2<dbsid>, i  logged on as user db2<dbsid> and enter the passwd command at the UNIX prompt. Then Entered  the old and new password.

After getting the right password,further updated the same new password in Transaction DBCO for the user db2<dbsid>.

Once updated successfully, i could see the tablepsace informations populating in Tx DBACOCKPIT or DB02/DB6SPACE Transaction

I did not bounce the app+db for updating the password for db2<dbsid>

Thanks a lot for your help!!!!

Regards

Ram

[paul_power · Accepted solution]

Hi Ram,

that's good to hear that the issue is resolved, even better that the restart was not needed.

Best regards,

Paul

[ashish_mishra2]

Hi Bharat,

Please check the SAP Note - 956214 for this issue.

Cheers !!!

Ashish

[Manas_Vincit]

Hi Bharat ,

what about DB02 , if this is returing the same error ?

After system copy you need to do execute below command which provide dbadm authoritiy to sap<sid>

db2 grant DBADM on database to user SAP<SID>

Thanks

Manas Behra

[former_member187565]

Hi Bharat,

Please check SAP Note 1367494  DB6: Tablespaces with AUTORESIZE are not displayed.

Also check whether you are able to check the info from RZ20 & try to reset the tree as given below process. (via T-cd:RZ20 -> SAP CCMS Monitor Templates -> Database -> DB2

Universal Database for NT/UNIX) and then execute report RSDBMON0

Regards,

Rafikul Hussain