Bcp Cheetah Defaults
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Bcp Cheetah Defaults as PDF for free.
More details
- Words: 204
- Pages: 1
Date 9/8/03
BCP Task ??? - DBA Team Changes DEFAULT_VALUE in CHEETAH_DEFAULTS table. Description:
S&P Team changes DEFAULT_VALUE setting in CHE1 table.
Purpose:
This task sets the DEFAULT_VALUE to false for Omaha jobs printing in Florida. The ‘True’ setting indicates a recirc line should be used. The setting should be ‘False’ when printing in Florida since there isn’t one.
Definition of Task:
Step 1: Manually query and the CHEETAH_DEFAULTS table to verify the record(s) have DEFAULT_VALUE value(s) of ‘True’. SELECT * FROM SPC_OWNER.CHEETAH_DEFAULTS WHERE DEFAULT_NAME_TX = 'RECIRCOPTION' Step 2: Manually update CHEETAH_DEFAULTS table in CHE1. UPDATE CHEETAH_DEFAULTS SET DEFAULT_VALUE = ‘False’
WHERE DEFAULT_NAME_TX = ' RECIRCOPTION ' Step 3: Manually query and the CHEETAH_DEFAULTS table to verify the record(s) with has been updated to DEFAULT_VALUE of ‘False’. SELECT * FROM SPC_OWNER.CHEETAH_DEFAULTS WHERE DEFAULT_NAME_TX = 'RECIRCOPTION'
Entry Requirement:
(NEEDS UPDATED) DBA Team has saved the snapshot of the data.
Who is Accountable?
(NEEDS UPDATED) DBA Team
Contingencies:
(NEEDS UPDATED) The FLA1 backup database is available and a copy of the data has been extracted to file.
Exit Requirement:
(NEEDS UPDATED) Florida Warehouse data has been removed from the FLA1 database.
Distribution:
(NEEDS UPDATED) Contact the ERT when complete.
Estimated Duration:
(NEEDS UPDATED) 1 Hour
-1-
BCP Task ??? - DBA Team Changes DEFAULT_VALUE in CHEETAH_DEFAULTS table. Description:
S&P Team changes DEFAULT_VALUE setting in CHE1 table.
Purpose:
This task sets the DEFAULT_VALUE to false for Omaha jobs printing in Florida. The ‘True’ setting indicates a recirc line should be used. The setting should be ‘False’ when printing in Florida since there isn’t one.
Definition of Task:
Step 1: Manually query and the CHEETAH_DEFAULTS table to verify the record(s) have DEFAULT_VALUE value(s) of ‘True’. SELECT * FROM SPC_OWNER.CHEETAH_DEFAULTS WHERE DEFAULT_NAME_TX = 'RECIRCOPTION' Step 2: Manually update CHEETAH_DEFAULTS table in CHE1. UPDATE CHEETAH_DEFAULTS SET DEFAULT_VALUE = ‘False’
WHERE DEFAULT_NAME_TX = ' RECIRCOPTION ' Step 3: Manually query and the CHEETAH_DEFAULTS table to verify the record(s) with has been updated to DEFAULT_VALUE of ‘False’. SELECT * FROM SPC_OWNER.CHEETAH_DEFAULTS WHERE DEFAULT_NAME_TX = 'RECIRCOPTION'
Entry Requirement:
(NEEDS UPDATED) DBA Team has saved the snapshot of the data.
Who is Accountable?
(NEEDS UPDATED) DBA Team
Contingencies:
(NEEDS UPDATED) The FLA1 backup database is available and a copy of the data has been extracted to file.
Exit Requirement:
(NEEDS UPDATED) Florida Warehouse data has been removed from the FLA1 database.
Distribution:
(NEEDS UPDATED) Contact the ERT when complete.
Estimated Duration:
(NEEDS UPDATED) 1 Hour
-1-
Related Documents
Bcp Cheetah Defaults
August 2019 18
Cheetah
November 2019 33
Bcp
October 2019 32
Bcp Harun.xlsx
June 2020 19
Cheetah Animal
December 2019 28