DB2 connect

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vikram1102
    New Member
    • Mar 2007
    • 14

    DB2 connect

    Hi all.. can anybody tell me what DB2 Connect is used for.. is it for connecting our db2 system to other db2 systems as well as other rdbms systems?
  • ramesh jampala
    New Member
    • Mar 2007
    • 10

    #2
    Originally posted by vikram1102
    Hi all.. can anybody tell me what DB2 Connect is used for.. is it for connecting our db2 system to other db2 systems as well as other rdbms systems?
    Hi Vikram,

    Db2 Connect is used to connect to Host databases like db2 on Mainframes.

    Thanks

    Comment

    • vikram1102
      New Member
      • Mar 2007
      • 14

      #3
      Originally posted by ramesh jampala
      Hi Vikram,

      Db2 Connect is used to connect to Host databases like db2 on Mainframes.

      Thanks
      Thanks Ramesh.. but if i want to connect my db2 server to the sql server server on the same system, then wat will the process be?....
      Thanks......... ..

      Comment

      • haozhj
        New Member
        • Mar 2007
        • 2

        #4
        what do u mean by DB2 SERVER connect to SQL server ,what do u want?
        if u wanna move data from db2 to sql server,u need the thirt part software.
        of course ,u can do it by hand .

        Comment

        • vikram1102
          New Member
          • Mar 2007
          • 14

          #5
          Originally posted by haozhj
          what do u mean by DB2 SERVER connect to SQL server ,what do u want?
          if u wanna move data from db2 to sql server,u need the thirt part software.
          of course ,u can do it by hand .

          wat is third part s/w? i want to connect heterogeneous servers to my db2 server so that i can run query on the data available there.....i want to get data from other type of rdbms and use it in my db2 server...like link servers in sql-server..

          Comment

          • haozhj
            New Member
            • Mar 2007
            • 2

            #6
            u can search "jta" in google .this technical allows us operate two heterogeneous db .u can write several line code with j2ee so that u can send "sql " to the db u want .i did it several days b4. its not complex at all.

            Comment

            • rajesh244
              New Member
              • Feb 2008
              • 2

              #7
              Originally posted by vikram1102
              Hi all.. can anybody tell me what DB2 Connect is used for.. is it for connecting our db2 system to other db2 systems as well as other rdbms systems?

              1.Easily scales to handle high volume transaction processing
              2.Reduces storage needs by up to 80% using industry unique automatic deep compression capabilities
              3.Reduces risk of unauthorized access with an innovative label based security model
              4.Maximizes data availability by reducing planned and unplanned downtime

              Comment

              • rajesh244
                New Member
                • Feb 2008
                • 2

                #8
                hai

                1. Differnt between DB2 and SQL Server?
                2.How to work DB2?
                3. advantage of DB2?

                Comment

                Working...