16.20 - Backing Up and Restoring Packages - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)
The use of savepkg and loadpkg is deprecated. These stored procedures may be removed in a future release.
Teradata provides the following tools for you to use to back up and restore packages and package components, such as source and include files:
  • System stored procedures called savepkg and loadpkg, located in the SYSLIB database
  • A Microsoft Windows, CLIv2-based executable called lobteq from which you call the savepkg and loadpkg stored procedures
Additionally, Teradata provides the following system tables in the SYSLIB database for storing information for versioning, backing up, and restoring packages:
  • dem
  • demddl
  • dempart

The database maintains the system tables and updates the contents when you back up or restore packages or package components.

Before You Begin

Before you can back up or restore any packages or package components, verify that lobteq is available for you to use on your Windows client system and that the SYSLIB system database contains the savepkg and loadpkg stored procedures and dem, demddl, and dempart tables.

For details on how to do this, see Before You Begin .