Converting values to a time stamp

(BMC.DB2.SPE2210)

Use the Convert Timestamp 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

  1. In the upper left corner of the 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.

To convert an LRSN value

  1. In the upper left corner of the 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*