Update QueryText to NULL in DBQLogTBL

Database
Enthusiast

Update QueryText to NULL in DBQLogTBL

Hi All

 

I want to update DBQLogTBL QueryText column to NULL value.

Presently the value was set to 10000 which is occupying space.

I have replaced query logging to change it to 0. We are using DBQLSQLTBL for query so don't need query here.

However I want to change existing values to NULL.

I am using DBC user still I cannot update the DBQLogTbl querytext column.

Kindly assist,

 

TIA 

Nitin

2 REPLIES
Junior Contributor

Re: Update QueryText to NULL in DBQLogTBL

You don't need to update the DBQL tables in dbc because there should be a daily housekeeping process moving the data to a history table where you got all rights.

Enthusiast

Re: Update QueryText to NULL in DBQLogTBL

Hi Dnoeth
Thanks for quick reply.
I am testing something on my local VM machine. Just wondering if it is possible to update dbql table.
I tried giving update privilege to DBC on DBC using TD Admin. Alas got the error and couldn't do it.
So is it possible to update dbqlogtbl ? I can try any possible solution.

Regards
Nitin