2SOPS-OLM-DM-WI-202_Manual_Repro_Data_Sync.doc
DOC document 155 KB Posted
- Attached to
- Pre-Solicitation Conference (Industry Day)
- Solicitation number
- FA8823-12-R-0004
About this file
2 SOPS OLM DM WI 202
View the file
Other files
Show 40 more
Latest 50 of 118 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
BOEING PROPRIETARY
| Rev # |
| Reason |
| Rev Date |
| Initials |
| A.1 |
| Initial Release |
| 07/26/11 |
| RF |
| A.3 |
| Verification of primary record |
| 03/09/12 |
| mg |
| 2SOPS-OM-DM-WI-202 |
| Title: Manual Repro Data Sync |
Description: This document describes how the OLM Data Management Team will perform manual synchronization of repro database tables and flat files.
Note This document is broken up into 2 sections, Database and Flat File. The sections can be performed in conjunction.
Constraints and Restrictions The flat file transfer requires >13G of disk space at the current time due to the number of files in the repro directory structure. This data does compress down considerably (13G -> ~60MB) This procedure assumes the transfer is from the MCS to AMCS (Nominal case).
Prerequisite Procedures None
Section 1 Flat Files
| 1. |
| Bring up terminal as the gps user at the MCS. |
| 2. |
| Ensure disk space adequate |
% rsh common1 % cd /net-1/gps/data/ttc/repro
% du –sk .
% du –sk /gpsinstall/MOX_AUDIT/ IF THERE IS NOT ADEQUATE DISK SPACE TO STORE THE DATA, DO NOT CONTINUE. CLEAN UP TARGET DIRECTORY AS NECESSARY.
| 3. |
| Tar repro data @ MCS |
% tar cvf /gpsinstall/MOX_AUDIT/reproff.tar *
% gzip /gpsinstall/MOX_AUDIT/reproff.tar (This will take a while)
| 4. |
| Transfer repro data @ MCS |
% rsh admin2
% cd /gpsinstall/MOX_AUDIT
% scp –p reproff.tar.gz root@admin2vm:/gpsinstall/MOX_AUDIT
| 5. |
| Clear repro data @ AMCS |
% rsh admin2vm
% rsh common1
# su -
# cd /net-1/gps/data/ttc/repro
# rm –rf /net-1/gps/data/ttc/repro/*
| 6. |
| Unpack repro data @ AMCS |
# pwd (Ensure you are still in /net-1/gps/data/ttc/repro) # gzcat /gpsinstall/ MOX_AUDIT/reproff.tar.gz | tar xf -
Section 2 Database
| 1. |
| Bring up a terminal as the gps user at the MCS. |
| 2. |
| Export repro data @ MCS |
% rsh mission1
% cd /gpsinstall/MOX_AUDIT
% ./GPS_export_repro.ksh (Enter db password when prompted)
Verify export is successful. You may get a warning regarding export for certain tables using “Conventional Path”. This warning can be ignored.
| 3. |
| Transfer data to AMCS |
% gzip /gpsinstall/MOX_AUDIT/repro_db.data
% rsh admin2
% scp –p repro_db.data.gz root@admin2vm:/gpsinstall/MOX_AUDIT
| 4. |
| Unzip data @ AMCS |
% rsh admin2vm
% rsh mission1
% gunzip repro_db.data.gz
| 5. |
| Delete and Import repro data @ AMCS |
% ./GPS_delete_repro.ksh
Verify truncates and table deletes successful.
% ./GPS_import_repro.ksh
Verify import successful.
Uncontrolled Document when Printed
Use or disclosure of data contained on this sheet is subject to the restriction(s) set forth in NCS-GPSIIF-3100-SCP-09-0285 dated October 1, 2009
File details come from the government source that posted it. Updated .