Archives of the TeradataForum

Message Posted: Fri, 10 May 2002 @ 15:47:49 GMT

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

If you archive your databases you can always parse your arcmain output and get everything you want - rows AND bytes. It's not very sexy, but it works. After every archive we run, the output is parsed and loaded to a table (we don't use asf2). This gives us excellent trending, and metrics reporting abilities, including how long it takes to archive something. There are also built-in tables in the xasf_fast_path database that might have what you want, but we didn't use these because they seem unreliably updated.

You might also query dbc.tablesize and dbc.columns. Take the sum of your column lengths (rows) by table from dbc.columns and divide it into the bytes from tablesize. If you manage to get this it will only be approximate due to partially populated (or null) columns, but I would like to see the query.

Mike

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