SAP Knowledge Base Article - Preview

2262379 - 'LOCK TABLE' command is not supported on any Secondary server in Multiplex - SAP IQ

Symptom

  • IQ 16.0 doesn't support 'Lock Table in write mode' in a Secondary server.
  • The following error is reported in IQ 16.0 SP10.x:

(DBA)> lock table "BASE_TAB01" in write mode wait
     Could not execute statement.
     Permission denied: Command not allowed on Multiplex Writer servers.
     (saintlib/saint_iqthresholdddl.cxx 11805)
     SQLCODE=-1004015, ODBC 3 State="HY000" Line 1, column 1

  • However, in IQ 12.7 this feature was successfully used on a Reader node which had Local Store in Multiplex. There was no errors.


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2
  • Multiplex

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

CR793936, CR#793936, 793936 , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.