Originally posted by Norman Biggar
OK,
Potentially, you could create the reporting database from the production database and then apply a prepared incremental .df to add the reporting indexes.
Norm,
I'm the DBA that works with DKR.
Did you mean an incremental .D file? I ask because I don't see how the definition would change, or is the index part of that? That would be interesting if we could selectively produce incremental .D files of the 30 or so tables we use.
I've been kicking it around for a few days. It seems like the best way for us would be to:
- create the reporting db structure (Rpt50Prd)
- dump & load data definitions of the required tables
- DKR adds his indexs
- we call that the empty structure and get a Probkup of it
Then going forward on a nightly basis we:
- prorest EmptyStructureBackup
- dump and load data from production to rpt50prd
- proutil unifipc -C idxbuild all
- start it up and print reports
Down side is each night this would take longer as the DB grows. That's where figuring out how to create incremental .D files would be helpful.