Generating SQL Statements for Re-creating Source or Target Objects for Troubleshooting
Generating SQL Statements for Re-creating Source or Target Objects for Troubleshooting
PowerExchange now provides a command that generates SQL statements for re-creating SQL source or target objects in a PowerExchange for DB2 for i5/OS environment. The command is intended to produce SQL statements that Informatica Global Customer Support can use for troubleshooting bulk data movement or CDC problems.
To generate the SQL statements for an i5/OS SQL object, enter the RTVSQLSTMT command from the i5/OS system where PowerExchange is installed. The PowerExchange
dtllib
library must be in the current library list for the i5/OS job. The RTVSQLSTMT command prompts you for a series of parameters that control what SQL statements are generated. The RTVSQLSTMT command validates your entries to reduce the risk of errors
At any point, you can display Help information in the i5/OS Console to see field descriptions, command examples, and the authorities that are required to run the command.