[cisco-voip] two informix DB questions - ARP & last executed sql queries

[Tim Smith]

The actual parameter in that string should be <garp>

On Thu, Jun 4, 2009 at 8:41 PM, Tim Smith <thsglobal at gmail.com> wrote:

> Hi,
>
> I havent done it in 6 yet, but I think it will probably be the same.
> Look for a field called vendorConfig is this in the device table?
> It should have an XML string in it which contains this setting.
> Change it from the default to ensure it shows up.
>
> It's a string in a field, so each different device can have a bunch of
> settings specific to that model.
>
> Cheers,
>
> Tim
>
>
>
>
>
> On Thu, Jun 4, 2009 at 6:58 PM, <Thorsten.Mayr at barclayscapital.com> wrote:
>
>> Feels silly asking but I just can't find "Gratuitous ARP" in the DB.
>> Would have assumed that there is a reference under Device (!?)
>>
>> If someone have stumbled across it in CUCM 6.X - don't want to bother
>> TAC/HTTS with silly questions like this.
>>
>> - I checked the "Cisco Unified Communications Manager Data Dictionary"
>> for version 6.
>> - Looked at all fields of "device"
>>
>> might be that I need glasses
>>
>>
>> Talking about the DB...
>>
>> "Show tech dbstateinfo"
>>
>> The output (showtechdbstateinfoXXXX.out) does contain the  " Last parsed
>> SQL statement :" ...
>> Thought I'd be clever.... changed a setting on a phone, hit save and ran
>> the command on a test cluster 2 seconds after...
>> Either my sight really has gone downhill or the insert/update query
>> really doesn't show up.
>> The lab cluster doesn't really have too much going on...
>>
>> This leads me to the following questions:
>>
>> a) are queries from users/admins are executed as "stduser" (I believe
>> they are)
>> b) should the output of show tech dbstateinfo it contain the last
>> executed query of admin's
>>
>>
>> Thx in advance
>> T
>>
>> PS: in desperation I have tried:
>> run sql select tabname, colname, owner, coltype FROM syscolumns join
>> systables on syscolumns.tabid = systables.tabid where colname like
>> '%arp%'
>>
>> &&
>>
>> run sql select tabname, colname, owner, coltype FROM syscolumns join
>> systables on syscolumns.tabid = systables.tabid where colname like
>> '%grat%'
>>
>> needless to say I didn't find it ;)
>>
>> _______________________________________________
>>
>> This e-mail may contain information that is confidential, privileged or
>> otherwise protected from disclosure. If you are not an intended recipient of
>> this e-mail, do not duplicate or redistribute it by any means. Please delete
>> it and any attachments and notify the sender that you have received it in
>> error. Unless specifically indicated, this e-mail is not an offer to buy or
>> sell or a solicitation to buy or sell any securities, investment products or
>> other financial product or service, an official confirmation of any
>> transaction, or an official statement of Barclays. Any views or opinions
>> presented are solely those of the author and do not necessarily represent
>> those of Barclays. This e-mail is subject to terms available at the
>> following link: www.barcap.com/emaildisclaimer. By messaging with
>> Barclays you consent to the foregoing.  Barclays Capital is the investment
>> banking division of Barclays Bank PLC, a company registered in England
>> (number 1026167) with its registered offi!
>>  ce at 1 Churchill Place, London, E14 5HP.  This email may relate to or be
>> sent from other members of the Barclays Group.
>> _______________________________________________
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090604/9b8b933f/attachment.html>