Company: Link Technologies
Case No: L12975. Project: 15.10: LinkSOFT Version 15.10
Logged By: Sanjay (Link Technologies) on 20 Nov 2023 03:18PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 14.00 (Weight: 20.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Friday, 01 December 2023 12:21 PM [149 days since logged date]
Status: Closed
Subject: Database Maintenance Improvement allowing us to Shrink the Database to save disk space as part of cleanup
Summary:    Database Maintenance Improvement allowing us to Shrink the Database to save disk space as part of cleanup
Audit Notes:Edited by sanjay on 29/11/23 16:11. Edited by sanjay on 29/11/23 16:07. 
20 Nov 202303:20PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-11-2023 03:18 PM Time Taken: 8.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.10

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

  1. Added option to "Shrink Database" in process SYS008. This will move empty spaced in the log files to the end of the file then remove the empty space

3. Affected Areas:

  1. System Maintenance Task - SYS008

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


27 Nov 202312:27PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-12-2023 12:21 PM Time Taken: 6.00 Notes: ETC extended from: 20/11/2023 to 01/12/2023
The following tests were performed:

Test Setup Instructions:
  1. Standard Demo Environment
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Run Process SYS008 with "ShrinkDB" = N
Database size should not change
Pass
Refer to Figure 1
2Run Process SYS008 with "ShrinkDB" = Y
Database size should reduce to original size

Refer to Figure 2. Database size reduced from 2.2GB to 250MB. Logs truncated

Figue1 1 - Database size with No Shrink

Figue1 1 - Database size with Shrink enabled

Environment Details

  1. OS version: Win11
  2. Application version: 15.10
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12975 in the subject line of all emails regarding this issue.

Document size: 203.0 KB
For call complaints, please contact the Managing Director of the company using this form