Reloading the database

You may wish to reload the TapeTrack Database for the following reasons:

You have loaded a lot of randomly organized data and the database pages have become unbalanced.
You have deleted a lot of data and the database contains a lot of slack space.
You have lost the database log files or the database has become inconsistent with the database log files.

In heavily fragmented TapeTrack databases reloading may reduce their size by a factor of one third.

Large databases may take 2 to 3 hours to completely reload.

Although the reload procedure takes a copy of each file before reloading please ensure that you take a full backup before attempting the reload. In the event of a reload failure you should rename the var/db and var/dblogs directory and restore from a backup.

Reload procedure

Notify your users that the TapeTrack System will be unavailable.
Stop the TapeTrack Service.
Backup the TapeTrack database files.
Open a command prompt as Administrator.
Change directory to the TapeTrack Database file (you can use variable TMSS10DB).
Run the command TMSS10Server with the -L argument.
Check the output to ensure each of the steps ended with a zero return code.
Start the TapeTrack Service.

If the TapeTrack Database was moved to another location after the initial install the TapeTrack database may not be in the location that is reflected in the variable TMSS10DB.

<sxh> C:\>cd %TMSS10DB%

C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db>TMSS10Server -L Reloading Database files Testing for existence of db_dump Berkeley DB 5.3.28: (September 9, 2013) Testing for existence of db_load Berkeley DB 5.3.28: (September 9, 2013)

           System: TapeTrack

Report Description: Reload Report

  Production Time: Tuesday, June 06, 2017 - 15:45:41 (Mountain Daylight Time)
     Report Width: 77 bytes

Database File db_dump rename db_load ———————————————— ——– ——– ——– TMSS10.ip-connect 0 0 0 TMSS10.heartbeat 0 0 0 TMSS10.dictionary 0 0 0 TMSS10.dictionary-data 0 0 0 TMSS10.message 0 0 0 TMSS10.message-response 0 0 0 TMSS10.message-response-user 0 0 0 TMSS10.journal 0 0 0 TMSS10.journal-date 0 0 0 TMSS10.client 0 0 0 TMSS10.client-pool 0 0 0 TMSS10.options 0 0 0 TMSS10.emailspool 0 0 0 TMSS10.container 0 0 0 TMSS10.barcode 0 0 0 TMSS10.password 0 0 0 TMSS10.stock 0 0 0 TMSS10.stock-id 0 0 0 TMSS10.customer 0 0 0 TMSS10.customer-libraryhealth-totals 0 0 0 TMSS10.user 0 0 0 TMSS10.user-email 0 0 0 TMSS10.group 0 0 0 TMSS10.zone 0 0 0 TMSS10.favorite 0 0 0 TMSS10.notes 0 0 0 TMSS10.attributes 0 0 0 TMSS10.attributetype 0 0 0 TMSS10.attribute-history 0 0 0 TMSS10.file 0 0 0 TMSS10.file-data 0 0 0 TMSS10.file-generation 0 0 0 TMSS10.dr-strategy 0 0 0 TMSS10.dr-strategy-item 0 0 0 TMSS10.catalog 0 0 0 TMSS10.catalog-id 0 0 0 TMSS10.catalog-extent 0 0 0 TMSS10.catalog-extent-time 0 0 0 TMSS10.media 0 0 0 TMSS10.certificate 0 0 0 TMSS10.simplemanagement 0 0 0 TMSS10.consignment 0 0 0 TMSS10.datacluster 0 0 0 TMSS10.dataset 0 0 0 TMSS10.repository 0 0 0 TMSS10.repository-move-totals 0 0 0 TMSS10.media-totals 0 0 0 TMSS10.volume 0 0 0 TMSS10.volume-offsitetime 0 0 0 TMSS10.volume-synctime 0 0 0 TMSS10.volume-container 0 0 0 TMSS10.volume-dup-global 0 0 0 TMSS10.volume-dup-customer 0 0 0 TMSS10.volume-cmserial 0 0 0 TMSS10.volume-status 0 0 0 TMSS10.volume-customer 0 0 0 TMSS10.volume-media 0 0 0 TMSS10.volume-relaxed 0 0 0 TMSS10.volume-repository 0 0 0 TMSS10.volume-repository-incoming 0 0 0 TMSS10.volume-repository-slot 0 0 0 TMSS10.volume-repository-scratch 0 0 0 TMSS10.usage 0 0 0 TMSS10.usage-drive 0 0 0 TMSS10.volume-container-tag 0 0 0 TMSS10.history 0 0 0 TMSS10.history-archive 0 0 0 ———————————————— ——– ——– ——–

C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db> </sxh>

← Copying TapeTrack Database

Advanced Administration