Viewing the First Record

The steps in this section explain how to set up the Logdump environment and start viewing records.

Parent topic: Using the Logdump Utility

Running Logdump

Run the logdump program from the Oracle GoldenGate installation location. Logdump command lines are numbered so that you can use edit and history commands.

Parent topic: Viewing the First Record

Setting Up the View

The following commands set up a Logdump environment that shows the information most commonly used when analyzing Oracle GoldenGate trail records.

To view the record header with the data:
```
Logdump 1> GHDR ON
```
The record header contains information about the transaction.
To add column information:
```
Logdump 2> DETAIL ON
```
Column information includes the number and length in hex and ASCII.
To add hex and ASCII data values to the column information:
```
Logdump 3> DETAIL DATA
```
To view user tokens:
```
Logdump 4> USERTOKEN ON
```
User tokens are custom user-defined information that is specified in a TABLE or FILE mapping statement and stored in the trail file for specific purposes.
To view automatically generated tokens:
```
Logdump 4> GGSTOKEN ON
```
Oracle GoldenGate automatically generated tokes include the transaction ID (XID), the row id for DML operations, the fetching status (if applicable), and tag value.
To control how much record data is displayed:
```
Logdump 5> RECLEN length
```

Parent topic: Viewing the First Record

Opening a Trail File

To open a trail file, complete the following steps:

Open a file with the following command:
```
Logdump 6> OPEN file_name
```
Where:

file_name is either the relative name or fully qualified name of the file, including the file sequence number. For example:
```
open /home/ggs/dirdat/jd000000
open $data01.glogggl.aa000000
```
To go to the first record and then move through records in sequence:
```
Logdump 7> NEXT
```
Alternatively, you can simply enter N.

Figure 1-1 Logdump Record as Seen on a Windows System

Description of "Figure 1-1 Logdump Record as Seen on a Windows System"

Figure 1-2 Trail Record as Seen on NonStop

Description of "Figure 1-2 Trail Record as Seen on NonStop"

Parent topic: Viewing the First Record