Copying PRODDTA in TESTDTA on AS/400

munster

Member
Does anyone know how to copy production data (PRODDTA) into development data (TESTDTA) on the AS/400? Do the Control Tables (PRODCTL) have to be copied over as well?

I have already tried to copy via CPYLIB into a new a new object but got 15 error messages in the log to do with *SQLPKG, eg:

Object ACTIVCOFJA in PRODDTA type *SQLPKG not duplicated
Object DEBUGGEFJA in PRODDTA type *SQLPKG not duplicated

Any help you can give would be appreciated as our developers need the data to test in Dev in E1.

Thanks

Morgan
AS400/XE6 SP22
 
Morgan,
SQLPKGS are recreated so these will not be replicated when you do a CPYLIB. As long as your data is copied you are good. Copying the PRODCTL is your choice.
devki
 
It is good procatise to copy your Control Tables when you copy the data. This will avoid some potential problems with Next Number etc. The way that I copy from Prod to CRP is to use the WRKLIB command and choose option 14 to clear the CRPDTA library. Once it has been cleared use the WRKLIB to bring up PRODDTA and use option 3 to copy, in the new library field put in CRPDTA and *NO to create the library. Do the same thing for the Control Tables library. Don't worry about the SQL packages not copying, they will be re-created when they are needed.
 
Back
Top