Skip to content
≡

Administrator

Developer

Tools

External Tools

Dumpddf

dumpddf#

About dumpddf#

dumpddf outputs header information of data files or specific pages in data files. Also, if dumpddf is executed on incremental backup files, header information of the backup file and backup information are output.

dumpddf {-f datafile_name} {-m | -p pid}

Syntax#

dumpddf

Parameters#

Parameter Description
-f Specifies the name of the data file for which it is desired to obtain information. This option must be given. If it is omitted, dumpddf will terminate and output an error message.
-m Outputs the data file header information.
-p Specifies the ID of the page in the data file for which it is desired to obtain information.

Description#

Outputs space and information in the data file. The menue page outputs a page from a table or socket.

Example#

At a shell prompt, type the following:

$ dumpddf -f datafile -m
$ dumpddf -f datafile -p page_id

Output#

The following is an example of dumpddf output:

[BEGIN DATABASE FILE HEADER]
Binary DB Version             [ 5.4.1 ]
Redo LSN                      [0, 734497 ]
Create LSN                    [0, 1886 ]
MustRedo LSN                  [0, 0 ]

In the output, each field has the following meaning:

Filed Name Description
Binary DB Version The version of the data file
Redo LSN The redo LSN for media recovery. If the loganchor SN is higher than the Redo LSN of the data file, it will be necessary to perform media recovery, starting from this redo LSN.
Create LSN The LSN at the time when the specified datafile was created.
MustRedo LSN Indicates that recovery must be performed up to this redo LSN
DataFileDescSlot ID The ID of the DataFileDescSlot of the changeTracking file bound to the disk datafile.

The following is an example of outputting an incremental backup file by dumpddf.

$ dumpddf -m -f system001.dbf_TAG_MONDAY.ibak
-----------------------------------------------------------------
     Altibase Client Dump Disk Database File utility.
     Release Version 6.3.1.0.0
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
[BEGIN DATABASE FILE HEADER]

Binary DB Version             [ 6.2.1 ]
Redo LSN                      [1, 5867599 ]
Create LSN                    [0, 1914 ]
MustRedo LSN                  [0, 0 ]
DataFileDescSlot ID           [ 1, 2 ]

[BEGIN BACKUPFILE INFORMATION]        # incremental backup information stored in the backup file

        Begin Backup Time             [ 2012_11_06 23:18:44 ]
        End Backup Time               [ 2012_11_06 23:18:46 ]
        IBChunk Count                 [ 0 ]
        Backup Target                 [ DATABASE ]
        Backup Level                  [ LEVEL0 ]
        Backup Type                   [ FULL ]
        TableSpace ID                 [ 2 ]
        File ID                       [ 0 ]
        Backup Tag Name               [ MONDAY ]
        Backup File Name              [ /backup_dir/TAG_MONDAY/system001.dbf_TAG_MONDAY.ibak ]

  [END BACKUPFILE INFORMATION]

[END DATABASE FILE HEADER]