Contact & password data in all CAWIS Non-Production regions should be maintained as is outlined below to ensure no real-world clients are contacted during MDM or EDM testing.
...
NOTE : It is strongly recommended that the DBA be requested to CLONE Production into the desired target region, rather than copy. Refresh attempts tend to fail on timeouts (too much production data changes during the copy) or conflicts with nightly backups otherwise. CAWIS contains a great volume of data and has a great deal of production data activity. (AAIR and SDR submissions etc…)
BATCH JOBS
ENSURE that any automated triggers for Batch jobs (CCARCS-CAWIS sync, Project Notifications) are inactive in all regions except Production. If the synchronization routine is run in Non-Production region, it can do a great deal of damage to the test data.
DB-LINKS
Ensure all DBLinks are pointed to the correctly corresponding region after a test region refresh
DEV to DEV,
ACC to ACC etc…
REGION-SPECIFIC DATA BACKUPS
Backup the following data into TXT files and attach to the PBI before beginning the refresh (or clone)
...
SELECT
'UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_VALUE = ''' ||
PROPERTY_VALUE || ''' WHERE PROPERTY_NAME = ''' ||
PROPERTY_NAME || ''' ; ' AS UPD1
FROM TR47_CAWIS_GENERAL_PROPS ;
...
GENERIC SYSTEM ACCOUNT PASSWORDS
The system account passwords need to be backed up from Production and applied into the target region. A list of “system” accounts is found in the Z980 table with Term_type_cd = ‘SYSID’
SELECT A01.USER_ID,
'UPDATE A01_USER SET PASSWORD = ‘'' || REPLACE(A01.PASSWORD,'''','''''') ||
''' WHERE USER_ID = ‘'' || A01.USER_ID || '’’ ;' UPD1
FROM A01_USER A01
WHERE A01.USER_ID IN (SELECT FROM_TXT FROM Z980_TERM_CONVERSION
WHERE TERM_TYPE_CD = 'SYSID') ;
...
AFTER A TEST REGION DATA REFRESH, PERFORM THE FOLLOWING TASKS
PASSWORDS
1)Passwords on all Userids are to be set to “XXXXXX”
...
(SELECT FROM_TXT FROM Z980_TERM_CONVERSION WHERE TERM_TYPE_CD = ‘SYSID’) ;
/* Apply the Production passwords for all SYSTEM Userids afterward Generic system Userids are skipped */
2) Owner AAIR Access code/passwords are to be set to “XXXX1111”
...