Results 1 to 5 of 5
  1. #1
    Join Date
    May 2007
    Posts
    2

    Exclamation Unanswered: Where is the query start position in the DB2 packet

    hi friends

    I am working with DB2 query packets. can anyone tell me from where in the DB2 query packet we canget Query start position.
    what protocol DB2 used. May I have the details of DB2 query packets.

    Plz mail me at mausam_kool@yahoo.com
    thanks
    Love
    Ashish

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Could you explain a bit more on what you achieve? DB2 has packages. Is this what you are referring to? What do you mean with "start position"?

    Which platform and which version of DB2 are you using?

    p.s: You post here, you can read here.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2007
    Posts
    2

    Question DB2 Packet formats in communication with any client

    hi stolze

    thanks for instant reply.

    I am playing with interprocess communication of DB2, and using version 7.1
    I am not concerning with packages, i am playing with communication packets.when we send a connection request to DB2 server by its client "Command line processor" then what packet received by DB2 Server and witch protocol it uses to coomunicate with these type of clients?
    how we can identify the connection packet or query packet.
    In short I want to know what is the format of DB2 connection packet and Query packet in terms of HEADER,DATA, TAILER etc. as descriptive as posibble.

    eagerly waiting for response.
    Thanks
    Love
    Ashish

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    protocol can be found using following at command window

    db2set -all | findstr -i db2comm
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DB2 uses DRDA as communication protocol. That is standardized.

    p.s: Version 7 (for Linux, Unix, and Windows) is out of service for nearly 1.5 years. You have a much higher chance to get responses if you use a current version of DB2.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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