Loading selected portion of production database to test data

umed · New User Joined: 13 May 2005 Posts: 38

Hi,

We want to refresh our test region databse so that we can get the
image copy of production database in test region.But in this case we are not having sufficient space so that we can load complete production databse. Please let me know if there is any way to load only a small version of prod databse to test region.

Thanks in advance.

Regards,
Amol

umed · New User Joined: 13 May 2005 Posts: 38

Here suppose production database is having 10000 records I want to upload only 1000 Records in Test region so please let me know how can we achive this.

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

Try with this query

Insert into test.table1
select * from prod.table1 fetch first 1000 rows only

DavidatK · Posted: Thu Jul 20, 2006 1:31 am

Amol,

How many tables are you talking about?

Can you do a selective UNLOAD of your Production Table(s), then LOAD to the Test system?

Dave

umed · New User Joined: 13 May 2005 Posts: 38

Hi,
yes Dave ,you are absolutely right.I want to do selective unload from
Production table and then want to upload the same records to the Test database. For this time I want to do it for 3/4 tables as initial basis. But I don't want to unload all the records from the table.I want some of them so that I can fulfill the space requirement for those in Test region.

Regards,
Amol

umed · New User Joined: 13 May 2005 Posts: 38

Hi,
I think now everyone is cllear with my problem.I just want to do selective unload from production database but I don't know how to do that
Can anyone tell me that. Thanks in advance.

Regards,
Amol

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

Can't you use DSNTIUAL utility specifying PARM as SQL and give SQL to fetch only limited or sleected records..Searc this forum if you want the JCL for this.

-Han.

trevor_rebelo · New User Joined: 18 Aug 2005 Posts: 17

Hi,

Try using the INCURSOR option in LOAD jobs...

In the Cursor give the Query which will select data from production table and load to test table...

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

TRy using QMF.

u can give the data records that have to be selected using
select * from
.........

when the qury runs u can store it in u r temp database (generally would be a vsam file allocated by the dba)
as
STORE DATA AS SQL1(the query that yoy would run be would be stored in the temp database as userid.sql1.
then u run another query to insert the retreived data into test using the query as

INSERT INTO table name
(SELECT * FROM T0666VR.sql1)