Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Question Unanswered: How to turn on USEREXIT? Please help...

    I need to enable archiving with userexit turn ON.
    How can I do that?

    Log retain for recovery enabled (LOGRETAIN) = RECOVERY
    User exit for logging enabled (USEREXIT) = OFF

    I issued 'db2 update cfg for <db> using USEREXIT ON'.
    It was successfully executed but when I checked the cfg file, USEREXIT is still OFF. Can someone please kindly walk me thru the steps to turn on USEREXIT?

    Thank you in advance.

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    some db parameters take effect after datbase is 'bounced'; you have to force everybody off the database; then the next connection brings the new configuration in. If this does not work and If you ACTIVATEd the database you have to DEACTIVATE it.
    mota

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you are using DB2 8.2 (8.1 with FP 7 or higher) then I would look at the LOGARCHMETH1 db parm before you use the userexit.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •