Dictionary Archive gets full data full data

Database
Enthusiast

Dictionary Archive gets full data full data

we are using the following archive job to have weeklty backup for objects definitions:

ARCHIVE DICTIONARY TABLES

(DBC) ALL , 

RELEASE LOCK,

FILE=ARCHIVE;

Surprisingly it results in FULL DATA archive for tables, i see the archive size for huge tables simillar  as it is on production.

From TaraGUI log displayed:

04/27/2012 13:59:36  ARCHIVE DICTIONARY TABLES

04/27/2012 13:59:36  (DBC) ALL , 

04/27/2012 13:59:36  RELEASE LOCK,

04/27/2012 13:59:36  FILE=ARCHIVE;

04/27/2012 13:59:37  EXCLUDED "DBC"

04/27/2012 13:59:37  EXCLUDED "SYSUDTLIB"

04/27/2012 13:59:37  UTILITY EVENT NUMBER  - 1718327

04/27/2012 13:59:42  LOGGED ON   15 SESSIONS

04/27/2012 13:59:42  ARCHIVE MAPPED TO  ...

.

...

.

.

04/27/2012 14:07:32  ARCHIVING DATABASE "DB1"

04/27/2012 14:07:43  TABLE "TABLE1" -   3,408 BYTES ARCHIVED

.....

04/27/2012 15:02:36  

04/27/2012 15:02:36  STREAM TOTALS:

04/27/2012 15:02:36  TABLE "TABLE1" -   3,211,281,800,552 BYTES,   36,275,357,572 ROWS ARCHIVED TOTAL


Is there's something i'm missing here, 

Regards

1 REPLY
Enthusiast

Re: Dictionary Archive gets full data full data

It's a problem with my archive script, dictionary archive  require single stream while my mistake was specifying  muliple streams.