75 ways to demystify DB2: #23: Techtip: Error SqlCode = -4700 returned to JCC applications after upgrading DB2/Z servers to V11 CM mode.
Subbu Prabhu 060001JD9S Visits (7582)
Recently we are seeing lot of cases where applications using IBM DB2 JDBC driv
I wanted to clarify about the error and explain the background.
-4700 is a sqlcode returned by the DB2/Z server.
It means: "ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE"
The error is returned when the application queries the special register CLIENT_CORR_TOKEN. This special register is not available in V11 CM and introduced in New Function Mode (NFM) only.
There are 2 cases:
Case 1: JCC driver has an API getJ
The API used to call the following query internally:
So if you are using an older JCC driver, upgrade it to V10.5 FP5 & above drivers. You can download it from here.
Case 2: If any application explicitly queries it using "Select CLIENT_CORR_TOKEN from sysibm.sysdummy", DB2/Z server will throw the -4700 error and its expected since the special register CLIENT_CORR_TOKEN is not available in DB2/Z V11 CM servers. You have to fix the application not to query that special register.
Hope this helps.
Feel free to post your comments/feedback in the comment section.