DB2 SQL locks

If you receive DB2 SQL-911 errors, be sure that the LTMOBJECTS system table does not share a tablespace with a primary table.

StepsTo correct DB2 SQL-911 errors

  1. Use the same user ID and password that originally created the system tables (usually LTMADMIN).

  2. Shut down Replication Agent.

  3. Save the data from the system tables using your site’s normal backup procedures.

  4. Drop all three system tables.

  5. Create all three system tables in a different tablespace or table blocks.

  6. Restore the contents of the system tables saved in step 3.