# Production & Test Database

**URL:** <https://techcommunity.softwareag.com/t/production-test-database/93573>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\
**Created:** [May 12, 2010, 5:34pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573 "2010-05-12T17:34:58Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\
**Post date:** [May 12, 2010, 5:34pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/1 "2010-05-12T17:34:58Z")

</div>

Hi All,

I would like to understand the concept of data transfer between production and test environment. Means, the how production data is taken to test environment, do we use any ADABAS utility to achieve the same or we run JCLs/scripts etc on perticular schedule?

Also, suppose we don’t transfer entire production data but a few, is it possible to mask the data in between so that transfered production data cannot be viewed?

I don’t work on DBA side but still curios to know. Please help.

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [May 12, 2010, 6:41pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/2 "2010-05-12T18:41:53Z")

</div>

Hi Ats,

You can use Adabas utilities and/or programs and/or other means to refresh your QA data from production. This is more a policy question for your shop to answer than a technical issue, as the technology exists to support whatever your shop decides to do.

Most shops I know of might refresh some of the files but not all in order to keep a handle on the size of the QA database. Transactional files may either be excluded or have some kind of filtering to reduce the impact.

One shop I know of has an elaborate menu-driven system for users to select production data for extraction from production and loading into QA if you have the time to develop such a system.

---

<div class="post-metadata">

**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\
**Post date:** [May 14, 2010, 12:54pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/3 "2010-05-14T12:54:45Z")

</div>

Hi Brian,

Thanks for your note.

Is ADABAS capable to mask data while loading it to QA?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [May 14, 2010, 1:11pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/4 "2010-05-14T13:11:09Z")

</div>

Hi Ats,

I think it is more common to mask the data while unloading it, i.e. when extracting it via a program or via the utilitly ADAULD you might select the data for QA. Depending on the amount of data extracted via program can be loaded via utility ADACMP/ADALOD.

Regards,  
Uschi

---

<div class="post-metadata">

**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\
**Post date:** [May 14, 2010, 1:30pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/5 "2010-05-14T13:30:36Z")

</div>

Thanks Uschi.

To make it more specific, I want to know if we can mask data as follows:

e.g. for a field ACCT\_NO = 1234567890 I would like to mask the value it to ACCT\_NO = XXXXXXX90  
I am not sure if ADABAS has this capability to do it (if has, not sure how) while loading/unloading data to QA.

Please throw some light on this, as I understand this type of masking need some algorythms and rules to be written.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [May 19, 2010, 12:46pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/6 "2010-05-19T12:46:50Z")

</div>

There is a (non SAG) utility on the market called ADAREORG that can be used to assign values to all records between unloading and reloading.

---

<div class="post-metadata">

**Author:** ![anon72918622](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@anon72918622](https://techcommunity.softwareag.com/u/anon72918622)\
**Post date:** [May 19, 2010, 2:55pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/7 "2010-05-19T14:55:11Z")

</div>

Hi Ats,

We (Software AG) are currently in the process to offer a data masking tool that is integrated in Adabas and allows rule-based masking and sub-setting.

Regards,  
Wolfgang

---

<div class="post-metadata">

**Author:** ![Ats](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ats](https://techcommunity.softwareag.com/u/Ats)\
**Post date:** [May 31, 2010, 11:10am UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/8 "2010-05-31T11:10:08Z")

</div>

Hi Wolfgang,

When we are expecting this tool or is it available currently?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:58pm UTC](https://techcommunity.softwareag.com/t/production-test-database/93573/9 "2021-04-02T14:58:29Z")

</div>


