The other way is to find the tables by running the CheckTables utility.\u00a0 Click HERE<\/a><\/span> to go to a post on how to run the check table utility.\u00a0 The results displayed show three tables have Logging Online Archive on.<\/p>\n RESOLUTION:<\/strong><\/p>\n Start a vi<\/strong> session to create a script that will remove Online Archive Logging found on tables.<\/p>\n The script is going to need user & password with enough access to log on to the Arcmain utility.\u00a0 Teradata Express is used in this example, so the dbc account is being used.\u00a0 Recommended using another account with enough permissions.<\/p>\n A line for each table will be need to remove Online Archive Logging.\u00a0 The OVERRIDE parameter will be needed in each statement.<\/p>\n Paste or write the script in the vi session, then save & close.<\/p>\n To execute the arcmain script, type arcmain<\/strong> then the less then sign<\/strong> then the script name <\/strong>(no double quotes).\u00a0 In testing adding spaces did not hurt the execution.<\/p>\n Arcmain may take a minute to get started.\u00a0 When successful, arcmain will display severity of 0 when completed.\u00a0 Requery DBC.ArchiveLoggingObjsV or rerun CheckTable to verify.\u00a0 Then as a security precaution, remove the password from the script, if planned to be saved & reused.<\/p>\n![\"DBC.ArchiveLoggingObjsV\"](\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/04\/DBC.ArchiveLoggingObjsV.jpg\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n.LOGON 127.0.0.1\/dbc,dbc ;\r\nLOGGING ONLINE ARCHIVE OFF FOR (RETAIL.CLIENT), OVERRIDE;\r\nLOGGING ONLINE ARCHIVE OFF FOR (RETAIL.ITEM), OVERRIDE;\r\nLOGGING ONLINE ARCHIVE OFF FOR (RETAIL.PRODUCT), OVERRIDE;\r\n.LOGOFF;<\/pre>\n
<\/a><\/p>\narcmain < \"script name\"\r\n\r\nexample: arcmain < stop_archive_logging.arc<\/pre>\n
<\/a><\/p>\n