I needed to bump the tlog space on my vCSA (4 servers, new deployment) but it looks like I'm still having issues with rollups not working. Does anyone here have the correct login / syntax in order to truncate the HIST tables (ala http://kb.vmware.com/kb/1007453)?
is useless when the response I get back as the db2inst1 user when I try the command is that the table "is an undefined name" SQLSTATE=42704. I know I've got the table names correct..is there some case sensitive stuff going on here or something?
I'll put in a ticket if I have to, but it should be in the kb article.