Professional Web Applications Themes

tion DB2 V7.1 Capture error ASN0009E - IBM DB2

Hello, I have set up a tion between two databases. I have set the appropriate environment variables, tion rables, tion subscription in the control center and rights (rwx) in the tion directory. I have also created a .PWD file with the exact Syntax for SERVER=.. USER=.. PWD= .. . I used the option to create the tables on the target server (database). But when I try to start the capture program (nohup ../asnccp controlserver &) the capture progam exits. In the logfile ..CCP, I reveived the error message ASN0009E. The workaround to solve this problem is to: Stop the Capture ...

  1. #1

    Default tion DB2 V7.1 Capture error ASN0009E

    Hello,

    I have set up a tion between two databases. I have set the
    appropriate environment variables, tion rables, tion
    subscription in the control center and rights (rwx) in the tion
    directory. I have also created a .PWD file with the exact Syntax for
    SERVER=.. USER=.. PWD= .. .

    I used the option to create the tables on the target server
    (database). But when I try to start the capture program (nohup
    ../asnccp controlserver &) the capture progam exits. In the logfile
    ..CCP, I reveived the error message ASN0009E.

    The workaround to solve this problem is to:

    Stop the Capture program.

    Delete the tion source.

    Define the tion source again; if you do not have the "Data
    capture is full-refresh only" check box selected, the DB2 Control
    Center will alter the source table with the DCC attribute.

    Start the Capture program

    I have done this, respectively I didn't find the button to deactivate
    the "Data capture is full-refresh only" check box. Where can I find it
    and how can I solve this problem ??

    Thanks
    Halberstadt Guest

  2. #2

    Default Re: tion DB2 V7.1 Capture error ASN0009E


    ASN0009E is when the data capture changes attribute for the source table
    is not set



    alter table <tablename> data capture changes



    Then start your capture program ..

    Cheers

    Sathyaram



    Originally posted by Halberstadt
    > Hello,
    >
    > I have set up a tion between two databases. I have set the
    > appropriate environment variables, tion rables, tion
    > subscription in the control center and rights (rwx) in the tion
    > directory. I have also created a .PWD file with the exact Syntax for
    > SERVER=.. USER=.. PWD= .. .
    >
    > I used the option to create the tables on the target server
    > (database). But when I try to start the capture program (nohup
    > ./asnccp controlserver &) the capture progam exits. In the logfile
    > .CCP, I reveived the error message ASN0009E.
    >
    > The workaround to solve this problem is to:
    >
    > Stop the Capture program.
    >
    > Delete the tion source.
    >
    > Define the tion source again; if you do not have the "Data
    > capture is full-refresh only" check box selected, the DB2 Control
    > Center will alter the source table with the DCC attribute.
    >
    > Start the Capture program
    >
    > I have done this, respectively I didn't find the button to deactivate
    > the "Data capture is full-refresh only" check box. Where can I find it
    > and how can I solve this problem ??
    >
    Thanks


    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

Similar Threads

  1. Paper Capture recognition service experienced an error (15000)
    By james_i._porter@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: September 19th, 09:26 PM
  2. Capture Server Error
    By Richard_Sowa@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 22
    Last Post: May 4th, 04:28 PM
  3. How can I capture the Script timeout Error?
    By Mathieu Blais in forum ASP
    Replies: 8
    Last Post: September 29th, 02:46 PM
  4. tion Db2 5.2 - Capture slowdown
    By Rogers Newsgroups in forum IBM DB2
    Replies: 6
    Last Post: August 9th, 12:05 PM
  5. How to capture this error?
    By davidw in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 5th, 09:41 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139