DB2 V11? May require ODBC service

[Ed_Arnold]

PI05686 needs to be installed if you receive the following -518:


>  Fetch row failed -1                                                         
>  ODF SQL entry print_error rtn                                               
>  ODF SQL SQLSTATE: 07003                                                     
>  ODF SQL Native Error Code: -518                                             
>  ODF SQL buffer: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015}                     
>   DSNT408I SQLCODE = -518, ERROR:  THE EXECUTE STATEMENT DOES NOT IDENTIFY A
>            VALID PREPARED STATEMENT                                         
>   DSNT418I SQLSTATE   = 07003 SQLSTATE RETURN CODE                           
>   DSNT415I SQLERRP    = DSNXERT2 SQL PROCEDURE DETECTING ERROR               
>   DSNT416I SQLERRD    = -280  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION     
>   DSNT416I SQLERRD    = X'FFFFFEE8'  X'00000000'  X'00000000'  X'FFFFFFFF'   
>            X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION               
>    ERRLOC=5:10:2


Ed

[Ed_Arnold]

The previous append's error was found with DB2 V11 in NFM.

With DB2 V11 in Compat Mode we've had a report of -501's received until the fix was applied.

PI05686 is like American Express - don't leave home without it.

Better yet, just put on all fixes available for the ODBC FMID.   

Ed

[Ed_Arnold]

We have also found a problem when using DB2 V11 resolved by CA PTF RO66822 .

Ed