1 Reply Latest reply on May 16, 2012 11:23 AM by benjarrell

    Truncate DB2 HIST logs for vCSA?

    kattrap Enthusiast

      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)?

      Pointing people here: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_truncate.htm

      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.