Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Integrated Validation for Archive and Retirement Projects
  12. Retention Management
  13. External Attachments
  14. Data Archive Restore
  15. Data Discovery Portal
  16. Data Visualization
  17. Oracle E-Business Suite Retirement Reports
  18. JD Edwards Enterprise Retirement Reports
  19. Oracle PeopleSoft Applications Retirement Reports
  20. Smart Partitioning
  21. Smart Partitioning Data Classifications
  22. Smart Partitioning Segmentation Policies
  23. Smart Partitioning Access Policies
  24. Language Settings
  25. Appendix A: Data Vault Datatype Conversion
  26. Appendix B: Special Characters in Data Vault
  27. Appendix C: SAP Application Retirement Supported HR Clusters
  28. Appendix D: Glossary

Create Seamless Data Access Physical and Logical Script

Create Seamless Data Access Physical and Logical Script

You can create seamless access between an IBM DB2 for AS/400 source connection with physical and logical files and a IBM DB2 for AS/400 target connection with archived data. Use the Create Seamless Data Access Physical and Logical Script standalone job to create a script that you can review and then run on the target database. The script includes statements to create the required database objects for seamless access between the source and target connections.
Provide the following information to run this job:
SourceRep
The IBM DB2 for AS/400 source connection that stores the source or production data.
DestRep
The IBM DB2 for AS/400 target connection that stores the archived data.
Script Location
Location where you want to save the scripts that the job creates. This location must be accessible to the ILM application server.
After the job completes successfully, download the script files from the
Monitor Jobs
page. To download the script files, expand the Job ID and click the
Download Physical and Logical Script
link. Then extract the downloaded file, which is named
ScriptGeneration_xx.zip
.
Within the extracted folder, the
bin
folder contains a connections properties file. Update the parameters to be specific to your environment. The
lib_name
and
file_name
parameters should be eight characters or less.
After you edit the connections file, run the
GenerateScriptForDb2AS400.bat
file on a Microsoft Windows operating system or the
GenerateScriptForDb2AS400.sh
file on a UNIX/Linux operating system. When the shell script or batch file runs, it creates the seamless access scripts in the location that you specified in the job parameters.
For more information, see the
Informatica Data Archive Administrator Guide
.

0 COMMENTS

We’d like to hear from you!