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 (<F4>) 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 LAND(DBXRSEC, X'E0')
    WHEN X'00' THEN '*USRID'
    WHEN X'20' THEN '*VLDONLY'
    WHEN X'40' THEN '*USRIDPWD'
    WHEN X'C0' THEN '*USRENCPWD'
    WHEN X'80' THEN '*ENCUSRPWD'
    WHEN 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:
24 February 2026

UID

nas8N1013679

Tips