Not able to login from users except DBC

Problem :

Not able to login from users except DBC. Even when the "pdestate a" was displaying "Logons are enabled"

Environment/Conditions/Configuration
ALL TDBMS versions

Cause

When we check the DBC.LogonRules table,there was a default rule for 1024 LogicalHostID which had a LogonStatus as R(Rejected).

This means that no user will be able to login except DBC.

sel UserName
,LogicalHostID
,LogonStatus
from DBC.LogonRules
order by 1,2;

*** Query completed. 6 rows found. 3 columns returned.
*** Total elapsed time was 1 second.

UserName LogicalHostID LogonStatus
Crashdumps
0 G
dbqm 0 G
Default 1024 R
SystemFe 0 G
Sys_Calendar 0 G
tdwm 0 G

Solution

The logon status for Default user in the table "DBC.LogonRules" should be set to 'G'(granted).
Issue the following grant statement to set status to 'G'. grant logon on all as default;