Troubleshooting
Problem
This document describes changing either the SMTP Domain or Address field if the SMTP alias table for all users.
Resolving The Problem
To change the SMTP domain in the alias table for all users, do the following:
|
1. | On the IBM i command line, type the following: WRKNAMSMTP Press the Enter key. If you get WRKNAMSMTP DISABLED or message TCP9610, this will not work as you have converted your system alias table with CVTNAMSMTP. If you get the option for system or personal alias tables, you should follow the steps below. |
| 2. | On the IBM i command line, type the following: STRSQL Press the Enter key. |
| 3. | On the SQL command line, run the following command(s). Note: The data entries are case-sensitive. UPDATE QUSRSYS/QATMSMTPA SET DOMROUTE = 'NEWDOMAIN' WHERE DOMROUTE = 'OLDDOMAIN' This changes all entries with the old SMTP DOMAIN to the new domain. UPDATE QUSRSYS/QATMSMTPA SET ADDRESS = 'NEWNAME' WHERE ADDRESS = 'OLDNAME' This changes all the entries from the old system name to the new system name |
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0"}]
Historical Number
26433147
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1017033