VMware Cloud Community
kattrap
Contributor
Contributor

Truncate DB2 HIST logs for vCSA?

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...

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.

Smiley Sad

Tags (4)
Reply
0 Kudos
1 Reply
benjarrell
Contributor
Contributor

The link they have is for DB2 on Z systems, which is not supported. The info for DB2 LUW is here.

Reply
0 Kudos