How to batch load mistakenly deleted item records from test server to prod

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
A staff member has deleted a large number of items records in error. They still exist on our test server (which has a snapshot of the production data).

Is there a way to extract them and load them back into production?

Resolution:
Either p_file_04 (with Append) or p_file_06 could be used to load a file of missing item records, but extracting them is a bit more complicated....

I suggest this:

On the test server:

1. find a library which doesn't have a z30 table

2. add z30 to the file_list

3. use util a/17/1 to create the table

4. use sql to copy the desired items from the abc50 z30 to the xxxnn z30

5. use p_file_03 to export the xxxnn z30

6. ftp the z30.seqnn from test ./xxxnn/files/ to prod ./abc50/files/

7. use p_file_04 (with Append) or p_file_06 to load the z30.seqnn on Prod

8. use this SQL to remove the xxxnn z30 on test:

SQL-XXXNN> drop table z30;

9. remove the z30 entry from the xxxnn file_list on test.

(keywords: file-06 file_06 p-file-06 p-file-04 file_04 file-04)

• Article last edited: 10/8/2013