Functional Specification
For information of the collected configuration change logs, delete the log recorded in the specified period.
Command Format
DTKDELST.EXE DTKDB <User> <Password> <StartDate> <EndDate> [-Y|-y]
Option
Fixed value.
Enter the logon ID registered in Server Settings Tool (The access authority is the logon ID of "Backup/Restore").
Enter the password of the above logon ID.
Enter the start day for data processing (8 digits). The range of value is "20010000" - "20349999" and "00000000". When the value of last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
.
When the last 4 digits are specified to "0000"
Jan. 1 of the specified year will be the start date.
When the last 4 digits are specified to "1232" - "9999"
Jan. 1 of the next year of the specified year will be start date.
When the last 2 digits are specified to "00"
1st of the specified month will be the start date.
When the last 2 digits are specified to "second day after the end of month" - "99"
1st of the next month of the specified month will be the start date.
In addition, when "00000000" is entered, the start date will be determined as the time when data started to be accumulated in database.
Enter the end date for data processing (8 digits). The range of value is "20010000" - "20349999" that is larger than the value of <StartDate>. When the value of last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
When the last 4 digits are specified to "0000"
Dec. 31 of the year previous to the specified year will be the end date.
When the last 4 digits are specified to "1232" - "9999"
Dec. 31 of the specified year will be the end date.
When the last 2 digits are specified to "00"
The last date of the last month of specified month will be the end date.
When the last 2 digits are specified to "second day after the end of month" - "99"
The last date of the specified month will be the end date.
When "-Y" or "-y" is entered, the deletion process is finished without displaying the confirmation message.
When "-Y" or "-y" is omitted, the following confirmation message will be displayed.
[Delete setting change log table. Execute? (y/n)]
In this window, enter "Y" or "y" and press the [Enter] key to continue processing. If other characters are entered and the [Enter] key is pressed, or when only the [Enter] key is pressed, processing will be interrupted.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKDELST.EXE
Authority Required for Execution/Execution Environment
Execute with a user that belongs to the Administrators group of the local computer or a user that belongs to the Domain Admins group of the domain.
Execute on the Management Server/Master Management Server.
Note
No restoration function.
Before deleting configuration change log, though backup can be executed through Master, the configuration change log before deletion can be saved, after restoring the data of master series, since overall replacement is required, after the backup process has been executed, the data before restoration process will be deleted
The command execution result will be output to the command prompt. If you wish to keep the execution result, specify the file for output through redirection when executing the command.
The time required for deletion will be extended with the increasing number of records to be deleted. Verify the time consumed for deleting data in a day, and in order to complete backup and deletion operation within available time, arrange the number of days for backup and deletion rationally.
When deleting, the disk I/O inside PostgreSQL will become very high, which may affect the service processing at server side of Systemwalker Desktop Keeper. When the deletion process consumes too much time, consider to stop the service at server side of Systemwalker Desktop Keeper and start the service of server side again after the deletion process has finished.
Example of Use/Execution Results/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKDELST.exe DTKDB User Password 20010000 20349999 2009/06/08 16:39:07 [BKCI-SEL101] Delete setting change log table. Execute? (y/n) y 2009/06/08 16:39:09 Delete setting change log information - Start 2009/06/08 16:39:09 2009/06/08 16:39:09 Database : DTKDB 2009/06/08 16:39:09 Processing start date : 20010000 2009/06/08 16:39:09 Processing finish date : 20349999 2009/06/08 16:39:09 Deletion indication : 2009/06/08 16:39:09 2009/06/08 16:39:09 Processing 2009/06/08 ... 40 items are deleted 2009/06/08 16:39:09 Number of deleted items....71 2009/06/08 16:39:09 2009/06/08 16:39:09 Delete setting change log information - End
