ARCMAIN to backup a database but exclude all table data.

Database
Enthusiast

ARCMAIN to backup a database but exclude all table data.

I regularly perform the following type of backup to get the database level backup so that I can lay down these databases first, in a full restore.  I can then kick off multiple restore jobs on different media servers to restore different tables in the same database, concurrrenlty.  We have found this to be a very efficient way to utilize all four of our media servers to recover our system.  Here is the typical syntax that I use:

ARCHIVE DATA TABLES

  (TESTDB)

    (EXCLUDE TABLES  (

     TEST03DB.SALES_STORE_FAM, 

     TEST03DB.SALES_STORE_ITEM, 

     TEST03DB.SALES_STORE_RSS, 

     TEST03DB.SALES_STORE_SUBDEPT_AW_L15)),

RELEASE LOCK,

FILE=ARCHIVE;

My question, is there some ARCMAIN syntax that will allow me to do this same thing as above but not require me to call out each and every table in the database?  Something like this for instance?

ARCHIVE DATA TABLES

  (TESTDB)

    (EXCLUDE ALL TABLES),

RELEASE LOCK,

FILE=ARCHIVE;

I have tried this syntax but it fails with syntax error.  I would like to do this on a work table database that changes frequently, so my table exlude list would never be correct at time of backup.  Any thoughts would be greatly apprecieated.

Thanks,

       Mike

Tags (3)