# USER DATA File 3

**URL:** <https://techcommunity.softwareag.com/t/user-data-file-3/101498>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Basics-on-Linux-Unix-Windows, Adabas-on-Windows-UNIX, Adabas-on-Linux\
**Created:** [September 25, 2012, 5:08pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498 "2012-09-25T17:08:19Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elena\_Papadopolis1](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@Elena\_Papadopolis1](https://techcommunity.softwareag.com/u/Elena_Papadopolis1)\
**Post date:** [September 25, 2012, 5:08pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/1 "2012-09-25T17:08:19Z")

</div>

Hi,  
does anyone know what the file 3 (USER DATA File) is used for (apart from ET Data?).  
This file is growing so quickly in our environment, I thought it was used for modules with ET Data only, we have less than 20 modules using ET Data but I just found out that are some records there for online users (we don’t have online modules with ET Data).  
Is it safe just to refresh the file when it gets too big?  
Thanks.

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [September 27, 2012, 1:11pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/2 "2012-09-27T13:11:41Z")

</div>

I would try to find out which online-session writes into file 3. If you’re using plog, maybe ADAPLP helps …

---

<div class="post-metadata">

**Author:** ![Elena\_Papadopolis1](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@Elena\_Papadopolis1](https://techcommunity.softwareag.com/u/Elena_Papadopolis1)\
**Post date:** [October 2, 2012, 4:30pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/3 "2012-10-02T16:30:52Z")

</div>

Hi Matthias.  
Thanks for your reply.  
We do use plog and it looks like the sessions being written to file 3 are from users using the screens, probably the ones with ET.  
Couldn’t find out any more as there is no documentation about this file.  
I think I will have to raise the issue with SAG.  
What does the ADAPLP do?  
Thanks again.

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [October 5, 2012, 9:42am UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/4 "2012-10-05T09:42:25Z")

</div>

> [@Elena Papadopolis](#):
>
> What does the ADAPLP do?

The ADAPLP utility reads a plog file and prints out the content of it - you can almost read it like a book.

Example (snippet):

[code]  
Rec 4, lng 52, seq 1932372976, type DA, th 3, internal id 121085  
file 222, RABN 5574304, ISN 3141597, clu 0 TSN 193508  
flags: DI

> > > Delta \<\<\<

Length = 161, ISN = 3141197

Field : AB: ^0735247C  
…  
Rec 6, lng 40, seq 1932372978, type ET, th 3, internal id 121085  
prio 0, clu 0, ET-TSN 0, TSN 193508, user-id MATTHIAS  
[/coce]

Rec 4 is a modification on field AB of ISN 3141597 in file 222.  
Rec 6 is the regarding End Transaction - showing the user-id.

Like that you can find out what user/session writes into your file 3.

---

<div class="post-metadata">

**Author:** ![Elena\_Papadopolis1](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@Elena\_Papadopolis1](https://techcommunity.softwareag.com/u/Elena_Papadopolis1)\
**Post date:** [October 18, 2012, 4:20pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/5 "2012-10-18T16:20:42Z")

</div>

Thanks Matthias, i will try that.

---

<div class="post-metadata">

**Author:** ![Elena\_Papadopolis1](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@Elena\_Papadopolis1](https://techcommunity.softwareag.com/u/Elena_Papadopolis1)\
**Post date:** [November 2, 2012, 5:25pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/6 "2012-11-02T17:25:04Z")

</div>

Hi, does anyone know the syntaxe of the ADAPLP? I have tried a few diferents commands, not getting an error but not getting an output either (apart from the header below):

[thunderbolt]: /opt/softwareag $ adaplp db=208 decompressed plog=0167 dataset=plog type=ET  
%ADAPLP-I-STARTED, 02-NOV-2012 15:45:51, Version 6.3.0.12 (AIX 64Bit)  
PLOG of db 208, created on 31-OCT-2012, session 167

%ADAPLP-I-IOCNT, 1 IOs on dataset PLPPLG  
%ADAPLP-I-TERMINATED, 02-NOV-2012 15:45:51, elapsed time: 00:00:00

Thanks.

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [November 15, 2012, 8:49am UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/7 "2012-11-15T08:49:33Z")

</div>

Example for one plog per adabas-session:

```auto

PLPPLG='/myplogdir/plog.1160.1'
export PLPPLG
adaplp db=014 'PLOG=(1160,1)' dataset=PLOG decompressed type='(DA,CE,ET,BT)' dump rabn=* record=*
```

Output:

```auto

%ADAPLP-I-STARTED, 15-NOV-2012 08:54:10, Version 6.1.10.10 (Solaris 64Bit)
PLOG of db 14, created on 15-NOV-2012, session 1160

 Block 1, size 172 bytes, session 1160, time stamp 15-NOV-2012 03:34:28

Rec 1, lng 68, seq 1, type DA, th 7, internal id 2
       file 1, RABN 4429483, ISN 272941, clu 0 TSN 0
       flags: FDATA AI FIRST_ENTRY

>>> After Image <<<

Length = 24, ISN = 272941

Group : CP
Field : TI: ^0000000051B44032
Field : BN: ^00000002
Field : JN: ^1006000000000000
Field : NA: ^52584F51
Field : TN: ^0488
Field : TY: ^01
Field : EX: ^01

...
```

Example for more than one plog per adabas-session:

```auto
PLPLEX='/myplogdir/plog.1154.27' 
export PLPLEX
PLPPLG='/myplogdir/plog.1154.28'
export PLPPLG
adaplp db=014 'PLOG=(1154,28)' dataset=PLOG decompressed type='(DA,CE,ET,BT)' dump rabn=* record=*
```

---

<div class="post-metadata">

**Author:** ![Elena\_Papadopolis1](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@Elena\_Papadopolis1](https://techcommunity.softwareag.com/u/Elena_Papadopolis1)\
**Post date:** [November 21, 2012, 10:53am UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/8 "2012-11-21T10:53:55Z")

</div>

Thanks for your help again Matthias! I can see the output now.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:02pm UTC](https://techcommunity.softwareag.com/t/user-data-file-3/101498/9 "2021-04-02T15:02:27Z")

</div>