Modifying the maximum allowable tokenTTL

You can change the maximum allowable tokenTTL value after SQL DI installation or at any other time by using the shell CLI.

About this task

Note:

For SQL DI installations made prior to APAR PH66445, the default maximum tokenTTL will be set to 168 (7 days) after migrating to APAR PH66445. SQL DI administrators should configure an appropriate maximum tokenTTL value that aligns with their typical usage.

A previously valid tokenTTL may now fail if it exceeds the newly enforced maximum. This is an intentional, incompatible change introduced to improve security.

Procedure

  1. In a bash session, change to the $SQLDI_INSTALL_DIR/sql-data-insights/bin directory.
  2. Start the modification of the maximum tokenTTL value by invoking the sqldi.sh shell script with the update_token_maxttl command as shown in the following example: 
    ./sqldi.sh update_token_maxttl

    See Shell commands for SQL Data Insights configuration, administration, and object model management for details about the update_token_maxttl command.

  3. Follow the onscreen prompt to enter the new maximum tokenTTL.
  4. After the update is successfully verified, restart the SQL DI server to use the modified maximum tokenTTL.

    Issue the following commands to stop and then start the SQL DI application:

    ./sqldi.sh stop
    ./sqldi.sh start