Example - Passing Authentication Provider Details

This DB2® example shows how to include session information, sourced from an authentication provider, into the information passed to the database.

The command block invokes the DB2 procedure SYSPROC.WLM_SET_CLIENT and passes down values derived from the available session variables. This information can be used by database administrators when defining workload management rules in the database that give higher priority to specific user groups when a database connection is shared by multiple user groups.

<commandBlock>
	<commands>
		<sqlCommand>
			<sql> CALL SYSPROC.WLM_SET_CLIENT_INFO
			(#$account.personalInfo.userName#,
			 'UserComputerName',
#$account.parameters.var1#, 'ApplicationName', 'AUTOMATIC')
			</sql>
		</sqlCommand>
	</commands>
</commandBlock>