Verifying the ECDA installed objects

Use the isql utility to log in to IBM DB2 Universal Database through ECDA as maintuser.

• To verify whether the rs_info table has been created successfully:

  isql –Umaintuser –Ppassword –SDCOServer
  select * from rs_info
  go
  

  This is returned:

  RSKEY           RSVAL
  -------------------- ----------------
  
  charset_name    iso_1
  sortorder_name  bin_iso_1
  (2 rows affected)
  

• To verify whether the rs_lastcommit table has been created successfully:

  isql –Umaintuser –Ppassword –SDCOServer
  select * from rs_lastcommit
  go
  

  The following is returned:

  ORIGIN  ORIGIN_QID SECONDARY_QID ORIGIN_TIME
  DEST_COMMIT_TIME
  

  -------------------- -------------------
  

  -------------------- ------------------
  (0 rows affected)
  

If the ECDA objects are not installed successfully, no results are displayed, and you encounter an error message.

Exit the isql session with the quit command.