# How to change the Adabas "Login ID"?

**URL:** <https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Basics-on-Linux-Unix-Windows, Adabas-on-Windows-UNIX, Adabas-on-Linux\
**Created:** [December 11, 2009, 10:44pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348 "2009-12-11T22:44:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![KlaBue](https://avatars.discourse-cdn.com/v4/letter/k/848f3c/32.png) [@KlaBue](https://techcommunity.softwareag.com/u/KlaBue)\
**Post date:** [December 11, 2009, 10:44pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/1 "2009-12-11T22:44:02Z")

</div>

Hello _._,

is it possible to advice adabas, calling from a natural-pgm, to use a specific “Login Id”, by a parameter or something like that?

The User-Q is looking like this

```auto

       Id Node Id Login Id ES Id User Id File ISN Locks Flg
        -- ------- -------- ----- ------- ---- --- ----- ---
     13262 myaqg 9593 KPF9550 101 17,404,170 X M   
     13262 myaqg 9593 KPF9550 101 17,252,592 X M   
     13278 myaqg 14286 KPF14245 101 17,392,193 X M   
     13262 myaqg 9593 KPF9550 101 17,323,305 X M   
     13278 myaqg 14286 KPF14245 101 17,392,194 X M   
     13278 myaqg 14286 KPF14245 221 37,687,502 X M   
     13262 myaqg 9593 KPF9550 104 26,470,893 X M   
     13278 myaqg 14286 KPF14245 221 37,687,503 X M   

 
```

I observed, that the Login Id for an Adabas-Session ist the Unix-Userid, but not the userid, which is used by natural. In our Environment we set the NaturalUserid with an Environment-Variable ($LOGNAME).it works fine. but the ADABAS Login-Id is not affected by this. the login-id in the example above is myagq, but this are different users, working with the same (invisible) unix-userid.

btw: the column with the heading “User ID” is _not_ the UserID, it is the ETID as defined with the Natparm ETID Parameter.

Any Suggestions?

tia  
KlaBueBaer

---

<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:** [December 14, 2009, 1:48pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/2 "2009-12-14T13:48:25Z")

</div>

Hello KlaBueBaer!

Your sample screenshot looks like a Hold-Queue …  
Probably you want to know which user is holding a specific record.

We got a similiar problem here at our company (ADABAS@Solaris). For Adabas 3.3 we found a solution decribed here

[http://tech.forums.softwareag.com/viewtopic.php?t=7217](http://tech.forums.softwareag.com/viewtopic.php?t=7217)

But maybe there’s a better way of doing this …

---

<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:** [December 15, 2009, 8:32pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/3 "2009-12-15T20:32:30Z")

</div>

Hi KlaBueBaer,

There are the functions lnk\_get\_adabas\_id and adalnk\_set\_adabas\_id, which allow you to read and overwrite the Adabas session ID. For more information look to Adabas Command Reference, Calling Adabas, Calling Adabas from Application Servers. However, I don’t know if it is possible to call these functions from Natural.

Regards,  
Wolfgang

---

<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:** [December 16, 2009, 4:55am UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/4 "2009-12-16T04:55:09Z")

</div>

Have you tried overriding the UserId from within the Natural parameter file you use when running the Natural program. However I doubt that this “USER” parameter can be changed dynamically.

---

<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:** [December 16, 2009, 1:56pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/5 "2009-12-16T13:56:30Z")

</div>

> [@Wolfgang Obmann](#):
>
> There are the functions lnk\_get\_adabas\_id and adalnk\_set\_adabas\_id, which allow you to read and overwrite the Adabas session ID.

Interesting hint!

The documentation  
[http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada517os/commands/calling.htm#appserv](http://techcommunity.softwareag.com/ecosystem/documentation/adabas/ada517os/commands/calling.htm#appserv) says, that the Adabas-Nucleus-Parameter OPEN\_REQUIRED has to be set. So I don’t think that there is a correspondig Natural-function - because Natural’s documentation doesn’t mention “OPEN\_REQUIRED” anywhere …

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [December 16, 2009, 10:48pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/6 "2009-12-16T22:48:28Z")

</div>

[http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat426mf/parms/db.htm#db\_db\_options](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat426mf/parms/db.htm#db_db_options)

DB options: OPEN This option applies to Adabas databases only, for which Adabas requires an open request to be issued. If OPEN is specified for such a database, an open request is always issued (even if the ETID is blank).

---

<div class="post-metadata">

**Author:** ![srini\_vasan](https://avatars.discourse-cdn.com/v4/letter/s/90ced4/32.png) [@srini\_vasan](https://techcommunity.softwareag.com/u/srini_vasan)\
**Post date:** [April 4, 2011, 4:55pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/7 "2011-04-04T16:55:17Z")

</div>

Thank for the shared this information

---

<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, 2:57pm UTC](https://techcommunity.softwareag.com/t/how-to-change-the-adabas-login-id/92348/8 "2021-04-02T14:57:50Z")

</div>


