Check for a Time Zone String | Teradata DSA - Checking for a Time Zone String - BAR - Data Stream Architecture

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities
Before running the DIPMIG script, use the DBS Control utility to check if a Time Zone String is set on the destination system.
  1. From a command prompt on the destination system, enter dbscontrol to start the DBS Control utility.
    For more information about the DBS Control utility, see Teradata Vantage™ - Database Utilities, B035-1102.
  2. At the DBS Control prompt, enter di gen to display the General DBS Control fields.
  3. Inspect General field 18 to see if there is a value for TimeZoneString.
    • If the value showing for System TimeZoneString is Not Set, there is no Time Zone String set on the destination system, and you do not need to make any Time Zone String changes.
    • If there is any other value showing for System TimeZoneString, you need to remove the Time Zone String prior to restoring data. For example:
      18. System TimeZoneString = America Pacific