When the DataStage Teradata Connector stage performs a bulk update, a RELEASE MLOAD statement is issued which locks the schema, preventing updates to other objects in the same schema until the job completes.
Resolving the problem
The DataStage Teradata Connector stage does not directly issue the RELEASE MLOAD statement. Rather it is issued by the Teradata TPT layer if a specific property has been set in the Teradata Connector stage properties.
Open the Teradata Connector stage properties and examine the setting of the Startup option. When Startup=Clean, Teradata will clean up the table and issue the RELEASE MLOAD command when the job starts. If the Startup option is instead set to "Restart" then the RELEASE MLOAD statement does not occur during job run.
NOTE: some jobs may depend upon the clearing of existing data in target table at start of job run, so before changing the Startup option from Clean to Restart, you need to examine the usage of the data in that table to determine if not clearing the table will cause errors or incorrect results for your job.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.