Inspect Java External Stored Procedures | Teradata Vantage - Inspecting Java External Stored Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
stb1559324757649.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Teradata Vantage
The post_data_restore script recompiles Java external stored procedures (JXSPs), and generates several output files for inspection.
  • In /var/opt/teradata/PUTTools/jxspconv_xx.xx.xx.xx , inspect each of the following output log files, and take the identified corrective actions, if necessary.
    Recompile Output File Purpose Corrective Action
    jxspconv.pl.date_timestamp.log Records the execution of the post_data_restore script, including creation of files related to errors encountered, if any.
    For cleanup operations, this file shows which JXSPs and JARs have been removed.
    If JXSPs do not exist on the system, this file reflects the following message:"No Teradata Java XSP/UDF or Jars...Returning from jxspconv.pl”
    Review generated error files, if any.
    jxspteradata.bteq Contains the SQL statements that actually recompile all of the JXSPs found. None.
    jxspteradata.log Lists the results of the bteq script execution. Review this file for causes of recompile failures.