Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Converting values to a time stamp

(BMC.DB2.SPE2210)

Use the Timestamp Converter app to convert a Db2 plan or package consistency token (contoken) to a date and time. You can also convert a Db2 basic (6-byte) and extended (10-byte) LRSN value to a date and time.

Related topic

Managing-apps

To convert a Db2 consistency token

New console
  1. In the upper left corner of the New console, click Apps.
  2. Click Timestamp Converter NW_clock_o_teal.png.
  3. Select CONTOKEN.
  4. In the Value field, enter the consistency token with or without the hexadecimal indicator.
    For example, 195F75C300C0DA51 and x'195F75C300C0DA51' are both valid entries and return the same result.
  5. Click Convert.
Classic console
  1. In the upper right corner of the Classic console, click Apps.
  2. Click Contoken Converter contoken_converter_app_64.png.
  3. In the Contoken field, enter the consistency token with or without the hexadecimal indicator.
    For example, 195F75C300C0DA51 and x'195F75C300C0DA51' are both valid entries and return the same result.
  4. Click Convert.

To convert an LRSN value

  1. In the upper left corner of the New console, click Apps.
  2. Click Timestamp Converter NW_clock_o_teal.png.
  3. Select LRSN.
  4. In the Value field, enter the basic (6-byte) or extended (10-byte) LRSN value.
    For example, CAFC676B51D5 (6-byte) and x'00CAFC676B51D5254000' (10-byte) are both valid entries and return the same result.
  5. Click Convert.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*