Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Unanswered: Data warehousing

    Hi people,
    I'm new with db2 and i have some problems with the data warehouse center.
    The problem is that i want to implement an etl process between the servers (NT and AIX).
    The DW is on the windows NT and the OLTP database is on AIX.
    So i have to define my sources(AIX)....could you help me with it?
    Do i have to install an agent for AIX?..and How can i do this?
    ...or...do i have to use the agent that was installed by default?

    Thanks for your help!

    Rui

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Data warehousing

    Do you have a db2 client installed on the NT m/c (ie , where DWC is installed)

    Cheers

    Sahtyaram

    Originally posted by rmleite
    Hi people,
    I'm new with db2 and i have some problems with the data warehouse center.
    The problem is that i want to implement an etl process between the servers (NT and AIX).
    The DW is on the windows NT and the OLTP database is on AIX.
    So i have to define my sources(AIX)....could you help me with it?
    Do i have to install an agent for AIX?..and How can i do this?
    ...or...do i have to use the agent that was installed by default?

    Thanks for your help!

    Rui
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: Data warehousing

    My db2 client is db2 udb 7.1.
    Cheers
    Rui
    Originally posted by sathyaram_s
    Do you have a db2 client installed on the NT m/c (ie , where DWC is installed)

    Cheers

    Sahtyaram

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605

    Re: Data warehousing

    Hi,

    On NT you have to define ODBC connection to AIX database. You can do this with DB2 Client Configuration Assistant.

    Hope this helps,
    Grofaty

    Originally posted by rmleite
    My db2 client is db2 udb 7.1.
    Cheers
    Rui

  5. #5
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: Data warehousing

    Grofaty,

    I've already define an ODBC conection to AIX database with the CCA but
    the problem continue.
    The problem continue to be the same... i can´t define an source ,on Data Warehouse Center, from AIX database!

    Thanks for you help, but do you know how i can resolve it?,

    Rui


    Originally posted by grofaty
    Hi,

    On NT you have to define ODBC connection to AIX database. You can do this with DB2 Client Configuration Assistant.

    Hope this helps,
    Grofaty

  6. #6
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Could you please send the error message?

    Grofaty

  7. #7
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74
    This is the error message:

    "DWC07174E The warehouse server was unable to send a request to spawn an agent process on host "hostname".
    RC = 7174 RC2 = 6106".

    Originally posted by grofaty
    Hi,

    Could you please send the error message?

    Grofaty

Posting Permissions

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