If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Where is the query start position in the DB2 packet

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-07-07, 06:17
gonmat gonmat is offline
Registered User
 
Join Date: May 2007
Posts: 2
Exclamation 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
Reply With Quote
  #2 (permalink)  
Old 05-07-07, 07:07
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
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
Reply With Quote
  #3 (permalink)  
Old 05-08-07, 00:10
gonmat gonmat is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 05-08-07, 00:23
rahul_s80 rahul_s80 is offline
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old 05-08-07, 03:55
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On