DB2 version mismatch in SAP-DBACOCKPIT and OS level

[former_member214464]

Hello All,

We have carried out FP upgrade on our DB2 from DB29.7 FP 4 to FP10.

On OS level, when we check the DB level, it shows the level to be DB2 9.7.0.10 ( which is what we expect).

Now when we login into through SAP GUI, and go to System --> Status

Now when I go to DBACOCKPIT, I can see this :

We have our DBSL level at 600 for kernel release 721 (64 bit UC on AIX ) and sub pkg level at 600.

Only latest level of DBSL is 617, available on SAP SMP.

Can anyone explain the reason for this discrepancy?

Regards,

Hrishav

[former_member214464 · Accepted solution]

Hello All,

We found the solution for this error.

Actually our client software was not updated properly. When we checked in Sm50 and picked up any work process trace it showed client software to be at 9.7 FP4 and DB server version to be at 9.7 FP9 ( which we still do not understand how FP9 was being shown as we have upgraded from FP4 to FP10 ) . Though with db2level command, it showed to be 9.7 FP10 at OS level.

Then we thoroughly studied the client upgrade script ( line by line what it was doing) and came to know that there was a file missing at a location.

Now we browsed through the download section in SAP SMP and found that SAP has started to deliver Client Software separately and there is also a Client folder in Actual FP SAR as well. Also the FP Note 1363169 does not specify about this.

The note mentions this :

     4. Download the attachment db6_update_client.SAR to the subdirectory <temp>/CLIENT, and unpack it there using the program SAPCAR.

We had this(db6_update_client.SAR) from our previous updates and used the same and this is where we were mistaken.

Just an addition please run "db6level" to check client version on all the application server hosts, as <SID>adm, in addition to "db2level".

Usefull commands can be found here :

Initially SAP support told that it is a problem with DBACOCKPIT for DB2 9.7 FP10 to which we said to release a note to. Then again no response was from their side.

Thank you for all the help.

Regards,

Hrishav

[Frank-Martin · Accepted solution]

Hi Hrishav,

thanks for posting the solution. Maybe the old 9.7 FP4 client has not yet been able to display two digit FP numbers.

Regards

                Frank

[former_member214464 · Accepted solution]

Hello Frank,

That would have been acceptable if it would have show FP4 in the SAP as well.

But FP9 being shown is totally not acceptable. We weren't not talking about decimals that SAP thought to round off to nearest possible correct ( assumed ) value.

Its a great relief for us that its showing correct value now. Also debugging approach of the client upgrade script helped us a lot.

Kudos for your efforts and interest, the same for my mates as well.

Regards,

Hrishav

[teddylv_andersen2]

http://service.sap.com/sap/support/notes/1558958 might help

[former_member214464]

Hello,

We had considered this option. Actually the same problem was there ( and still there) in our BW landscape system.

There we had notified it to SAP via OSS message that we have updated this note version in our system. Then SAP asked us to update DBSL version ( which is now at n-1 level in our ECC ) which we couldn't do for BW as it involved downtime.

And for ECC we are are n-1 in terms of kernel patch as well.

Regards,

Hrishav

[Frank-Martin]

Hi,

did you run the db6_update_db script after upgrading to FP10?

Maybe FP10 is not committed yet. What is the output of the following query?

db2 "select * from sysibm.sysversion "

Regards

                  Frank

[Frank-Martin]

Sorry,

db2 " select * from sysibm.sysversions"

[former_member214464]

Hello, Thank you for responding.

Yes we did run db6_update_db script after upgrading to FP10

The query given by you gives following output at last:

9071000 2015-10-29-21.54.30.274784 DB2<SID>                                                                                                                           special_34106

The date & time-stamp is the same when we had applied FP10 on this DB.

Regards,

Hrishav

[Frank-Martin]

Interesting. I looked at another system running with DB2 9.7 FP10 and it shows 09.07.0010 in DBACOCKPIT.

Which client and DB versions are shown in your dev_w* traces? Die you upgrade your client to FP10 too?

Regards

               Frank