SAP Knowledge Base Article - Preview

2744189 - sp_iqcheckdb using OUTPUT TO runs slower and the report is printed twice in the IQMSG file since upgrading to 16.1 – SAP IQ

Symptom

  •  Post upgrading to IQ version 16.1 when running the sp_iqcheckdb stored procedure using an OUTPUT TO statement, the procedure appears to run slower.

  •  The DBCC consistency report produced is printed to the iqmsg file twice.

  •  This only happens when the checkdb is run for wide table objects where the number of columns is in the region of 500 or more.

  • The SQL request level logging appears to show the SQL statement being PREPAREd and EXECUTEd  twice.

  • Client side messages that may be seen that indicate you are hitting this issue...
    (First 500 rows)
    Note: Some of the data values have been truncated for display purposes.
  • The issue may also be affecting other stored procedures using the OUTPUT TO statement and wide objects.


Read more...

Environment

  • SAP IQ 16.1 and above on all platfroms

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

sybase, double, duplicate, degrade, performance, messages, checkdb, 'check db', replicated, isql, dbisql, proc, spcheckdb, consistency, check, linux, solaris, rhel, , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.