Verifying DDM TCP/IP Attribute Lowest Authentication Method (Password Required) Current Setting

Troubleshooting

Problem

How to view DDM TCP/IP Attributes "Lowest authentication method" and "Lowest encryption algorithm" without prompting on CHGDDMTCPA.

Resolving The Problem

You can verify these attributes with an SQL statement run in iSQL or the ACS Run SQL Scripts function as shown below:

SELECT                                                
CASE 
   WHEN AUTOSTART = '*YES' THEN '*YES' 
ELSE '*NO' END AS "Autostart server",                        
CASE                                                  
   WHEN LAND(DBXRSEC,X'E0') = X'00' THEN '*USRID'        
   WHEN LAND(DBXRSEC,X'E0') = X'20' THEN '*VLDONLY'      
   WHEN LAND(DBXRSEC,X'E0') = X'40' THEN '*USRIDPWD'     
   WHEN LAND(DBXRSEC,X'E0') = X'C0' THEN '*USRENCPWD'    
   WHEN LAND(DBXRSEC,X'E0') = X'80' THEN '*ENCUSRPWD'    
   WHEN LAND(DBXRSEC,X'E0') = X'A0' THEN '*KERBEROS'     
ELSE '*UNKNOWN' END AS "Lowest authentication method", 
CASE 
   WHEN LAND(DBTFLGS,X'01') = X'01' THEN '*AES' 
ELSE '*DES' END AS "Lowest encryption algorithm" 
FROM QSYS.QADBXRDBD, QUSRSYS.QATOCSTART WHERE DBXRMTN = '*LOCAL' and SERVER = '*DDM'

Related Information

CHGDDMTCPA

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"Data Access","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

Historical Number

487100778

Was this topic helpful?

Document Information

Modified date:
02 July 2025

UID

nas8N1013679

Tips