Get Data Moving 1
Results 1 to 4 of 4

Thread: DB400 CDC - library name

  1. #1
    braj is offline Junior Member
    Join Date
    Jan 2009
    Posts
    2
    Rep Power
    0

    Post DB400 CDC - library name

    In one of the scenario, there are different libraries (having same files) for different countries in the AS400 machine. Now to capture the changes from these library we want to build an Attunity solution. But to make different solutions for different libraries is a bit tedious task which lacks maintanability as well.

    Is there any way by which single solution can be made by parameterizing the library name.

    Thanks for reading all these stuffs. :)

    Thanks,
    Brajesh.

  2. #2
    Tony Mou is offline APAC Support Manager
    Join Date
    Sep 2006
    Location
    China
    Posts
    35
    Rep Power
    0
    Please try this way:

    First of all you need to make sure all those libraries are using same journal.

    Then define one DB400 CDC solution,in the step implementation->server configuration->datasource , assign a space for library name and leave default owner as empty.

    Then all tables' names in StagingArea will be <LibraryName>_<TableName>


    Tony Mou
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    braj is offline Junior Member
    Join Date
    Jan 2009
    Posts
    2
    Rep Power
    0

    Post

    Thanks for reply Tony.

    I tried with that way but after putting all that, it gave and error messge:

    "GetRows on RowCursor failed on table name 'SP_TABLES' ".

    Is this like Attunity admin profile must have all the required privileges on all libraries in the database.

    This will be a great help.

    Thanks in advance.

    Regards
    Brajesh.

  4. #4
    Tony Mou is offline APAC Support Manager
    Join Date
    Sep 2006
    Location
    China
    Posts
    35
    Rep Power
    0
    Hi ,

    Forgot to mention that the solution is based on AIS5.0.1 or AIS5.1,And


    1) You better install the lastest patch of AIS5.01 or AIS5.1.
    2) I think it is needed to assign Attunity Admin profile the priviledge of getting the metadata of all libraries.

    If you still have problem, you can enable acxtrace ,generaltrace ,drivertrace on NAV binding, then define the CDC solution again until you get the error , then send the AIS log on AS400 to our support team


    Tony
    Last edited by Tony Mou; 05-27-2009 at 06:28 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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