Replication Guide and Reference

Problem source identification questions

If you call IBM Software Support Services, you will be asked the following types of questions by Level 2 Service Support. You can save time and perhaps diagnose the error yourself by researching the answers to these questions.

1. What was occurring at the time of the problem?

2. What has changed recently in the environment?

3. Describe the environment.

4. What is the CSD level of DB2 Universal Database V6 where the Control Center is installed?

5. On what platform is the Capture program running?

6. At what maintenance level is the Capture program?

7. What is the maintenance level of DB2 where the Capture program is running?

8. On what platform is the Apply program running?

9. At what maintenance level is the Apply program?

10. On what release of DB2 does the Apply program run?

11. What is the maintenance level of DB2 where the Apply program is running?

12. Is this a mobile user?

13. What are the ASN messages that are issued?

14. Are there other messages either in SYSLOG (for AS/400, the QSYSOPR message queue) or on the screen?

15. What is the complete message text for all messages? Be sure to note all message numbers, database names, table names, user IDs, and file names that appear in messages.

16. Where does the failure occur?

    1. The DB2 Control Center

       • Is the problem with a replication source or subscription?

       • What messages appear?

       • Can the user successfully connect to the source or target database from a command line or command prompt window?

    2. The Apply program

       • Is the Apply program running?

       • If not, what occurs when the Apply program starts?

       • What messages appear?

       • Is there error information in the ASN.IBMSNAP_APPLYTRAIL table?

       • Is there error information in the Apply program log file (for AS/400, in the Apply job log)?

       • Are data changes being successfully replicated to the target table?

       • Do all tables in a replication subscription have the same problem?

       • What table types (for example, user copy, point-in-time, CCD) are involved in the failure?

       • Did you run the Apply program with trace?

       • Are CALL procedures being used?

       • Is a CCD being used?

    3. The Capture program

       • Is the Capture program running?

       • If the Capture program is not running, what happens when a warm start of the Capture program is tried?

       • Is there error information in the ASN.IBMSNAP_TRACE table?

       • Is there error information in the Capture program log file?

       • What is the DB2 configuration?

       • Are data changes being successfully inserted into the CD tables?

       • Does the user ID running the Capture program have sufficient privileges to run the Capture program?

    4. DJRA

       • What level of DJRA are you using? (Click About from the main window for this information.)

       • If accessing non-IBM data sources, what level of DB2 DataJoiner are you using, and on which platform (AIX or NT)?

       • Save the Generated Script file and the output file.

[ DB2 List of Books | Search the DB2 Books ]