Getting DBACockpit error after applyied support pack

[Former Member]

Hi Expert,

i have applied the BASIS ABAP support package from level 18 to 26 now i am getting error in dbacockpit....

db2sap library has not yet been invoked (see SAP Note 1124987)

Therefore some functions may not work properly

Database is not yet configured for monitoring

and also db2 log not going to archive thats why log directory getting full is very fluently.

please advice me..

Regards

Shiv

[former_member189725]

Can you please let us know the Basis release and the DB2 version .

Refer this note Note 1521392 - DB6: Use of SAP specific table functions

check if db2sap library is present under /db2/db2<sid>/sqllib/function . If it exists , then it can be invoked as db2<sid> user.

db2 connect to <DBSID>

db2 invoke db2sap

db2 terminate

Now check in DBACOCKPIT , if the error persists .

For the second issue  check the reason for logs not getting shipped to archive location . What medium are you using filesystem,tape , TSM or any vendor library?

Regards

Ratnajit

[Former Member]

Dear Mr. Ratanjeet,

thanks for your reply,

as per your instruction DBAcockpit problem has been resolve but still logs not getting shipped to archive location and archive medium is TSM.

BASIS Release 7.00 26

DB2 level "DB2 v9.1.0.7" with fix pack 7

Kindly help...

[former_member189725]

I believe there is a long running transaction which is not freeing up log space in the system. Else check the TSM API(CLient)  is able to connect to TSM server . Check with the TSM team . Check in the db2diag.log the the last log shipped to TSM server. If the previous log to the current log in log_dir directory is sent to TSM server , it means you do not have issues with TSM. Then its a long running job which is the culprit.

Regards

Ratnajit