Online archiving is a facility that is available to to have concurrent DML operations run while the archive process archiving. ONLINE ARCHIVE means that the database or tables that are archived are not locked for any DML operations, meaning archive is done during the real time operation of the business. How it works is the logger is triggered which captures all the DML changes that are happening during the archive process, once the archive finishes the logger applies all the changes either it could be commit or rollback statements. Remember the logger is active only when the archive is running and not active when the archive job finishes its archival process.
Code for ONLINE ARCHIVE
ARCHIVE DATA TABLES (DATABASE.TABLE),
RELEASE LOCK,
ONLINE,
FILE=
How to find which tables or databases are archived ONLINE currently:
select CreateTimeStamp,
DatabaseName (VARCHAR(30)),
TVMName (VARCHAR(30))
from DBC.ArchiveLoggingObjsV;
DBC.ArchiveLoggingObjsV is a view that provides information about a table(s) that has an active log for the online archive.
Notes: It is not recommended to have the view databases to be archived with ONLINE criteria. I came across a bug dated October 10th 2010 when you archive view databases online, the archive job doesn't release the online logging active log. so it prohibits to do any DDL changes like Refresh view even after the archival process is completed. you need to issue an exclusive OFF statement, it is below:
LOGGING ONLINE ARCHIVE OFF FOR (DATABASENAME), OVERRIDE;
---you use the override in situations where the user ID logged in to issue the above statement is different from the user ID that turned ON the ONLINE LOGGING.
---One more note is that you need to issue this statement as an ARC statement and not any SQL statment. It is not like the sql statement that you use to release the HUT locks from any sql tool.
I'm attaching a simple script and how to invoke it.
step1:
create an arc script with any name like release_online_arc_lock.arc
step2:
code for the script should be like this:
.LOGON TDPID/dbc,
LOGGING ONLINE ARCHIVE OFF FOR (DATABASE), OVERRIDE;
.LOGOFF;
step3:
After saving invoke the command prompt, a DOS command prompt assuming the BAR server is on a windows box. type the below statement in the command prompt and enter
arcmain
step4: You should see in the following:
C:\Documents and Settings\vkillada>arcmain release_lock.arc
10/11/2010 13:19:42 Copyright 1989-2008, Teradata Corporation.
10/11/2010 13:19:43 All Rights Reserved.
10/11/2010 13:19:43
10/11/2010 13:19:43 *** **** ****
10/11/2010 13:19:43 * * * * * PROGRAM: ARCMAIN
10/11/2010 13:19:43 ***** **** * RELEASE: 13.00.00.05
10/11/2010 13:19:43 * * * * * BUILD: 080221eW (Nov 12 2009)
10/11/2010 13:19:43 * * * * ****
10/11/2010 13:19:43
10/11/2010 13:19:43 RESTARTLOG = ARCLOG101011_131943_130196.RLG
10/11/2010 13:19:43
10/11/2010 13:19:43 PARAMETERS IN USE:
10/11/2010 13:19:43
10/11/2010 13:19:43
10/11/2010 13:19:43
10/11/2010 13:19:43 CHARACTER SET IN USE: ASCII
10/11/2010 13:19:43 .LOGON TDPID/dbc,;
10/11/2010 13:19:45 LOGGED ON 3 SESSIONS
10/11/2010 13:19:45
10/11/2010 13:19:45 DBS LANGUAGE SUPPORT MODE Standard
10/11/2010 13:19:45 DBS RELEASE 12.00.03.08
10/11/2010 13:19:45 DBS VERSION 12.00.03.08
10/11/2010 13:19:45
10/11/2010 13:19:45 STATEMENT COMPLETED
10/11/2010 13:19:45
10/11/2010 13:19:45
10/11/2010 13:19:45 LOGGING ONLINE ARCHIVE OFF FOR (DATABASENAME),
OVERRIDE;
10/11/2010 13:19:45 UTILITY EVENT NUMBER - 326813
10/11/2010 13:19:46 STATEMENT COMPLETED
10/11/2010 13:19:46
10/11/2010 13:19:46
10/11/2010 13:19:46 .LOGOFF;
10/11/2010 13:19:47 LOGGED OFF 3 SESSIONS
10/11/2010 13:19:47 STATEMENT COMPLETED
10/11/2010 13:19:47
10/11/2010 13:19:47
10/11/2010 13:19:47 ARCMAIN TERMINATED WITH SEVERITY 0
THE ONLINE will trigger again if the online archive arcmain script is initiated.
Now if you run this query again you should not see the database that you could not get released after the arcmain script kicked off. The above script exclusively releases the logging locker.
select CreateTimeStamp,
DatabaseName (VARCHAR(30)),
TVMName (VARCHAR(30))
from DBC.ArchiveLoggingObjsV;
if you've any questions related to ARCHIVAL AND LOGGING ISSUES....please feel free to email me
vasudev.killada@gmail.com or at least comment to have me update this blog with more information.
______________________________________________________________
Make sure there is no space between this statement.
ReplyDeletearcmain<release_lock.arc
Hi Vasu,
ReplyDeleteThanks for your effort sharing knowledge on Teradata in very detailed manner. Its really helps me alot.
Would like to clarify on the ONLINE LOGGING, after we issued the command eg. LOGGING ONLINE ARCHIVE ON FOR (DATABASE1);
we can see those tables in DATABASE1 for active ONLINE ARCHIVE LOGGING from the view DBC.ArchiveLoggingObjsV.
Could you advise where exactly those data changes(update/delete/insert) on these tables being stored during the logging period?
and how to monitor the space used for logging?
I noticed that there is no change in the size of the table DBC.ArchiveLoggingObjsTbl even after no of updates on tabels in DATABASE1,
so wondering where these changes will be stored and how to monitor the space used the logging?
Thanks in advance.
Raj.
This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this.
ReplyDeleteAre you aware of any other websites on this subject.
GOOD TERADATA ONLINE TRAINING
This is the information that I was looking for and let me tell you one thing that is it is very useful for who is looking for Teradata Online Training.
ReplyDeleteThanks for share this with us.
ReplyDeleteIs there any way to take backup without any DML/DDL Intervention from client. currently i'm using online option to take backup but facing some read,write,exclusive lock issue (Blocking). i want to know how we can take backup smoothly through arcmain without any blocking issue.
On what statement of the arcjob you experiencing the blocking? If your experiencing it through the "Logging online archive on database" statement, you can try to use the NOSYNC option to shorten the consistency time of read lock being held on the database.
DeleteVery good articles,thanks for sharing
ReplyDeleteMicrostrategy Corporate Training
MSBI Corporate Training
Oracle 11g RAC Corporate Training
Oracle DBA Corporate Training
Oracle SOA Corporate Training
Thanks for giving Good Example It are very useful to us.
ReplyDeleteFantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Teradata. Thanks a lot.It is useful to me and my training Teradataonline Training
very nice article.Thanks for sharing the post...!
ReplyDeleteETL Testing
Hadoop
Thank you for sharing nice information.
ReplyDeleteIt is very useful to me and who are searching for Teradata online training
Thanks for the nice information, Teradata DBA Training
ReplyDelete
ReplyDeleteQuickBooks has made payroll management quite definitely easier for accounting professionals. There are so many individuals who are giving positive feedback if they process payroll either QuickBooks Payroll Support Phone Number and online options.
tech support team of several your software related issues. If you are aa QuickBooks enterprise user, you'll be able to reach us out immediately at our QuickBooks Tech Support our solution from our technical experts.
ReplyDeleteQuickBooks Enterprise Technical Support Number Being That They Are In Continuous Utilization Of Workbook, Sheets, Account Records, And Payroll Management Sheets. While QuickBooks Offers Multiple Financial Needs And Advantageous Assets To Its Users, QuickBooks Enterprise Support Number Helps Its User To Solve Any Type Of Issue Generated.
ReplyDeleteQuickBooks Technical Support Phone Number could be the toll-free volume of where our skilled, experienced and responsible team can be obtained 24*7 at your service. You will find an array of errors that pop up in QuickBooks Payroll which are taken care of by our highly knowledgeable and dedicated customer support executives.
ReplyDeleteQuickBooks Online Payroll Contact Number helps one to resolve all your valuable technical and functional problems whilst looking after this well known extensive, premium and end-to-end business accounting and payroll management software. Our experts team at QuickBooks payroll support number is going to make you understand its advanced functions and assists someone to lift up your business growth.
ReplyDeleteQuickBooks 24/7 Payroll Support Phone Number USA provides 24/7 make it possible to our customer. Only you must do is make a person call at our toll-free QuickBooks Payroll tech support number . You could get resolve most of the major issues include installations problem, data access issue, printing related issue, software setup, server not responding error etc with this QuickBooks payroll support team.
ReplyDeleteLet’s talk about our QuickBooks Enterprise Tech Support Number that'll be quite exciting for your needs all. The advanced QuickBooks Desktop App for QuickBooks Support is now able to act as an ERP system beneficial for medium scale businesses. QuickBooks Desktop Enterprise just isn't alike to pro, premier & online versions. Capacity and capability could possibly be the reason for this.
ReplyDeleteIf you’re encountering any kind of QuickBooks’ related problem, you will get all that problems solved just by utilising the QuickBooks Customer Service.
ReplyDeleteQuickBooks Support Phone Number is assisted by our customer support representatives who answer your call instantly and resolve all your valuable issues at that moment.
ReplyDeletebefore calling us, all you have to do is always to make sure that you have an excellent connection to the internet and you are clearly clearly competent to here QuickBooks Enterprise Support Number clearly before calling us. You can cherish our above-mentioned beneficial services at most affordable price on just a call.
ReplyDelete
ReplyDeleteQuickBooks Premier is an accounting software which includes helped you grow your business smoothly. It offers some luring features which make this software most desirable. In spite of most of the well-known QuickBooks Premier features you will probably find difficulty at some steps. QuickBooks Help & Support is the foremost destination to call in the time scale of these crisis.
Our support also extends to those errors when QB Premier is infected by a virus or a spyware. We also handle almost any technical & functional issue faced during installation of drivers for QuickBooks Technical Support We also troubleshoot any type of error which can be encountered in this version or this version in a multi-user mode.
ReplyDeleteIf just in case you come across any QuickBooks Support Phone Number errors or problems or would like any facilitate, you’ll dial the direct line variety to achieve the QuickBooks specialists.
ReplyDeleteIntuit is perhaps all concerning User expertise which is the reason why they require creating dedicated QuickBooks Tech Support Phone Number variety; Users will dial the fee number in case they usually have any facilitate concerning the code.
ReplyDeleteQuickBooks Tech Support Phone Number excellent accounting tool is especially utilized for bookkeeping purposes just to keep up with the many business people account. And also it is the best accounting software for resources and always saving time.
ReplyDeleteQuickBooks Help & Support encounter an amount of undesirable and annoying errors which keep persisting as time passes if you don't resolved instantly. Certainly one of such QuickBooks issue is Printer issue which mainly arises due to a number of hardware and software problems in QuickBooks, printer or drivers.
ReplyDeleteCommon issues that QuickBooks Support number receives:Very often client faces some traditional issues like he/she isn’t happy to open QuickBooks Tech Support Number package, it is playing terribly slow, struggling to install and re-install, a challenge in printing checks or client reports.
ReplyDeleteOur dedicated team is sure to you. These are generally surely working twenty-four hours a day to help and make suggestions if you run into any QuickBooks error/s. Our Quickbooks Tech Support Phone Number surely have in-depth knowledge concerning the problems and issues of QuickBooks.
ReplyDeleteQuickBooks Tech Support Number advisors are certified Pro-advisors’ and has forte in furnishing any kind of technical issues for QuickBooks. They have been expert and certified technicians of these domains like QuickBooks accounting,QuickBooks Payroll, Point of Sales, QuickBooks Merchant Services and Inventory issues to provide 24/7 service to our esteemed customers. QuickBooks payroll Services provide methods to all your valuable QuickBooks problem and in addition assists in identifying the errors with QuickBooks data files and diagnose them thoroughly before resolving these problems.
ReplyDeleteQuicKbooks Customer Support Phone Number many of the small or mid-sized businesses companies, it is always been the most challenging task to efficiently manage the business accounts in a genuine and proper way by simply getting the best and proper solutions. And the best, right and easy resolutions are the most important for the growth of everyone business.
ReplyDeleteHope now you recognize that how to relate with QuickBooks Enterprise Tech Support Phone Number. We've been independent alternative party support company for intuit QuickBooks, we do not have almost any link with direct QuickBooks, the employment of name Images and logos on website only for reference purposes only.
ReplyDeleteLast but not least, don’t hesitate to call us on our QuickBooks Online Help Number. Our company is surely here for your needs. To conclude, any error, any issue, any bug or other things linked to QuickBooks related problem, just call our QuickBooks Support Surely, call our QuickBooks Support phone Number.
ReplyDeleteIn order that’s why our technical support experts are yield to offer you every possible solution for all you associated issue at our QuickBooks Payroll Technical Support Number Our experts’ team at QuickBooks Support will likely make you gather its advanced functions and assists you to definitely increase your business growth.
ReplyDeleteThe QuickBooks Tech Support Phone Number software allows you to seamlessly manage your payroll, inventory, sales, as well as quarterly and yearly tax filing with quite ease and precision. Even though the application is an easy task to put up and use, users may often need support services to help make the almost all of it.
ReplyDeleteAny QuickBooks user faces any sort of identified errors in their daily accounting routine; these errors can differ in one another to a sizable degree, so our dedicated QuickBooks Tech Support Phone Number Service Pro-Advisors are very well designed with their tools and expertise to produce most effective resolutions very quickly to the customers.
ReplyDeleteWow! What a remarkable blog. Keep it up and never stop writing such a wonderful blog. Bloggers like you are gradually disappearing from the internet. If you need any accounting software, try using QuickBooks. Recently I came across QuickBooks Desktop Support Phone Number +1-888-238-7409. They provide premium quality QuickBooks service at a very affordable price. Visit us:- https://www.enetquickbookenterprise.com/quickbooks-desktop-support/
ReplyDeleteYour blog is probably one of the best blogs, I’ve ever read. This was the best information for me. I now insist upon the frequent sharing of your writings. Well, if your working on QuickBooks gets corrupted via the occurrence if the QuickBooks Error 6000 83, avail the 24*7 consultation services with QuickBooks experts and instant resolution of problems at QuickBooks Support Phone Number 1 833-441-8848.
ReplyDeleteHi, thanks for such a factual blog. I really liked your content and couldn’t resist sharing it with my entire friend circle. You should really be consistent in sharing more of your work. You should be really cautious about the faulty working situations on QuickBooks. In case there are faults like the QuickBooks Error 6000 107, get it resolved at QuickBooks Support Phone Number 1-833-441-8848.
ReplyDelete
ReplyDeleteAmazing Post Man, too good!
While going through your wonderful Post, I was able to connect it well with my problem. You have explained the concept in layman language that is well understood and the facts you have presented are very authentic. I personally admire your writing style. To manage your time more efficiently in your business, QuickBooks accounting software is the most prominent solution. While working on the application, you face some errors; one such is QuickBooks Error H505. Thus, to fix QuickBooks Error H505 you can contact QuickBooks Helpline Number +1 833-228-2822 and avail prominent solutions from our QuickBooks Experts.
Nice content! I appreciate the research and hard work you put into crafting such an informative blog. However, one can utilize QuickBooks solutions that can help you doing routine accounting and payroll tasks with ease. However, there are chances that you may face some errors. Don’t fret! Get the solution on QuickBooks Payroll Support Phone Number +1 800-674-9538. Our team of experts is available 24*7 for your assistance.
ReplyDeleteThis is an awesome post and I would like to extend my gratitude by sharing this post on different platforms. If you are looking for a reliable and an efficient accounting software contact our experts at QuickBooks Support Phone Number +1-833-441-8848 and educate yourself more about this amazing software and its unending beneficial features and functionalities.
ReplyDeleteWhat a post! you just hit it out of the park. Great people like you deserve a great software that can be found in QuickBooks. This software helps you easily manage your accounting works, moreover, if you get any error related to this product, contact us at QuickBooks Desktop Support Phone Number +1-833-422-8848. This is a great customer support service, where you can get remote help as well if needed. So, without thinking twice, just connect with us.
ReplyDeleteI admire the efforts that you have put in to bring forth this worthy piece. Your works are a treat to the brain. They are highly motivating. Keep rocking the same way. In case, you want assistance for managing accounts, try QuickBooks. It is really helpful and allows you to perform various tasks including calculating the salary of the employees. It has inbuilt features that can replace manual work and provide effective results. You can call on QuickBooks Payroll Support Phone Number +1-833-422-8848 to know more about it.
ReplyDeleteI liked your blog. I have read your other blogs, and they are amazing. It has been a while since I am using QuickBooks as my primary accounting software. If you want to make your accounting process easy and interactive, I would recommend you to give it a shot. You can also get premium class service on QuickBooks Phone Number +1-833 441-8848.
ReplyDeleteYeah, I liked your post. It is extremely informative. I wish you a successful career in blogging. Further, if you do account related works manually, then please stop it immediately as you can use QuickBooks accounting software which will save your time and energy. Additionally, you have a great support available 24x7 at QuickBooks Helpline Number +1-833 441-8848. Connect now!
ReplyDeleteThe team at QuickBooks Error Support +1-833 422-8848 are trained under the guidance of professionals and provides prolific support services.visit us:-https://tinyurl.com/umsoen9
ReplyDeleteHaving queries in mind related with QuickBooks? Get in touch with QuickBooks Support Phone Number 1-833-401-0005. Our QuickBooks technicians deployed on the support provide immediate assistance related with the software. For More Visit: https://www.accountauditxpert.com/quickbooks-support/
ReplyDelete
ReplyDeleteVery well explained and informative blog click here for
QuickBooks support phone number844-908-0801 for more detail dial on our support toll free number 844-908-0801
Very well explained and informative blog click here for
ReplyDeleteQuickBooks POS support phone number and for more detail dial on 844-908-0801
Awesome content I must say! Keep writing like this. Further, if you want to manage your accounts without difficulty and spending so much time, use QuickBooks accounting software. It offers payroll management as well. Also, you can call QuickBooks Payroll Support Phone Number 1-877-282-6222 regarding support in payroll. Service is available round the clock.visit us: https://www.enetservepartners.com/quickbooks-payroll-support/
ReplyDeleteHi! Superb blog. You have written an excellent, self-explained, and thought-provoking blog. Being a small-sized business owner, it can get tough for you to manage your business accounts on your own. With QuickBooks, you can easily keep track of your business accounts. If you want quick help for the software, reach our experts via QuickBooks Support Phone Number +1-844-232-O2O2.
ReplyDeletevisit us:-https://www.mildaccounting.com/quickbooks-support-phone-number/
Hey! Excellent post. I am impressed by your blogging skills. I have read many blogs earlier but haven’t read such a beautiful piece of work before. In case you are having any difficulty in tracking your income and expenses, then go for QuickBooks software. This software can help you to keep track of your income and expenses. To get support for the technical errors, contact us via QuickBooks Customer Care Number +1-844-232-O2O2.
ReplyDeletevisit us:-https://www.mildaccounting.com/
Wow! Keep writing stuff like this. Moreover, if you need an accounting software for managing your day to day task then go for QuickBooks software. It has many outstanding features that will help you out. Besides, get assistance to fix any issue at QuickBooks Contact Number Tech Support 1-833-401-0204. Read more: https://www.paysoln.com/quickbooks-contact-number-tech-support/
ReplyDeleteThe experts at QuickBooks Technical Support Phone Number +1 (877) 282-6222 are available 24x7 hours and are always ready to help you with the best solution, every time. The experts at QuickBooks Technical Support Phone Number +1 (877) 282-6222 are available 24x7 hours and are always ready to help you with the best solution, every time.
ReplyDeleteQuickBooks Technical Support Phone Number
QuickBooks Technical Support Phone Number
QuickBooks Technical Support Phone Number
QuickBooks Enterprise Support Phone Number is successfully delivering the world class technical assistance for QuickBooks Enterprise at comfort of your home. We understand your growing business need and that is the reason we provide only the best.
ReplyDeleteQuickBooks Enterprise Support Phone Number
QuickBooks Enterprise Support Phone Number
QuickBooks Enterprise Support Phone Number
The team at QuickBooks Payroll Support Phone Number 1 855-907-0605 resolves all your issues that pop up in your software. Read more- https://tinyurl.com/rxkgwon & Visit us- https://issuu.com/qbcustomerssupportphonenumber/docs/quickbooks_payroll_support_phone_number_2
ReplyDeleteHey! Excellent Post. You have written a very fabulous blog. Keep it up. Thanks for sharing such a great blog. Moreover, if you are engaged in QuickBooks Desktop Payroll software and facing any error in your software, dial QuickBooks Payroll Support Phone Number 1-833-401-0204 and get instant resolution for your queries. Read more: https://issuu.com/colqb/docs/quickbooks_payroll_support_phone_nu_c7f0f7d7817544
ReplyDeleteOr
http://www.authorstream.com/Presentation/WILLIAMSMITH4010204-4171002-quickbooks-payroll-support-phone-number-833-401-0204/
Hey! Excellent Post. You have written a very fabulous blog. Keep it up. Thanks for sharing such a great blog. Moreover, if you are engaged in QuickBooks Desktop Payroll software and facing any error in your software, dial QuickBooks Payroll Support Phone Number 1-833-401-0204 and get instant resolution for your queries. Read more: https://issuu.com/colqb/docs/quickbooks_payroll_support_phone_nu_c7f0f7d7817544
ReplyDeleteOr
http://www.authorstream.com/Presentation/WILLIAMSMITH4010204-4171002-quickbooks-payroll-support-phone-number-833-401-0204/
Just simply clearing the “Cache” resolves many issues, this can work for QuickBooks Error Code 9999 as well. You can try this solution for other bank feed or crashed feed issues. Try on this solution and see if this works well. This itself might clear the issue without performing any other significant modifications to QuickBooks system. If you would like to learn how to Troubleshoot Quickbooks Error 9999, you can continue reading this blog.
ReplyDeletehttps://youtu.be/RF5hTm9vmnc
ReplyDeletehttps://youtu.be/Xrkf8OudbWs
https://youtu.be/YWsOxdHkJt0
Very helpful and i would like to thanks!
ReplyDeleteKnow How to Do QuickBooks general ledger? Get live support 24*7 from QuickBooks expert on tool-free Number.
Click here to know how to do QuickBooks general ledger
Dial for any tech support: 1-844-908-0801
Thankyou for Explained! Best accounting software Quickbooks Provide 24*7 Live service just make a call on 1-855-511-6911 Quickbooks Enterprise customer service.
ReplyDelete
ReplyDeleteVery helpful and i would like to thanks! Know How to cancel quickbooks subscription? Get live support 24*7 from QuickBooks expert on tool-free Number. Click here to know how to Cancel Quickbooks Enterprise customer servicer Dial for any tech support: 1-855-511-6911
ReplyDeleteNice Blog !
Dealing with issues in QuickBooks? Don’t become worried, you are not alone. We are here to help you. Just place a call at Quickbooks Contact Number? Call us : 1-855-511-6911.
Great and I have a super proposal: How Much Should House Renovations Cost average remodel cost
ReplyDelete