We want delete System Log tables in test environment as the System log table count reaches 100+ and occupies more space. We tried with all the below commands to drop old tables and indexes from DB. But getting the errors as unknown table.
Please correct me if wrong with the commands. Thanks in advance.
root is the instance owner & Instance name is ARCHIVE. CMOD version is 8.5.0.9 MP. Db2 is 9.7.
arsdb -I ARCHIVE -d SL10
arsdb -I ARCHIVE -d root.SL10
arsdb -I ARCHIVE -e SL10
arsdb -I ARCHIVE -e root.SL10
Are you sure you wish to drop the database tables and/or indexes:arsdb: Unknown table sl10
Are you sure you wish to drop the database tables and/or indexes:arsdb: Unknown table root.sl10
Consider shortening the retention period in the Application Group configuration on the System Log, then using arsmaint with the -cd and -g options to choose the System Log for expiration.
The arsdb command is a powerful and dangerous tool -- you should be very careful if you don't understand exactly how it works. (You almost dropped all of the configuration tables on that system by using the -d option.)
-JD.
Thanks Justin. I changed the retention as 1 year and run arsmaint -d for system log AG. Able to reclaim 30 GB space. :)
Just to know, what is the correct syntax for arsdb to delete any segment table in Ondemand? Thanks in advance.
You shouldn't ever delete table segments manually -- that's why there's no CMOD command for it.
If you configure the Application Group correctly, and run arsmaint, it will take care of itself! :)
-JD.