Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 12:53:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

As you can see in the $NETVAULT_CATALOG database, the catalog table grows all the time and there is no column relating to the time (date, timestamp, ...etc). In order to maintain this table do you have any idea how we could purge or delete information without having a problem with Netvault?

Any suggestions?

Thanks,

Chamoun

Columns of catalog table

EVENTNUM INTEGER NOT NULL,
SEQNUM INTEGER NOT NULL,
OBJLEVEL CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
TVMKIND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
TABLEPROTECTION CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
DATABASENAME VARCHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
TABLENAME VARCHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
POSTYPE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
REPOSITIONINFO VARBYTE(256)

	<Prev	Next>		<<First	<Prev	Next>	Last>>