Functional Specification
All tables of operation logs and prohibition logs of Systemwalker Desktop Keeper recorded as "Log Information" managed in database can be backed up as a CSV file in tables and the tables that have been backed up can be deleted from the database.
For log information that can be backed up and deleted, refer to relevant information in "1.13 DTKLGTB.EXE (Backup of Log Information)".
Command Format
Execute in the following format through the command prompt.
DTKDELR.EXE DTKDB <User> <Password> <StartDate> <EndDate> [-Y|-y] [SERVER] [STOP <seconds>]
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 the last 4 digits of "20010000" - "20349999" does 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" does 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.
[BKCI-SEL004] Delete log table. Execute? (y/n)]
In this window, enter "Y" or "y" key and press the [Enter] key to continue processing. If "N" or "n" key is entered and the [Enter] key is pressed, processing will be interrupted.
When specifying "SERVER" (Halfwidth character), processing is performed based on the date when log information is saved in Management Server/Master Management Server. If "SERVER" is omitted, processing will be performed by taking the date specified in <StartDate> and <EndDate> as condition, based on the date when the log information is collected on client.
When "STOP" (halfwidth character) is specified, the command is completed if the log is not deleted even after the specified time has elapsed after the command start.
When it is omitted, the processing is continued till the deletion process has finished.
When "STOP" is not specified, <seconds> cannot be specified.
When "STOP" is specified, <seconds> must be specified.
The operating time must be specified in the range 1 to 999999 in <seconds>. The unit is 'seconds', 999999 seconds = 11-days 13-hours 46-minutes 39-seconds.
When "STOP" is not specified, the process is not interrupted till the deletion process has finished.
When "STOP" is specified, the process is interrupted if the command is running for the time beyond the specified time. Note that the process is continued till the internal processing is paused; therefore, the command is completed few minutes after the specified time.
When "STOP" is specified, if the command is completed before crossing the specified time, then similar to the normal processing, an error code 100 is given and the processing is stopped.
In the command option, an option that contains space, etc., cannot be specified.
When specifying an option, data enclosed in double quotations cannot be specified.
Return Value
Ended normally.
Process interrupted after the elapse of the time
Ended abnormally.
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKDELR.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
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.
The image file of the screen hard copy collected from the client (CT) through the screen capture function will be saved in Management Server/Master Management Server connected with the client (CT). In database, only the index information of image file is saved in the "COMMONLOG2" table. Backup and deletion process only processes the index information while the image file will not be processed.
Example of Use/Execution Result/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKDELR.EXE DTKDB User Password 20111201 20111205 STOP 3600 [BKCI-SEL004] Delete log table. Execute? (y/n) y 2012/06/04 11:35:37 Delete Log Information - Start 2012/06/04 11:35:37 2012/06/04 11:35:37 Database : DTKDB 2012/06/04 11:35:37 Processing start date : 20111201 2012/06/04 11:35:37 Processing finish date : 20111205 2012/06/04 11:35:37 Deletion indication : 2012/06/04 11:35:37 Extraction Key : 2012/06/04 11:35:37 Interruption instruction (seconds) : 3600 2012/06/04 11:35:37 2012/06/04 11:35:37 - COMMONLOG1 2012/06/04 11:35:37 Processed on 2011/12/05 ... 123456 items deleted 2012/06/04 11:35:37 Processed on 2011/12/04 ... 234567 items deleted 2012/06/04 11:35:37 Processed on 2011/12/03 ... 345678 items deleted 2012/06/04 12:41:34 Specified time has elapsed. 2012/06/04 12:41:34 Processed on 2011/12/02... 97345 items deleted (Actually deleted items) 2012/06/04 12:41:34 2012/06/04 12:41:34 Delete log information - End
