Troubleshooting
Problem
Data Server Manager log files are full of SQLCODE=-206 "
Symptom
The symptoms can vary depending on each installation.
Most common scenario, DSM shows Data Pending status for the monitored database.
Cause
When you apply a new DB2 fixpack, the db2iupdt command is used to update an instance to a higher level within a release.
But that command does not necessarily update the database system catalog to support the new fix pack that you have installed.
Meaning, just because the db2level shows a higher level, your database can still be using routines from an older DB2 level.
Diagnosing The Problem
One way to verify what routine levels your database is using, you can run the following DB2 command on the monitored database:
db2 "select versionnumber from sysibm.sysversions order by 1 desc"
If the results is showing a lower level than the ones DSM supports, that means your environment
is not supported, and you are getting the SQLCODE=-206 error.
To verify what are the DB2 levels supported by DSM, please refer to the links below:
- System requirements for IBM Data Server Manager, version 1.1.2
- System requirements for IBM Data Server Manager, version 2.1
Resolving The Problem
Run the db2updvnn command according to the db2level of your monitored database:
- For DB2 V9.7 run db2updv97 command
- For DB2 V10.1 run db2updv10 command
- For DB2 V10.5 run db2updv105 command
- For DB2 V11.1 run db2updv111 command
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21983739