PI44951: NO ROWS RETURNED FROM CLI INVOCATION OF REMOTE DB2 FOR Z/OS PROCEDURE THAT RETURNS AN ACCELERATED QUERY RESULT SET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ODBC CLI application requested DB2 for z/OS QUERY
  ACCELERATION and then invoked a remote DB2 for z/OS SQL
  native procedure that is expected to return a result set from
  a query that is accelerated to an accelerator server.
  However, when the DB2 procedure terminated, CLI did not return
  result set data to the CLI application, and also no -SQLCODE.
  .
  Note that the same behavior occurs when using the CLI Command
  Line Processor ( CLP ) to invoke the remote DB2 for z/OS
  procedure. The procedure can also be a DB2 stored procedure,
  not only an SQL native procedure.
  .
  Examination of related trace information shows that DB2 for
  z/OS did return the result set data to the CLI client.
  .
  IBM investigation determined that the incorrout in this very
  specific case of "using CLI to invoke a remote DB2 for z/OS
  procedure that returns an accelerated query result set"
  occurred because DB2 for z/OS returned the procedure query
  result set in ' fixed row protocol ' that ODBC CLI did not
  expect for this query.
  

Local fix

• If the CLI invoking application (or CLP) did not request DB2
  query acceleration (or specifically used QUERY ACCELERATION
  NONE ), then CLI returned result set data to the application
  as expected.
  .
  This INCORROUT only occurred when using ODBC CLI to invoke
  the remote DB2 for z/OS procedure. When invoking the DB2
  procedure using non-CLI interfaces (even remotely), result set
  data was returned to the user as expected, even when the
  result set query is accelerated. Also, when using CLI (either
  an application or CLP) to execute the remote accelerated query
  as 'stand-alone' on DB2 for z/OS 'outside' of the DB2 remote
  procedure, the query result was also returned to the user.
  .
  .
  Additional search keywords: INCORROUT IDAAV3R1/K IDAAV4R1/K
                              SQLPROCEDURE SQLSP SQLSTOREDPROC
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of remote DB2         *
  *                 for z/OS procedures called from CLI          *
  *                 applications that return an accelerated      *
  *                 query result set.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using an ODBC CLI application      *
  *                      to invoke a remote DB2 procedure that   *
  *                      returns an accelerated query result     *
  *                      set, CLI did not return result set      *
  *                      data to the CLI application. The        *
  *                      CALL statement did not return a         *
  *                      negative SQLCODE either.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This specific problem occurred because, when DB2 for z/OS
  returned the accelerated result set, DB2 did not use the
  protocol expected by ODBC CLI driver.
  

Problem conclusion

• DB2 for z/OS code is modified to return an accelerated query
  result set in the protocol expected by ODBC CLI.
  
  Additional Keywords:
  INCORROUT SQLINCORROUT SQLINCORR DB2INCORR/K
  IDAAV3R1/K IDAAV4R1/K SQLPROCEDURE SQLSP SQLSTOREDPROC
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI32277 UI32278

Modules/Macros

• DSNXEPM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI32277

     UP15/11/06 P F511

• RB10 PSY UI32278

     UP15/11/06 P F511

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.