Re: [iqug] IQ 15.2 - Error trying to lock tables on writer node?

[Mark Mumy]

This is a known feature. Lock table can only be run on the coordinator node. Open a case and have it associated to the feature request to change this. Please!

Mark

========================
Mark D. Mumy
IQ/RAP Technology Specialist
Global FSI Solutions
Sybase, an SAP Company
VOICE: 972.687.6478
MOBILE: 347.820.2136
========================

Sent from my mobile device

On Jul 13, 2011, at 12:15, Ron Watkins <rwat...@dssolutions.com> wrote:

> Has anyone encountered an issue when trying to use the "lock table" command on a MPX writer node in IQ15.2?
> Im getting an error:
> SQL Anywhere Error -1004015: Permission denied: Command not allowed on Multiplex Writer servers. (saint_iqthresholdddl.cxx 14945)
> I can create/update/insert into base tables from the writer, but cannot issue lock table statements.
> Is this somthing simple/stupid that I don't have setup correctly in the MPX environment or is this a core "feature" of IQ15.2 MPX?
>
> --
> Ron Watkins
> Distributed Systems Solutions Inc.
> 480.558.2203
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: iqug-uns...@dssolutions.com
> For additional commands, e-mail: iqug...@dssolutions.com
>
> --
> You received this message because you are subscribed to the Google Groups "iqug" group.
> To post to this group, send email to iq...@googlegroups.com.
> To unsubscribe from this group, send email to iqug+uns...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/iqug?hl=en.
>

[Julie Nishimura]

For some reason, I've stopped receiving emails from IQ user group.
Will you please check if juli...@hotmail.com in the list please?
 
Thank you,
Julie Nishimura
 

> CC: iq...@dssolutions.com
> From: mark...@gmail.com
> Subject: Re: [iqug] IQ 15.2 - Error trying to lock tables on writer node?
> Date: Wed, 13 Jul 2011 12:57:26 -0400
> To: iq...@googlegroups.com

[Mark Mumy]

I wonder if the group has been quiet??

Just checked my email history (I keep the IQUG emails) and I haven’t had an email since 11 March.

Mark

To unsubscribe from this group and stop receiving emails from it, send an email to iqug+uns...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Julie Nishimura]

Yes, same here! Last email is from 11 March. Then I am good :)

 

Thanks

 

---

Subject: Re: [iqug] will you please check in my email address in the list?
From: mark...@gmail.com
Date: Thu, 16 Apr 2015 14:42:57 -0500
CC: iq...@dssolutions.com
To: iq...@googlegroups.com