Solved

Logical Files and UAT deployments

Posted on 2012-03-22
3
350 Views
Last Modified: 2012-06-27
Hi All,

We have a so called "staging" AS400 server which gets periodically backed up with data from production. This server is used for various business purposes including preparing for UAT deployments. Before a UAT deployment, these are the steps that we perform on this server:

1) Create duplicates for all source, objects and data files (not database tables).
2) For purposes of security, we scramble and subset the data in the files.
3) All this is then put into a save file and pushed out to the respective UAT servers.
4) A remote restore save file command is issued on the staging server which deploys the code on the UAT server.

The problem i am facing is in step# 2 above. An elaboration of step# 2 is as follows:

1) After a duplicate of production data files are created, I delete all LF's that exist on the PF's.
2) Remove all members from all PF's.
3) Based on our business needs, I add back a version (or not) with specific member names.
4) Scramble and subset that single member if needed.
5) Add back all the LF's that were earlier deleted.

All the above steps work fine except that some of the LF's that we have in our libraries are based on 1-2 tables in a schema. Ideally, when I am re-creating the LF, I want the LF to be recreated using the schema name that I am going to use on the UAT server. Most of the times, we do not have that schema name present on the "staging" server. I either end up not creating that LF or if it creates, it is pointed to one of the schema names that exist on staging.

Is there any work-around?

My restrictions are:

1) I have to run all these steps on the "staging" server.
2) We have multiple UAT regions, so it is not feasible to have a program deployed on all UAT servers to take care of this problem with the LF.
3) I want to avoid hard coding of any kind because this program would be used across applications.

The version of OS we are currently on is V5R4 (with plans to migrate to V7R1 this summer).

Regards
Ali.
0
Comment
Question by:bhagatali
  • 2
3 Comments
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 37756362
Hi bhagatali,

Not totaly clear to me, why are you deleting the logicals, if you need to re-build them anyway ?

Regards,
murph
0
 

Author Comment

by:bhagatali
ID: 37756835
Hi Murph,

There are 2 reasons:

1) In a subsequent step I remove all versions of physical files that I copied from production so that I could create a blank version of the PF.
2) The LF's that I copied from production are pointing to PF's in the production library. I need to recreate them pointing to the UAT libraries.

Regards
Ali
0
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 500 total points
ID: 37756937
Hi Ali,

1) By clearing all PF members, you don't need to rebuild any file.

2) I do my very best to get your situation, copy files from Lib1 to Lib2, but LF's are pointing to the right PF's after coppying.
I even tried to add Lib1 to my LIBL and copy the LF first, but that is not possible if the PF is not in the target library. You only can do that during creation by defining the PF, otherwise copy will point to the right file.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help needed with DCM certificate renewal 9 368
AS400 Forms 9 134
AS400 / OS400 security guidelines & hardenings & patchings 10 113
Compatibility MOVEX 10A on V6R1 9 85
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question