cancel
Showing results for 
Search instead for 
Did you mean: 

Database error -206 at OPC Error in DB2

0 Kudos

Dear All

System is showing below mentioned issue on regular basis in SM21 and also same error occur when i trying to check table space.

System details

SAP ERP 6.0 EHP 5 / EHP2 FOR SAP NETWEAVER 7.0

OS : AIX 6.1

DB : db2 09.07.003

Error :

1. When try to check table space (db12/st04).

"SQL0206N "DBPARTITIONNUM" is not valid in the context where it is used. SQLSTATE=42703"

2. In sm21 :

Red : Database error -206 at OPC

Information : SQL0206N "DBPARTITIONNUM" is not valid in the context where

User : SAPSYS

Thanks,

Accepted Solutions (0)

Answers (1)

Answers (1)

oliver_brein
Discoverer

Dear V R Madhukumar,

SAP_BASIS 7.00 with DB2 for LUW 9.7 FixPack 3 is a very old combination.
Please make sure that your system is on an SAP-certified FixPack level
(see SAP Note 101809 - DB6: Supported Db2 Versions and Fix Pack Levels)
and check the system requirements in SAP Note 1251160 - Using Db2 V9.7 with SAP applications.

If all this requirements are fulfilled in your system, then I could imagine that the
DBA Cockpit master note (SAP Note 1314750 - DB6: DBA Cockpit Correction Collection SAP Basis 7.00 / 7.10)
is not implemented and its implementation would solve the issue.

Another option is that you monitor your system remotely with a much newer Solution Manager system
and you receive the error when you are trying to use the DBA Cockpit locally on the system.
In this constellation, the local DBA Cockpit, which is on a much older code base, is not compatible
with the data collectors owned by the Solution Manager system.
In this scenario, the monitoring should be done using the DBA Cockpit connecting remotely from the Solution Manager
to your system.

I hope this gives you some ideas where to check.
If it doesn't help in your case, please open an incident on component BC-DB-DB6-CCM
and we will analyze your problem.

Best Regards,
Oliver