Top
Systemwalker Desktop Keeper Reference Manual
FUJITSU Software

1.23 DTKTBLUNLOAD.BAT (High-speed Backup of Entire Log Table)

Functional Specification

The backup of all the records from the log table and configuration change log table can be taken at a high speed.
However, the backup of all the records in the table is taken. It is not possible to take backup of some records by specifying the period.

Command Format

DTKTBLUNLOAD.BAT  DTKDB  {OPELOG | SETTINGSLOG | ALLLOG}  <OutDir>  [NOPROMPTLOG]  [AUTOPATH]

Option

DTKDB:

It is a fixed value.

<Processing target>:

Uppercase/lowercase letters can be used in the string of option. Fullwidth characters cannot be specified.

OPELOG:

Specify for processing the log table.

SETTINGSLOG:

Specify for processing the configuration change log table.

ALLLOG:

Specify for processing both the log table and the configuration change log table.

<OutDir>:

Enter the file of saving target with absolute path. The folder should be created in advance.

NOPROMPTLOG:

Specify when it is not required to take backup of the command prompt log text file under the PromptLog folder collected from the client (CT).
When NOPRONPTLOG is omitted by specifying OPELOG or ALLLOG in <Processing target>, a folder named "PromptLog" is created at the location specified in the <OutDir> and all the text files storing the command prompt log details are placed immediately under that folder.
When NOPRONPTLOG is omitted by specifying SETTINGSLOG in <Processing target >, the command prompt log is not deleted.
It can be omitted.

AUTOPATH:

Create a folder named "BKyyyymmddhhmmss" (yyyymmddhhmmss is the date and time of command execution) in the folder specified under <OutDir>, and store backup files under that folder. Also, create a folder called "PromptLog" under this folder, and place all the text files storing the command prompt log details.
It can be omitted. If omitted, create a folder called "PromptLog" under <OutDir>, and place all the text files storing the command prompt log details.

Return Value

[ERRORLEVEL] 0:

Ended normally

[ERRORLEVEL] 1:

Option error

[ERRORLEVEL] 2:

Other errors

Location for Saving Commands

<Installation folder for database related files>\BackupCommand\DTKTBLUNLOAD.BAT

Authority Required for Execution/Execution Environment

Note

  • All the logs in the log table are output; therefore, a large quantity of data might be output. Confirm that the output destination has the sufficient empty space. While displaying a file, if it is found that the area is not sufficient, the process ends abnormally.

  • If the output destination folder contains a file with the same name, the process ends abnormally. Delete the file in advance or automatically create a folder on the given date and time by specifying the AUTOPATH.

  • As per the result output by DTKLGTB.exe, the file creation order is different from the data record output order.

  • Only local hard disk can be specified in the output destination folder. Do not specify network drives or removable drives. When sending files to network drives or removable drives, take a backup in the local disk, and then transfer the file to any other folder.

  • When executing this command in Windows Server 2008, Windows Server 2012, or Windows Server 2016, it is necessary to open the command prompt with "Run as Administrator".

  • According to the environment being used, it is necessary to edit DTKTBLUNLOAD.BAT. For information on how to edit, refer to relevant content in "Edit Backup Commands" of "Using the Backup Commands" of Installation Guide. In addition, error check is not performed in backup command for database name, connection user ID and password. When the set value is incorrect, an error will occur during the execution of backup command.

Example of Use/Execution Results/Output Format

[Example of use when backup of all logs is taken by specifying AUTOPATH]
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKTBLUNLOAD.BAT DTKDB ALLLOG "C:\DTKBKUP" AUTOPATH
Tue 06/02/2015-20:05:59.54   (1) [Start]Backup of log system table
Tue 06/02/2015-20:05:59.55    (1-1) COMMONLOG1 Start of processing
COPY 4052
Tue 06/02/2015-20:06:01.30    (1-2) COMMONLOG2 Start of processing
COPY 16348
Tue 06/02/2015-20:06:05.10    (1-3) COMMONLOG3 Start of processing
COPY 1625
Tue 06/02/2015-20:06:06.28    (1-4) FILEACCESSLOG Start of processing
COPY 80519
Tue 06/02/2015-20:06:50.45    (1-5) FILEBRINGOUTLOG Start of processing
COPY 39
Tue 06/02/2015-20:06:51.87    (1-6) LOGINGUARDLOG Start of processing
COPY 0
Tue 06/02/2015-20:06:52.07    (1-7) LOGKEYWORDS Start of processing
COPY 22073
Tue 06/02/2015-20:06:56.43    (1-8) PRINTLOG Start of processing
COPY 2
Tue 06/02/2015-20:06:56.81    (1-9) SESSIONMANAGE Start of processing
COPY 68
Tue 06/02/2015-20:06:57.20    (1-10) STARTUPGUARDLOG Start of processing
COPY 7
Tue 06/02/2015-20:06:57.53    (1-11) USERLIST Start of processing
COPY 0
Tue 06/02/2015-20:06:57.71    (1-12) Command Prompt Log File Start of processing
0 File(s) copied
Tue 06/02/2015-20:06:57.85   (1) [End]Backup of log system table
Tue 06/02/2015-20:06:57.87   (2) [Start]Backup of setting change log system table
Tue 06/02/2015-20:06:57.87    (2-1) SETTINGS Start of processing
COPY 1053
Tue 06/02/2015-20:06:58.73    (2-2) LOGONUSER_SETTINGS Start of processing
COPY 0
Tue 06/02/2015-20:06:58.96   (2) [End]Backup of setting change log system table