Verifying the ECDA installed objects

Log in to IBM DB2 Universal Database through ECDA as maintuser.

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

  isql –Umaintuser –Ppassword –SDCService
  

  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, enter:

  isql –Umaintuser –Ppassword –SDCService
  

  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 appear, and you see an error message.

Exit the isql session with the quit command.