Integration Server 10.11 | Built-In Services Reference Guide | OAuth Folder | Summary of Elements in this Folder | pub.oauth:removeExpiredAccessTokens
 
pub.oauth:removeExpiredAccessTokens
WmPublic. Removes expired OAuth access tokens from the database.
Input Parameters
maxRows
String. Optional. Maximum number of rows containing expired tokens to be deleted from the database, where each row contains a single expired access token. If you specify 0 or do not specify a value, the service removes all of the rows containing expired tokens from the database.
The maxRows parameter applies to Oracle or DB2 databases only. The maxRows parameter is ignored for all other database types, such as MySQL, SQL Server, or Derby. Instead, the service deletes all of the rows containing expired tokens.
Output Parameters
removedTokensCount
String Number of expired tokens removed by the service. If the service did not remove any expired tokens to be removed, the value of removedTokensCount is 0.
Usage Notes
To improve the performance of the pub.oauth:removeExpiredAccessTokens service, create the following two database indexes:
*Create index idx_oauth_tmp_idx on IS_OAUTH_ACCESSTOKEN(TOKEN_ID);
*Create index idx_oauth_tmp_idx2 on IS_OAUTH_REFRESHTOKEN(TOKEN_ID);