Verifying the ECDA Installed Objects

Verify the ECDA installed objects.

1. 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 result 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

   This result 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.
2. Exit the isql session with the quit command