Richard,
Again, you have not specified if you need to copy programs and versions,
or just data. Please, download and read
http://www.jdelist.com/downloads/psasd.zip - it describes creation of a
new environment (which partially consists of copying an environment to a
new location).
Brief list of steps:
1. To copy data - copy all tables from Business Data and Control Tables
datasources with R98403. Take XJDE0021 and XJDE0022 versions for a
sample (they are basically correct). Make sure that you feel PO.2 and
PO.4 with valid OW DS, and PO.1 and PO.5 are blank, PO.6 = 1, I'd
recommend setting PO.8 to blank, but in default versions it's set to 1.
Standard Data Selections are OK.
An opinion that only UDC will be copied is probably a result of only
running version XJDE0022, which, in fact, copies a very limited number
of tables.
It is not possible to restrict transactional data being transferred,
only to transactions prior to 1st of June. If you need to limit the data
- you'd have to do this manually (figuring out what tables to clear will
take you ... a while).
Data can be copied in under 4 hours.
2. To copy versions - copy table F983051 from [Versions ...] datasource.
Take version XJDE0019 of R98403 as an example, change PO.2 and PO.4 to
correct Version DS. Only interactive versions will be functional after
this copying - batch versions will only be copied after you copy
programs.
This runs pretty fast, just takes a little longer on Oracle.
3. To copy programs and batch versions run version XJDE0019 of R98403.
It copies data between Central Objects datasources.
I have never run it, but would expect that it runs forever (24 hrs will
be a good result). Other Listers may advise you better on this part.
4. To copy C sources and packages - copy pathcode directory on
deployment server, rename package directories (if you have a
significantly different number of packages, you may need to edit .inf
files). This MUST be done simultaneously with step 3. If your specs go
out of sync with your sources - you'll have PROBLEMS.
Copying will only take an hour or so.
To speed things up:
In step 1 you can copy tables with owner proddtat and indices with
proddtai to crpdtat and crpdtai respectively (you may need to regenerate
indices instead of copying - I'm not that good with Oracle).
You must complete step 2 as is, because a couple of fields are changed
underway.
In step 3 you can also copy tables with owner prodorcl(?) (? I don't
have an Oracle install in front of me - take the owner for Control
Objects datasource).
Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
