News
Abstract
To support multi-factor authentication (MFA), an additional authentication factor can be appended to the password string.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > CONNECT statement supports additional factor for authentication
An additional authentication factor, such as a time-based one-time password (TOTP), can be passed on the CONNECT statement like this:
SET current_totp = '123456';
SET password_and_totp = 'mypassword' concat ':' concat current_totp;
CONNECT to remotesys USER user1 USING password_and_totp;
For information about providing an additional factor with a password value, see this page:
See the SQL Reference for CONNECT statement details:
CONNECT (type 2)
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.6.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
08 April 2025
UID
ibm17229556